WordPress Slow Queries from Autoloaded Options Bloat

Warning Frequency: Common

Error message: Slow query: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'

Every WordPress page load queries all autoloaded options from the wp_options table. If this data grows too large (over 500KB), it adds measurable latency to every single request. A healthy autoloaded data size is under 200KB.

This is one of the most common and overlooked WordPress performance issues. Plugins love to store data with autoload=yes, and they rarely clean up after themselves when deactivated.

Common Causes

Plugins storing large serialized data with autoload=yes
Abandoned plugin data left in wp_options after deactivation
Transients stored in wp_options (when no external object cache is configured)
Theme settings, customizer data, and widget data accumulating
Some plugins storing log data or analytics in autoloaded options

How to Fix It

Audit autoloaded data size: SELECT SUM(LENGTH(option_value)) FROM wp_options WHERE autoload IN ('yes','on','auto');
Find the biggest offenders: SELECT option_name, LENGTH(option_value) as size FROM wp_options WHERE autoload IN ('yes','on','auto') ORDER BY size DESC LIMIT 20;
Set large options to autoload=no: UPDATE wp_options SET autoload='no' WHERE option_name='large_option_name';
Clean up orphaned plugin data: Delete options from plugins you've removed
Install Redis or Memcached object cache to move transients out of the database
Use the MakeWPFast WP Multi Tool to audit and optimize autoloaded data

Frequently Asked Questions

What is autoloaded data in WordPress?

Every page load, WordPress queries all options marked as autoload='yes' from the wp_options table and loads them into memory. This is meant for small, frequently-used settings. When plugins abuse it to store large blobs of data, it slows down every page.

How much autoloaded data is too much?

Under 200KB is healthy. 200-500KB means you should investigate. Over 500KB is bloated and definitely impacting performance. Use our WP Multi Tool to audit this.