InnoDB
{{short description|Storage engine for the MySQL database management system}}
{{Use dmy dates|date=November 2016}}
{{Infobox software
| name = InnoDB
| logo =
| caption =
| developer = Oracle Corporation
| programming language = C
| latest release version =
| latest release date =
| operating system = Cross-platform
| genre = Database engine
| license = GNU GPL v2 or proprietary
}}
InnoDB is a storage engine for the database management system MySQL and MariaDB.{{Cite web|url=https://mariadb.com/kb/en/innodb/|title=InnoDB}} Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's default table type.{{cite web|title=Introduction to InnoDB|url=https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html|website=MySQL 5.5 Reference Manual|access-date=2 Oct 2019}}{{cite web|title=Changes in MySQL 5.5.5|url=https://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-5.html|website=MySQL 5.5 Reference Manual|access-date=2 Oct 2019}} 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
InnoDB became a product of Oracle Corporation after its acquisition of the Finland-based company Innobase in October 2005.
{{cite web
|url = http://www.oracle.com/us/corporate/press/016679_EN
|title = Oracle Announces the Acquisition of Open Source Software Company, Innobase
|publisher = Oracle Corporation |date= 7 October 2005
|access-date = 28 March 2017
}}
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.
{{cite web
|url = http://www.innodb.com/licenses.php
|title = Licensing MySQL and InnoDB
|publisher = InnoDB.com
|access-date = 2008-07-31
}}
InnoDB supports:
- Both SQL and XA transactions
- Tablespaces
- Foreign keys
- Full text search indexes, since MySQL 5.6 (February 2013){{cite web |url=http://www.oracle.com/us/corporate/press/1904335 |url-status=dead |archive-url=https://web.archive.org/web/20130208011003/http://www.oracle.com/us/corporate/press/1904335 |archive-date=8 February 2013 |title=Oracle Announces General Availability of MySQL 5.6}} and MariaDB 10.0{{Cite web|url=https://mariadb.com/kb/en/library/mariadb-1000-release-notes/|title = MariaDB 10.0.0 Release Notes}}
- Spatial operations, following the OpenGIS standard
- Virtual columns, in MariaDB{{Cite web|url=https://mariadb.com/kb/en/library/generated-columns/|title=Generated (Virtual and Persistent/Stored) Columns|website=MariaDB KnowledgeBase|access-date=2019-12-22}}
See also
References
{{Reflist}}
External links
- [https://www.mysqltutorial.org/understand-mysql-table-types-innodb-myisam.aspx Mysqltutorial.org], InnoDB and other table types in MySQL
- [https://dev.mysql.com/doc/refman/8.0/en/innodb-storage-engine.html The InnoDB Storage Engine], in the MySQL manual.
{{MySQL}}
{{Oracle}}
{{Oracle FOSS}}