The information in this section provides background to help you get
the most performance and functionality from using
InnoDB tables. It is intended for:
Anyone switching to MySQL from another database system, to explain what things might seem familiar and which might be all-new.
Anyone moving from
InnoDB, now that
InnoDBis the default MySQL storage engine.
Anyone considering their application architecture or software stack, to understand the design considerations, performance characteristics, and scalability of
InnoDBtables at a detailed level.
In this section, you will learn:
InnoDBclosely adheres to ACID principles.
InnoDBimplements transactions, and how the inner workings of transactions compare with other database systems you might be familiar with.
InnoDBimplements row-level locking to allow queries and DML statements to read and write the same table simultaneously.
How multi-version concurrency control (MVCC) keeps transactions from viewing or modifying each others' data before the appropriate time.