Hi All,
I was hoping that someone would be kind enough to review the MySQL configuration below and let me know if there are any settings that are either out of whack (to high or to low) or any missing settings.
I took a stab at it myself, but I think I’ve made some “mistakes”.
Looking to enhance server performance, currently running a dedicated database server (for just one website) with 8GB of RAM (can go to 16GB if necessary).
[mysqld]wait_timeout = 15long_query_time = 2log-slow-queries = /var/lib/mysql/slow_queries.log#log = /var/lib/mysql/mysql.logquery_cache_size = 300Mthread_cache_size = 128 max_connections = 500key_buffer_size = 256Msort_buffer_size = 100Mread_rnd_buffer_size = 100M open_files_limit = 4096table_cache = 2028max_heap_table_size = 800Mtmp_table_size = 800Mread_buffer_size = 100Mquery_cache_limit = 100Mquery_cache_type = 1datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysqlmax_connect_errors = 20join_buffer_size = 100Minteractive_timeout = 10[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid
Many thanks!