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.

Was this answer helpful? 4 Users Found This Useful (57 Votes)

Most Popular Articles

What is the MySQL Default Hostname?

All of our servers are configured with MySQL listening on localhost.  If you install from...
How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with...
How can I import a large database? PhpMyAdmin times out.

For importing large databases we recommend using tools such as MySQL Query Browser. Before being...
What type of databases do you support? MySQL, PGSQL?

All Lithium Hosting servers support MySQL and PostgreSQL databases. Also with any of our hosting...
Is SQLite supported?

SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...