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