How to Optimize WordPress Database for Better Performance

By Emily Watson Jul 9, 2026 8 min read How-To Guides

WordPress stores everything in a MySQL database: posts, pages, comments, users, settings, and plugin data. Over time, this database accumulates unnecessary data that slows down queries and page loading. Here is how to optimize your WordPress database.

Why Database Optimization Matters

Every time a visitor loads your page, WordPress queries the database for content. A bloated database with thousands of post revisions, spam comments, and transients makes these queries slower. Database optimization removes this unnecessary data, reduces database size, and improves query speed.

Use a Database Optimization Plugin

WP-Optimize is the best free plugin for cleaning and optimizing your WordPress database. It removes post revisions, trashed posts, spam comments, transients, and pingbacks with one click. The plugin also optimizes database tables by reclaiming unused space. WP Rocket includes database optimization as part of its feature set.

Manual Database Cleanup

If you prefer manual control, use phpMyAdmin to access your database directly. Look for tables like wp_posts, wp_postmeta, wp_comments, and wp_options. Delete post revisions older than 30 days. Remove orphaned post metadata. Delete expired transients from wp_options table. Always back up your database before making manual changes.

Limit Post Revisions

WordPress saves a revision every time you save a draft, which can create hundreds of revisions per post. Add define(WP_POST_REVISIONS, 5) to your wp-config.php file to limit revisions to the most recent 5 per post. Or disable revisions completely with define(WP_POST_REVISIONS, false). This significantly reduces database bloat for sites with many posts.