InnoDB Website

White papers about InnoDB

White papers on InnoDB … coming soon

Presentations about InnoDB

InnoDB: Innovative Technologies for Performance and Data Protection (MySQL Conference 2009)

InnoDB has always had unique features to maximize performance and protect the integrity of your data. As hardware has evolved, InnoDB has been enhanced to take full advantage of modern multi-core, large memory platforms. This presentation covers the special design features of InnoDB and the performance- and reliability-enhancing features recently introduced in the InnoDB Plugin.

Crash Recovery and Media Recovery in InnoDB (MySQL Conference 2009)

InnoDB provides a reliable, true-and-tested automatic crash recovery for MySQL database users. It is based on a redo log and write-ahead logging, two techniques that are used in most of the leading database engines in the world. This presentation explains these techniques in depth, and presents some benchmarks of crash recovery time. InnoDB’s media recovery is done from a (hot) backup of a database, using the MySQL binlog to replay the transactions just as they happened originally. The presentation discusses the difference between MySQL’s statement-based and row-based replication and binlogging, and how they should be used to ensure a successful replay of transactions.

Concurrency Control: How it Really Works (MySQL Conference 2009)

This presentation describes how InnoDB manages concurrency control, so that users get superior performance and transaction throughput, while the system protects data integrity. The presentation begins with the basics of transaction management, includes a discussion of the ACID (atomicity, consistency, isolation, and durability) properties, and explains various transaction modes, locking, deadlocks, and more advanced topics such as the impact of next-key (gap) locking, referential integrity, XA (distributed transaction management) support and more. While the discussion focuses on the InnoDB implementation, many of the concepts presented apply to other database systems and storage engines. Armed with this knowledge, you will be better able to choose the appropriate storage engine for your application, select appropriate transaction modes, and understand how to diagnose performance problems that are a result of concurrency bottlenecks.

InnoDB File Formats and Source Code Structure (MySQL Conference 2009)

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. The discussion explains how the new file format management works in the InnoDB Plugin. This presentation also covers InnoDB source code structure – 31 subdirectories that come with the MySQL source code under storage/innobase

InnoDB Overview and InnoDB Plugin Announcement MySQL UC 2008

This presentation introduces the InnoDB Plugin and describes its new features and performance capabilities.

Intro to InnoDB at the 2008 MySQL User Conference

This presentation provides a quick introduction to InnoDB, the InnoDB Plugin and InnoDB Hot Backup, along with a comparison to other storage engines and other backup approaches.

Introduction to InnoDB and InnoDB Hot Backup

This presentation provides an introduction and overview of InnoDB and of InnoDB Hot Backup (PDF).

InnoDB Overview 2006 MySQL User Conference

This presentation introduces InnoDB and its architecture. Illustrations of the way InnoDB manages storage, memory, locking and transactions are presented.

InnoDB Architecture & Locking MySQL User Conference 2007

This presentation complements the previous presentation, reviewing the architecture briefly and providing an in-depth look at InnoDB locking. Upcoming new features are also described.

InnoDB Performance Optimization

InnoDB can perform extremely well or be your performance nightmare if you do not tune it right. This talk is about InnoDB performance optimization, covering a wide range of topics from Server Settings optimization, to InnoDB specific query optimization, including hardware configuration and OS tuning tricks. This presentation was delivered at the 2007 MySQL User Conference by Peter Zaitsev of Percona, Ltd. and Heikki Tuuri. You will find this and other presentations and articles about MySQL and InnoDB performance on the MySQL Performance Blog.

Articles relating to InnoDB

Books relating to InnoDB

Documentation

Documentation for InnoDB is integrated with the MySQL documentation. See the relevant chapters in the online manual for the version you are using:

• v4.1 and earlier
• v5.0
• v5.1
• v6.0