Optimize Database after Deleting Revisions Plugin

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)

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’

Starting the Analysis / Optimization

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!

Running the plug in from a Unix crontab

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:
<?php
define(‘RUN_OPTIMIZE_DATABASE’, true);
require_once(‘wp-load.php’);
?>

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
• German [de_DE] – translated by 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.
• Turkish [tr_TR] – translated by Keremcan Buyuktaskin
• Ukranian [uk_UA] – translated by Anna Goriacha, Coupofy – http://coupofy.com

Disclaimer

NO WARRANTY, USE IT AT YOUR OWN RISK! MAKE BACKUPS FIRST!

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)

Multisite

• 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!

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]

• Minor changes

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]

• Initial release