Mysql

Posted on Sunday March 13, 2016 / by Eric Potvin

Here are some suggested settings for the my.cnf file.

 [mysqld]
 max_connections = 400
 key_buffer = 16M
 myisam_sort_buffer_size = 32M
 join_buffer_size = 1M
 read_buffer_size = 1M
 sort_buffer_size = 2M
 table_cache = 1024
 thread_cache_size = 286
 interactive_timeout = 25
 wait_timeout = 1000
 connect_timeout = 10
 max_allowed_packet = 16M
 max_connect_errors = 10
 query_cache_limit = 1M
 query_cache_size = 16M
 query_cache_type = 1
 tmp_table_size = 16M
 skip-innodb

 [mysqld_safe]
 open_files_limit = 8192

 [mysqldump]
 quick
 max_allowed_packet = 16M

 [myisamchk]
 key_buffer = 32M
 sort_buffer = 32M
 read_buffer = 16M
 write_buffer = 16M