InnoDB: A hands-on exploration of on-disk storage with innodb_ruby

Database Administration
4 April 11:00AM - 11:50AM @ Ballroom C

Experience level: 
Intermediate
Duration: 
50 minutes conference
Last year, we demoed innodb_ruby in “InnoDB: A journey to the core” with very small snippets; this year we’ll walk you through exploring InnoDB’s on-disk storage for yourself. We’ll provide sample data files and a working environment for you to explore along with us, and demonstrate usage of the tool’s many features in realistic scenarios. The innodb_ruby library and tools can be used to: * Understand byte-by-byte the exact data stored in InnoDB files, pages, and records. * Make better informed decisions about database and schema design. * Discover the storage efficiency of InnoDB for different table schemas. * Uncover storage-related bugs and problems with different table schemas and access patterns. In addition to the provided data files, feel free to bring your own computer, data files, and create table statements (nothing confidential please!) and we’ll help you get set up to explore them on your own. We’ll be on-hand to explain and answer any questions you may have about InnoDB storage internals.


Speakers

Sr. Systems Engineer, Google, Inc.
Biography: 
Jeremy is working on MySQL and related systems as a Sr. Systems Engineer in the SRE organization at Google. Jeremy was an early MySQL user, and an early employee of MySQL; later on, a community member, and an outside contributor. Prior to Google, Jeremy organized and led the MySQL Geeks that kept Yahoo! running, ran Proven Scaling consulting for dozens of companies, and built and led the DBA team at Twitter.
Senior Software Engineer, LinkedIn
Biography: 
Davi Arnaut is a member of the MySQL development team at LinkedIn. He works closely with LinkedIn's data team to add new features to MySQL, evaluate performance, and track down and fix bugs. In the past, Davi was a lead software engineer in the MySQL development teams at Twitter and Oracle.

Slides