Blog / Tag
database
2 posts
WordPress autoloaded options: how to find what is loading on every page, and fix it
Every request starts by loading every wp_options row marked autoload into memory. On a healthy site that's a few hundred kilobytes. On most sites I open, it's megabytes of leftovers. How to measure it, read the list, find who is writing it, and clean it without breaking anything.
Speed 12 min
The 29 GB WordPress database that was mostly nothing
A client's dashboard took eleven seconds to open. The database was 29 GB. The actual content, every post, product, order, and customer, was a small fraction of that. What was in the rest, how it got there, and the three queries that found it.
From the bench 7 min