Optimizing Mysql Databases
Databases have the potential to grow very large, particularly on sites that receive a lot of traffic or have a large amount of content. In such cases, periodic database optimization may help improve web site performance.
To optimize a MySQL database, follow these steps:
Log in to cPanel server.
In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.
In the left pane, click the name of the database that you want to optimize. For example, the following image shows the example_wordpress database selected
Optimize WordPress from phpmyadmin
In the right panel, select the check boxes for the tables in the database that you want to optimize.
Optimize WordPress from phpmyadmin
Optimize WordPress from phpmyadmin
In the 'With selected' list box, select 'Optimize table'. phpMyAdmin informs you whether or not the optimization process is successful.
Repairing Mysql Databases
Databases can become corrupted for many number of reasons, from software defects to hardware issues. If this occurs, you can try to repair database tables using phpMyAdmin.
To repair MySQL database tables, follow these steps:
Log in to cPanel.
In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.
In the left pane, click the name of the database that you want to work on. For example, the following image shows the example_wordpress database selected:
db4
On the right side, select the check boxes for the tables in the database that you want to repair.
In the 'With selected' list box, select 'Repair table'. phpMyAdmin informs you whether or not the repair process is successful.
