How to optimize a MySQL database?

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.

cPanel Hosting from WebhostFace

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.

Optimize a mysql database

Should you experience any difficulties you can always contact our 24/7 Support Team who will gladly help you out with them.