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.
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).
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.