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

Performance Optimization
23 September 5:20PM - 6:10PM @ Zürich 1

Experience level: 
Intermediate
Duration: 
50 minutes conference
Following up on "InnoDB: A journey to the core", 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: * Illustrate/plot index models in InnoDB and their impact on disk usage * Make better informed decisions about database and schema design * Discover the storage efficiency (fragmentation) of InnoDB for different table schemas * Understand byte-by-byte the exact data stored in InnoDB files, pages, and records. In addition to the provided data files, feel free to bring your own computer, data files, and create table statements 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.
Jeremy Cole is a long-time MySQL Geek and pioneer of MySQL scalability. Jeremy started his MySQL adventure in 2000 as the fourteenth employee of a startup: MySQL AB. His initial work was primarily on documentation and core development, soon transitioning into support, and finally running the training and consulting organization during his four and a half years there. After MySQL, Jeremy coined the “MySQL Geek” title at Yahoo!, supporting hundreds of internal users of MySQL and many thousands of MySQL servers within Yahoo!’s infrastructure, as well as building a large team of MySQL experts around the world. Jeremy went on to found one of the premier MySQL consulting companies, Proven Scaling, which during its more than three years of operation provided detailed advice, optimization, new tools, and hands-on DBA and emergency support to more than 100 influential companies. For more than two years, Jeremy managed the growing team of DBAs at Twitter, keeping the world tweeting. Jeremy is currently making MySQL more awesome at Google.
Software Engineer, LinkedIn
Davi Arnaut works on leveraging MySQL to support LinkedIn's distributed data storage platform. In the past, Davi was a part of the the MySQL development teams at Twitter and Oracle.