WordPress Plugins For Managing WordPress Post Revisions
In a separate tutorial, we looked at the WordPress Post Revisions feature, where WordPress saves all your post revisions, so you can always go back to an earlier version of what you have written and restore it.
In this tutorial, we look at a number of WordPress plugins that will help you manage your post revisions.
Managing Revisions – WordPress Plugins
As soon as you update your posts/pages, WordPress begins to store new post revisions in its database. You can see these displayed in a Revisions box at the bottom of the post or page …
(Revisions box – Post Editor screen)
Autosave and post revisions are no doubt features that help create a more productive workflow. If you write or edit often, however, the number of revisions can start building up. This can significantly increase the size of your WordPress database, so it’s important to manage your revisions.
(As post revisions accumulate, your WordPress database could be storing lots of unnecessary data)
For example, if you have 200 posts published on your site with an average of 10 revisions each your database could be storing an extra 2,000 copies of old data. If your post is approximately 100KB data, then with 2,000 revisions of that post, the total database space wasted is about 200MB.
Fortunately, there are several plugins for WordPress that can help you control your revisions and reduce the size of your database. Here are some of these:
Better Delete Revision
(Better Delete Revision – WordPress Plugin)
This plugin deletes redundant post revisions from your database and database content belonging to each revision such as relationships, meta data, tags, and more.
After installing and activating the plugin, you can use it to optimize your database.
Go to the admin area and select Settings > Better Delete Revision …
(Better Delete Revision – WP Settings)
This brings you to the Better Delete Revision Manager area. Click ’Check Revision Posts’ to calculate how many redundant post revisions can be deleted from the database …
(Better Delete Revision Manager – Check Revision Posts)
A table of revisions stored in the database will display on the screen …
(Better Delete Revision – Posts revisions)
Click on the ‘Yes, I would like to delete them! …’ button to delete all list items from the database …
(Delete posts revisions list)
The unnecessary items will be cleared from the database …
(Revisions cleared)
After some time has passed, therefore, we recommend repeating this process to keep your WordPress database as light as possible, since WordPress will automatically begin storing all new post revisions again (unless you have chosen to turn the feature off) …
(Revisions automatically start again!)
Like the other plugins described further below, you can also use the plugin to keep your site’s database optimized …
(Keep your database optimized – Better Delete Revision)
Better Delete Revision checks to see if the database tables need optimization and runs an easy one-click database optimization routine without the need to log into your server control panel …
(Better Delete Revision checks if the WP database needs to be optimized)
For more details, go here}:
Optimize Database after Deleting Revisions
(Optimize Database after Deleting Revisions – WordPress Plugin)
This plugin is similar to the one described above. It not only lets you delete unnecessary revisions of posts and pages (with the added option to keep a specific number of your most recent revisions) and lets you perform an easy one-click table cleaning and optimization routine, it also lets you perform the following maintenance tasks:
- Delete trashed pages, posts, and comments
- Delete spammed comments
- Delete ‘expired transients’
- Exclude certain tables or even specific posts/pages from cleaning and optimization
- Create a log file of the optimizations
- And more!
(Optimize Database after Deleting Revisions Plugin – Settings Panel)
For more details, go here}:
WP Optimize
(WP Optimize – WordPress Plugin)
In addition to removing unnecessary revisions of posts and pages and performing optimization maintenance routines, WP Optimize also lets you do the following:
- Enable/Disable trackbacks for published posts
- Removal of trashed comments
- Mobile device friendly
- Removal of all transient options
- Clean up auto draft posts
- Ability to retain selected number of weeks data when cleaning up
- Option to add or remove link on WP admin bar
- Enable/Disable weekly optimization scheduling
- See database table statistics (e.g. how much space has been cleared
- Receive email notifications after scheduled cleanups
- Displays dangerous cleanup operations in red
- And more!
(WP Optimize Plugin For WordPress – Settings Page)
For more details, go here}:
WP-Sweep
(WP Sweep – WordPress Plugin)
In addition to optimizing your database tables and deleting unnecessary post revisions, WP-Sweep also cleans up:
- Auto drafts
- Unapproved comments
- Orphaned user meta
- Duplicated post meta
- Unused terms
- And more!
(WP-Sweep WP Plugin – Settings Panel)
For more details, go here}:
For more plugins that can help you manage post revisions and optimize your database, go to Plugins > Add New and type in keywords like “Revisions“, “Database Optimize“, etc …
(Add Plugin – Plugins Menu)
We hope that you have found the above information on plugins that will help you manage your WordPress post revisions useful.
***
"If you're new to WordPress, this can stand on its own as a training course and will stay with you as you progress from beginner to advanced and even guru status." - Bruce (Columbus, Ohio)
***