The MySQL Query Cache was once one of the most recognizable performance features in MySQL. It was deprecated and eventually removed because it couldn’t scale on modern multicore systems. Does that mean query caching itself is a bad idea?
In this session, Marcelo Altmann revisits why the original Query Cache failed, why traditional key/value caches became the dominant solution, and how Readyset combines ideas from both approaches to overcome many of their historical limitations. He covers:
- the anatomy of reads in MySQL and PostgreSQL
- cache invalidation strategies
- how transparent query caches deliver low-latency reads while maintaining correctness
Marcelo has almost 20 years of experience with MySQL, has contributed code fixes to MySQL itself, and is part of the Oracle ACE program.