InnoDB Internals: InnoDB File Formats and Source Code Structure

Heikki Tuuri (Innobase / Oracle Corp.), Calvin Sun (Twitter)
Average rating: **...
(2.75, 4 ratings)

InnoDB is the most popular, reliable and functional of the transactional storage engines available for MySQL database users. InnoDB provides transactions, row-level locking, and automatic crash recovery. InnoDB on-disk files play a pivotal role for those features. This presentation describes how on-disk files are structured, how compressed tables are organized, and how long variable-length columns are stored.

As we develop new features, it is inevitable for file format changes. We will explain how the new file format management works in the InnoDB Plugin.

During this session, we will also cover InnoDB source code structure – 31 subdirectories that come with the MySQL source code under storage/innobase.

Heikki Tuuri

Innobase / Oracle Corp.

Heikki Tuuri is the creator of the InnoDB transactional storage engine in MySQL. He founded Innobase Oy in 1995 and is the CEO of the company. Prior to founding Innobase Oy, Tuuri worked at the University of Helsinki, from which he also received a Ph.D, degree in mathematical logic in 1990.

Photo of Calvin Sun

Calvin Sun

Twitter

Calvin Sun is the senior engineering manager at Twitter, managing the MySQL development. Prior to that, he was managing the InnoDB team at Oracle. Calvin was a development manager at MySQL from 2006 to 2008, managing MySQL storage engines and 3rd party storage engine vendors relationships. He has over 15+ years of database development experience, mostly on various storage engines.

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.