Hiya guys, if any of you own a dedicated server and want to reduce the MySQL load hopefully I can help. Before doing the following steps it is advised to have had the MySQL service running for at least 24 hours, preferred 48 hours +

CentOS:

Download MySQLTuner:

Code: 
wget http://mysqltuner.com/mysqltuner.pl
Make executable:

Code: 
chmod 755 mysqltuner.pl
Run MySQLTuner:

Code: 
./mysqltuner.pl
Then the output will display what you need to do/can do to increase performance. Most of the configuration will lay in the following file:

Code: 
/etc/my.cnf
If you don't understand what it is telling you ask me here
Sp32 Reviewed by Sp32 on . Optimize MySQL - MySQLTuner Hiya guys, if any of you own a dedicated server and want to reduce the MySQL load hopefully I can help. Before doing the following steps it is advised to have had the MySQL service running for at least 24 hours, preferred 48 hours + CentOS: Download MySQLTuner: wget http://mysqltuner.com/mysqltuner.plMake executable: chmod 755 mysqltuner.plRun MySQLTuner: Rating: 5