外掛標籤
開發者團隊
原文外掛簡介
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
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.
