Notice:

We've recently performed some software upgrades to both cPanel and the Client Area that has resulted in some of the KB articles appearing outdated and obsolete. We are working to update and/or remove the affected articles but this may take some time. We appreciate your patience!

How to optimize a MySQL database in PhpMyAdmin

It is always a good idea to keep your databases' tables optimized.

Fortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel.

To perform the optimization, log in to your phpMyAdmin and select the database whose 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.

Click the box [With selected:] and choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.