MySQL Repair and Optimize Tables in phpMyAdmin
Occasionally the MySQL database may run slower than desired. This issue can be fixed quickly through phpMyAdmin.
Important note: Please back up any database on the account before making changes
Note: Legacy accounts will feature a horizontal navigation bar at the top of the screen, while Bluerock account users will see a vertical navigation menu on the left-hand side of the screen. If you are still unsure what interface your account uses, please see Bluerock vs. Legacy to determine which step to follow.
- Log in to your Bluehost control panel.
- For the Rock user account, click on Advanced on the left-side navigation menu.
For the Legacy, from the top menu, click on hosting, then from the submenu, select databases.
- Under Databases, click on phpMyAdmin.
- On the left will be a list of databases. Select the one to repair/optimize.
- On the right, it will load all of the tables in your database. Scroll to the bottom and select Check All.
- Just to the right, select the Repair Table option in the drop-down list.
- This will list all the tables, with "OK" listed next to them.
- Click on the Structure tab.
- Click Check All again, and then choose to Optimize in the drop-down menu.
- The process is done!
Many MySQL errors can be fixed by this process. It is recommended to perform these steps frequently to keep any database in good condition.
Still Not Fixed?
If you are using InnoDB as a storage engine, we have noticed an issue regarding database size. For various reasons, it occasionally occurs that memory allocated to a customer for database usage is not released when it is no longer required by the database. This memory does not appear as in use when the database size is viewed using phpMyAdmin, but since it is still allocated to the customer account, the server-side administrative tools will include it in calculations of overall database memory usage and determinations of whether or not an account has exceeded the database memory limits specified in the terms of Service.
Pro Tip! The easiest way to free this "hidden" memory is to export the database information, completely clear the database, and re-import the information. This will cause phpMyAdmin and the server-side tools to report the actual database usage and prevent account deactivation due to the "hidden" memory usage.
The repair/optimize function in phpMyAdmin will not correct this issue. The server-side tools report complete memory usage, which is the information required to determine the server's overall performance. That is why the server-side tools are used to determine usage for ToS compliance purposes. The phpMyAdmin does not correctly report all memory usage allocated to the account and is therefore not used for these calculations.
If you need further assistance, feel free to contact us via Chat or Phone:
- Chat Support - While on our website, you should see a CHAT bubble in the bottom right-hand corner of the page. Click anywhere on the bubble to begin a chat session.
- Phone Support -
- US: 888-401-4678
- International: +1 801-765-9400
You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.