rss feed Twitter Page Facebook Page Github Page Stack Over Flow Page

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