An old saw
Fast, reliable, cheap - Pick two. Reliable Referential Integrity is apparently not required by some users. So we can't have fast too?
The developers of MySQL Server have decided its Query Cache feature is a bottleneck and killed it off. Looking over the number of results (and the diversity of advice offered) if you search “tuning MySQL query cache”, it's not entirely surprising. The problem is scalability, as MySQL Server product manager Morgan Tocker …