Title: Mega Database Cleanup Author: MegaWix Technologies Published: 2025 年 12 月 28 日 Last modified: 2026 年 3 月 26 日 --- 搜尋外掛 ![](https://ps.w.org/mega-database-cleanup/assets/banner-772x250.png?rev=3428489) ![](https://ps.w.org/mega-database-cleanup/assets/icon.svg?rev=3428489) # Mega Database Cleanup 由 [MegaWix Technologies](https://profiles.wordpress.org/megawixtech/) 開發 [下載](https://downloads.wordpress.org/plugin/mega-database-cleanup.2.0.0.zip) * [詳細資料](https://tw.wordpress.org/plugins/mega-database-cleanup/#description) * [使用者評論](https://tw.wordpress.org/plugins/mega-database-cleanup/#reviews) * [安裝方式](https://tw.wordpress.org/plugins/mega-database-cleanup/#installation) * [開發資訊](https://tw.wordpress.org/plugins/mega-database-cleanup/#developers) [技術支援](https://wordpress.org/support/plugin/mega-database-cleanup/) ## 外掛說明 **Mega Database Cleanup** is a modern, high-performance cleanup utility built to remove unused, empty, bloated, or orphaned metadata from your WordPress database— safely and automatically. It includes a smart scanner, preview mode, ACF pattern cleanup, scheduled tasks, and full backup support. Ideal for site owners, developers, agencies, and power users who want a faster & cleaner database without risking important data. **Version 2.0.0** introduces a completely rewritten modular architecture, a real- time Health Dashboard, and targeted cleanup modules for post revisions, trash, spam comments, and expired transients. #### Highlights * **Health Score Dashboard** Real-time visual representation of your database health and performance at a glance. [NEW in 2.0.0] * **Targeted Cleanup Modules** Fast, one-click optimization for Post Revisions, Trashed Content, Spam Comments, and Expired Transients. [NEW in 2.0.0] * **Empty / Unused Meta Scanner** Detects empty, null, serialized-empty, or JSON- empty metadata across Post, User, Term, and Comment tables. * **ACF Cleanup Engine** Automatically identifies patterns used by Advanced Custom Fields to detect orphan entries. * **Safety Vault System** Automatically secures deleted revisions and junk data in a temporary vault for easy recovery. [NEW in 2.0.0] * **Snapshot Management** Create manual snapshots of your metadata before cleanup and restore them whenever needed. [NEW in 2.0.0] * **Real-Time Safe Preview** See exactly what will be deleted before confirming cleanup. * **Backup Before Delete** All removed metadata can be stored in a dedicated backup table / snapshot. * **Scheduled Cleanup (WP-Cron)** Cleanup can run automatically (daily, weekly). * **Retention Rules** Keep the latest N meta rows per meta_key (default: 3). * **Safe & Secure** Full validation, sanitization, and capability checks included. * **One-Click Full Cleanup** Delete unused metadata across the entire database. * **Custom Cleanup Patterns** Add or remove ACF-like patterns (SQL LIKE rules). * **Activation Welcome Popup** On first activation, optionally subscribe to optimization tips and anonymous diagnostic sync. * **Deactivation Feedback** If you deactivate the plugin, an optional feedback popup appears so you can share why. #### Who Is This For? **Website Owners** – Improve site performance and reduce database size safely. **Agencies & Developers** – Maintain clean data structures, especially on large sites. **ACF Users** – Automatically remove leftover fields that accumulate over time. **Performance Optimizers** – Speed up queries by removing thousands of useless meta rows. #### Why Mega Database Cleanup Is Different * Designed for **large databases** * Uses safe preview mode * Runs scheduled cleanups automatically * Creates a backup of every deleted row * **Safety Vault** prevents permanent loss of revisions and trashed data * Preserves the **Latest 3 entries** for absolute safety * Uses optimized SQL queries for predictable performance ### Privacy Policy Mega Database Cleanup is committed to transparency regarding user data: * **No external data transmission** — No information ever leaves your site. * **Activation popup (optional)** — If you enter your email in the welcome popup, it is saved to your site’s `wp_options` table (`mdbcp_subscriber_email`). It is never sent to any third-party server. You can skip this step entirely. * **Deactivation feedback (optional)** — If you submit a deactivation reason, it is saved locally to your site’s `wp_options` table (`mdbcp_deactivation_log`). It is never sent externally. You can skip this step entirely. * **Database backups** — Backup data is stored in a dedicated custom table on your own database server. ### Developer Hooks #### Filters * `mega_db_cleanup_patterns` – Modify cleanup patterns * `mega_db_cleanup_retention_limit` – Change default “keep latest N” count #### Actions * `mega_db_cleanup_before_delete` – Fires before deletion * `mega_db_cleanup_after_delete` – Fires after deletion ### Credits Developed with ❤️ by [MegaWix Technologies](https://www.megawix.com) * Plugin Development: MegaWix Technologies * Testing & QA: MegaWix Technologies ### Support Need help? Have a question or feature request? * Website: https://www.megawix.com * Email: info@megawix.com We are committed to providing reliable support and regular updates to ensure this plugin remains compatible with the latest WordPress versions. ## 螢幕擷圖 * [[ * Health Dashboard – Real-time visual metrics * [[ * Cleanup Modules – Quick one-click optimization * [[ * Meta Cleaner – Advanced table scan and filter * [[ * Snapshot Manager – Backup and restore history * [[ * Settings – Task scheduler and patterns * [[ ## 安裝方式 #### Automatic Installation 1. Log in to **WordPress Admin Plugins Add New** 2. Search for **Mega Database Cleanup** 3. Click **Install Now** **Activate** 4. Navigate to **Mega DB Cleanup** in your WordPress sidebar #### Manual Installation 1. Download the plugin ZIP 2. Go to **Plugins Add New Upload Plugin** 3. Select the ZIP and install 4. Click **Activate Plugin** #### Initial Setup 1. Open **Mega DB Cleanup** from your WordPress sidebar 2. Enable ACF Cleanup (optional) 3. Enable Preview Mode (recommended) 4. Add patterns if needed 5. Enable scheduled cleanup (optional) 6. Save changes You’re ready to analyze or clean your database! ## 常見問題集 ### Does this delete important data? No — the plugin only targets metadata that is clearly empty, unused, or orphaned. With the new Safety Vault and Snapshot systems, you can restore deleted data at any time. ### Is there a preview mode? Yes. Preview mode allows you to see exactly which meta rows are considered empty before removing anything. ### Does this support ACF fields? Yes! It includes a dedicated ACF cleanup engine that uses pattern rules to identify real orphan fields. ### What is the Health Score? It is a percentage-based calculation that tells you how optimized your database is based on the amount of junk data found. ### What if I delete something by mistake? If backups/snapshots are enabled, deleted metadata is stored in a dedicated table so you can restore it from the plugin dashboard. ### How safe is the scheduled cleanup? Very safe — it follows the same rules as manual cleanup, including retention rules and backups. ## 使用者評論 這個外掛目前沒有任何使用者評論。 ## 參與者及開發者 以下人員參與了開源軟體〈Mega Database Cleanup〉的開發相關工作。 參與者 * [ MegaWix Technologies ](https://profiles.wordpress.org/megawixtech/) [將〈Mega Database Cleanup〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/mega-database-cleanup) ### 對開發相關資訊感興趣？ 任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/mega-database-cleanup/)、 查看 [SVN 存放庫](https://plugins.svn.wordpress.org/mega-database-cleanup/)，或透過 [RSS](https://plugins.trac.wordpress.org/log/mega-database-cleanup/?limit=100&mode=stop_on_copy&format=rss) 訂閱[開發記錄](https://plugins.trac.wordpress.org/log/mega-database-cleanup/)。 ## 變更記錄 #### 2.0.0 * Major Overhaul: Completely redesigned modular class-based architecture. * New: Health Score Dashboard with real-time database diagnostics. * New: Support for User, Term, and Comment metadata cleanup. * New: Targeted cleanup modules for Revisions, Trash, Spam, and Transients. * New: Safety Vault system to temporary secure deleted data. * New: Metadata Snapshot system for manual backups and restoration. * New: Modern tabbed UI with improved user experience. * Added: Telemetry system for anonymous site optimization diagnostics. #### 1.1.1 * Fixed: Critical PHP compatibility issue by replacing modern arrow functions with traditional anonymous functions, ensuring support for older server environments. * Fixed: Resolved a glitch that caused plugin deactivation during the update process due to script execution timeouts on some servers. * Improved: Better handling of plugin state during version transitions. #### 1.1.0 * Added optional activation popup: subscribe to plugin update tips (email stored locally only) * Added deactivation feedback popup: 6 selectable reasons + custom text (stored locally only) * Plugin now appears as a top-level menu item in the WordPress sidebar * Quick-access link added to the WordPress admin bar (header) * All new features are fully WordPress.org compliant #### 1.0.0 – Initial Release * Empty meta scanner and preview mode * ACF orphan cleanup with pattern-based detection * Scheduled automatic cleanup (hourly/daily/weekly) * Backup table to store deleted meta rows * Retention rule: keep latest N entries per meta_key * One-click delete all empty metadata * Add/remove ACF patterns * Inline logs and real-time reports * Fully optimized SQL cleanup * Admin UI with jQuery enhancements ## 中繼資料 * 版本 **2.0.0** * 最後更新 **2 個月前** * 啟用安裝數 **少於 10 次** * WordPress 版本需求 ** 5.0 或更新版本 ** * 已測試相容的 WordPress 版本 **6.9.4** * PHP 版本需求 ** 7.4 或更新版本 ** * 語言 * [English (US)](https://wordpress.org/plugins/mega-database-cleanup/) * 標籤: * [acf](https://tw.wordpress.org/plugins/tags/acf/)[cleanup](https://tw.wordpress.org/plugins/tags/cleanup/) [database](https://tw.wordpress.org/plugins/tags/database/)[optimization](https://tw.wordpress.org/plugins/tags/optimization/) [postmeta](https://tw.wordpress.org/plugins/tags/postmeta/) * [進階檢視](https://tw.wordpress.org/plugins/mega-database-cleanup/advanced/) ## 評分 這個項目尚無任何評論記錄。 [Your review](https://wordpress.org/support/plugin/mega-database-cleanup/reviews/#new-post) [查看全部使用者評論](https://wordpress.org/support/plugin/mega-database-cleanup/reviews/) ## 參與者 * [ MegaWix Technologies ](https://profiles.wordpress.org/megawixtech/) ## 技術支援 使用者可在技術支援論壇提出意見反應或使用問題。 [檢視技術支援論壇](https://wordpress.org/support/plugin/mega-database-cleanup/) ## 贊助 想要支援這個外掛的發展嗎？ [ 贊助這個外掛 ](https://www.megawix.com)