WordPress Database Cleanup Guide

Your WordPress database quietly accumulates clutter the entire time your site is running — most of it invisible until it starts slowing things down. Here's what's actually building up, and how to clean it out safely.

What Actually Causes Database Bloat

WordPress saves a new revision every time you update a post by default, with no automatic limit — on an active site, revisions alone can make up 40-60% of all rows in your posts table. Beyond that: spam and trashed comments stay in the database indefinitely unless deleted, expired "transients" (temporary cached data plugins create) often never get cleaned up on lower-traffic sites, and uninstalling a plugin frequently leaves its tables and settings behind rather than removing them.

How Bloat Slows Your Site Down

Every page load runs database queries, and a bloated database makes each one slower — the effect compounds as your site grows. In practice this shows up as a sluggish admin dashboard, larger and slower backups, higher memory use (especially noticeable on shared hosting), and reduced effectiveness from any caching you have in place. If the admin dashboard specifically is the main pain point, see our dedicated guide to a slow wp-admin for the other common causes beyond the database.

What's Safe to Delete (and What Isn't)

Old post revisions, spam and trashed comments, and expired transients are generally safe to clear — they're not content anyone is relying on. Orphaned metadata left behind by a deleted plugin is usually also safe, but worth confirming the plugin is genuinely gone first. What you should not touch without knowing exactly what it does: any table tied to an active plugin, your users table, or anything in your actual posts and pages content.

Limiting Future Bloat

Rather than repeatedly cleaning up revisions after the fact, capping how many WordPress keeps going forward stops the problem at the source — adding a single line to wp-config.php (define('WP_POST_REVISIONS', 3);) limits WordPress to keeping only the most recent few revisions per post automatically.

Cleaning Up Safely

Always back up your full database before any cleanup — this is non-negotiable, since a bad cleanup script can remove more than intended. A reputable plugin like WP-Optimize handles the common cleanup tasks with a clear confirmation step before anything is deleted, which is a safer path than running manual SQL queries unless you're confident reading a database schema. Running OPTIMIZE TABLE afterward reclaims the actual disk space the deleted rows were using. A monthly cleanup schedule is enough to keep most small business sites from re-accumulating meaningful bloat.

Common Questions