Optimize your wordpress database at regular basis will reduce the size of your database and prevent your site from using excessive server resources on your web server. By doing this, it can drastically speed up the load time of your blog.
Optimize your database using WP-Optimize plugin
WP-Optimize is the Database Optimization plugin allows you optimize your WordPress database by deleting the redundant revisions of posts and pages, auto drafts, spam comments and pending comments with simple click. It also optimizes the database tables without using phpMyAdmin.
Remove the WordPress post revisions – Everytime you click save draft or update your post, WordPress creates a revision of that post. If you edit a post 6 times you might have 5 copy of that post as revisions. If you have a small website it’s not a big deal, but if you’re running a high traffic site with hundreds of posts it can clutter your database and can potentially slow down your website. So I highly recommend to clean up all posts revisions from your database once in a while.
- Remove the WordPress auto draft posts – WordPress automatically creates auto-drafts of the posts that you write. As time goes, it can greatly increase the size of the WordPress database on your Web server and potentially slow down your website. so it’s recommended to clear up auto draft posts from your database at regular interval by enabling this option.
- Remove all the comments in the spam queue – In some cases you may have hundreds or even thousands of spam comments to delete. This option allows you to remove all spam comments from your database with one click.
- Remove all the un-approved comments – Allows you to remove all pending comments from your database with one click.
- Optimize database tables – With “optimizing” the tables, you can free some amount of space from your database.
The plugin also display Database table statistics. It shows how much space can be optimized and how much space has been cleared from your database. Here is a screenshot of my WordPress database, which need to optimize.
Now your blog will load faster than before. I recommend running this plugin at least once a week, if not more depending on how often you make changes to your site.
Remember every time you try to do something with your database that you need to backup all the database first.