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