ARN Smart Support
Language: English

Clean the WordPress database

Updated 8 Nov 2026 3 min read
Browse DualFix articles

Every WordPress site collects database clutter over time. Revisions pile up, transients expire without being removed and deleted content leaves metadata behind. The DualFix database scanners find this clutter and remove it through the same classification, verification, Safety Snapshot and audit stages as every other scope. They are included in both editions.

Where to find it: Cleanup Launcher → Cleanup Flow. In DualFix Free, this flow is the database cleanup. In DualFix Pro, the database scanners run as part of Full Cleanup.

What the database scanners find

ScannerWhat it findsWhat cleanup does
RevisionsStored older versions of postsDualFix Pro: removed after verification. DualFix Free: listed for review, not removed
AutosavesAutomatic drafts WordPress saves while you editListed for your review; never deleted by DualFix
Trashed itemsPosts in the trashListed for your review; never deleted by DualFix
Expired transientsTemporary cache values whose expiry has passedRemoved after verification
Orphaned post, comment and user metaMetadata rows whose parent post, comment or user no longer existsComment meta: removed after verification. Post and user meta: DualFix Pro removes them after verification; DualFix Free lists them for review, not removed
Stale cron hooks and inactive widgetsScheduled tasks and widget entries left behind by removed codeReported for your review; never deleted by DualFix
Heavy autoloaded optionsOptions WordPress loads on every page request, analysed by sizeReported for your review; never deleted by DualFix

DualFix does not change autoload flags, delete cron events or remove widget entries. These findings come with their reason, and the decision stays with you.

Autosaves and trashed posts stay in review on purpose: an autosave can hold edits that were never saved, and WordPress empties the trash on its own, after 30 days by default. Deleting a revision does not change the post it belongs to.

Clean the database

  1. Make sure the Setup Wizard profile is confirmed and a recent backup is restore-ready.
  2. Open Cleanup Launcher and click Run First Scan (or Run Scan) under Cleanup Flow.
  3. Read the findings by class. Items of active plugins are marked protected.
  4. Click Create Preview, then Run Verify, and read the reason for any blocked item.
  5. Click Confirm Cleanup. DualFix takes a database backup (while Backup before cleanup is on, the default) and a Safety Snapshot, and removes only the items Verify approved as safe.
  6. Read the audit and check your site.

Each item is checked again at the moment it is deleted. A post that left the trash after the scan, or a transient that is no longer expired, is skipped.

Data of active plugins stays protected

Even inside the database scope, data that belongs to an active plugin is protected. The plugin registry knows the meta keys, options and tables of WordPress core, the block editor, page builders (Elementor, Divi, WPBakery), WooCommerce, custom field plugins (ACF, Meta Box, Pods), SEO plugins (Yoast SEO, Rank Math), multilingual plugins (WPML, Polylang) and the ARN Smart plugins WebPix, Linkix and Clonex. Data of plugins the registry does not know still goes through the dependency checks of the verification stage.

Keep clutter from coming back

Cleaning once is the easy part; revisions and transients return within weeks.

On this page

Submit a ticket

Create a new support request without needing a portal account.

Priority
Attachments
Only you and our staff see a ticket. Never send passwords or licence codes.

Track a ticket

Use the ticket number and password from your confirmation email.

The number and the password are in your confirmation email.

Sign in

Access your support portal account.

New here?

Create account

Create your support portal account.

Already have an account?

Forgot password?

We email you a link to choose a new password.

Conversation

Was this helpful?
Open full article
↑ ↓ to moveEnter to openEsc to close