Memory Management in MySQL and Drizzle

Cloud Computing, Storage Engine Development and Optimization
Location: Ballroom A Level: Expert
Average rating: ***..
(3.00, 2 ratings)

How does the database server use memory? Where? What are the scaling implications of how we allocate, use and free memory in the database server? Can we scale to many CPU cores effectively? Do alternate malloc libraries really help? Why? What does MySQL do? What does Drizzle do (and what have we changed?). These questions (and more) will be answered in this session.

We’ll cover a variety of caches in the database server and how they’re allocated and used (query cache, key cache, table cache etc). We’ll delve into the server internals and go over “What is a MEM_ROOT?”, how they’re implemented, the impact of them over plain malloc() and other types of allocators. What impact does this have for tools such as valgrind? Are we getting speed at the expense of the usuability of tools such as valgrind? Are we using more memory than we need to? Is this a space vs speed tradeoff?

What do various storage engines do? Are they any better/worse than the SQL server?

I’ll present research and experience on the MySQL and Drizzle database servers. I’ll present new work on Drizzle (a whole bunch of which is in progress and yet to be completed) and plans of how to get to a more efficient database server as well as one that’s easier to write correct code for.

Photo of Stewart Smith

Stewart Smith


Stewart Smith works for Sun as a Senior Software Engineer. He has recently moved to working full time on Drizzle after spending four years working on MySQL Cluster (which he continues to love). He’s often found writing free software, speaking at conferences, at 38,000ft, in the kitchen and on the jiu jitsu mat (not all at the same time though).

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.