Database and cache tools

  • tools
  • database
  • cache
  • revisions
  • cleanup

Database & cache tools clear caches, trim stored clutter, and optimize tables. Open Dirigible → Tools & Maintenance. Overview: Using Tools & Maintenance.

Destructive cleanups permanently remove data. Scan first, confirm, and take a backup before you delete.

Flush transients

Clears expired or theme-prefixed transients and reports how many were removed. Safe for routine housekeeping when the site feels stuck on stale cached values.

Click Run on the card. Some setups also offer an object-cache flush from the same area — use it only when you know the site uses object caching.

Optimize database tables

Runs table optimization to defragment and reclaim unused space.

  1. Scan first.
  2. Optimize during low traffic.
  3. Confirm when prompted.

Revisions

Tool What it does
Purge revisions One-time cleanup of excess revisions already stored. Does not change the ongoing keep limit.
Revision limit Dirigible keeps 10 revisions per post by default. Change or uncap here. Excess trims the next time each post is saved — run Purge revisions to trim now.

Autoloaded options audit

Reports the largest options loaded on every request. You can disable autoload per option when safe — reversible, does not delete the data.

  1. Scan the report.
  2. Disable autoload only on options you understand.

Orphaned metadata cleanup

Finds metadata rows whose parent post, comment, or term no longer exists.

  1. Scan for counts.
  2. Confirm, then clean — permanent, no undo.

Empty taxonomy terms

Lists taxonomy terms with no published posts assigned (verified from relationships, not the stored count). Read-only listing; use recount actions on the card if offered.

Auto-draft cleanup

Permanently deletes abandoned auto-drafts (Add New tabs never saved) — not regular drafts. Core cron usually removes older ones; use this when cron is unreliable.

  1. Scan.
  2. Confirm, then purge.

oEmbed cache cleanup

Clears cached oEmbed HTML in post meta. Safe — embeds re-fetch on the next page view.

Spam & trashed comment purge

Permanently deletes spam and trashed comments (optional age filter).

  1. Scan for counts.
  2. Confirm — no undo.

Tips

  • Prefer Flush transients before deeper database surgery when the symptom is “stale” front-end data.
  • Do not disable autoload on options you cannot identify.
  • After large cleanups, spot-check the front end and a few edit screens.