InnoDB
Storage engine for the MySQL database management system
InnoDB is a storage engine for the database management system MySQL and MariaDB. Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's default table type. 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.
01Description
InnoDB became a product of Oracle Corporation after its acquisition of the Finland-based company Innobase in October 2005. 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.
InnoDB supports:
- Both SQL and XA transactions
- Tablespaces
- Foreign keys
- Full text search indexes, since MySQL 5.6 (February 2013) and MariaDB 10.0
- Spatial operations, following the OpenGIS standard
- Virtual columns, in MariaDB
Sources and credits
This article is adapted from the Wikipedia article “InnoDB”, written by its contributors and licensed under CC BY-SA 4.0. Fathomly has changed the layout, removed citation markers, navigation and maintenance notices, and adjusted punctuation. This adapted version is shared under the same license. For references, see the original article.
Fathomly is not affiliated with or endorsed by the Wikimedia Foundation. Spotted a problem? Tell us.