Optimize Database after Deleting Revisions – WordPress plugin Free download

Click to Download

Optimize Database after Deleting Revisions

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’

Running the Analyzer

Before running the Optimization, you can run the Database Analyzer first
Go to: Dashboard > Tools > Optimize Database
Click the ‘Analyze Database’ button

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

Click to 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!

FAQ

How can I change the settings of this plugin?

Change the settings in the WP Admin Panel » Settings » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings)

How do I run this plugin?

Go to: Dashboard » Tools &araquo; Optimize Database. Then click the ‘Start Optimization’-button -or- via the WP Admin Panel » Optimize Database icon (depends on settings)
Click the ‘Optimize DB (1 click)’ link in the Admin Bar (if enabled)

How do I run the Analyzer?

Go to: Dashboard » Tools » Optimize Database and click the ‘Analyze Database’ button

Why do I see ‘InnoDB table: skipped…’?

That’s because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
Update: if you want to optimize your InnoDB tables too, just check the ‘Optimize InnoDB tables too’ option on the settings page
IMPORTANT: optimizing InnoDB tables, might increase the size of the database! However, it will speed up the performance of the database

After I ran the plugin, I got “Total savings since the first run: -64 KB”

Sometimes that happens when you optimize InnoDB tables (instead of MyISAM tables).
Optimizing InnoDB tables works differently than MyISAM.
InnoDB focuses on speed optimization and sometimes it means the database can grow a little.

I scheduled the optimization for 8pm but it runs at 6pm (my local time)

The scheduler uses the local time of the web server which can differ from your own local time

The plugin is visible in Main Site Tools but not in my subsites

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!

Reviews

Leave a Reply

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