The MySQL Query Cache

Baron Schwartz (VividCortex Inc)
Architecture and Technology
Location: Ballroom F
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

VividCortex Inc

Baron is co-founder and CTO of VividCortex, a provider of SaaS database administration tools. He is the lead author of High Performance MySQL and continues to research and publish under the O’Reilly imprint. He has created several open-source software tools, including Maatkit, and has authored features for MySQL and InnoDB. He is an Oracle ACE, and the founder of the worldwide OpenSQL Camp conference series. He holds a degree in Computer Science from the University of Virginia. Baron lives in Charlottesville, Virginia with his family.

Sponsors
  • 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.