How to Optimize a WordPress Database (2026)

How to Optimize Your WordPress Database

Over time, WordPress databases accumulate bloat: post revisions, trashed content, expired transients, spam comments, and orphaned metadata. A clean database runs faster and uses less storage.

What Causes Database Bloat?

• Post revisions: WordPress saves a revision every time you update a post. A busy blog generates thousands of revision rows.
• Transients: Temporary data cached in the database. Expired transients aren't always cleaned up automatically.
• Spam and trash: Comment spam and trashed posts/pages remain in the database until deleted.
• Orphaned metadata: Post meta rows that reference deleted posts.
• Plugin data: Deactivated plugins often leave tables and options behind.

Method 1: WP-Optimize Plugin (Recommended)

1. Install WP-Optimize from the plugin directory
2. Go to WP-Optimize → Database
3. Review the optimizations available: Post Revisions, Trashed Posts, Spam Comments, Transients, etc.
4. Check the items you want to clean, then click Run All Selected Optimizations

Always back up your database before running optimizations. SiteICO's automated daily backups provide this safety net automatically.

Method 2: WP-CLI Commands

SiteICO provides WP-CLI access for every site. From your site dashboard, open the terminal and run:

wp transient delete --expired
wp post delete $(wp post list --post_status=trash --format=ids) --force
wp comment delete $(wp comment list --status=spam --format=ids) --force
wp db optimize

Limit Post Revisions

Add this line to wp-config.php to limit revisions going forward:

define( 'WP_POST_REVISIONS', 5 );

This keeps only the 5 most recent revisions per post — enough for recovery purposes without excessive bloat.

Schedule Regular Maintenance

WP-Optimize supports scheduled automatic cleanups. Configure weekly runs to keep your database lean without manual intervention.