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.
How multi-version concurrency control (MVCC) keeps transactions from viewing or modifying each others' data before the appropriate time.