MySql - InnoDb

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.

Articles Related

Documentation / Reference

• https://dev.mysql.com/doc/refman/5.6/en/innodb-introduction.html