Optimize MySQL

You could try running the following script to see the recommendations it provides:

Code:

/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl

You need to modify your /etc/my.cnf according to the mysqltuner results.

Next, you can optimize all databases with this command:

Code:

mysqlcheck --auto-repair --check --optimize --all-databases

Restart MySQL after you've done the above:

Code:

/etc/init.d/mysql restart

Please wait 24 hours and then re-run mysqltuner.pl again on the machine to see any other variable changes to make.

Kunnskapsbase