mysqltuner optimization

[matt murdock78]

Hello everyone,

On two database mysql server (from two different websites), I launched a mysqltuner (we have timeout but on the web server, but we do not really know where it comes from at the moment)

Here are the optimizations to bring advise by mysqltuner, the databse runs on a machine with 4vcpu and 115 GB of ram (ubuntu 16.04 server)



db01 PROD

mysqltuner recommendation:

Variables to adjust:
query_cache_type (= 1)
join_buffer_size (> 256.0K, always use indexes with joins)
table_open_cache (> 431)
innodb_buffer_pool_size (> = 1G) if possible.



db02 PROD:

Variables to adjust:
max_connections (> 151)
wait_timeout (<28800)
interactive_timeout (<28800)
query_cache_type (= 1)
sort_buffer_size (> 256K)
read_rnd_buffer_size (> 256K)
join_buffer_size (> 256.0K, always use indexes with joins)
table_open_cache (> 431)
innodb_buffer_pool_size (> = 2G) if possible.

I wanted to have your opinion and especially understand a little parameters (I start a little mysql ^^)


thank you in advance