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.

 

  1. Login to cPanel
  2. Click on the phpMyAdmin button in the Databases section.
  3. 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.
  4. 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.
  5. On the drop-down box that says “with selected…” select “Optimize Table.” This will optimize the table and take you to a new screen.