Optimize Database after Deleting Revisions

plugin banner

It deletes the redundant revisions of posts and pages, trashed items and/or spammed items and, after that, optimizes all database tables. Short review is available here.

Author:CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands (profile at wordpress.org)
WordPress version required:2.8
WordPress version tested:6.0
Plugin version:5.0.110
Added to WordPress repository:23-11-2011
Last updated:06-05-2022
Rating, %:94
Rated by:175
Plugin URI:http://cagewebdev.com/optimize-database-after...
Total downloads:3 563 706
Active installs:100 000+
plugin download
Click to start download

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 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/optimize-database-after-deleting-revisions-wordpress-plugin

Download URL

https://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/



FAQ
ChangeLog