Optimize Database after Deleting Revisions

Optimize Database after Deleting Revisions | CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands

Description

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

Optimize Database after Deleting Revisions

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/

Installation

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!

Plugin author

CAGE Web Design | Rolf van Gelder, Eindhoven, The Netherlands

Plugin official website address

https://wordpress.org/plugins/rvg-optimize-database/
If you encounter problems in using the Optimize Database after Deleting Revisions plugin, you can comment below, and I will try my best to help you solve the problem

Leave a Comment

Your email address will not be published. Required fields are marked *