The MySQL Query Cache

Understanding and tuning the query cache can be daunting. It’s not really complicated; it only seems that way. Schwartz will explain it in ways you’ll understand and remember. Here’s what we’ll cover:

• How the query cache works.
• What the query cache is NOT.
• Myth-busting time! Everyday “wisdom” that is repeated often, but remains untrue (imagine that!)
• How the query cache uses memory.
• What kinds of workloads benefit from the query cache, and when you should just disable it.
• How to understand the query cache’s performance, fragmentation, average query size, and other important metrics.
• How to tune the query cache to balance its benefits against fragmentation, pruning, and other costs. Schwartz will present a flow-chart that will demystify this process.
• What FLUSH QUERY CACHE really does, and how to use it to improve performance.
• Little details: how the cache works with prepared statements, LOCK TABLES, and transactions.
• Time for your questions!