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