WordPress database optimization-reduce size and improve speed

WordPress databases accumulate bloat: old revisions, spam, unnecessary options. A bloated database slows queries. Optimization removes junk and defrags tables for speed.

Remove post revisions

Each time you save a post, WordPress stores a revision. After 100s of revisions, the database grows large.

Limit revisions in wp-config.php:

define('WP_POST_REVISIONS', 5);  // Keep only 5 recent revisions

Clean spam comments

Akismet and spam plugins catch comments but may not auto-delete. Empty trash manually:

1. WordPress admin → Comments
2. Click Spam tab
3. Select all → Delete permanently

Reduce autoload options

WordPress loads certain options on every page load (autoload='yes'). Too many autoload options slow WordPress:

SELECT COUNT(*) FROM wp_options WHERE autoload='yes';

Disable autoload for unused plugin options via phpMyAdmin.

Run OPTIMIZE TABLE

Defragments tables and reclaims space:

OPTIMIZE TABLE wp_posts;
OPTIMIZE TABLE wp_postmeta;
OPTIMIZE TABLE wp_comments;

Use optimization plugins

• Advanced Database Cleaner: Remove revisions, spam, orphaned data
• WP-Optimize: Optimize, compress, clean all in one
• WP-Sweep: Delete unused data safely

Related: WordPress troubleshooting-common issues and fixes | Slow database queries

Related articles