I have a cpanel server with MySQL 5.7. MySQL uses the most of the cpu. Here I attached the specification of server and parameters in /etc/my.cnf. I would like to tweak the parameters. Can anyone help to tweak the those parameters to reduce the server load. More thing I need to know, if I changed any wrong value on my.cnf, is there any chance to crash MySQL
Mysql causes high load on server
Hello friends,
I have a cpanel server with MySQL 5.7. MySQL uses the most of the cpu. Here I attached the specification of server and parameters in /etc/my.cnf. I would like to tweak the parameters. Can anyone help to tweak the those parameters to reduce the server load. More thing I need to know, if I changed any wrong value on my.cnf, is there any chance to crash MySQL
