Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.4Mb
PDF (A4) - 37.5Mb
PDF (RPM) - 33.2Mb
HTML Download (TGZ) - 8.3Mb
HTML Download (Zip) - 8.4Mb
HTML Download (RPM) - 7.3Mb
Man Pages (TGZ) - 130.1Kb
Man Pages (Zip) - 185.6Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb

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

Pre-General Availability Draft: 2018-02-24

15.1 Introduction to InnoDB

InnoDB is a general-purpose storage engine that balances high reliability and high performance. In MySQL 8.0, 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.

Key Advantages of InnoDB

Table 15.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 16, 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.