How to Optimize your WordPress Database
In this article, we will show you how to optimize your MySQL database using phpMyAdmin. The benefit of this is in removing overhead data in tables, which is unused, but still adds to the overall size of your database. As such, by removing this, you can potentially increase your website’s performance.
1) Login to phpMyAdmin. If you don’t know how, contact your hosting provider for information.
2) Go into the structure view of the database that your WordPress is uses.
3) Select all the tables by clicking the Check All link
4) Click the Optimize Table option found in the drop down menu