Optimize Database after Deleting Revisions

How well this listing is tuned to rank in WordPress.org search, on the factors an owner controls. Not popularity, optimization.

Directory searches this plugin turns up in, and which way each one is moving. WordPress.org publishes no history of search positions, so this starts the day we first tracked a keyword and never backfills.

wp.org is where the directory puts the plugin for that search. On merit is where it would sit if results were ranked on rating, support and updates, without the install boost. The last column is how far the wp.org position moved, from our first reading in the last 90 days to the latest.

119 searches this plugin appeared in over the last 90 days, 20 listed. 92 left out as unrelated or noise (years, numbers, stray words).

Directory rank vs rivals

wp.org popularity rank over time · higher is better · when a rival's line climbs above yours, they've overtaken you

How often this plugin actually ships. A steady rhythm is the maintenance signal a single "last updated" date can't show.

Share of active installs on each version of this plugin · 62% run the current release. Green is the current release; a big slice on older versions is a user base that has stopped updating.

Crossed into this band 12 months ago; a band this size takes about a year or more to cross, which places it about 50% of the way through.

1. ★★★★★ Anthony Hortin

   1.9y ago

   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.

   Read on wp.org ↗
2. ★★★★★ copytrans

   2.2y ago

   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_FACEDelete revisions older than: 720 daysMaximum number of - most recent - revisions to keep per post / page: 25Delete trashed items: YESDelete spammed items: YESDelete unused tags: YESDelete transients: NODelete pingbacks and trackbacks: YESClear oEmbed cache: NOKeep a log: YESOptimize InnoDB tables: YESNumber 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.

   Read on wp.org ↗
3. ★★★★★ ⠚⠁⠗⠇

   2.5y ago

   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 🙂

   Read on wp.org ↗
4. ★★★★★ Das Capitolin

   3.5y ago

   I consider Optimize Database an essential plugin for every website.

   Read on wp.org ↗
5. ★★★★★ wpprup

   3.9y ago

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

   Read on wp.org ↗
6. ★★★★★ novakpeter

   4.4y ago

   Works like a breeze!

   Read on wp.org ↗
7. ★★★★★ yevhenwordpress

   5.3y ago

   Just another good feedback about a useful plugin.

   Read on wp.org ↗
8. ★★★★★ eerkan

   5.5y ago

   very good plugin, set up and it works automatically and clean the site.

   Read on wp.org ↗

Recent releases and news for this plugin

1. — Version 5.3.0 Fix issue where deactivation and uninstallation routines would not run as intended. oEmbed caches are no longer fully embedded in detail reports, but instead show stored HTML to save resources and improve security. Fix f 5.3.0
2. — Version 5.2.2 Some links looked like buttons. They’re now links. Fix sanitization for databases and table prefixes with capital letters. Removed unnecessary FROM clause in the table lookup query. 5.2.2
3. — Version 5.2.1 Add missing nonce on “Optimize DB (1 click)” admin bar link. Remove “Optimize” buttons from Log page. Fix PHP 8 Deprecation Notices. 5.2.1
4. — Version 5.2 NerdPress has adopted Optimize Database After Deleting Revisions! Read the announcement here. Security improvement: Additional CSRF hardening. Security improvement: Add capability checks. Security improvement: Improve sa 5.2
5. — Version 5.1.1 Security improvement: Hardens links to prevent CSRF. Security fix: Implements proper preparation of queries. 5.1.1
6. — Version 5.1 BUG FIX: Fixed the CSRF security issue 5.1

All 3 disclosed vulnerabilities are patched in the current version (5.3.0). Sites still on an older version should update.

1. Patched Medium · 5.3 Optimize Database after Deleting Revisions <= 5.0.110 - Missing Authorization via 'odb_csv_download' ↗
   2023-10-03 Missing Authorization Affects <= 5.0.110 Patched in 5.1
2. Patched Medium · 4.3 Optimize Database after Deleting Revisions <= 5.1.1 - Cross-Site Request Forgery via 'odb_start_manually' ↗
   2023-07-26 CVE-2023-25980 Cross-Site Request Forgery Affects <= 5.1.1 Patched in 5.2
3. Patched Medium · 4.3 Optimize Database after Deleting Revisions <= 5.0.110 - Cross-Site Request Forgery via 'odb_csv_download' ↗
   2023-07-26 Cross-Site Request Forgery Affects <= 5.0.110 Patched in 5.1

Automated install-time checks, tested on PHP 8.1.12 · WP 6.8.2

Translated into 59 languages, 16 at 90% or more

Plus 35 more locales with partial translations.

Whether ChatGPT and Claude name this plugin when asked the category question, and whether the readme gives them something to quote.

Not measured yet for this plugin’s topics. Its tracked searches are not among the measured topics. See the topics measured so far.

Growth timeline

Install-tier crossings we have observed, and how long each tier took to outgrow

1. 2025-11-03 70K+ → 60K+ down after 328 days in tier
2. 2024-12-10 80K+ → 70K+ down after 318 days in tier
3. 2024-01-27 100K+ → 80K+ down after 2127 days in tier
4. 2018-04-01 90K+ → 100K+ up after 70 days in tier
5. 2018-01-21 80K+ → 90K+ up after 230 days in tier
6. 2017-06-05 70K+ → 80K+ up after 184 days in tier
7. 2016-12-03 60K+ → 70K+ up after 120 days in tier
8. 2016-08-05 50K+ → 60K+ up after 248 days in tier

Competes with

The plugins that solve the same job, ranked by shared tags then reach, closest match first. The letter on the right is each plugin's health grade (A best, F worst).

Embed this report card

Drop a live Pulse card for Optimize Database after Deleting Revisions into a readme, a review or a deck. It updates itself.

Optimize Database after Deleting Revisions: 60K+ active installs, 4.7★ (181 reviews). Plugin Pulse (WP Mayor), as of 2026-10-31. https://plugins.wpmayor.com/plugin/rvg-optimize-database