MySQL is a great database type but the truth is that it is not smart enough to clean itself up the way it should. This is why manual optimization is always a great addition you can make to it.
To optimize a MySQL database or a certain table, log into your cPanel -> phpMyAdmin and select the database which tables you wish to optimize.
A list with all the database’s tables will appear. Tick the tables you wish to optimize, or simply click [Check All] to select all tables.
From the With selected drop-down menu choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.
Should you experience any difficulties you can always contact our 24/7 Support Team who will gladly help you out with them.