Research Article

Database Constraints Applied to Metabolic Pathway Reconstruction Tools

Table 6

MySQL optimization parameters.

Variable Default value Optimized value

query_cache_size 0 MB 64 MB
table_open_cache 64 4096
key_buffer_size 7996 MB 100 MB
join_buffer_size 128 KiB 1 MB
query_cache_limit 1 MB 16 MB