How to Optimize database tables?

Please use following steps to optimize your MySQL tables.

 

1) Log into your cPanel and select the PHPMyAdmin icon.

2) Select the database you wish to optimize.

3) Select the tables you wish to optimize. Or you can click the select all link located at the bottom of the table list.

4) Click the “with selected” drop-down menu, and select optimize

5) After it completes optimize you will see the results of it on the next screen.

 

That’s it! You should see a message confirming the requested operation.

  • optimize, database, tables
  • 121 Users Found This Useful
Was this answer helpful?

Related Articles

What are the information_schema tables I see when viewing my database?

INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such...

How can I access mysql database remotely?

Under the mysql header in Cpanel, select 'manage mysql'Then scroll down to the 'access hosts'...

How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...