[WordPress] 外掛分享： Nexura Database Cleaner & Optimizer

內容簡介

Nexura Database Cleaner & Optimizer 是一款現代化的 WordPress 資料庫優化與清理外掛，旨在加速網站運行、減少伺服器負載並回收佔用的儲存空間。

【主要功能】
• 資料庫健康審核與透明評分
• 安全的乾跑與預覽模式
• 風險等級分類
• 批次處理引擎
• 清理前備份安全提示
• 完整的審計追蹤與歷史記錄

外掛標籤

開發者團隊

原文外掛簡介

Nexura Database Cleaner & Optimizer is a modern, safety-first WordPress database optimization and cleanup plugin built to speed up your website, reduce server load (TTFB), and reclaim gigabytes of bloated storage.
🔗 Quick Links:
* Official Website: nexurasecurity.com/database-cleaner-optimizer
* GitHub Repository: github.com/nexurasecurity/nexura-database-cleaner
* Pricing & Pro Version: View Pricing & Plans
Why Clean and Optimize Your WordPress Database?
Over time, every active WordPress and WooCommerce site accumulates gigabytes of unseen bloat:
* Old Post Revisions & Auto-Drafts accumulating over years of editing.
* Orphaned Metadata left behind by uninstalled plugins and deleted posts, users, or terms.
* Massive Autoloaded Options in wp_options that load on every single page view, slowing down TTFB and PHP memory.
* Bloated WooCommerce Action Scheduler Tables with hundreds of thousands of completed or failed task logs.
* Expired Transient Caches & Spam Comments creating database query bottlenecks.
This clutter increases database file size, slows down WP-Admin queries, causes slow WooCommerce checkouts, and increases server backup time.
Nexura Database Cleaner follows a strict safety principle: Scan first. Preview what was found. Clean only what you approve.
Key Features at a Glance

Database Health Audit & Transparent Score: Instant 0–100 health assessment with fully transparent calculation deductions—never arbitrary or misleading.
Safe Dry Run & Preview Mode: Inspect matched records and estimated disk space before deleting a single row.
Risk Level Classification: Every item is transparently classified by risk (Safe, Low Risk, Medium Risk, High Risk).
Batch Processing Engine: Removes clutter in asynchronous, controlled AJAX batches to prevent server timeouts and 504 gateway errors.
Pre-Cleanup Backup Safety Prompt: Displays safety recommendations before bulk deletion operations.
Full Audit Trail & History: Complete records of every cleanup operation, including rows removed, bytes reclaimed, and execution timestamps.
Automated Scheduled Maintenance: Set recurring background cleanups (Daily, Weekly, or Monthly) via WordPress Cron for hands-free optimization.
InnoDB Storage Awareness: Correctly distinguishes normal 2 MB MySQL InnoDB extent reservations from true table fragmentation.
Multisite Compatible: Safely distinguishes network-wide tables and subsite prefixes.

Comprehensive Cleanup Modules
1. Posts & Content Cleaners

Post Revisions: Remove excessive past revisions while preserving published posts.
Auto-Drafts: Clean abandoned auto-drafts created by the WordPress block editor.
Trashed Posts: Empty discarded posts and pages remaining in the trash bin.

2. Comments Clutter Cleaners

Spam Comments: Purge spam comments marked by moderators or antispam tools.
Trashed Comments: Permanently empty deleted comments.
Pingbacks & Trackbacks: Remove legacy blog notifications stored in the comments table.

3. Metadata & Relationships Cleaners

Orphaned Post Meta: Clean metadata tied to deleted post IDs.
Orphaned User Meta: Remove metadata referencing removed user accounts.
Orphaned Comment Meta: Clean metadata belonging to deleted comments.
Orphaned Term Meta: Remove metadata referencing deleted categories or tags.
Orphaned Term Relationships: Clean relationships pointing to missing post entries.
Duplicated Post Meta: Deduplicate redundant postmeta rows sharing identical keys and values.
Duplicated User Meta: Remove redundant duplicate usermeta records.
Duplicated Comment Meta: Deduplicate identical commentmeta entries.

4. Transients & Caches

Expired Transients: Purge expired temporary cached options from the options table.
Expired Site Transients: Clean expired network-wide and multisite transient caches.
oEmbed Caches: Clean temporary embedded media HTML caches from postmeta.

5. WooCommerce & Action Scheduler Cleaners

Action Scheduler: Completed Actions: Purge completed background jobs older than 30 days.
Action Scheduler: Failed Actions: Remove failed background actions that will not retry.
Action Scheduler: Canceled Actions: Delete canceled scheduled actions.
Action Scheduler: Orphaned Logs: Clean orphaned log rows whose parent actions were deleted.
Customer Sessions (Pro): Clean expired WooCommerce customer session tokens.
Orphaned Order Items & Meta (Pro): Identify and clean leftover order items and metadata from deleted orders.
Webhook Delivery Logs (Pro): Purge accumulated historical WooCommerce webhook delivery logs.

6. Database Table Optimization & Defragmentation

Table Inventory: View table names, database engines (InnoDB/MyISAM), row counts, data size, index size, and overhead.
Single & Bulk Optimization: Defragment tables and rebuild index trees with one click.
InnoDB Extent Baseline Recognition: Understands MySQL extent reservations and marks baseline tables as Optimal.
Table Analysis: Execute MySQL ANALYZE TABLE to refresh index statistics for the query optimizer.

7. Options & Autoload Diagnostics

Autoload Size Monitoring: Real-time calculation of total autoloaded bytes with a warning if exceeding 800 KB.
Large Options Detection: Identifies the heaviest individual options in your database (> 50 KB).
1-Click Autoload Toggle: Turn autoload ON or OFF for any option without executing manual SQL queries.

8. Cron Jobs Analyzer

Scheduled Task Overview: Inspect all active WP-Cron hooks and next run timestamps.
Orphaned Cron Detection: Identify cron events with no valid callback registered by active plugins or themes.
1-Click Unschedule: Safely remove orphaned scheduled tasks.

Free vs Pro Feature Comparison
While our Free version gives you everything you need to safely clean clutter, optimize tables, and speed up standard WordPress sites, Pro is designed for agencies, WooCommerce stores, and high-traffic websites that need deep identification of uninstalled plugin tables via our built-in signature library, automated safety backups, and granular scheduled maintenance.
👉 Check Out Pro Pricing & Plans
Included in Free & Pro

Database Health Audit Score (0–100)
Post Revisions, Auto-Drafts & Trash Cleaners
Spam & Trash Comments, Pingbacks & Trackbacks
Expired Transients & Site Transients Cleanup
Orphaned Metadata Cleaners (Post, User, Comment, Term)
Orphaned Term Relationships Cleanup
Duplicated Metadata Cleaners (Post, User, Comment)
oEmbed HTML Caches Cleanup
Table Optimization & Defragmentation (InnoDB & MyISAM)
InnoDB 2 MB Extent Reserve Recognition
Autoload Options Size Monitor & Top Options Inspector
1-Click Autoload Toggle (On/Off)
WP-Cron Task Analyzer & Unschedule
Interactive Dry Run & Safety Preview
Asynchronous Batch Processing (No Timeout)
Full Audit Trail History & Execution Log
Action Scheduler Cleanup (Completed, Failed & Canceled)
Basic Scheduled Cleanup (Daily, Weekly, Monthly)

Pro Exclusive Features

Plugin Signature Library — identify leftover tables & options from uninstalled plugins
Abandoned Table Detector & Cleaner — auto-detect and remove orphaned plugin tables
Abandoned Options & Meta Purger — clean leftover options from deleted plugins
WooCommerce Deep Clean Suite — sessions, variations, order items & meta, webhooks, analytics
Granular Schedule Engine — custom cleanup intervals per individual cleaner
Scheduled Cleanup Email Summary Reports — automated delivery after every scheduled run
1-Click SQL Table Backup — instant pre-cleanup export (Free shows warning modal only)
Table Engine Converter — convert MyISAM tables to InnoDB with one click
Raw Table Data, Columns & Index Browser — inspect database internals visually
Deep Search & Filter inside Options / Postmeta tables
WordPress Multisite Full Network Cleanup — super-admin network-wide operations
VIP Dedicated 1-on-1 Support & Priority Updates

Privacy & Data Protection

100% Local Processing: All scans, queries, and cleanup operations run locally on your server.
No Database Transmission: Your database contents, post text, user credentials, and customer data are never uploaded or transmitted to any external server.
GDPR Compliant: Keeps your user and website data strictly private on your hosting infrastructure.

3rd Party Services (Freemius)
This plugin uses Freemius for optional usage tracking, licensing, and upgrades. No data is collected unless you explicitly opt-in. Freemius is a secure third-party service specifically built for WordPress plugins.
By opting in or upgrading, you agree to Freemius’ terms and policies:
* Freemius Privacy Policy
* Freemius Terms of Service