1. Log into your cPanel account.

2.click on “phpMyAdmin” Icon,In the “Databases” section.

chwkb-phpmyadmin-icon

3. To expand database Click on the expand button like “example”, in the left sidebar.

chwkb-phpmyadmin-expand-db

4. Beneath your cPanel username, you can see the list of all databases, Choose proper database which you want to optimize.

chwkb-phpmyadmin-db-list

5. Scroll down and mark “Check All” then click on the Drop-down option and select “Optimize tables”.

chwkb-optimize-db

Table successfully optimized.