Optimize your MySQL Server with MySQLTuner

Login to your server’s console and download MySQLTuner (I use my user’s home directory)

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

Optional
If you don’t like to enter the user details for every test it’s possible to create a .my.cnf file in the same directory and add a mysql admin user to access your database

Use this kind of settings:

[client]
user=mysqladminuser
password=dbpassword

Continue reading Optimize your MySQL Server with MySQLTuner