Mar 1, 2015
New Post has been published on WebSetNet
New Post has been published on http://websetnet.com/how-to-optimize-mysql-mysqltuner/
How to optimize MySQL - MySQLTuner
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.pl
Make executable
chmod 755 mysqltuner.pl
Run MySQLTuner
./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
/etc/my.cnf