Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.3Mb
PDF (A4) - 31.4Mb
PDF (RPM) - 29.9Mb
HTML Download (TGZ) - 7.6Mb
HTML Download (Zip) - 7.6Mb
HTML Download (RPM) - 6.5Mb
Man Pages (TGZ) - 177.0Kb
Man Pages (Zip) - 287.1Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb
Excerpts from this Manual

MySQL 5.6 Reference Manual  /  The InnoDB Storage Engine  /  Introduction to InnoDB

14.1 Introduction to InnoDB

InnoDB is a general-purpose storage engine that balances high reliability and high performance. In MySQL 5.6, InnoDB is the default MySQL storage engine. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE= clause creates an InnoDB table.

InnoDB includes all the features that were part of the InnoDB Plugin for MySQL 5.1, plus new features specific to MySQL 5.5 and higher.


The mysql and INFORMATION_SCHEMA databases that implement some of the MySQL internals still use MyISAM. In particular, you cannot switch the grant tables to use InnoDB.

Key Advantages of InnoDB

Table 14.1 InnoDB Storage Engine Features

Feature Support
Storage limits 64TB
Transactions Yes
Locking granularity Row
Geospatial data type support Yes
Geospatial indexing support Yes (InnoDB support for geospatial indexing is available in MySQL 5.7 and later.)
B-tree indexes Yes
T-tree indexes No
Hash indexes No (InnoDB utilizes hash indexes internally for its Adaptive Hash Index feature.)
Full-text search indexes Yes (InnoDB support for FULLTEXT indexes is available in MySQL 5.6 and later.)
Clustered indexes Yes
Data caches Yes
Index caches Yes
Compressed data Yes
Encrypted data (Implemented in the server (via encryption functions). Data-at-rest tablespace encryption is available in MySQL 5.7 and later.) Yes
Cluster database support No
Replication support (Implemented in the server, rather than in the storage engine.) Yes
Foreign key support Yes
Backup / point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes
Query cache support Yes
Update statistics for data dictionary Yes

To compare the features of InnoDB with other storage engines provided with MySQL, see the Storage Engine Features table in Chapter 15, Alternative Storage Engines.

InnoDB Enhancements and New Features

For information about InnoDB enhancements and new features, refer to:

Additional InnoDB Information and Resources

User Comments
Sign Up Login You must be logged in to post a comment.