Nexura Database Cleaner & Optimizer Wordpress Plugin - Rating, Reviews, Demo & Download
Plugin Description
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 TABLEto 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
Feature
Free Version
Pro Version
Database Health Audit Score (0–100)
Yes
Yes
Post Revisions, Auto-Drafts & Trash Cleaners
Yes
Yes
Spam & Trash Comments, Pingbacks/Trackbacks
Yes
Yes
Expired Transients & Site Transients
Yes
Yes
Orphaned Metadata Cleaners (Post, User, Comment, Term)
Yes
Yes
Orphaned Term Relationships
Yes
Yes
Duplicated Metadata Cleaners (Post, User, Comment)
Yes
Yes
oEmbed HTML Caches Cleanup
Yes
Yes
Table Optimization & Defragmentation (InnoDB & MyISAM)
Yes
Yes
InnoDB 2 MB Extent Reserve Recognition
Yes
Yes
Autoload Options Size Monitor & Top Options Inspector
Yes
Yes
1-Click Autoload Toggle (On/Off)
Yes
Yes
Cron Task Analyzer & Unschedule
Yes
Yes
Interactive Dry Run & Safety Preview
Yes
Yes
Asynchronous Batch Processing (No Timeout)
Yes
Yes
Audit Trail History & Local Execution Log
Yes
Yes
Basic Action Scheduler Cleanup (Failed & Canceled)
Yes
Yes
Basic Scheduled Cleanup (Daily, Weekly, Monthly)
Yes
Yes
Plugin Signature Library (popular plugins, stored locally)
View only
Yes, with table and option cleanup
Abandoned Tables Detector & Cleaner (Uninstalled Plugins)
No
Yes
Abandoned Options & Metadata Purger (Deleted Plugins)
No
Yes
WooCommerce Deep Clean Suite (Sessions, Variations, Order Items & Meta, Webhooks, Analytics)
No
Yes
Granular Schedule Engine (Custom intervals per cleaner)
No
Yes
Scheduled Cleanup Email Summary Reports
No
Yes
1-Click Pre-Cleanup SQL Table Backup
Warning Modal
Yes (1-Click SQL)
Database Table Engine Converter (MyISAM to InnoDB)
Engine View
Yes (1-Click)
Raw Table Data, Columns & Index Browser
No
Yes
Deep Search & Filter inside Options / Postmeta
No
Yes
WordPress Multisite (Network Super-Admin Clean)
Single Site
Yes (Full Network)
Support & Updates
Community (wp.org)
VIP Dedicated 1-on-1
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
Screenshots
Dashboard & Health Audit: Real-time database metrics, health score, total database size, and quick action overview.
Batch Cleanup & Preview: Itemized clutter list with risk levels, counts, space estimates, and Dry Run inspection.
Table Optimization & Extents: Detailed table statistics, overhead defragmentation, and intelligent InnoDB extent reserve handling.
Options & Autoload Diagnostics: Total autoloaded memory monitor, large options table, and 1-click autoload toggling.
Automated Scheduled Cleanup: Configure recurring background maintenance via WordPress Cron.
Audit History & Verification: Transparent history log documenting rows cleaned, freed bytes, and timestamps.
