Understanding How MySQL Works by Understanding Metadata

Sheeri K. Cabral (Mozilla Foundation), Patrick Galbraith (Blue Gecko)
Average rating: ***..
(3.29, 7 ratings)

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.

Photo of Sheeri K. Cabral

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

Photo of Patrick Galbraith

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.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/29/2009 1:10pm PDT
Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/06/2009 4:29pm PDT

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.

Picture of Sheeri K. Cabral
Sheeri K. Cabral
05/19/2009 10:57am PDT
Video for this presentation: Play part 1 – technocation.org/node/714/play Play part 2 – technocation.org/node/715/play Download part 1, 374 Mb, .mov format – technocation.org/node/714/d... Download part 2, 382 Mb, .mov format – technocation.org/node/715/d...
Picture of Sheeri K. Cabral
Sheeri K. Cabral
05/19/2009 10:55am PDT
Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/27/2009 10:44am PDT

John—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!

04/21/2009 5:55am PDT

lots of excellent practical examples. Would have liked more of the same.

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