The MySQL Query Cache

Architecture and Technology
Location: Ballroom F Level: Novice
Average rating: *****
(5.00, 1 rating)

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!
Photo of Baron Schwartz

Baron Schwartz


Baron Schwartz is the founder and CTO of VividCortex, the best way to see what your production database servers are doing. Baron has written a lot of open source software and several books, including High Performance MySQL. He’s focused his career on learning and teaching about performance and observability of systems generally, including the view that teams are systems and culture influences their performance, and databases specifically.

  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.