4 min read

WordPress sites tend to accumulate weight over time. Extra plugins, unused themes, oversized media, auto-draft revisions, and spam comments all slow things down. If your site feels sluggish or your hosting resources are maxed out, it might be time for a checkup.

Signs of a Bloated WordPress Site

  • Load times over 3 seconds on a simple page
  • Database larger than 200MB for a standard business or blog site
  • 30+ active plugins (most sites need 10-15)
  • Multiple unused themes installed
  • High CPU or memory usage in cPanel’s resource tracking
  • Frequent 508 (Resource Limit Reached) errors

How to Audit Your Site

1. Check Your Plugin Count

Go to Plugins > Installed Plugins in your WordPress dashboard.

Count them. For a typical business site, anything over 20 active plugins is worth reviewing. Ask yourself for each one:

  • Does this plugin do something I actually need?
  • Could two or more of these plugins be replaced by a single one?
  • Is there a lighter alternative?

Common culprits:

  • Multiple SEO plugins installed (you only need one)
  • Analytics plugins when you already use Google Analytics
  • Social sharing plugins that load heavy scripts
  • “Coming soon” or “maintenance” plugins left active after launch
  • Performance plugins that conflict with each other

2. Check Your Database Size

In phpMyAdmin, look at the total size shown at the bottom of the table list. Or run:

  SELECT table_name, 
       ROUND(data_length / 1024 / 1024, 2) AS size_mb
FROM information_schema.tables 
WHERE table_schema = 'your_database_name'
ORDER BY data_length DESC
LIMIT 20;

Commonly bloated tables:

  • wp_options: should be under 5MB. If it’s larger, you have autoloaded data from old plugins
  • wp_posts: includes revisions and auto-drafts. Thousands of revisions inflate this
  • wp_postmeta: grows fast with WooCommerce and page builders
  • wp_actionscheduler_*: WooCommerce’s task scheduler can accumulate millions of rows

3. Check Post Revisions

WordPress stores every revision of every post by default. A post edited 50 times has 50 revisions.

  SELECT COUNT(*) FROM wp_posts WHERE post_type = 'revision';

If this returns thousands, limit revisions by adding to wp-config.php:

  define('WP_POST_REVISIONS', 5);  // keep only the last 5 revisions

Then clean up old ones. Back up the database first. The simplest way is the revision cleanup in WP-Optimize (see Tools below), which also removes the revisions’ metadata. On a VPS, Business Cloud or dedicated server with WP-CLI:

  wp post delete $(wp post list --post_type=revision --format=ids) --force

A raw DELETE FROM wp_posts WHERE post_type = 'revision'; in phpMyAdmin works too, but it leaves orphaned rows in wp_postmeta and wp_term_relationships. Change wp_ if your table prefix is different.

4. Check Media Library Size

Large, unoptimized images are one of the biggest performance drains. Check your wp-content/uploads/ folder size:

  du -sh ~/public_html/wp-content/uploads/

If it’s over 1GB for a site with fewer than 500 posts, you likely have oversized images. Consider:

  • Compressing existing images with ShortPixel or Imagify
  • Adding WebP conversion
  • Deleting media files that aren’t attached to any post

5. Check Autoloaded Data

Autoloaded options are loaded on every single page view, whether they’re needed or not:

  SELECT SUM(LENGTH(option_value)) / 1024 / 1024 AS autoload_mb
FROM wp_options 
WHERE autoload IN ('yes', 'on', 'auto-on', 'auto');

Under 1MB is healthy. Over 3MB is a problem.

How to Slim Down

ActionImpact
Remove unused pluginsHigh - reduces PHP execution, memory, and sometimes database queries
Delete unused themes (keep one default)Medium - reduces disk space and potential security surface
Limit post revisions to 5Medium - prevents database growth
Clean up spam and trash commentsLow-medium - fewer rows in wp_comments
Optimize database tablesLow - reclaims fragmented disk space
Compress imagesHigh - reduces page size and load time
Delete transientsLow - they regenerate automatically

Tools That Help

  • WP-Optimize - one-click database cleanup, image compression, and caching
  • Query Monitor - shows which plugins run the most database queries per page
  • WP-CLI (if you have SSH access):
      wp plugin list --status=inactive    # find inactive plugins
wp transient delete --all           # clear all transients
wp db optimize                      # optimize tables

Last updated 21 Oct 2026, 00:00 +0300. history

Was this page helpful?