Optimize Database after Deleting Revisions

Plugin works exactly as described. Thanks! It was easy to configure and I especially like the ability to remove all revisions except for XX amount, which makes it great for cleaning up existing sites where you’ve reduced the number of revisions, but the database still contains heaps of older revisions.

I have used this plugin on 5 different multi-site wordpress and have achieved awesome results. Here’s the best one:

• 13779 revisions deleted
• database size reduced from 297MB to 65MB = 22% of original size!!
• this lead to an 11% speed gain (server side execution time to generate the page)
• we had such good results, because we had no limit on the number of revisions per post a few years back. wordpress does not automatically clean the revisions. The revisions for a post, only get cleaned up when you actually work on a post. In our case we had revisions from 2015 that were still encumbering the database.
  

Those are the settings I used:
Delete revisions of: POST, PAGE, USER_REQUEST, WP_BLOCK, WP_TEMPLATE, WP_TEMPLATE_PART, WP_GLOBAL_STYLES, WP_NAVIGATION, WP_FONT_FAMILY, WP_FONT_FACE
Delete revisions older than: 720 days
Maximum number of - most recent - revisions to keep per post / page: 25
Delete trashed items: YES
Delete spammed items: YES
Delete unused tags: YES
Delete transients: NO
Delete pingbacks and trackbacks: YES
Clear oEmbed cache: NO
Keep a log: YES
Optimize InnoDB tables: YES
Number of excluded tables: 0

I’ve reviewed the plugin’s source code and tested it extensively and found out a few issues in the source code that I have shared with the maintainers. Overall, I think this plugin is safe to use, provided you backup your database before and that you fully understand what you’re doing.

I tested this on two different sites, one almost clean, another one well up and running. The same result on both of them. Misconfigured references in the database and wordpress error messages. Its no longer possible to save data to the database. This obviously also includes trying to install or unistall plugins. The website is dead in the water.

Been troubleshooting this for a while now, reading other users experiences with this plugin. The takeaway is that this is a kind of “Install and see how it goes” kind of deals.

Sitting here waiting to load in my backup, but guess what 🙂
This plugin used over 100.000 database-updates to run once. My webhost has a limitation on 100.000 udates pr. hour, so no backup goes back in for the next hour.

If for some reason one of your hobbies are to run head first (as fast as you can) into a brick wall, and by that I mean try to install this plugin……..Pretty Please, with sugar on top, take a fresh backup 🙂

I consider Optimize Database an essential plugin for every website.

I am using this plugin for years on a few websites, never had an issue. Very efficient. Thanks!