Clean up wp_options table (autoloaded data)

My favorite commands for cleaning up autoloaded data from your wp_options table.

Why should you remove autoloaded data? It’s because this type of data is loaded on every page load and often contains data that is no longer used (left behind by already deleted themes/plugins) or left behind because WP-cron wasn’t working and some plugins didn’t clean up after themselves.

Get into your phpmyadmin tool from webhosting control panel (cPanel, Plesk, etc) and follow the commands below!

How much difference can autoloads make?

HUGE! Freaken huge! I’ve seen awful bloated sites with many MB of autoloaded data. Cleared it all and the whole site felt so much lighter, both on frontend and backend. Keep in mind y’all, the backend can’t be cached. Cleaning autoloads definitely has a measureable impact on massively bloated sites and one of the advanced tasks that separates pros from non-pros.

NOTES:

  • Backup your database before trying any of these optimizations.
  • If your database has a prefix (e.g. “wp_123abc_” instead of only “wp_”), then retype SQL commands below using the prefix “wp_123abc_options” instead of “wp_option”.

1. Check autoloaded data size

SELECT SUM(LENGTH(option_value)) as autoload_size FROM wp_options WHERE autoload='yes';

This one shows you how big the autoloaded table is. Anything above 1MB really badly needs to be cleaned up; I’ve seen sites with even 40MB (no wonder they crashed!). I try to stay below 500kb if possible (although even 1MB is considered OK). If you have 500kb or less, you can stop here!

2. List top autoloaded data entries

SELECT option_name, length(option_value) AS option_value_length FROM wp_options WHERE autoload='yes' ORDER BY option_value_length DESC LIMIT 200;

This will list the top 30 autoloaded data entries in the table. Delete the ones you know aren’t being used anymore. You can also increase the DESC LIMIT 200 to a higher number like 300 or 500 if you want to see more items. Usually the first 10-50 items make up the bulk of your autoloaded data anyway. And it’s usually only a few plugins that are creating most of the bloat. (Although some really old sites may have tons of stuff left over from deleted themes and plugins.)

3. Find specific autoloaded data

SELECT * 
FROM `wp_options` 
WHERE `autoload` = 'yes'
AND `option_name` LIKE '%jetpack%'

This command is useful for targeting specific plugins that you KNOW for certain you aren’t using any longer. This is great for cleaning up remnants left from old themes and plugins. Simply replace the string “jetpack” with anything else you like. You’ll also notice that many plugins don’t use their full name. For example, items related to “Full Velocity Minify” plugin might be listed with the string “fvm” in the database.

4. Tracking down mystery autoloads

Did you see some giant autoloads but you’re not sure whether or not you can delete it? Don’t you worry, I have a few handy tricks up my sleeve:

  • Click on edit and look at the data inside. Sometimes they give you a clue what it’s used for.
  • Search the option name in Google in quotations. It might also help if you type the word “WordPress” or “plugin” or “theme” before it.
  • You can also try using step #3 above, but search only the first prefix of the option name. For example, if the full name is “wds_service_results” then you can do step #3 but replace “jetpack” with “wds_”. Sometimes, you’ll find the other option names with more helpful data to track down which plugin it is.
  • Last but not least, you can simply change the autoload value to “no”. (Then change it back if anything breaks, or delete after a month if all is well.)

Johnny’s personal autoload removal list

A list of the biggest autoload offenders that I often run into. If you see any autoloads you aren’t familiar with. Google around to see what they might be related to. Perhaps an old theme or plugin you haven’t used in a while. (Obviously, you should not delete any autoloads for active plugins!)

Plugins with high autoloads

  • BackupBuddy
  • Mobi by Phpbits
  • Revolution Slider (of course!)
  • Thrive Architect/Leads
  • cherry_customiser_fonts_google – probably came from some Google fonts plugin
  • transients – some people don’t realize they have 40mb of transients sitting there! (YIKES!)
  • SchemaPro
  • BeRocket
  • Jetpack
  • WPMU DEV (and their many plugins)
  • Pegasus Accelerator WP
  • Redirect plugins
  • Redux framework (any theme using this)
  • Security Ninja

There’s hundreds more plugins with awful autoload…find them all! (Feel free to report in the comments and I’ll add them here.)

Themes with high autoloads

  • Martify

Latest Guides