Contents

InnoDB

C

Cross-platform

Database engine

GNU GPL v2orproprietary

dev.mysql.com/doc/refman/8.1/en/innodb-storage-engine.html 

InnoDB is a storage engine for the database management system MySQL and MariaDB.^[1] Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's default table type.^[2][3] It provides the standard ACID-compliant transaction features, along with foreign key support (declarative referential integrity). It is included as standard in most binaries distributed by MySQL AB, the exception being some OEM versions.

Description[edit]

InnoDB became a product of Oracle Corporation after its acquisition of the Finland-based company Innobase in October 2005.^[4] The software is dual licensed; it is distributed under the GNU General Public License, but can also be licensed to parties wishing to combine InnoDB in proprietary software.^[5]

InnoDB supports:

• Both SQL and XA transactions
• Tablespaces
• Foreign keys
• Full text search indexes, since MySQL 5.6 (February 2013)^[6] and MariaDB 10.0^[7]
• Spatial operations, following the OpenGIS standard
• Virtual columns, in MariaDB^[8]

See also[edit]

• Comparison of MySQL database engines

References[edit]

External links[edit]

• Mysqltutorial.org, InnoDB and other table types in MySQL
• The InnoDB Storage Engine, in the MySQL manual.