Optimizing databases can be important for many reasons, most importantly to increase the speed of your website / application. Typically, optimization will only produce noticeable results if you have a large database. If your database has tables with over 10,000 rows or is over 500MB in size, it may be beneficial to optimize it. Databases smaller in size my not produce any noticeable results from optimization.
- Access your cPanel
- From the Database section click on phpMyAdmin
- From the menu on the left side select your database
- In the right column select all the tables (click on Check all at the bottom)
- Then click With selected and select Optimize table
