How to Optimize a MySQL Database in cPanel

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.

Tags: , , , , , , | Posted under cPanel/Linux Hosting, MySQL, Video | RSS 2.0

Author Spotlight

Arian Jahansouz

Hello, I am Arian! I have been writing for Arvixe since 2009 and now head the Arvixe Blog. Feel free to contact me at any time with questions or comments!

6 Comments on How to Optimize a MySQL Database in cPanel

  1. Dave Leach says:

    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!)

    • 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.

    • Arvixe Blog says:

      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.

  2. Doug Wilson says:

    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

  3. Will says:

    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!

    • 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.

Leave a Reply

Your email address will not be published. Required fields are marked *