Adi Glibanović

RVS Database Doctor 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.
<h4>Key features</h4>
<ul>
<li>Dashboard with health score and one-click Optimize Now.</li>
<li>Time-based job runner (default batch 1000, auto-adapts to <code>max_execution_time</code>) – works smoothly on databases with 100k+ rows.</li>
<li>Background queue (WP-Cron drain every minute, Action Scheduler when available) – you can close the tab and the job continues.</li>
<li>Before / After snapshots with SVG charts and per-table delta (no external dependencies).</li>
<li>Guided Safe Cleanup Wizard with recommended selections, CARE confirmations, before/after snapshots, and cleanup result deltas.</li>
<li>Smart Advisor v2 – health score (0-100, grade A-F), actionable tips, and EXPLAIN query-plan hints for slow queries.</li>
<li>Bulk actions for Table Sizes, Autoload Options, Index Analysis, and Cleanup tabs.</li>
<li>Manual full database backup with a user-selectable table list and manifest.json metadata. Choose PHP chunked dump (works anywhere) or native mysqldump (fast).</li>
<li>Full database restore from plugin-created backups – automatic pre-restore backup, streaming SQL import, progress tracking, and mandatory confirmation (type RESTORE).</li>
<li>Micro-backup of affected tables before destructive operations (gzip when available, retention by days and count).</li>
<li>Scheduled optimizations – hourly / daily / weekly / monthly.</li>
<li>Scheduled health digest emails – daily, weekly, or monthly summaries sent to the configured notification email.</li>
<li>MyISAM → InnoDB conversion (batched with progress bar).</li>
<li>Autoload analysis with severity levels, segmentation, search, filter, pagination, and bulk update – no longer limited to 50 options.</li>
<li>Index analysis – missing expected, composite suggestions, sys redundant / unused.</li>
<li>WooCommerce / HPOS detection and specific suggestions.</li>
<li>Cleanup: 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>Actions log – every attempt is recorded (success / error / dry-run).</li>
<li>WP-CLI 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; Optimize Now 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.

Joost de Valk

Ari Stathopoulos

Progress Planner

Filip Ilić

This plugin tracks which of the autoloaded options are used on a page, and stores that data at the end of page render. It keeps an array of options that it has seen as being used. On the admin page, it compares all the autoloaded options to the array of stored options, and shows the autoloaded options that have not been used as you were browsing the site. If you’ve been to every page on your site, or you’ve kept the plugin around for a week or so, this means that those options probably don’t need to be autoloaded.
<h3>How to use this plugin</h3>
Install this plugin, and go through your entire site. Best is to use it normally for a couple of days, or to visit every page on your site and in your admin manually. Then go to the plugin’s settings screen, and go through the unused options. You can either decide to remove an unused option (they might for instance be for plugins you no longer use), or to set it to not autoload. The latter action is much less destructive: it’ll still be there, but it just won’t be autoloaded.

AAA Option Optimizer

And I love the speed in which improvements are made :)

Great tool to minimize autoloaded data size


I wonder how on earth a plugin tha promises to optimize the wp_options tables, stores 25MB of data in the option_value !!!! Maybe the guy who developed it does not understand the fundamentals of the internal database optimizers but such a huge deviation, totally ruins MariaDBs/MySQL internal optimizer. You see optimizers work on the assumption that in a table, the fields have somewhat related sizes. For more details please go to MariaDB Jira and check for cases MDEV-34097 and MDEV 32663If you add records with huge sizes (say > 100k) in wp_options table where each option is usually less than 30Bytes, then you have an issue. In our case the issue was caused by the very plugin that we used to monitor our options (that are by and large incorrect). Avoid it at all costs.


A joke!!!

Plugin that tracks autoloaded options usage and allows the user to optimize them.

RVS Database Doctor vs AAA Option Optimizer