Building the Invisible Cache
Performance e tuningNobody sets out wanting a cache. You end up needing one. MySQL's built-in query cache was the right idea at the wrong time. It didn't scale on modern multi-core systems. Under real concurrency it became a bottleneck rather than a relief valve. It was deprecated in 5.7 and removed in 8.0. The problem it was solving never went anywhere, so platform teams have been rebuilding it by hand ever since on Redis or Valkey, which will happily store whatever you put in it and leave the hard part to you. You pay in hardware, invalidation bugs, and engineering time. Readyset has been working on this for years. This talk walks the path through shallow caching, deep caching via incremental view maintenance, Query Pilot all the way to Adaptive Cache, which decides what to cache and when without application changes or manual invalidation logic.