InnoDB Website

InnoDB provides full support of standard SQL isolation levels for ACID-compliant transaction processing, and maximizes throughput with row level locking and multi-version concurrency control (MVCC). InnoDB ensures high performance, minimizing expensive disk I/O, via many techniques to efficiently use memory and processor resources. InnoDB ensures data integrity and reliability with such capabilities as referential integrity support and automatic data recovery following hardware and software failures.

InnoDB fully integrates with MySQL and such features as stored procedures, triggers and views. InnoDB in MySQL 5.0 introduced a compact table format that saves about 20% of space when compared to the old table format. With MySQL 5.0, InnoDB also supports two-phase commit through the XA protocol.

With MySQL 5.1, InnoDB introduces improvements in memory management for databases with large tables, improved scalability and reliability.

The InnoDB Plugin for MySQL 5.1 permits users to replace the “built-in” InnoDB storage engine in MySQL 5.1 with a dynamically loaded version of InnoDB that brings new features, performance, reliability and ease of use. Key new features of InnoDB Plugin 1.0 for MySQL 5.1 include table compression, “fast index creation” and Information Schema tables for monitoring runtime information.