InnoDB storage engine
E97106
InnoDB storage engine is a widely used transactional storage engine for MySQL that provides ACID compliance, row-level locking, and crash recovery for reliable, high-performance database operations.
Statements (51)
| Predicate | Object |
|---|---|
| instanceOf |
MySQL storage engine
ⓘ
transactional storage engine ⓘ |
| defaultStorageEngineOf |
MySQL
ⓘ
surface form:
MySQL 5.5 and later
|
| designedFor |
OLTP workloads
ⓘ
high-concurrency workloads ⓘ |
| developedFor |
MySQL
ⓘ
surface form:
MySQL relational database management system
|
| originallyDevelopedBy | Innobase Oy ⓘ |
| ownedBy | Oracle Corporation ⓘ |
| provides |
ACID compliance
ⓘ
automatic recovery after crashes ⓘ crash-safe operations ⓘ data integrity ⓘ referential integrity enforcement ⓘ |
| storesDataIn | tablespaces ⓘ |
| supports |
ACID transactions
ⓘ
MVCC ⓘ atomicity ⓘ automatic crash recovery ⓘ buffer pool caching ⓘ clustered indexes ⓘ consistency ⓘ crash recovery ⓘ durability ⓘ foreign key cascading actions ⓘ foreign key constraints ⓘ full-text indexes ⓘ gap locks ⓘ isolation ⓘ locking reads ⓘ multi-version concurrency control ⓘ next-key locks ⓘ non-locking consistent reads ⓘ read committed isolation level ⓘ read uncommitted isolation level ⓘ redo logs ⓘ referential integrity ⓘ repeatable read isolation level ⓘ row-based data storage ⓘ row-level locking ⓘ row-level locking for writes ⓘ savepoints ⓘ secondary indexes ⓘ serializable isolation level ⓘ spatial indexes ⓘ transactions ⓘ undo logs ⓘ |
| usedFor | reliable, high-performance database operations ⓘ |
| uses |
buffer pool for caching data and indexes
ⓘ
redo log for crash recovery ⓘ undo log for MVCC ⓘ |
| writtenIn | C ⓘ |
Referenced by (3)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
InnoDB
this entity surface form:
XtraDB