Located in your cPanel is a tool to optimize your MySQL database. You can use “Optimize Table” to reclaim unused space and defragment the data file for optimal performance.
- Login to cPanel
- Click on the phpMyAdmin button in the Databases section.
- Select the database you’d like to optimize from the list in the left column, which should take you to the “structure” tab for the database.
- Select the tables you want to optimize by checking the checkbox in front of each one, or by clicking on Select All if you want to optimize all of them.
- On the drop-down box that says “with selected…” select “Optimize Table.” This will optimize the table and take you to a new screen.