Hello, Richie

You can optimize your database via phpMyAdmin or via ssh.
You can also use a WordPress plugin to do that, this one is really good: https://wordpress.org/plugins/wp-dbmanager/

Also you can mysqltunner (it’s a really cool script written in perl). It will check your current mysql values and it will suggest some values to adjust in the my.cnf file:

Download the MySQLTuner script:

wget http://mysqltuner.com/mysqltuner.pl

Change the scripts permissions to be executable:

chmod +x mysqltuner.pl

```Run the mysqltuner.pl script. You will be prompted to enter in your MySQL administrative login and password:

./mysqltuner.pl

You should see some recommended values that you can tweak in the my.cmf file. This should help you optimize your database a bit.

Let me know if you have some questions.

Alex