Breaking my radio silence on this here blog to call out for help: if you know why my alloptions cache ends up as 0 when I restart Memcached, I’d love to hear from you.
Because when alloptions ends up as 0, wp_cache_add() never adds alloptions to the object cache, resulting in hundreds of options queries on every page load.