InnoDB provides MySQL with a transaction-safe (
ACID compliant) storage engine with commit, rollback, and crash recovery capabilities.
InnoDB does locking on the row level and also provides an Oracle-style consistent non-locking read in
SELECT statements. These features increase multi-user concurrency and performance. There is no need for lock escalation in
InnoDB because row-level locks in
InnoDB fit in very little space.
InnoDB also supports
FOREIGN KEY constraints. In SQL queries you can freely mix
InnoDB type tables with other table types of MySQL, even within the same query.
InnoDB has been designed for maximum performance when processing large data volumes. Its CPU efficiency is probably ...