GOMAX ULTIMATE 5.44.0 adds a built-in database cleanup and optimization tool that reports exactly what bloat is sitting in your WordPress database — old revisions, expired transients, trashed posts, spam comments, orphaned metadata — then clears the categories you choose (dry-run first) and optimizes your tables to reclaim wasted space, all on your own server. Over time every WordPress database fills with junk that slows queries and inflates backups; now you can see it and safely remove it without another plugin sending your data anywhere.
The catch with database cleanup is trust: delete the wrong rows and you break your site. GOMAX handles that by previewing every cleanup, keeping recent revisions, and using WordPress's own delete functions so related data is never left orphaned.
Key takeaways
See the bloat first. analyze reports counts for revisions, auto-drafts, trashed posts, spam/trashed comments, pingbacks, expired transients, oEmbed cache and orphaned post/comment/term meta — plus each table's size and reclaimable overhead.
Clean only what you choose. Pick the categories to clear; everything is dry-run by default so you preview before anything is deleted.
Safe by design. Revisions keep the newest few per post, and posts/comments are removed through WordPress's delete APIs so nothing is left orphaned.
Reclaim space. optimize_tables runs OPTIMIZE TABLE to recover the overhead left behind after big deletes.
Set and forget. An optional daily auto-clean keeps the database tidy — off by default, and entirely on your own server.
What actually bloats a WordPress database
Most of it accumulates silently:
Post revisions — every save can create one; a single old page might have dozens.
Auto-drafts and trashed posts — abandoned drafts and "deleted" content that still lives in the database.
Spam and trashed comments — often the largest table on a busy blog.
Expired transients — temporary cached values that were supposed to expire but linger in the options table.
Orphaned metadata — post/comment/term meta whose parent was deleted, left behind by plugins that didn't clean up.
oEmbed cache and pingbacks/trackbacks — more low-value rows.
None of this is doing useful work, but it all makes queries slower and backups bigger.
Cleaning without the risk
The workflow is deliberately cautious:
- Analyze to see the counts and table overhead. 2. Cleanup as a dry-run to confirm exactly how many items each category would remove. 3. Cleanup for real by passing dry_run:false. Revisions keep the newest keep_revisions per post, posts and comments are deleted with WordPress's own functions (so their meta and relationships go too), and big categories are removed in batches you can repeat until they're clear. 4. Optimize tables to reclaim the freed space.
Because it runs on your own database and never sends anything out, it fits a pay-once, self-hosted, privacy-first approach — no cloud service, no subscription, no data leaving your site.
Pairs with performance
A bloated database is a common hidden cause of slow response times, and oversized autoloaded options in particular drag every page load. This module pairs naturally with GOMAX's performance auditor: the auditor flags the symptom (slow TTFB, heavy autoload), and the database tool clears the cause.
Frequently asked questions
Is it safe to delete post revisions and transients? Yes. Expired transients are meant to be discarded and WordPress regenerates them as needed. Revisions are just old copies — and the tool keeps the newest few per post by default, so you retain recent history. Everything is previewed with a dry-run before deletion.
Will cleanup break my site or leave orphaned data? No. Posts and comments are removed using WordPress's own delete functions, so their metadata and relationships are cleaned up too. Orphaned-meta categories specifically target rows whose parent is already gone.
Does this send my database anywhere? No. It operates only on your own database on your own server. Nothing is sent to GOMAX or any vendor cloud — it's a self-hosted, pay-once tool.
What does optimizing tables do? After large deletions, tables can hold empty "overhead" space. OPTIMIZE TABLE compacts them to reclaim that space, which can shrink your database and speed up queries.
Can it run automatically? Yes. There's an optional daily auto-clean that clears your chosen categories a batch at a time. It's off by default, so nothing runs until you enable it.
Top comments (0)