跳至主要內容
WordPress.org

Taiwan 正體中文

  • 佈景主題目錄
  • 外掛目錄
  • 最新消息
  • 技術支援
  • 關於我們
  • 團隊
  • 取得 WordPress
取得 WordPress
WordPress.org

Plugin Directory

Mega Database Cleanup

  • 提交外掛
  • 我的最愛
  • 登入
  • 提交外掛
  • 我的最愛
  • 登入

Mega Database Cleanup

由 MegaWix Technologies 開發
下載
  • 詳細資料
  • 使用者評論
  • 安裝方式
  • 開發資訊
技術支援

外掛說明

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.

Highlights

  • Empty / Unused Meta Scanner
    Detects empty, null, serialized-empty, or JSON-empty postmeta values.

  • ACF Cleanup Engine
    Automatically identifies patterns used by Advanced Custom Fields to detect orphan entries.

  • 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.

  • Scheduled Cleanup (WP-Cron)
    Cleanup can run automatically (hourly, daily, weekly).

  • Retention Rules
    Keep the latest N meta rows per meta_key (default: 5).

  • 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).

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
  • Preserves the first meta entry + last 5 entries for safety
  • Uses optimized SQL queries for predictable performance

Privacy Policy

Mega Database Cleanup does not track, collect, or transmit any user data.
No information leaves your site.
All backups remain stored locally on your 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

  • Plugin Development: MegaWix Technologies
  • Testing & QA: MegaWix Technologies

Support

Need help? Have a question or feature request?

  • Website: https://www.megawix.com
  • Email: [email protected]

We are committed to providing reliable support and regular updates to ensure this plugin remains compatible with the latest WordPress versions.

螢幕擷圖

  • Dashboard – Main cleanup panel
  • Empty Meta Preview table
  • ACF pattern manager
  • Cleanup settings and scheduler
  • Log viewer
  • Backup information panel

安裝方式

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 Tools → Mega DB Cleanup

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 Tools → Mega DB Cleanup
  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.
If backup is enabled, you can restore deleted rows 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.

Can I add my own patterns?

Absolutely. You can add or remove SQL LIKE patterns directly from the admin panel.

Does it work on multisite?

Yes, it works on standard and multisite installations. Cleanup runs per site.

Will this improve my website speed?

Yes — removing thousands of empty meta rows reduces database size and speeds up queries.

What if I delete something by mistake?

If backups are enabled, deleted metadata is stored in a dedicated table so you can manually restore it via phpMyAdmin.

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

將〈Mega Database Cleanup〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄。

變更記錄

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

中繼資料

  • 版本 1.0.0
  • 最後更新 2 個月前
  • 啟用安裝數 少於 10 次
  • WordPress 版本需求 5.0 或更新版本
  • 已測試相容的 WordPress 版本 6.9.1
  • PHP 版本需求 7.4 或更新版本
  • 語言
    English (US)
  • 標籤
    database cleanupoptimization
  • 進階檢視

評分

這個項目尚無任何評論記錄。

新增使用者評論

查看全部使用者評論

參與者

  • MegaWix Technologies

技術支援

使用者可在技術支援論壇提出意見反應或使用問題。

檢視技術支援論壇

贊助

想要支援這個外掛的發展嗎?

贊助這個外掛

  • 關於我們
  • 最新消息
  • 主機代管
  • 隱私權
  • 展示網站
  • 佈景主題目錄
  • 外掛目錄
  • 區塊版面配置目錄
  • Learn
  • 技術支援
  • 開發者資源
  • WordPress.tv ↗
  • 共同參與
  • 活動
  • 贊助基金會 ↗
  • Five for the Future
  • WordPress.com ↗
  • Matt ↗
  • bbPress ↗
  • BuddyPress ↗
WordPress.org
WordPress.org

Taiwan 正體中文

  • 查看我們的 X (之前的 Twitter) 帳號
  • Visit our Bluesky account
  • 造訪我們的 Mastodon 帳號
  • Visit our Threads account
  • 造訪我們的 Facebook 粉絲專頁
  • Visit our Instagram account
  • Visit our LinkedIn account
  • Visit our TikTok account
  • Visit our YouTube channel
  • Visit our Tumblr account
程式碼,如詩
The WordPress® trademark is the intellectual property of the WordPress Foundation. WordPress® is not the same thing as WP Engine®. Since October 2024, WordPress.org’s creator Matt Mullenweg is a defendant in a legal action from WP Engine®. The WordPress Hosting page does not recommend WP Engine®.