14.2 The InnoDB Storage Engine

14.2.1 Configuring InnoDB
14.2.2 InnoDB Startup Options and System Variables
14.2.3 Creating and Using InnoDB Tables
14.2.4 Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace
14.2.5 Backing Up and Recovering an InnoDB Database
14.2.6 Moving an InnoDB Database to Another Machine
14.2.7 The InnoDB Transaction Model and Locking
14.2.8 InnoDB Multi-Versioning
14.2.9 InnoDB Table and Index Structures
14.2.10 InnoDB Disk I/O and File Space Management
14.2.11 InnoDB Error Handling
14.2.12 InnoDB Performance Tuning and Troubleshooting
14.2.13 Limits on InnoDB Tables

Key Advantages of InnoDB

InnoDB is a high-reliability and high-performance storage engine for MySQL. Key advantages of InnoDB include:

To determine whether your server supports InnoDB use the SHOW ENGINES statement. See Section 13.7.5.13, “SHOW ENGINES Syntax”.

InnoDB Storage Engine Features

The InnoDB storage engine maintains its own buffer pool for caching data and indexes in main memory. InnoDB stores its tables and indexes in a tablespace, which may consist of several files (or raw disk partitions). This is different from, for example, MyISAM tables where each table is stored using separate files. InnoDB tables can be very large even on operating systems where file size is limited to 2GB.

The Windows Essentials installer makes InnoDB the MySQL default storage engine on Windows, if the server being installed supports InnoDB.

MySQL Enterprise Backup and InnoDB

The MySQL Enterprise Backup product lets you back up a running MySQL database, including InnoDB and MyISAM tables, with minimal disruption to operations while producing a consistent snapshot of the database. When MySQL Enterprise Backup is copying InnoDB tables, reads and writes to both InnoDB and MyISAM tables can continue. During the copying of MyISAM tables, reads (but not writes) to those tables are permitted. In addition, MySQL Enterprise Backup supports creating compressed backup files, and performing backups of subsets of InnoDB tables. In conjunction with MySQL’s binary log, users can perform point-in-time recovery. MySQL Enterprise Backup is commercially licensed. For a more complete description of MySQL Enterprise Backup, see Section 22.2, “MySQL Enterprise Backup”.

Additional Resources

A forum dedicated to the InnoDB storage engine is available at http://forums.mysql.com/list.php?22.

InnoDB is published under the same GNU GPL License Version 2 (of June 1991) as MySQL. For more information on MySQL licensing, see http://www.mysql.com/company/legal/licensing/.