In the following tutorial i will describe the steps to optimize the performance of a MySQL database with the mysqltuner script:

Step1. Download the mysqltuner script:

cd /usr/bin
 chmod +x

Step2.  Run mysqltuner:

[email protected]:~# /usr/bin/

Enter the root as username and the  password and you will get a output like this:

[email protected]:~# /usr/bin/

>>  MySQLTuner 1.2.0 - Major Hayden <[email protected]>
>>  Bug reports, feature requests, and downloads at
>>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.58-1~dotdeb.1
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

Continue Reading…

Page 1 of 11