InnoDB
InnoDB is a storage engine for the database management system MySQL. Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's default table type.[1][2] 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.
Developer(s) | Oracle corporation |
---|---|
Written in | C |
Operating system | Cross-platform |
Type | Database engine |
License | GNU GPL v2 or proprietary |
Website | www![]() |
Description
InnoDB became a product of Oracle Corporation after its acquisition of the Finland-based company Innobase in October 2005.[3] 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.[4]
InnoDB supports:
- Both SQL and XA transactions
- Tablespaces
- Foreign keys
- Full text search indexes, since MySQL 5.6 (February 2013)[5] and MariaDB 10.0[6]
- Spatial operations, following the OpenGIS standard
- Virtual columns, in MariaDB[7]
gollark: Hmm, yes, I suppose stars count, so just "not important in large-scale interactions directly".
gollark: The strong nuclear force is much stronger than electromagnetism, but also not important in cosmology because it's short range.
gollark: I mean, irrelevant ones which don't back your claims, yes.
gollark: Oh, and "you constantly just refer people to giant sets of papers and random YouTube videos".
gollark: Also "you aren't using actual evidence" and "you're constantly shifting the goalposts" and "you're not even bothering to explain your claims and just expect people to infer them from random papers" and "you say stupidly vague things and cite papers for evidence because they sound vaguely related".
See also
References
- "Introduction to InnoDB". MySQL 5.5 Reference Manual. Retrieved 2 October 2019.
- "Changes in MySQL 5.5.5". MySQL 5.5 Reference Manual. Retrieved 2 October 2019.
- "Oracle Announces the Acquisition of Open Source Software Company, Innobase". Oracle Corporation. 7 October 2005. Retrieved 28 March 2017.
- "Licensing MySQL and InnoDB". InnoDB.com. Retrieved 31 July 2008.
- http://www.oracle.com/us/corporate/press/1904335
- https://mariadb.com/kb/en/library/mariadb-1000-release-notes/
- "Generated (Virtual and Persistent/Stored) Columns". MariaDB KnowledgeBase. Retrieved 22 December 2019.
External links
- Mysqltutorial.org, InnoDB and other table types in MySQL
- The InnoDB Storage Engine, in the MySQL manual.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.