Performance

Database Optimisation Playbook.

Clears database clutter in stages: a readiness check, a verified database backup, a count that flags anything unusual, a sweep through WordPress's own delete functions, a check afterwards and a final report.

Super Agent
Performance
Effect
Can change the site
Steps
81 changes the site, 1 takes a backup first
Connector
No connector needed

What you get

A written Markdown report of what was counted, cleared and rechecked, plus advice on reclaiming table space.

What it looks at

  • Revisions, auto drafts, trashed items and pending or spam comments
  • Transients, orphaned and duplicated metadata, unused terms and oEmbed cache
  • Tables with reclaimable space
8 steps

The Steps In Order.

  1. Step 01

    DB Preflight Readiness

    Checks the site is healthy, at least 200 MB is free for the backup, no other run is in progress and the last run did not end in a critical state.

  2. Step 02

    DB Smart Backup

    Saves a full database backup file in your uploads folder before anything is removed. It is not a copy kept off your server.

  3. Step 03

    Verify DB Backup

    Checks that the database backup is complete and readable before any clean up starts.

  4. Step 04

    Count And Anomaly Guard

    Counts each type of clutter and leaves out any type that is over half of its table. Posts with visitor comments are never swept.

  5. Step 05

    Sweep Safe Types

    Deletes the remaining clutter types one at a time with WordPress's own delete functions, after confirming the backup. Pending, spam and trashed comments are deleted permanently, and deleting a trashed or draft post also deletes its comments.

    Changes the siteTakes a backup first
  6. Step 06

    Post Sweep Verification

    Rechecks that each cleared type dropped, a few untouched types did not change, no published post or approved comment was lost and the site is still healthy.

  7. Step 07

    Optimize Tables Advisory

    Lists tables with space to reclaim and recommends how to reclaim it, without running any optimization.

  8. Step 08

    DB Final Report

    Writes the final report of what was cleared and how the run ended.

Free Site Audit

Which Of Your Sites Needs Looking At?

The free audit looks at the site from the outside, from the address alone. Connect the site afterwards to let playbooks run.

We suggest connecting a staging copy of your site first, before your live site.

85 Site ChecksNo Credit Card100% Free