I’m looking for some help tuning our my.cnf file to handle many current users (about 20 orders/minute). This particular site is in WordPress and running Woocommerce.

After a lot of reading online, I’ve come up with the settings below. The server is Debian 8 with 12 CPUs and 48GB RAM.

query_cache_type = 1
query_cache_limit = 256K
query_cache_min_res_unit = 2k
query_cache_size = 80M

key_buffer      = 2G
max_allowed_packet  = 512M
thread_cache_size   = 256K
tmp_table_size      = 4G
max_heap_table_size = 4G
table_cache     = 1024
table_definition_cache  = 1024
myisam_recover          = FORCE,BACKUP
max_connections         = 300
wait_timeout        = 120
connect_timeout     = 120
interactive_timeout     = 120

innodb_flush_method            = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 2G
innodb_io_capacity      = 1000
innodb_read_io_threads      = 32
innodb_thread_concurrency   = 0
innodb_write_io_threads     = 32

It seems to be running pretty good for now. Any additional thoughts? Thanks for your input!

Read more here: Tuning MySql my.cnf for Many Users


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.


Wordpress related questions and answers: