Optimize Database after Deleting Revisions

Wordpress Plugin
Download latest - 5.0.4

Developers

cageehv

Download Stats

Today 2,414
Yesterday 2,887
Last Week 18,833
All Time 1,730,014
Banner 772x250

This plugin is a 'One Click' WordPress Database Cleaner / Optimizer.

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

Author

CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com - http://rvg.cage.nl

Plugin URL

http://cagewebdev.com/optimize-database-after-deleting-revisions-wordpress-plugin

Download URL

http://wordpress.org/plugins/rvg-optimize-database/

Disclaimer

NO WARRANTY, USE IT AT YOUR OWN RISK!

Plugins by CAGE Web Design | Rolf van Gelder

WordPress plugins created by CAGE Web Design | Rolf van Gelder
http://cagewebdev.com/category/news-tech-art/wordpress/


Releases (126 )

Version Release Date Change Log
4.9.1 2020-05-17

[05/17/2020] = * BUG FIX: Fixed a bug for deleting orphans

4.9 2020-04-10

[04/10/2020] = * NEW: Deletion of orphaned term relationships

4.8.8 2019-12-02

[12/02/2019] = * BUG FIX: Fixed an (innocent) warning (while cleaning)

4.8.7 2019-09-28

[09/28/2019] = * BUG FIX: Bug fix for 'Delete revisions older than'

4.8.6 2019-09-22

[09/22/2019] = * BUG FIX: Some bug fixes + other minor changes

4.8.5 2019-09-19

[09/19/2019] = * BUG FIX: Logging bug fixed

4.8.4 2019-09-07

[09/07/2019] = * CHANGE: Improved performance

4.8.3 2019-09-01

[09/01/2019] = * BUG FIX: Scheduler bug fixed

4.8.2 2019-08-15

[08/15/2019] = * CHANGE: Rewrote the deletion of (expired) transients

4.8.1 2019-07-15

[07/15/2019] = * BUG FIX: Scheduler bug fixed

4.8.0 2019-05-26

[05/26/2019] = * NEW: New analyze / optimize options (summary or detail)

4.7.4 2019-01-28

[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 2018-12-12

[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 2018-11-12

[11/12/2018] = * BUG FIX: Fixed a MySQL query

4.7.1 2018-11-11

[11/11/2018] = * BUG FIX: Fixed an 'undefined variable' notice

4.6.3 2018-08-23

[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 2018-06-05

[06/05/2018] = * BUG FIX: Fixed a javascript bug for the 'Clear Log' confirmation * NEW: PayPal donation button

4.6.1 2018-06-04

[06/04/2018] = * BUG FIX: Fixed the WordPress Admin Menu dropdowns on 'View Log' page

4.6 2018-05-08

[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 2018-03-22

[03/21/2018] = * NEW: Clear oEmbed cache (optional) * BUG FIX: Translation corrected ('Next scheduled run: 0 days, 9 hours, 35 minutes and 27 seconds')

4.5.1 2018-01-29

[01/29/2018] = * NEW: Added last run seconds * NEW: French translation added * BUG FIX: Fixed a typo ('DELETEED')

4.5 2018-01-08

[01/08/2018] = * CHANGE: Revamped and improved the scheduler code

4.4.3 2018-01-06

[01/06/2018] = * BUG FIX: Fixed some scheduler time issues

4.4.2 2017-12-14

[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 2017-11-09

[11/06/2017] = * BUG FIX: Bug in counting excluded tables fixed

4.4 2017-08-22

[08/22/2017] = * NEW: New options to delete revisions of posts, pages and / or specific custom post types

4.3.2 2017-08-12

[08/12/2017] = * CHANGE: fixed some (innocent) PHP warnings

4.3.1 2017-08-10

[08/10/2017] = * NEW: New option for deleting ALL transients (not the expired ones only)

4.3 2017-07-24

[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 2017-07-11

[07/05/2017] = * CHANGE: Extra save button added to the settings page

4.2.2 2017-06-09

[04/06/2017] = * NEW: Indonesian (id_ID) translation added

4.2.1 2017-03-11

[09/23/2016] = * CHANGE: fixed some (innocent) warnings

4.2.0 2016-09-19

[09/16/2016] = * NEW: Added a 'monthly' schedule to the scheduler

4.1.10 2016-08-27

[07/15/2016] = * BUG FIX: Bug fix for 4.1.9

4.1.9 2016-07-15

[07/15/2016] = * CHANGE: 'Running indicator' added

4.1.8 2016-06-23

[06/24/2016] = * CHANGE: Reverted back to 4.1.6 due to some problems. Sorry!

4.1.7 2016-06-23

[06/23/2016] = * CHANGE: Orphaned media items will be deleted too now

4.1.6 2016-05-20

[05/20/2016] = * NEW: Belarus (be_BY) translation added (thanks Natasha!)

4.1.5 2016-03-11

[03/11/2016] = * NEW: Turkish (tr_TR) translation added (thanks Keremcan Buyuktaskin!)

4.1.4 2016-03-02

[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 2016-02-22

[02/22/2016] = * BUG FIX: Saving settings didn't work well for multi-sites

4.1.2 2016-02-14

[02/14/2016] = * NEW: Brasilian Portuguese (po_BR) translation added * NEW: Network: True added to the plugin header

4.1.1 2016-01-24

[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 2016-01-14

[01/14/2016] = * NEW: New option: delete revisions older than... * NEW: Persian translation (fa_IR) added * CHANGE: For muliti-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 2015-12-17

[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 2015-11-28

[11/28/2015] = * BUG FIX: Settings weren't saved correctly for MultiSites

4.0.1 2015-11-27

[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 2015-11-22

[11/22/2015] = * NEW: Total rewrite of the code (OO code) * CHANGE: Many changes and bug fixes

3.5.1 2015-11-01

[11/01/2015] = * BUG FIX: Views are skipped from the optimization

3.5 2015-10-23

[10/24/2015] = * CHANGE: Stylesheet is only loaded on required admin pages

3.4.9 2015-10-23

[10/23/2015] = * BUG FIX: Bug fixed for deleting unused tags

3.4.8 2015-09-14

[09/14/2015] = * BUG FIX: Bug fixed for deleting transients

3.4.7 2015-08-30

[08/30/2015] = * BUG FIX: Transients are now deleted using the delete_transient() / delete_site_transient() functions

3.4.6 2015-08-20

[06/21/2015] = * NEW: Danish translation (da_DK) added

3.4.5 2015-06-07

[06/07/2015] = * NEW: Russian translation (ru_RU) added

3.4.4 2015-06-03

[06/03/2015] = * NEW: German translation (de_DE) added

3.4.2 2015-05-28

[05/10/2015] = * BUG FIX: fixed a bug (options didn't get saved in old multisite installs) Many thanks to Pat who helped me fixing the issue!

3.4.1 2015-04-27

[04/26/2015] = * BUG FIX: fixed a bug for the excluded tables (didn't work anymore)

3.4 2015-04-24

[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 2015-04-23

[04/08/2015] = * BUG FIX: fixed a bug with the scheduler (it didn't clean everything)

3.3 2015-03-27

[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 2015-03-18

[03/18/2015] = * CHANGE: due to problems, I removed the MULTISITE support again for now... Sorry about that!

3.2 2015-03-18

[03/18/2015] = * NEW: MULTISITE support added * CHANGE: various minor improvements

3.1.4 2015-03-01

[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 2015-02-21

[02/21/2015] = * NEW: showing the icon in the admin menu is now configurable via the settings page

3.1.2 2015-02-20

[02/20/2015] =

  • BUG FIX: fixed the link to the settings page
3.1.1 2015-02-20

[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 2015-02-20

[01/29/2015] = * NEW: deletion of pingbacks and trackbacks (optional) * CHANGE: link to settings page in the main plugins page

3.0 2014-12-28

[12/28/2014] = * BUG FIX: tags only used in scheduled posts won't be deleted anymore (thanks Michael!)

2.9 2014-12-19

[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 2014-09-10

[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 2014-08-01

[08/01/2014] = * BUG FIX: all problems with getting the table names should be fixed now!

2.8.1 2014-07-31

[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 2014-07-30

[07/30/2014] = * CHANGE: 'administrator'-role changed to 'edit_themes'-capability * BUG FIX: no table names beside checkboxes

2.7.9 2014-05-02

[05/02/2014] = * BUG FIX: some minor bug fixes (thanks Mike!)

2.7.8 2014-05-01

[05/01/2014] = * CHANGE: replaced depreciated MySQL queries (from WP 3.9 / PHP 5.5)

2.7.7 2014-02-15

[02/16/2014] = * BUG FIX: made jQuery also https compatible

2.7.6 2014-01-16

[01/16/2014] = * BUG FIX: empty lines removed from output (gave problems with some RSS feeds)

2.7.5 2013-12-13

[12/13/2013] = * CHANGE: two queries optimized for better performance

2.7.4 2013-12-11

[12/11/2013] = * BUG FIX: added 'backticks' around the database name in a few queries

2.7.3 2013-12-09

[12/09/2013] = * BUG FIX: deleted some CR/LF's from the end of the plugin sigh

2.7.2 2013-12-09

[12/09/2013] = * BUG FIX: forgot to delete a debug item... oops! sorry!

2.7.1 2013-12-09

[12/09/2013] = * BUG FIX: query and depreciated item (mysql_list_tables) fixed

2.7 2013-12-06

[12/06/2013] = * NEW: deletion of expired transients (optional)

2.6 2013-07-22

[07/22/2013] = * NEW: deletion of unused tags (optional)

2.5.1 2013-05-24

[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 2013-05-24

[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.4.2 2013-05-24
2.4.1 2013-05-23

[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.4 2013-05-23

[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 2013-05-03

[05/03/2013] = * BUG FIX: fixed a problem with 'invalid header' (during installation)

2.3 2013-04-26

[04/26/2013] = * BUG FIX: fixed the 'Stealing Cron Schedules' issue

2.2.9 2013-04-10

[04/10/2013] = * BUG FIX: bug fix for the 'check all NON-WordPress tables' link

2.2.8 2013-03-19

[03/19/2013] = * BUG FIX: bug fix for deleting Post Orphans

2.2.7 2013-03-18

[03/18/2013] = * NEW: 'Orphan Post items' (like 'Auto Drafts') will be automatically deleted too now (thanks to: 0izys)

2.2.6 2013-03-05

[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 options page (thanks to: RonDsy)

2.2.5 2013-02-20

[02/20/2013] = * Bug fix: fixed an (innocent) PHP warning (in error.log)

2.2.4 2013-02-12

[02/12/2013] = * Bug fix: error corrected in readme.txt file

2.2.3 2013-02-09

[08/02/2013] * Bug fix: fixed an (innocent) PHP warning (in error.log)

2.2.2 2013-01-20

[01/20/2013] = * Bug fix: deleting of postmeta orphans didn't work correctly

2.2.1 2013-01-17

[01/17/2013] = * Bug fix: fixed some debug warnings

2.2 2013-01-11

[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 2013-01-04

[01/04/2013] = * Bug fix: keeping a maximum number of revisions didn't work correctly

2.0 2012-12-18

[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 2012-12-14

No Upgrade Notice available.

1.3.3 2012-12-01

No Upgrade Notice available.

1.3.2 2012-11-14

No Upgrade Notice available.

1.3.1 2012-10-07

No Upgrade Notice available.

1.3 2012-10-06

No Upgrade Notice available.

1.2 2012-10-03

No Upgrade Notice available.

1.1.9 2012-09-27

No Upgrade Notice available.

1.1.8 2012-09-08

No Upgrade Notice available.

1.1.7 2012-09-03

No Upgrade Notice available.

1.1.6 2012-09-01

No Upgrade Notice available.

1.1.5 2012-09-01

No Upgrade Notice available.

1.1.4 2012-09-01

No Upgrade Notice available.

1.0.4 2012-09-01

No Upgrade Notice available.

1.0.3 2012-09-01

No Upgrade Notice available.

1.1.3 2012-09-01

No Upgrade Notice available.

1.1.2 2012-08-30

No Upgrade Notice available.

1.1.1 2012-08-29

No Upgrade Notice available.

1.1 2012-08-29

No Upgrade Notice available.

1.0.5 2012-08-21

No Upgrade Notice available.

1.0.2 2011-12-02

No Upgrade Notice available.

1.0.1 2011-11-24

No Upgrade Notice available.

1.0 2011-11-23

No Upgrade Notice available.