WordPress Database Performance

Autoloaded options, post revisions, transients and orphaned metadata: what actually makes a WordPress database slow, and how to fix each one.