How to Optimize a MySQL Database in cPanel

Written by Arian Jahansouz Friday, 23 July 2010

Related documents:
1. How to Create a Database and User for MySQL in cPanel
2. How to Add Databases and Users Using MySQL Wizard in cPanel
3. How to Allow Remote Access to a MySQL Database in cPanel
4. How to Change the Password of a MySQL User in the cPanel

This article will give you a step by step guide on how to optimize a MySQL database’s tables in the cPanel.

Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click phpMyAdmin

2) Click Databases in the top table

3) Select the database whose tables you would like to optimize

4) Click Check All

5) Select Optimize table from the drop-down menu

This concludes how to optimize a MySQL database’s tables in the cPanel.

Looking for quality cPanel Hosting? Check out Arvixe Web Hosting.

6 Comments

1. Dave Leach   |  Monday, 26 July 2010 at 9:05 am

   Hi
   Just looking at the C/Panel help listings and wondering what on earth they all are. The Help blog is very good IF you know what the components are! For example, what is Magento, MOdx, Habari, Nucleus etc etc. Is there a list somewhere that explains what all these things are?….sort of simple description…..I have no idea what 95% of those items are so I can’t access them. Just need a list…a discriptor of each item to understand what I would like to discover further.

   Thanks for your time

   Dave Leach, (lifetimer learner or at least trying!)

   
2. Arian Jahansouz   |  Wednesday, 04 August 2010 at 1:18 pm

   Magento, MOdx and Nucleus are all various software and services provided. The best place to find a description for these programs would be through Softaculous. Log into your cPanel, find the Software/Services bar, and click Softaculous. Here, you can browse through all of the different programs available. A short description on each program is also provided. If you like, almost all of the programs have a Demo feature where you can try out the script before installing it.

   
3. Arvixe Blog   |  Monday, 09 August 2010 at 5:37 am

   From within Softaculous, you can read a short description and view a demo. Furthermore, the link to each one is available there as well so you can go to their site. Please note that each type of software has a specific purpose and no one really knows every single piece of software. You’ll need to choose the one you feel fits your needs best and then familiarize yourself by visiting their site.

   
4. Doug Wilson   |  Monday, 09 August 2010 at 9:11 am

   Followed Directions, got this:

   Fatal error: Cannot redeclare pma_tableheader() (previously declared in /usr/local/cpanel/base/3rdparty/phpMyAdmin/db_structure.php:83) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/db_structure.php on line 118

   
5. Will   |  Thursday, 14 July 2011 at 12:30 am

   I have done the optimization, yes it has a effect to my site, i want to know how does this function did this? what has been optimized to make site faster? and how often should we optimize it? thank you!

   
6. Arian Jahansouz   |  Sunday, 24 July 2011 at 8:04 am

   Optimization reclaims unused disk space, which may result from deleting or moving around files. Optimizing your database should be done after any major changes, or once every few weeks for best results.