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: Yes, knowledge has improved in an absolute sense but apparently vaccine trials are still only successful 1/3 of the time generally.
gollark: You can get it *later*, probably.
gollark: The annoying thing is that, regardless of whether the mRNA ones *are* actually bad at all, with wide enough deployment someone will get a heart attack or something after getting it due to sheer random chance and people will start complaining.
gollark: I mean, "logically" it shouldn't do awful things, sure, but immunology and biology in general are hellishly complex and unpredictable.
gollark: https://www.who.int/news-room/fact-sheets/detail/ebola-virus-disease says it's 50%ish.
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.