InnoDB
Template:Short description Template:DMCA
Page Module:Infobox/styles.css has no content.
| InnoDB | |
|---|---|
| [[Programmer|DeveloperTemplate:Pluralize from text]] | Oracle Corporation |
| Written in | C |
| Engine | Page Template:Plainlist/styles.css has no content.Template:EditAtWikidata |
| Operating system | Cross-platform |
| Type | Database engine |
| License | GNU GPL v2 or proprietary |
| Website | Script error: No such module "WikidataIB". |
| Repository | Page Template:Plainlist/styles.css has no content.
|
Script error: No such module "Check for conflicting parameters".
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
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
References
Page Template:Reflist/styles.css has no content.
- ^ Page Module:Citation/CS1/styles.css has no content."InnoDB".
- ^ Page Module:Citation/CS1/styles.css has no content."Introduction to InnoDB". MySQL 5.5 Reference Manual. Retrieved 2 October 2019.
- ^ Page Module:Citation/CS1/styles.css has no content."Changes in MySQL 5.5.5". MySQL 5.5 Reference Manual. Archived from the original on 7 January 2019. Retrieved 2 October 2019.
- ^ Page Module:Citation/CS1/styles.css has no content."Oracle Announces the Acquisition of Open Source Software Company, Innobase". Oracle Corporation. 7 October 2005. Retrieved 28 March 2017.
- ^ Page Module:Citation/CS1/styles.css has no content."Licensing MySQL and InnoDB". InnoDB.com. Retrieved 31 July 2008.
- ^ Page Module:Citation/CS1/styles.css has no content."Oracle Announces General Availability of MySQL 5.6". Archived from the original on 8 February 2013.
- ^ Page Module:Citation/CS1/styles.css has no content."MariaDB 10.0.0 Release Notes".
- ^ Page Module:Citation/CS1/styles.css has no content."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.
Lua error in package.lua at line 80: module 'Module:Navbox/configuration' not found. Lua error in package.lua at line 80: module 'Module:Navbox/configuration' not found.
