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 :
This concludes the process.