Adi Glibanović

<p><strong>RVS Database Doctor</strong> is a professional database administration tool. It gives you insight into the current state, safely cleans and optimizes, and shows exactly how much you saved – with full support for large databases.</p>
<h4>Key features</h4>
<ul>
<li><strong>Dashboard</strong> with health score and one-click <strong>Optimize Now</strong>.</li>
<li><strong>Time-based job runner</strong> (default batch 1000, auto-adapts to <code>max_execution_time</code>) – works smoothly on databases with 100k+ rows.</li>
<li><strong>Background queue</strong> (WP-Cron drain every minute, Action Scheduler when available) – you can close the tab and the job continues.</li>
<li><strong>Before / After snapshots</strong> with SVG charts and per-table delta (no external dependencies).</li>
<li><strong>Guided Safe Cleanup Wizard</strong> with recommended selections, CARE confirmations, before/after snapshots, and cleanup result deltas.</li>
<li><strong>Smart Advisor v2</strong> – health score (0-100, grade A-F), actionable tips, and EXPLAIN query-plan hints for slow queries.</li>
<li><strong>Bulk actions</strong> for Table Sizes, Autoload Options, Index Analysis, and Cleanup tabs.</li>
<li><strong>Manual full database backup</strong> with a user-selectable table list and <strong>manifest.json</strong> metadata. Choose PHP chunked dump (works anywhere) or native <strong>mysqldump</strong> (fast).</li>
<li><strong>Full database restore</strong> from plugin-created backups – automatic pre-restore backup, streaming SQL import, progress tracking, and mandatory confirmation (type RESTORE).</li>
<li><strong>Micro-backup of affected tables</strong> before destructive operations (gzip when available, retention by days and count).</li>
<li><strong>Scheduled optimizations</strong> – hourly / daily / weekly / monthly.</li>
<li><strong>Scheduled health digest emails</strong> – daily, weekly, or monthly summaries sent to the configured notification email.</li>
<li><strong>MyISAM <span aria-hidden="true" class="wp-exclude-emoji">→</span> InnoDB</strong> conversion (batched with progress bar).</li>
<li><strong>Autoload analysis</strong> with severity levels, segmentation, search, filter, pagination, and bulk update – no longer limited to 50 options.</li>
<li><strong>Index analysis</strong> – missing expected, composite suggestions, sys redundant / unused.</li>
<li><strong>WooCommerce / HPOS</strong> detection and specific suggestions.</li>
<li><strong>Cleanup</strong>: expired transients, revisions, auto-drafts, old trash, spam / trash comments, orphan postmeta / commentmeta / term_relationships, expired WC sessions, Action Scheduler old actions / logs, duplicate postmeta, stale session tokens, <code>_edit_lock</code> / <code>_edit_last</code>.</li>
<li><strong>Actions log</strong> – every attempt is recorded (success / error / dry-run).</li>
<li><strong>WP-CLI</strong> commands for every action including <code>backup create --all</code>, <code>backup validate <uid></code>, and <code>backup restore <uid> --confirm=RESTORE</code> (<code>wp rvs-database-doctor …</code>; <code>wp rvs-db-doctor …</code> is also supported).</li>
</ul>
<h4>Safety rules</h4>
<ul>
<li>All destructive actions require the <code>manage_options</code> capability + nonce + explicit confirmation checkbox.</li>
<li>Table names are validated against <code>information_schema</code> before any <code>ALTER / ANALYZE / OPTIMIZE / DELETE</code>.</li>
<li>Auto-backup of affected tables before destructive operations (enabled by default).</li>
<li>The plugin never deletes anything automatically; <strong>Optimize Now</strong> runs safe categories only by default.</li>
</ul>


RVS Database Doctor

Safely analyze and optimize your WordPress and WooCommerce database with backups, restore, schedules, and a built-in health advisor.

Jon Christopher

cageehv

NerdPress

Colin Devroe

<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 ‘One Click’ WordPress database cleaner & 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 ‘x’-amount of the most recent revisions and you can choose to delete revisions older than…)</li>
<li>Deletes trashed posts, pages and comments (optional)</li>
<li>Deletes spammed comments (optional)</li>
<li>Deletes unused tags (optional)</li>
<li>Deletes ‘expired or all transients’ (optional)</li>
<li>Deletes ‘pingbacks’ and ‘trackbacks’ (optional)</li>
<li>Clears the ‘OEMBED cache’ (optional)</li>
<li>Deletes ‘orphan postmeta items’</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>‘Optimize DB (1 click)’ link in the admin bar (optional)</li>
<li>‘Optimize Database’ 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 » Optimize Database -or- via the WP Admin Panel » 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 ‘keep_revisions’ for that post/page and give it the value ‘Y’</p>
<h4>Starting the Analysis / Optimization</h4>
<p>You can start the Optimization in the WP Admin Panel » Optimize Database.<br />
Note: if you use the Scheduler the Optimization will run automatically!<br />
Note: you also can click the ‘Optimize DB (1 click)’ link in the admin bar (if enabled)<br />
You can click one of the following buttons:<br />
‘Analyze (summary): analyzes the database and gives the count of what will be cleaned<br />
‘Analyze (detail): analyzes the database and gives a detailed report of what will be deleted<br />
‘Optimize (summary): actually deletes the items and gives the count of what has been deleted<br />
‘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 » Plugins)</li>
<li>‘Network Activate’ 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 />
<?php<br />
define(‘RUN_OPTIMIZE_DATABASE’, true);<br />
require_once(‘wp-load.php’);<br />
?></p>
<p>Then, start the .php file from your crontab!</p>
<h4>Supported languages</h4>
<ul>
<li>Belarus [be_BY] – translated by Natasha – https://www.ustarcash.com/ – keyword UStarCash</li>
<li>Danish [da_DK] – translated by Alexander Leo-Hansen – http://alexanderleohansen.dk</li>
<li>Dutch [nl_NL] – translated by Rolf van Gelder, CAGE Web Design – http://cagewebdev.com</li>
<li>English [en_US] – translated by Rolf van Gelder, CAGE Web Design – http://cagewebdev.com</li>
<li>French [fr_FR] – translated by Guillaume Blet – http://www.mycinetheque.fr</li>
<li>German [de_DE] – translated by Kolja Spyra</li>
<li>Indonesian [id_ID] – translated by ChameleonJohn.com</li>
<li>Italian [it_IT] – translated by Fabio Marzocca</li>
<li>Persian [fa_IR] – translated by Milad Mordi, http://seodaramal.ir</li>
<li>Portuguese [po_BR] – translated by Rede Sul Mineira de Comunicações</li>
<li>Russian [ru_RU] – translated by Vadim Sokhin, PluginZone – http://pluginzone.ru</li>
<li>Serbian [sr_RS] – translated by Ogi Djuraskovic, FirstSiteGuide  – http://firstsiteguide.com</li>
<li>Swedish [sv_SE] – translated by P.E.</li>
<li>Turkish [tr_TR] – translated by Keremcan Buyuktaskin</li>
<li>Ukranian [uk_UA] – translated by Anna Goriacha, Coupofy – http://coupofy.com</li>
</ul>
<h4>Disclaimer</h4>
<p>NO WARRANTY, USE IT AT YOUR OWN RISK! MAKE BACKUPS FIRST!</p>


Optimize Database after Deleting Revisions

In principle this would be an excellent plugin but it always leads in time-out errors. In our view, the problem lies with the execution of the optimization process itself. There is no safeguard against time-out errors. This should be fixed as there must be better ways to code this. 

Good plugin but leads to ongoing time-out errors


Plugin works exactly as described. Thanks! It was easy to configure and I especially like the ability to remove all revisions except for XX amount, which makes it great for cleaning up existing sites where you've reduced the number of revisions, but the database still contains heaps of older revisions.


Easy to use with great results

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

RVS Database Doctor vs Optimize Database after Deleting Revisions