WordPress database optimization: revisions, transients and autoload
Over time a WordPress database fills up with revisions, auto-drafts, expired transients and heavy autoload options. This guide uses safe commands and a backup first to show what to clean up and what to leave alone.