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)
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