Optimize MySQL

By:

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

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

Next, you can optimize all databases with this command:
Code:

Restart MySQL after you’ve done the above:
Code:

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