Optimize Database after Deleting Revisions

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!