How to Use phpMyAdmin To Optimize a Database?

 

You can log into phpMyAdmin from your cPanel.  From there:

1) Click on the table icon next to the database name you are working on

2) On the right hand column your tables should be listed. Scroll down till you see the “Check all” link.

3) Click on that link, make sure all database tables are checked and then from the dropdown next to it, select “Optimize table”.

This command will not work on all table types.

Was this answer helpful?

 Print this Article

Also Read

Guide for optimizing your site for the purpose of using less system resources

This section can be used as a guide for optimizing your site for the purpose of using less system...

How to Optimize Wordpress?

Wordpress is one of the most popular blogging platforms available, and is used widely for...

How to Register Private Nameservers?

Why register nameservers? New nameservers need to be registered with your registrar before they...

Why account is suspended due to high CPU/Memory resource?

If your account was flagged/suspended for high system resource usage. This is a simple guide put...