What is the recommended my.cnf settings for 32 GB Server

Posted on

Question :

I am just moving my website to a new server and ı want to know what is the recommended settings for 32 GB server?

Mysql tunning for my old server (16 GB)


Answer :

Suggestions to consider for your my.cnf [mysqld] section

thread_cache_size=100  # to reduce threads_created count of 16K in 42d per MSTuner
table_open_cache=6000  # from 2500 to reduce opened_tables count
innodb_open_files=6000  # from 2500 to be paired with table_open_cache

Welcome to dba.stackexchange.com

I’m not sure why you upped to 32G. It seems from your tuning report that your innodb datasize is 0.5G.

Main thing to look at based on your tuning report is the table_cache. 3% is horrible and is incurring quite a penalty. Aim to get this up to 99%.

Read about table cache here: https://dev.mysql.com/doc/refman/5.7/en/table-cache.html (since you are using MySQL-5.7)

There is a warning about your join buffer size. Start looking through your slow query log (has 1M entries apparently – with what long_query_time?) with the aim to improve your schema indexing and this warning might go away. Ask separate questions about your slow queries. Initial reading – https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html

Leave a Reply

Your email address will not be published. Required fields are marked *