One-click database optimization with precise revision cleanup and flexible scheduling. Speeding up sites since 2011!

Optimize Database after Deleting Revisions

<p>NerdPress has adopted Optimize Database After Deleting Revisions! <a href="https://www.nerdpress.net/announcing-optimize-database/" rel="nofollow ugc">Read the announcement here.</a></p>
<p>This plugin is a &#8216;One Click&#8217; WordPress database cleaner &amp; optimizer, with precise revision cleanup and flexible scheduling.</p>
<h4>Main Features</h4>
<ul>
<li>Deletes revisions of posts, pages and / or custom post types (you optionally can keep an &#8216;x&#8217;-amount of the most recent revisions and you can choose to delete revisions older than&#8230;)</li>
<li>Deletes trashed posts, pages and comments (optional)</li>
<li>Deletes spammed comments (optional)</li>
<li>Deletes unused tags (optional)</li>
<li>Deletes &#8216;expired or all transients&#8217; (optional)</li>
<li>Deletes &#8216;pingbacks&#8217; and &#8216;trackbacks&#8217; (optional)</li>
<li>Clears the &#8216;OEMBED cache&#8217; (optional)</li>
<li>Deletes &#8216;orphan postmeta items&#8217;</li>
<li>Optimizes the database tables (optionally you can exclude certain tables, or even specific posts/pages, from optimization)</li>
<li>Creates a log of the optimizations (optional)</li>
<li>Optimization can be scheduled to automatically run once hourly, twice daily, once daily or once weekly at a specific time (optional)</li>
<li>&#8216;Optimize DB (1 click)&#8217; link in the admin bar (optional)</li>
<li>&#8216;Optimize Database&#8217; Icon in the admin menu (optional)</li>
<li>MULTISITE compatible: optimizes all sites in the network with one click</li>
</ul>
<h4>Settings</h4>
<p>You can find the settings page in the WP Admin Panel &raquo; Optimize Database -or- via the WP Admin Panel &raquo; Optimize Database icon (depends on settings)</p>
<h4>Excluding specific posts/pages from deleting revisions</h4>
<p>If you want to keep revisions for a specific post/page (no matter what the other settings are), create a custom field named &#8216;keep_revisions&#8217; for that post/page and give it the value &#8216;Y&#8217;</p>
<h4>Starting the Analysis / Optimization</h4>
<p>You can start the Optimization in the WP Admin Panel &raquo; Optimize Database.<br />
Note: if you use the Scheduler the Optimization will run automatically!<br />
Note: you also can click the &#8216;Optimize DB (1 click)&#8217; link in the admin bar (if enabled)<br />
You can click one of the following buttons:<br />
&#8216;Analyze (summary): analyzes the database and gives the count of what will be cleaned<br />
&#8216;Analyze (detail): analyzes the database and gives a detailed report of what will be deleted<br />
&#8216;Optimize (summary): actually deletes the items and gives the count of what has been deleted<br />
&#8216;Optimize (detail): actually deletes the items and gives a detailed report of what has been deleted</p>
<h4>Multisite Support</h4>
<ul>
<li>Install the plugin as Network Administrator (Network Admin &raquo; Plugins)</li>
<li>&#8216;Network Activate&#8217; the plugin</li>
<li>You only can configure and run the plugin on the main network site, but it will optimize ALL the sub-sites too!</li>
</ul>
<h4>Running the plug in from a Unix crontab</h4>
<p>In case you cannot use WPCron, but you can edit the Unix crontab:</p>
<p>Create a .php file, in the root directory of your site, with:<br />
&lt;?php<br />
define(&#8216;RUN_OPTIMIZE_DATABASE&#8217;, true);<br />
require_once(&#8216;wp-load.php&#8217;);<br />
?&gt;</p>
<p>Then, start the .php file from your crontab!</p>
<h4>Supported languages</h4>
<ul>
<li>Belarus [be_BY] &#8211; translated by Natasha &#8211; https://www.ustarcash.com/ &#8211; keyword UStarCash</li>
<li>Danish [da_DK] &#8211; translated by Alexander Leo-Hansen &#8211; http://alexanderleohansen.dk</li>
<li>Dutch [nl_NL] &#8211; translated by Rolf van Gelder, CAGE Web Design &#8211; http://cagewebdev.com</li>
<li>English [en_US] &#8211; translated by Rolf van Gelder, CAGE Web Design &#8211; http://cagewebdev.com</li>
<li>French [fr_FR] &#8211; translated by Guillaume Blet &#8211; http://www.mycinetheque.fr</li>
<li>German [de_DE] &#8211; translated by Kolja Spyra</li>
<li>Indonesian [id_ID] &#8211; translated by ChameleonJohn.com</li>
<li>Italian [it_IT] &#8211; translated by Fabio Marzocca</li>
<li>Persian [fa_IR] &#8211; translated by Milad Mordi, http://seodaramal.ir</li>
<li>Portuguese [po_BR] &#8211; translated by Rede Sul Mineira de Comunicações</li>
<li>Russian [ru_RU] &#8211; translated by Vadim Sokhin, PluginZone &#8211; http://pluginzone.ru</li>
<li>Serbian [sr_RS] &#8211; translated by Ogi Djuraskovic, FirstSiteGuide  &#8211; http://firstsiteguide.com</li>
<li>Swedish [sv_SE] &#8211; translated by P.E.</li>
<li>Turkish [tr_TR] &#8211; translated by Keremcan Buyuktaskin</li>
<li>Ukranian [uk_UA] &#8211; translated by Anna Goriacha, Coupofy &#8211; http://coupofy.com</li>
</ul>
<h4>Disclaimer</h4>
<p>NO WARRANTY, USE IT AT YOUR OWN RISK! MAKE BACKUPS FIRST!</p>


Alternative Plugins for

Discover the Lists with Optimize Database after Deleting Revisions

Primary List

starter

Performance

Basic set-up

Misc

Functions

Freetanga Plugins

Freetanga Plugins

wordpress security

Essential Wordpress Plug