MySQL load can be really heavy on some servers, especially if you are hosting big communities, reducing the load of MySQL is in that case is essential. To help us achieving this task we will use MySQLTuner.
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.  

MySQL logo



Download MySQLTuner :

cd /usr/local/src
wget http://mysqltuner.com/mysqltuner.pl

Make it executable :

chmod 0755 mysqltuner.pl

Run the script :

./mysqltuner.pl

Note: you may be asked to enter the MySQL root password, if yes, please provide.


The MySQLTuner output is separated into 5 parts as below:
General Statistics / Storage Engine Statistics / Security Recommendations / Performance Metrics / Recommendations

You should go through all parts especially on the Recommendations. It’s the main part which summarizes everything you need to step by step review your MySQL installation or make changes on some settings in the configuration file (usually located in /etc/my.cnf or /etc/mysql/my.cnf).

Share this article
FaceBook  Twitter

Comments (0)

There are no comments posted here yet

About Me

My Name is Mike, I'm 34 years old, and a computer technician from France.

I'm passionate about new technologies, computers and many other Geeky/Nerdy things, such as Cinema, Video Games and Mangas.

I hope you will have a good time here and will excuse me for my bad English, it's still a work in progress, but i really wanted to give it a shot so I could share with as many people as possible.

Recent Comments

No activities found.