how to implement MySQL Tuner in linux

 

The Tuner will monitor a database (run it once per week or so on a live app) and suggest changes based on what it’s seen in the logs.

Step 1) Download tuner file.

wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl -O /tmp/mysqltuner.pl

Step 2) Login with super user account

sudo -i

Step 3) Move Into /tmp directory

cd /tmp

Step 4) Give excutibile permision to  mysqltuner.pl file

chmod +x mysqltuner.pl

Step 5) Run the file by following command.

./mysqltuner.pl

Find Slow_queries and No_joins_without_indexes line and anything more.