immu
New member
- Joined
- Jul 6, 2012
- Messages
- 2
- Points
- 0
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:
Make executable:
Run MySQLTuner:
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:
If you don't understand what it is telling you ask me here
CentOS:
Download MySQLTuner:
PHP:
wget http://mysqltuner.com/mysqltuner.pl
PHP:
chmod 755 mysqltuner.pl
PHP:
./mysqltuner.pl
PHP:
/etc/my.cnf
