內容簡介
Advanced Database Cleaner 是一款完整的 WordPress 優化外掛，幫助用戶清理資料庫雜訊並優化性能，透過移除未使用的資料來提升網站速度，確保 WordPress 安裝精簡高效。
【主要功能】
• 刪除舊版文章和頁面的修訂檔
• 刪除未使用的文章元資料
• 自動化清理過程設定
• 提供詳細的資料庫預覽和過濾器
• 監控外掛和佈景主題活動
外掛標籤
開發者團隊
② 後台搜尋「Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance」→ 直接安裝（推薦）
📦 歷史版本下載
原文外掛簡介
Advanced Database Cleaner is a complete WordPress optimization plugin that helps you clean up database clutter and optimize database performance by removing unused data such as old revisions, auto drafts, spam comments, expired transients, unused post meta, duplicated post meta, unused user meta, etc.
It is designed to help you improve website speed by reducing database bloat and ensuring a lean, efficient WordPress installation. It also provides detailed previews, powerful filters, and automation tools to safely control what gets cleaned.
With the ✨Premium version✨, you can unlock even more advanced features, such as detecting and cleaning orphaned options, orphaned tables, orphaned post meta, orphaned user meta, orphaned transients, and orphaned cron jobs. It also gives you clear insights into how your database evolves over time through built-in analytics, lets you monitor plugin and theme activity to better understand when new data is created or when leftovers appear, and much more.
Why use Advanced Database Cleaner❓
👉 Get a clear overview: see how many tables, options, transients, cron jobs, metadata… records you have, and identify which are unused or orphaned.
👉 Save time: configure what to clean, how far back to keep data, and how often to run automations. The plugin will then handle recurring cleanups for you.
👉 Save space and improve performance: removing unnecessary data reduces database size, makes backups faster, and can improve query performance, especially on busy or older sites.
✅ Main Features
Delete old revisions of posts and pages
Delete old auto-drafts
Delete trashed posts
Delete pending comments
Delete spam comments
Delete trashed comments
Delete pingbacks
Delete trackbacks
Delete unused post meta
Delete unused comment meta
Delete unused user meta
Delete unused term meta
Delete unused relationships
Delete expired transients
Delete duplicated post meta
Delete duplicated user meta
Delete duplicated comment meta
Delete duplicated term meta
Delete oEmbed caches
Display the database size that will be freed before cleaning for each item type, and the total size to be freed
Display and preview items to clean before performing a database cleanup to ensure safety
Sorting capability in cleanup preview tables (by name, date, size, site id, etc.)
View options value content in original or formatted mode for serialized or JSON structures (and other items types as well).
Keep last X days of data: clean only data older than the number of days you specify
✅ Automation
Schedule database cleanup to run automatically
Create scheduled cleanup tasks and specify which items each task should clean
Schedule database optimization and/or repair to run automatically
Execute scheduled tasks based on several frequencies: once, hourly, twice a day, daily, weekly, or monthly
Specify the “keep last X days” rule for each item type in a scheduled task
Pause/Resume scheduled tasks whenever needed
Create as many scheduled cleanup tasks as needed and specify what each task should clean
✅ Tables
Display the list of database tables with information such as number of rows, table size, engine, etc.
Sort tables by any column such as table name or table size
Detect and filter tables with invalid prefixes (tables that do not belong to the current WordPress installation), this can be enabled or disabled from the settings page
Optimize database tables (the plugin notifies you when tables require optimization)
Repair corrupted or damaged database tables (the plugin notifies you when tables are corrupted)
Empty rows of database tables
Clean and delete database tables
✅ Options
Display the options list with information such as option name, option value, option size, and autoload status
Sort options by any column such as option name or option size
View option value content in original or formatted mode for serialized or JSON structures.
Notify you if autoloaded options are large and help reduce autoload size for better performance
Detect large options that may slow down your website
Set option autoload to yes/no
Clean and delete options
✅ Cron Jobs
Display the list of active cron jobs (scheduled tasks) with information such as arguments, action, next run, schedule, etc.
Sort cron jobs by any column such as action name or next run time
Detect cron jobs with no valid actions
Clean and delete scheduled tasks
✅ Post Meta
Display the post meta list with information such as meta key, value, size, associated post ID, etc.
Sort post meta by any column such as meta key, meta size, or post ID
View post meta value content in original or formatted mode for serialized or JSON structures.
Detect unused post meta (meta not associated with any existing posts)
Detect duplicated post meta (same meta key/value for the same post ID)
Clean and delete post meta
✅ User Meta
Display the user meta list with information such as meta key, value, size, associated user ID, etc.
Sort user meta by any column such as meta key, meta size, or user ID
View user meta value content in original or formatted mode for serialized or JSON structures.
Detect unused user meta (meta not associated with any existing users)
Detect duplicated user meta (same meta key/value for the same user ID)
Clean and delete user meta
✅ Transients
Display the list of transients with information such as name, value, size, and expiration time
Sort transients by any column such as transient name, size, or expiration time
View transient value content in original or formatted mode for serialized or JSON structures.
Clean expired transients
Detect large transients that may slow down your website
Clean and delete transients
Set transient autoload to yes/no
✅ Other Tools
Display current database size
Logging system for easy troubleshooting
Access the WordPress debug log directly from the plugin interface
Multisite support (network-wide database cleanup and optimization from the main site)
Modern, responsive interface powered by React for a smooth experience without page reloads
Show/hide plugin tabs for better usability
⚡ Premium Features ⚡ Official website
Unlock the full power of database cleanup and optimization with Advanced Database Cleaner Premium – packed with smart features that take accuracy, speed, and cleanup control to the next level.
✅ Remote SmartScan
Local scan + Remote SmartScan technology to accurately detect the true owners of tables, options, post meta, user meta, transients, and cron jobs
Cloud-enhanced ownership detection using a large and continuously improving remote database
Improved accuracy for identifying orphaned items left by deleted plugins and themes
Ability to edit ownership of any item and correct misidentified owners
Ability to send ownership corrections to improve the global detection database
Enhanced “Belongs to” ownership column everywhere using cloud data + local data
Display multiple possible owners for each item when applicable
Display owner status (active, inactive, not installed) to simplify cleanup decisions
Check your remote scan credits to monitor usage
✅ Action Scheduler Cleanup
Clean Action Scheduler Completed actions
Clean Action Scheduler Failed actions
Clean Action Scheduler Canceled actions
Clean Action Scheduler Completed logs
Clean Action Scheduler Failed logs
Clean Action Scheduler Canceled logs
Clean Action Scheduler Orphan logs
✅ General Cleanup Enhancements
Keep last X items feature in General Cleanup
Keep last X items per parent (e.g., per post)
Keep last X items globally (e.g., keep the last 10 pingbacks)
Combine Keep Last X Days with Keep Last X Items for advanced cleanup safety
✅ Advanced Filters
Advanced filters in all modules (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs)
Filter by size, value content, autoload, expiration, metadata type, and more
Filter by plugin owner, theme owner, WordPress core, orphan, or unknown
Filter by multisite site ID with full per-site visibility
Filter by action frequency and interval in cron jobs
Filter by duplicated, unused, large, not-yet-scanned, or expired items
✅ Advanced Automation
Unlimited automation tasks (Free version is limited to 5 tasks)
Create any number of scheduled cleanup tasks with different configurations
Create scheduled optimization and repair tasks
Use Keep Last X Items and Keep Last X Days inside scheduled tasks
Run automation tasks hourly, twice daily, daily, weekly, monthly, or at any supported frequency
Pause/resume/delete automation tasks without losing settings
Per-task automation event logging showing executed actions, number of items cleaned, execution timestamps, and detailed logs
✅ Database Analytics
Daily tracking of total database size and number of tables
Daily and monthly charts showing database growth trends
Raw data tab with all recorded measurements
Table-level analytics showing size growth, rows growth, and daily changes
Ability to detect abnormal table growth caused by logs, caches, or runaway actions
Multi-table selection and search for analyzing multiple tables at once
✅ Addons Activity
Automatically track plugin activations, deactivations, and uninstalls
Automatically track theme switches and uninstalls
Display activity in a color-coded timeline for better readability
All timestamps shown in your local timezone
Multisite support (activity recorded on the main site)
✅ Full Multisite Support
Clean any site or all sites
Filter items by site ID in every module (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs)
Display which site each item belongs to
Run automation tasks across the entire network
