How to use MySQLTuner ?

• 03 January 2022
• in: MySQL

Using the MySQLTuner helps you review a MySQL installation quickly and being considered is a script it has more effective way to improve its performance and achieve stability.

Note : Before you run the MySQLTuner script you’d need to be logged in as root user.

Let’s see the steps to use MySQLTuner ?

Step 1 : Log into your server with a root or sudo user via SSH.

Step 2 : Use the command as below to download and execute :

wget mysqltuner.pl

Step 3 : For the script you will need to assign 775 permissions :

chmod 775 mysqltuner.pl

Step 4 : To Run the script use the command as below:

perl mysqltuner.pl

After that it will display the stats and recommendations same as to the one shown below :