Database Performance

Clean wp_options Autoload Bloat Safely

Autoloaded options load on every request. Bloated rows inflate memory and TTFB. Audit first — delete last.

Identify heavy autoload rows

Query wp_options for autoload = 'yes' ordered by length. Flag abandoned plugin prefixes and oversized transients stored as options.

Pair with wp-config limits

While you clean the database, tighten revisions and memory defines with the free tweaker:

Open wp-config Tweaker

Automate with a freemium plugin

For recurring audits, use WP Database & Performance Optimizer — Free for scans, Pro for scheduled cleanups.

FAQ

Is it safe to set autoload=no?

Often yes for orphaned plugin data. Always back up and test on staging before changing critical options.