About
InnoDB is the default storage engine (From MySQL 5.6)
It is:
- a transaction-safe (ACID compliant)
- that has commit, rollback, and crash-recovery capabilities
It supports:
- FOREIGN KEY referential-integrity constraints.
It has
- row-level locking (without escalation to coarser granularity locks)
- and Oracle-style consistent nonlocking reads increase multi-user concurrency and performance.
InnoDB stores user data in clustered indexes to reduce I/O for common queries based on primary keys.