- Login to Cpanel.
- Click on phpMyAdmin to open.
- Navigate to the Databases tab and click on the name of the desired database.
- Select all of the tables that you want to be optimized by ticking the check-box next to their name.
- From the With Selected: drop-down menu choose Optimize table. The optimization will be performed automatically and a new page will open that shows the result of the operation.
You have successfully optimized your database.