Understanding How MySQL Works by Understanding Metadata
Location: Ballroom H
We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.
Examples: Understanding the “query_cache%” system variables and “Qcache%” status variables helps us learn about the query cache—what it is, when it is used, how to examine query cache efficiency, how to tune the query cache. This relates to the GLOBAL_VARIABLES and GLOBAL_STATUS system views and corresponding SHOW commands.
The CHECKSUM field of the TABLES system view in the INFORMATION_SCHEMA DATABASE seems straightforward—it holds the checksum. But when is that field updated, and for which storage engines?
Like CHECKSUM, there are many storage-engine features that are hiding in plain sight. By reverse engineering MySQL’s metadata, we will show you many of these features.
People planning to attend this session also want to see:
Sheeri K. Cabral
Mozilla Foundation
Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; has worked with Oracle, Sybase, DB2, Solaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and co-wrote The MySQL Server Administrator’s Bible, to be published in May 2009. Keep up with all this at www.technocation.org
Patrick Galbraith
Blue Gecko
Patrick Galbraith is a senior systems and database administrator at Blue Gecko. He is the author or two recent books:
“Developing Web Applications with Apache, MySQL, memcached, and Perl” (Wiley)
“Expert PHP and MySQL” (Wiley)
In his “spare time”, he also maintains DBD::mysql, DBD::drizzle, FederatedX storage engine and the Memcached Functions for MySQL. He has just authored “Developing Web Applications using Perl, Memcached, MySQL, and Apache”. Patrick lives up in the sticks of New Hampshire with his wife Ruth and son Kiran as well as his Kubota tractor.
Comments on this page are now closed.
Co-presented By:
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
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@ oreilly.com
Press and Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
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.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
Event Software Powered by Expectnation
© 2009, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
Comments
Watch part 1: www.youtube.com/watch?v=V3I...
Watch part 2: www.youtube.com/watch?v=C_U...
People have reported that the “play” link loads for 15-20 minutes before actually streaming the content; however, the download link works just fine. I apologize for any inconvenience.
The video for this presentation is at:
Play part 1 – 1 hour 26 min and Play part 2 Download part 1, 374.07 MB, .mov format. and Download part 2John—thanx! Maybe next year we’ll do a full day tutorial so we can cram more examples in. Until then, you can use what you learned to figure out more examples by yourself, too. We hoped to give both practical examples and the methodology by which we figured the examples out, so that anyone can figure out other practical examples.
I hope the tutorial was extremely helpful for you!
lots of excellent practical examples. Would have liked more of the same.