Like regular servicing of any machine, it is very important to service WordPress site as well & clean WordPress database regularly. Updating theme to current version, updating WordPress version , updating plugins are some regular servicing you need to do for your WordPress site.
Along with updating themes and plugins, it is very important to update WordPress database as well by cleaning auto drafts, clearing pending posts, running a security scan are some very important steps.
So, we have collected some of the best and very important plugins to carry out these activities.
A very important and must have plugin on any WordPress site. WP-Optimize is a simple but effective plugin allows you to clean WordPress database and optimize it without phpMyAdmin.
Every time you write a blog post or do some revisions WordPress automatically creates drafts, so if you don’t delete those drafts it will keep on adding and eventually affect performance of your site.
WP-Optimize is a WordPress 3.xx database cleanup and optimization tool. It doesn’t require PhpMyAdmin to optimize your database tables.
It allows you to remove post revisions, comments in the spam queue, un-approved comments, items in trash within few clicks.
WP-DBManager is another great plugin to clean WordPress database which allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.
3. Revision Control
Post revisions can really bloat a WordPress database, this plugin allows the user to set a site-global setting (Settings -> Revisions) for pages/posts to enable/disable/limit the number of revisions which are saved for the page/post. The user may change this setting on a per-page/post basis from the Revisions Meta box.
4. ManageWP Worker
ManageWP Worker plugin allows you to remotely manage your WordPress sites from one dashboard. So, you don’t have to worry about maintenance of your WordPress site
5. Optimize DB
Optimize DB plugin managed by Yoast is another great plugin to clean WordPress database. MySQL is a great database, but it doesn’t clean itself up the way it should sometimes. This plugin runs an optimize table command on your WordPress tables, effectively defragmenting it.