內容簡介
RVS Database Doctor 是一款專業的資料庫管理工具，提供即時狀態檢查、安全清理與優化功能，並能顯示節省的具體數據，特別適合大型資料庫使用。
【主要功能】
• 健康分數儀表板與一鍵優化功能
• 時間基礎的任務執行器，適用於超過 100k 行的資料庫
• 背景佇列，任務可在關閉標籤後持續執行
• 安全清理向導，提供建議選項與快照
• 智能顧問 v2，提供健康分數與查詢計劃提示
• 手動完整資料庫備份與恢復功能
外掛標籤
開發者團隊
原文外掛簡介
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-site backup stored as one archive that contains both the database dump and the wp-content ZIP, with a signed manifest and selective table/file restore. WordPress core and wp-config.php are excluded from this backup. Uses native mysqldump and an uncompressed ZIP by default when the host supports them, with PHP chunked dump and directory-copy fallbacks.
Migrate any full-site backup into one portable package plus a standalone rvsmigrate.php installer. The package contains the database dump, wp-content, WordPress core and wp-config.php (all checksum-verified), so an empty hosting account is enough. Upload both by FTP, open the installer, and it extracts the files, imports the database into the new database and rewrites the old URL to the new one – including serialized widget, menu and theme data.
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.
