What this problem is
The wp_options table becomes very large and slows down every page load (autoloaded data loads on each request).
Why it happens
- Plugins store large serialized data in autoloaded options
- Expired transients are not cleaned
- Plugin uninstall leaves options behind
Prerequisites
- Database backup
- phpMyAdmin access
Diagnosis
In phpMyAdmin, check autoloaded size by querying options where autoload = yes and sorting by size (advanced) or use a trusted DB analysis tool.
Detailed steps
Step 1) Identify large autoloaded options
Look for unusually large values belonging to specific plugins.
Step 2) Reduce autoload when safe
If a plugin stores large data and does not need autoload, set autoload to no (only if you know the plugin behavior or vendor confirms).
Step 3) Clean transients
Delete expired transients and, if needed, remove all transients to force regeneration.
Step 4) Remove leftover options for removed plugins
Only remove if you are sure the plugin is not used.
Expected results
- Smaller autoload size and faster TTFB
What to do if it fails
- Restore from backup if a removal breaks functionality
Best practices
- Audit autoload size after installing large plugins (builders, caches, security suites)