Day 27: Clean Up and Optimize your WordPress mySQL Database

Clean Up and Optimize your WordPress mySQL Database

While WordPress’ autosave and drafts feature is a very useful feature, it can bloat your WordPress’ mySQL database. Spam comments can also bloat your mySQL database to epic proportions. While a large mySQL database doesn’t slow down your website (Source), it does increase the chances of mySQL errors. Besides, no one likes overly bloated files or databases.

WP-Optimize will clean up and shrink your mySQL database by removing WordPress post revisions, WordPress autosaves, comments in the spam que, un-approved comments, and more. WP-Optimize will even give you statistics on how much space on the mySQL database can be optimized and how much space has cleared.

Wp-Optimize in action
WP-Optimize cleaning and optimizing your mySQL database

Don’t know how to install WordPress plugins? Check out our video tutorial showing how to use WordPress plugins.

31 Days to a Better WordPress Blog

This post is apart of the 31 Days to a Better WordPress Blog series. Be sure to subscribe via RSS, follow on Twitter, follow on Facebook, or circle us on Google+ to keep up with wpLifeGuard’s latest WordPress and blogging tips and tricks.

Follow wpLifeGuard

« Back to Blog