Optimize Database after Deleting Revisions


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

Este plugin es un limpiador y administrador de bases de datos de WordPress de «un clic». optimizador, con limpieza de revisión precisa y programación flexible.

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


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)

Excluding specific posts/pages from deleting revisions

If you want to keep revisions for a specific post/page (no matter what the other settings are), create a custom field named ‘keep_revisions’ for that post/page and give it the value ‘Y’

Iniciando el análisis / optimización

You can start the Optimization in the WP Admin Panel » Optimize Database.
Note: if you use the Scheduler the Optimization will run automatically!
Note: you also can click the ‘Optimize DB (1 click)’ link in the admin bar (if enabled)
You can click one of the following buttons:
‘Analyze (summary): analyzes the database and gives the count of what will be cleaned
‘Analyze (detail): analyzes the database and gives a detailed report of what will be deleted
‘Optimize (summary): actually deletes the items and gives the count of what has been deleted
‘Optimize (detail): actually deletes the items and gives a detailed report of what has been deleted

Multisite Support

  • Install the plugin as Network Administrator (Network Admin » Plugins)
  • ‘Network Activate’ the plugin
  • You only can configure and run the plugin on the main network site, but it will optimize ALL the sub-sites too!

Ejecutando el plugin desde un crontab de Unix

In case you cannot use WPCron, but you can edit the Unix crontab:

Create a .php file, in the root directory of your site, with:
define(‘RUN_OPTIMIZE_DATABASE’, true);

Then, start the .php file from your crontab!

Supported languages

  • Belarus [be_BY] – translated by Natasha – https://www.ustarcash.com/ – keyword UStarCash
  • Danish [da_DK] – translated by Alexander Leo-Hansen – http://alexanderleohansen.dk
  • Dutch [nl_NL] – translated by Rolf van Gelder, CAGE Web Design – http://cagewebdev.com
  • English [en_US] – translated by Rolf van Gelder, CAGE Web Design – http://cagewebdev.com
  • French [fr_FR] – translated by Guillaume Blet – http://www.mycinetheque.fr
  • Alemán [de_DE] – traducido por Kolja Spyra
  • Indonesian [id_ID] – translated by ChameleonJohn.com
  • Italian [it_IT] – translated by Fabio Marzocca
  • Persian [fa_IR] – translated by Milad Mordi, http://seodaramal.ir
  • Portuguese [po_BR] – translated by Rede Sul Mineira de Comunicações
  • Russian [ru_RU] – translated by Vadim Sokhin, PluginZone – http://pluginzone.ru
  • Serbian [sr_RS] – translated by Ogi Djuraskovic, FirstSiteGuide – http://firstsiteguide.com
  • Swedish [sv_SE] – translated by P.E.
  • Turco [tr_TR] – traducido por Keremcan Buyuktaskin
  • Ukranian [uk_UA] – translated by Anna Goriacha, Coupofy – http://coupofy.com




Single site

  • Upload the Plugin to the /wp-content/plugins/ directory
  • Activate the plugin in the WP Admin Panel » Plugins
  • Change the settings (if needed) in the WP Admin Panel » Settings » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings)


  • Install the plugin as Network Administrator (Network Admin » Plugins)
  • ‘Network Activate’ the plugin
  • The settings are the same for ALL sites in the network, so if you change a setting for one site, it will be used for all other sites.
  • If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!


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)

¿Cómo ejecuto el analizador?

  • 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

Después de ejecutar el plguin, obtuve un «Ahorro total desde la primera ejecución: -64 KB».

  • A veces eso sucede cuando optimizas tablas InnoDB (en lugar de tablas MyISAM).
    La optimización de tablas InnoDB funciona de manera diferente a MyISAM.
    InnoDB se centra en la optimización de la velocidad y, a veces, esto significa que la base de datos puede crecer un poco.

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

El plugin es visible en las herramientas del sitio principal pero no en mis subsitios

  • Multisite Support
    – Install the plugin as Network Administrator (Network Admin » Plugins)
    – ‘Network Activate’ the plugin
    – You only can configure and run the plugin on the main network site, but it will optimize ALL the sub-sites too!


9 de mayo de 2024 2 respuestas
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 🙂
29 de noviembre de 2022
I am using this plugin for years on a few websites, never had an issue. Very efficient. Thanks!
17 de abril de 2021
very good plugin, set up and it works automatically and clean the site.
Leer todas las 179 reseñas

Colaboradores y desarrolladores

«Optimize Database after Deleting Revisions» es un software de código abierto. Las siguientes personas han colaborado con este plugin.


«Optimize Database after Deleting Revisions» está traducido en 14 idiomas. Gracias a los traductores por sus contribuciones.

Traduce «Optimize Database after Deleting Revisions» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

5.2.2 [02/07/2024]

  • 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.1 [02/05/2024]

  • Add missing nonce on «Optimize DB (1 click)» admin bar link.
  • Remove «Optimize» buttons from Log page.
  • Fix PHP 8 Deprecation Notices.

5.2 [01/31/2024]

  • 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 sanitization of database queries.
  • Fix: PHP 8 Deprecation Notice.

5.1.1 [01/24/2024]

  • Security improvement: Hardens links to prevent CSRF.
  • Security fix: Implements proper preparation of queries.

5.1 [08/02/2023]

  • BUG FIX: Fixed the CSRF security issue

5.0.10 [10/26/2021]

  • BUG FIX: set_time_limit fixed

5.0.9 [08/04/2021]

  • BUG FIX: Syntax error corrected

5.0.8 [08/03/2021]

  • BUG FIX: Some performance inprovements (2nd try)

5.0.7 [07/24/2021]

  • BUG FIX: Changed back to v5.0.4

5.0.6 [07/23/2021]

  • BUG FIX: Scheduler fixed

5.0.5 [07/20/2021]

  • BUG FIX: Some performance inprovements

5.0.4 [02/26/2021]

  • BUG FIX: Field names INFORMATION_SCHEMA corrected

5.0.3 [11/17/2020]

  • BUG FIX: Creating log table if not exists

5.0.2 [11/06/2020]

  • BUG FIX: Deletion of orphaned term relationships deactivated

5.0.1 [09/10/2020]

  • BUG FIX: Deletion of Duplicated Postmeta entries deactivated

5.0 [08/14/2020]

  • New: Deletion of Duplicated Postmeta entries

4.9.1 [05/17/2020]

  • BUG FIX: Fixed a bug for deleting orphans

4.9 [04/10/2020]

  • NEW: Deletion of orphaned term relationships

4.8.8 [12/02/2019]

  • BUG FIX: Fixed an (innocent) warning (while cleaning)

4.8.7 [09/28/2019]

  • BUG FIX: Bug fix for ‘Delete revisions older than’

4.8.6 [09/22/2019]

  • BUG FIX: Some bug fixes + other minor changes

4.8.5 [09/19/2019]

  • BUG FIX: Logging bug fixed

4.8.4 [09/07/2019]

  • CHANGE: Improved performance

4.8.3 [09/01/2019]

  • BUG FIX: Scheduler bug fixed

4.8.2 [08/15/2019]

  • CHANGE: Rewrote the deletion of (expired) transients

4.8.1 [07/15/2019]

  • BUG FIX: Scheduler bug fixed

4.8.0 [05/26/2019]

  • NEW: New analyze / optimize options (summary or detail)

4.7.4 [01/05/2019]

  • CHANGE: ‘set_time_limit’ warning suppressed
  • CHANGE: Some lay-out fixes
  • NEW: Added a ‘help’-button on the settings page

4.7.3 [12/12/2018]

  • CHANGE: The deletion of transients has been fully rewritten and is many times faster now!
  • CHANGE: Increased the time_limit
  • CHANGE: German translations have been updated

4.7.2 [11/12/2018]

  • BUG FIX: Fixed a MySQL query

4.7.1 [11/11/2018]

  • BUG FIX: Fixed an ‘undefined variable’ notice

4.7 [11/10/2018]

  • NEW: Optional analysis before actual cleaning
  • CHANGE: Many minor improvements
  • BUG FIX: Several bug fixes

4.6.3 [08/23/2018]

  • CHANGE: Removed the MyISAM engine for the log table (now it uses the default-storage-engine of the database)

4.6.2 [06/05/2018]

  • BUG FIX: Fixed a javascript bug for the ‘Clear Log’ confirmation
  • NEW: PayPal donation button

4.6.1 [06/04/2018]

  • BUG FIX: Fixed the WordPress Admin Menu dropdowns on ‘View Log’ page

4.6 [05/08/2018]

  • NEW: Logging system has been totally rewritten (from now it will store the logs in the database)
  • NEW: Export the log to a CSV file

4.5.2 [03/21/2018]

  • NEW: Clear OEMBED cache
  • BUG FIX: Translation corrected (‘Next scheduled run: 0 days, 9 hours, 35 minutes and 27 seconds’)

4.5.1 [01/29/2018]

  • NEW: Added last run seconds
  • NEW: French translation added
  • BUG FIX: Fixed a typo (‘DELETEED’)

4.5 [01/08/2018]

  • CHANGE: Revamped and improved the scheduler code

4.4.3 [01/06/2018]

  • BUG FIX: Fixed some scheduler time issues

4.4.2 [12/14/2017]

  • NEW: Skip standard posttype ‘oembed_cache’
  • BUG FIX: Hide the settings link (plugin page) for multi site sites (except for the main network site)

4.4.1 [11/06/2017]

  • BUG FIX: Bug in counting excluded tables fixed

4.4 [08/22/2017]

  • NEW: New options to delete revisions of posts, pages and / or specific custom post types

4.3.2 [08/12/2017]

  • CHANGE: Fixed some (innocent) PHP warnings

4.3.1 [08/10/2017]

  • NEW: New option for deleting ALL transients (not the expired ones only)

4.3 [07/24/2017]

  • NEW: New setting added: Delete revisions of (POSTS and PAGES, POSTS only or PAGES only)
  • CHANGE: Some code clean-up and minor changes

4.2.3 [07/05/2017]

  • CHANGE: Extra save button added to the settings page

4.2.2 [04/06/2017]

  • NEW: Indonesian (id_ID) translation added

4.2.1 [09/23/2016]

  • CHANGE: Fixed some (innocent) warnings

4.2.0 [09/16/2016]

  • NEW: Added a ‘monthly’ schedule to the scheduler

4.1.10 [07/15/2016]

  • BUG FIX: Bug fix for 4.1.9

4.1.9 [07/15/2016]

  • CHANGE: ‘Running indicator’ added

4.1.8 [06/24/2016]

  • CHANGE: Reverted back to 4.1.6 due to some problems. Sorry!

4.1.7 [06/23/2016]

  • CHANGE: Orphaned media items will be deleted too now

4.1.6 [05/20/2016]

  • NEW: Belarus (be_BY) translation added (thanks Natasha!)

4.1.5 [03/11/2016]

  • NEW: Turkish (tr_TR) translation added (thanks Keremcan Buyuktaskin!)

4.1.4 [03/02/2016]

  • NEW: Custom field ‘keep_revisions’, for excluding the deletion of revisions for specific posts/pages
  • NEW: Run the optimization from a Unix crontab (if possible)

4.1.3 [02/22/2016]

  • BUG FIX: Saving settings didn’t work well for multi-sites

4.1.2 [02/14/2016]

  • NEW: Brasilian Portuguese (po_BR) translation added
  • NEW: Network: True added to the plugin header

4.1.1 [01/17/2016]

  • CHANGE: Use can use the ‘Delete revisions older than’ AND ‘Keep max number of revisions’ options at the same time!

4.1 [01/14/2016]

  • NEW: New option: delete revisions older than…
  • NEW: Persian translation (fa_IR) added
  • CHANGE: For multi-site installations you only can use the plugin on the Main site, but all other sites will be cleaned too.
  • CHANGE: Some minor updates / changes

4.0.3 [12/17/2015]

  • BUG FIX: Bug fix for Cron Schedules
  • BUG FIX: Un-installation generated an error
  • CHANGE: Some minor updates / changes

4.0.2 [11/28/2015]

  • BUG FIX: Settings weren’t saved correctly for MultiSites

4.0.1 [11/27/2015]

  • NEW: New option: optimize InnoDB tables too
  • BUG FIX: Localization fixed for extra cron schedules
  • BUG FIX: De-activation issue on update fixed

4.0 [11/22/2015]

  • NEW: Total rewrite of the code (OO code)
  • CHANGE: Many changes and bug fixes

3.5.1 [11/01/2015]

  • BUG FIX: Views are skipped from the optimization

3.5 [10/24/2015]

  • CHANGE: Stylesheet is only loaded on required admin pages

3.4.9 [10/23/2015]

  • BUG FIX: Bug fixed for deleting unused tags

3.4.8 [09/14/2015]

  • BUG FIX: Bug fixed for deleting transients

3.4.7 [08/30/2015]

  • BUG FIX: Transients are now deleted using the delete_transient() / delete_site_transient() functions

3.4.6 [06/21/2015]

  • NEW: Danish translation (da_DK) added

3.4.5 [06/07/2015]

  • NEW: Russian translation (ru_RU) added

3.4.4 [06/03/2015]

  • NEW: German translation (de_DE) added

3.4.3 [06/01/2015]

  • NEW: Swedish translation (sv_SE) added

3.4.2 [05/10/2015]

  • BUG FIX: fixed a bug (options didn’t get saved in old multisite installs)

3.4.1 [04/26/2015]

  • BUG FIX: fixed a bug for the excluded tables (didn’t work anymore)

3.4 [04/24/2015]

  • NEW: Ukrainian translation (uk_UA) added
  • CHANGE: updates for Dutch and Italian translations
  • CHANGE: a new, fresh look!
  • CHANGE: a better way to show the EXCLUDED tables on the settings page

3.3.1 [04/08/2015]

  • BUG FIX: fixed a bug with the scheduler (it didn’t clean everything)

3.3 [03/27/2015]

  • NEW: MULTISITE support added (second try ;-))
  • CHANGE: various minor improvements
  • BUG FIX: sub-sites are accessible again (in the admin panel)

3.2.1 [03/18/2015]

  • CHANGE: due to problems, I removed the MULTISITE support again for now… Sorry about that!

3.2 [03/18/2015]

  • NEW: MULTISITE support added
  • CHANGE: various minor improvements

3.1.4 [03/01/2015]

  • NEW: italian language support [it_IT] added (thanks Fabio Marzocca!)
  • NEW: optimization timer
  • CHANGE: from now on InnoDB tables are skipped from optimization
  • CHANGE: various minor improvements
  • BUG FIX: removed strtolower while fetching database properties

3.1.3 [02/21/2015]

  • NEW: showing the icon in the admin menu is now configurable via the settings page

3.1.2 [02/20/2015]

  • BUG FIX: fixed the link to the settings page

3.1.1 [02/20/2015]

  • NEW: added plugin banners and icons
  • NEW: added a new admin menu item with icon (‘Optimize Database’)
  • CHANGE: moved the language files to the ‘/language’ directory
  • CHANGE: moved the styles to the ‘/css’ directory
  • CHANGE: credit removed from the front-end pages

3.1 [01/29/2015]

  • NEW: deletion of pingbacks and trackbacks (optional)
  • CHANGE: link to settings page in the main plugins page

3.0 [12/28/2014]

  • BUG FIX: tags only used in scheduled posts won’t be deleted anymore (thanks Michael!)

2.9 [10/22/2014]

  • NEW: plugin has been fully localized
  • NEW: dutch language support [nl_NL] added
  • NEW: serbian language support [sr_RS] added

2.8.3 [09/10/2014]

  • CHANGE: using the WP jQuery libs now (not from googleapis anymore)
  • BUG FIX: check_admin_referer() fixed (gave a debug warning)

2.8.2 [08/01/2014]

  • BUG FIX: all problems with getting the table names should be fixed now!

2.8.1 [07/31/2014]

  • CHANGE: changed the ‘edit_themes’ capability back to ‘administrator’-role
  • BUG FIX: no table names beside checkboxes (rewrote it, so it should work for every site now)

2.8 [07/30/2014]

  • CHANGE: ‘administrator’-role changed to ‘edit_themes’-capability
  • BUG FIX: no table names beside checkboxes

2.7.9 [05/02/2014]

  • BUG FIX: some minor bug fixes (thanks Mike!)

2.7.8 [05/01/2014]

  • CHANGE: replaced depreciated MySQL queries (from WP 3.9 / PHP 5.5)

2.7.7 [02/16/2014]

  • BUG FIX: made jQuery also https compatible

2.7.6 [01/16/2014]

  • BUG FIX: empty lines removed from output (gave problems with some RSS feeds)

2.7.5 [12/13/2013]

  • CHANGE: two queries optimized for better performance

2.7.4 [12/11/2013]

  • BUG FIX: added ‘backticks’ around the database name in a few queries

2.7.3 [12/09/2013]

  • BUG FIX: deleted some CR/LF’s from the end of the plugin sigh

2.7.2 [12/09/2013]

  • BUG FIX: forgot to delete a debug item… oops! sorry!

2.7.1 [12/09/2013]

  • BUG FIX: query and depreciated item (mysql_list_tables) fixed

2.7 [12/06/2013]

  • NEW: deletion of expired transients (optional)

2.6 [07/22/2013]

  • NEW: deletion of unused tags (optional)

2.5.1 [05/24/2013]

  • BUG FIX: some short tags removed
  • CHANGE: schedule time is only relevant and therefore only shown for ‘daily’ and ‘weekly’ schedules
  • NEW: option to turn the ‘1-click’ button in the admin bar on/off

2.5 [05/24/2013]

  • NEW: you can set a time (hour) for the scheduler to run (thanks to frekel)
  • NEW: ‘1-click run button’ in the admin bar (thanks to JB ORSI)

2.3.1 [05/03/2013]

  • BUG FIX: fixed a problem with ‘invalid header’ (during installation)

2.3 [04/26/2013]

  • BUG FIX: fixed the ‘Stealing Cron Schedules’ issue

2.2.9 [04/10/2013]

  • BUG FIX: bug fix for the ‘check all NON-WordPress tables’ link

2.2.8 [03/19/2013]

  • BUG FIX: bug fix for deleting Post Orphans

2.2.7 [03/18/2013]

  • NEW: ‘Orphan Post items’ (like ‘Auto Drafts’) will be automatically deleted too now (thanks to: 0izys)

2.2.6 [03/05/2013]

  • Text change: ‘logging on’ changed to ‘keep a log’ (thanks to: Neil Parks)
  • NEW: number of orphans deleted now also shown in the log file
  • NEW: ‘Go To Optimizer’ button on settings page (thanks to: RonDsy)

2.2.5 [02/20/2013]

  • Bug fix: fixed an (innocent) PHP warning (in error.log)

2.2.4 [02/12/2013]

  • Bug fix: error corrected in readme.txt file

2.2.3 [02/09/2013]

  • Bug fix: fixed an (innocent) PHP warning (in error.log)

2.2.2 [01/20/2013]

  • Bug fix: deleting of postmeta orphans didn’t work correctly

2.2.1 [01/17/2013]

  • Bug fix: fixed some debug warnings

2.2 [01/11/2013]

  • NEW: ‘Orphan Postmeta items’ will be automatically deleted
  • NEW: the possibility to exclude tables from Optimization (for instance for ‘heavy traffic’ tables)

2.1 [01/04/2013]

  • Bug fix: keeping a maximum number of revisions didn’t work correctly

2.0 [12/18/2012]

  • NEW: Logging of the Optimizations (optional)
  • NEW: Scheduling Optimizations for Automatic Execution (optional)
  • Many other (technical and cosmetical) changes and improvements

1.3.4 [12/14/2012]

  • Changed the buttons for WP 3.5

1.3.3 [12/01/2012]

  • Some layout changes

1.3.2 [11/14/2012]

  • Shows more information about the optimized tables + other minor changes

1.3.1 [10/07/2012]

  • Cambios menores

1.3 [10/06/2012]

  • Extra button for starting optimization, shows savings (in bytes) now

1.2 [10/03/2012]

  • Major update: new options ‘delete trash’, ‘delete spam’, ‘only optimize WordPress tables’

1.1.9 [09/27/2012]

  • Using a different method for retrieving database table names

1.1.8 [09/08/2012]

  • Another link fix

1.1.7 [09/03/2012]

  • Some textual and link fixes

1.1.6 [09/01/2012]

  • Fixed the link to the settings page

1.1.3 [09/01/2012]

  • Moved the ‘Optimize DB Settings’ item to Dashboard ‘Settings’ Menu and the ‘Optimize Database’ item to the Dashboard ‘Tools’ Menu. That makes more sense!

1.1.2 [08/30/2012]

  • Minor bug fix for the new option page

1.1 [08/29/2012]

  • Added: a new option page, in de plugins section, where you can define the maximum number of – most recent – revisions you want to keep per post or page

1.0.5 [08/21/2012]

  • Depreciated item (‘has_cap’) replaced, abandoned line of code removed

1.0.4 [06/06/2012]

  • Now also works with non short_open_tag’s

1.0.3 [12/15/2011]

  • Some minor layout updates

1.0.2 [12/02/2011]

  • Some minor updates

1.0.1 [11/24/2011]

  • A few updates for the readme.txt file

1.0 [11/22/2011]

  • Version inicial