How to optimize a MySQL database using phpMyAdmin?
Author: admin admin Reference Number: AA-00329 Views: 4076 Created: 2013-04-11 12:57 Last Updated: 2013-04-11 12:57 0 Rating/ Voters

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

Fortunately, making this optimization is quite easy when using phpmyadmin  available in your 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.

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.

Quick Jump Menu