How to use MySQLTuner ?

mysqltuner

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

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

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

wget mysqltuner.pl

Step 3 : You’d need to assign 775 permissions for the script:

chmod 775 mysqltuner.pl

Step 4 : To Run the script use:

perl mysqltuner.pl

It’d then display the stats and recommendations similar to the one shown below :

 

MySQLTuner_stats_recommendation_screen

This concludes the process.


Vishwajit Kale

Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.