Type to search.

#690 by installs

Optimize Database after Deleting Revisions

by NerdPressVersion 5.3.0

One-click database optimization with precise revision cleanup and flexible scheduling. Speeding up sites since 2011!

Active installs
60,000+
#690 of 1,000
Downloads, all time
4M
4,002,989
Downloads, 30 days
4.6K
1.2K in the last 7
Rating
4.7 / 5
181 reviews
Last updated
5 months ago
May 21, 2026
Version
5.3.0
144 releases

Upkeep and compatibility

Last updatedMay 21, 2026Updated in the last year
Tested up toWordPress 7.0.8Older than WordPress 7.1.4, the current release
Needs WordPress2.8 or newer
Needs PHP5.6 or newer
First publishedNovember 23, 2011
Support, last two monthsNo threads opened

Reviews

4.7 / 5 from 181 reviews

Reviews by star rating
5 stars161
4 stars7
3 stars3
2 stars1
1 star9

Downloads, last 30 days

Low 64 a dayHigh 474 a day

What the author says it does

NerdPress has adopted Optimize Database After Deleting Revisions! Read the announcement here.

This plugin is a ‘One Click’ WordPress database cleaner & optimizer, with precise revision cleanup and flexible scheduling.

Main Features

  • Deletes revisions of posts, pages and / or custom post types (you optionally can keep an ‘x’-amount of the most recent revisions and you can choose to delete revisions older than…)
  • Deletes trashed posts, pages and comments (optional)
  • Deletes spammed comments (optional)
  • Deletes unused tags (optional)
  • Deletes ‘expired or all transients’ (optional)
  • Deletes ‘pingbacks’ and ‘trackbacks’ (optional)
  • Clears the ‘OEMBED cache’ (optional)
  • Deletes ‘orphan postmeta items’
  • Optimizes the database tables (optionally you can exclude certain tables, or even specific posts/pages, from optimization)
  • Creates a log of the optimizations (optional)
  • Optimization can be scheduled to automatically run once hourly, twice daily, once daily or once weekly at a specific time (optional)
  • ‘Optimize DB (1 click)’ link in the admin bar (optional)
  • ‘Optimize Database’ Icon in the admin menu (optional)
  • MULTISITE compatible: optimizes all sites in the network with one click

Settings

You can find the settings page in the WP Admin Panel » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings)

The opening of the plugin's own description. The full text, installation notes and changelog are on its WordPress.org page.

Questions the author answers

How can I change the settings of this plugin?
  • Change the settings in the WP Admin Panel » Settings » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings)
How do I run this plugin?
  • Go to: Dashboard » Tools &araquo; Optimize Database. Then click the ‘Start Optimization’-button -or- via the WP Admin Panel » Optimize Database icon (depends on settings)
  • Click the ‘Optimize DB (1 click)’ link in the Admin Bar (if enabled)
How do I run the Analyzer?
  • Go to: Dashboard » Tools » Optimize Database and click the ‘Analyze Database’ button
Why do I see ‘InnoDB table: skipped…’?
  • That’s because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
  • Update: if you want to optimize your InnoDB tables too, just check the ‘Optimize InnoDB tables too’ option on the settings page
  • IMPORTANT: optimizing InnoDB tables, might increase the size of the database! However, it will speed up the performance of the database
After I ran the plugin, I got “Total savings since the first run: -64 KB”
  • Sometimes that happens when you optimize InnoDB tables (instead of MyISAM tables).

Optimizing InnoDB tables works differently than MyISAM.

InnoDB focuses on speed optimization and sometimes it means the database can grow a little.

I scheduled the optimization for 8pm but it runs at 6pm (my local time)
  • The scheduler uses the local time of the web server which can differ from your own local time

Latest changelog entry

5.3.0 [07/21/2025]

  • 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 fatal error on very old PHP 5.x. (Note, future updates will require newer PHP versions!)
  • Fix deprecation warning on PHP 8.3.
  • Tested up to 6.8.

Tagged

Plugins that share its tags

#290 by installs

Search Regex

by John Godley

Search Regex adds a powerful set of search and replace functions to WordPress posts, pages, custom post types, and other data.

Installs
100,000+
Rating
4.7 (101)
Updated
25 days ago

#292 by installs

WP-Sweep

by Lester Chan

WP-Sweep allows you to clean up unused, orphaned and duplicated data in your WordPress. It also optimizes your database tables.

Installs
100,000+
Rating
4.7 (138)
Updated
2 months ago

#477 by installs

Go Live Update Urls

by Mat Lipe

Change the domain on your site with one click.

Installs
90,000+
Rating
4.5 (59)
Updated
4 days ago

#514 by installs

BackUpWordPress

by Tom Willmot

Simple automated backups of your WordPress-powered website.

Installs
80,000+
Rating
4.7 (1.4K)
Updated
3 years ago

#624 by installs

Database Backup for WordPress

by WP Engine

Database Backup for WordPress is your one-stop database backup solution for WordPress.

Installs
60,000+
Rating
4.5 (66)
Updated
6 months ago

Where this page's numbers come from

Read from the WordPress.org plugin API on , when WordPress 7.1.4 was the current release. WordPress.org rounds active installs into buckets. These are the directory's figures, not my verdict, and I haven't tested this plugin.