Many times people use the the plugin for deleting the post revisions. There are so many plugins are available for deleting the post revisions. Deleting by revisions perform optimizations on your WordPress database action. Removing old revisions and database optimizations is one of the best things you can do to your WordPress blog to keep it running as fast as it can. Here in this article I will show you how to delete the post revisions automatically.
clean wordpress by deleting revisions automatically
Removing old revisions and database optimization is best. Here in this article I will show you how to clean wordpress by deleting revisions automatically.
What you need is you need to put following code in functions.php file.
$wpdb->query( " DELETE FROM $wpdb->posts WHERE post_type = 'revision' " );
Here are some plugins which are helpful for cleaning the database and delete the revisions.
Better Delete Revision
Better Delete Revision not only deletes redundant revisions of posts from your WordPress Database, it also deletes other database content related to each revision such meta information, tags, relationships, and more. Better Delete Revision is based on the old “Delete Revision” plugin but it is compatible with the latest version of WordPress (3.x) with improved features.
Your current published, scheduled, and draft posts are never touched by this plugin!
This plugin can also perform optimizations on your WordPress database. With optimization and old revision removal this plugin will keep your database lighter and smaller throughout use. Removing old revisions and database optimizations is one of the best things you can do to your WordPress blog to keep it running as fast as it can.
WordPress MU or customs installation (like some pre-made installation of some Hosting Providers) are not yet supported. WordPress MU support is in our TODO list.
Post Revisions are a feature introduced in WordPress 2.6. Whenever you or WordPress saves a post or a page, a revision is automatically created and stored in your WordPress database. Each additional revision will slowly increase the size of your database. If you save a post or page multiple times, your number of revisions will greatly increase overtime. For example, if you have 100 posts and each post has 10 revisions you could be storing up to 1,000 copies of older data! The Better Delete Revision plugin is your #1 choice to quickly and easily removing revision from your WordPress database. Try it out today to see what a lighter and smaller WordPress database can do for you!
WP-Optimize
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.
TW Disable Revisions
This plugin will disable revision function in WordPress and delete all entries of revisions in database.
It is extremely important to back up your database before install this plugin if you want to keep backup of your revisions.
Bulk Delete
Bulk Delete is a WordPress Plugin which can be used to delete posts in bulk from selected categories, tags, post types or custom taxonomies. This Plugin can also delete all drafts, post revisions, scheduled posts or pages and users based on user role.
Bulk delete users based on user role and posts from selected categories, tags, post types, custom taxonomies or by post status like drafts, scheduled