RVS Database Doctor

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.

Key features

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

Safety rules

• All destructive actions require the manage_options capability + nonce + explicit confirmation checkbox.
• Table names are validated against information_schema before any ALTER / ANALYZE / OPTIMIZE / DELETE.
• Auto-backup of affected tables before destructive operations (enabled by default).
• The plugin never deletes anything automatically; Optimize Now runs safe categories only by default.