WordPress.org

Plugin Directory

Test out the new Plugin Directory and let us know what you think.

Optimize Database after Deleting Revisions

Optimizes the WordPress Database after Cleaning it out

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

Main Features

  • Deletes redundant revisions of posts and pages (you optionally can keep an 'x'-amount of the most recent revisions)
  • Deletes trashed posts, pages and comments (optional)
  • Deletes spammed comments (optional)
  • Deletes unused tags (optional)
  • Deletes 'expired transients' (optional)
  • Deletes 'pingbacks' and 'trackbacks' (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 file 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 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)

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
  • German [de_DE] - translated by the.mnbvcx
  • 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

Author

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

Plugin URL

http://cagewebdev.com/index.php/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/index.php/wordpress-plugins/

Requires: 2.8 or higher
Compatible up to: 4.6.1
Last Updated: 2 months ago
Active Installs: 70,000+

Ratings

4.8 out of 5 stars

Support

1 of 2 support threads in the last two months have been marked resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

4 people say it works.
0 people say it's broken.

100,2,2 100,2,2 100,1,1
100,1,1 100,1,1
100,5,5
100,3,3 100,2,2
100,1,1
100,2,2 100,1,1 100,1,1 100,1,1 100,1,1 100,1,1 100,1,1 100,1,1 100,1,1
100,2,2 100,2,2 100,1,1 100,1,1 100,2,2 100,1,1 100,1,1
100,1,1 100,3,3 100,6,6 100,4,4 100,3,3 100,1,1 100,4,4
100,3,3 100,1,1 100,1,1 100,3,3 100,4,4 100,1,1 100,3,3 100,4,4 67,3,2 100,4,4 100,1,1 100,1,1 100,4,4
100,4,4 100,5,5
100,9,9
100,5,5 100,1,1
100,3,3
100,7,7 100,2,2 33,3,1 100,2,2 100,1,1 100,1,1
100,1,1 75,4,3 100,1,1
100,2,2 100,5,5
100,1,1
100,1,1
100,1,1 100,1,1 100,3,3
100,7,7 100,1,1 100,1,1 100,1,1
100,4,4
75,4,3 100,1,1 100,5,5
100,3,3 100,1,1
100,1,1 100,4,4 100,2,2 100,1,1 100,1,1 100,1,1 100,1,1
100,2,2 100,2,2 100,1,1 100,1,1 100,4,4 100,1,1
100,1,1 100,1,1
100,2,2 100,1,1
100,1,1 100,1,1
100,4,4 100,2,2 100,2,2 100,4,4 100,1,1
100,3,3
100,1,1
100,1,1 100,2,2 100,1,1 100,1,1
100,2,2 100,1,1 100,4,4 100,4,4 100,2,2 100,1,1 100,1,1
100,2,2 100,3,3 100,1,1 100,1,1
100,1,1 100,1,1 100,1,1
100,1,1 100,1,1 100,3,3 100,1,1 67,6,4
100,3,3
100,3,3
100,1,1 100,2,2
100,6,6 100,1,1 100,1,1 100,1,1 100,1,1
100,1,1
100,1,1 100,1,1 100,4,4