How to optimize a MySQL database using phpMyAdmin?

Linux Web Hosting Related Discussions

How to optimize a MySQL database using phpMyAdmin?

Postby webhostingindia » Sun Apr 01, 2012 10:29 am

How to optimize a MySQL database using phpMyAdmin?


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.



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.

Web Hosting India
Reseller Web Hosting
webhostingindia
 
Posts: 51
Joined: Sun Mar 11, 2012 4:46 pm

Return to Linux Web Hosting Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron