Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
InnoDB Transaction Model and LockingInnoDB
Lock ModesSELECT ... FOR UPDATE and SELECT ... LOCK IN
SHAREMODE)InnoDB Record, Gap, and Next-Key LocksInnoDBInnoDB Multi-VersioningInnoDB Table and Index StructuresInnoDB Recovery ProcessInnoDB Error Handling 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 MyISAM tables to InnoDB, now that InnoDB is the default MySQL
storage engine.
Anyone considering their application architecture or software stack, to understand
the design considerations, performance characteristics, and scalability of InnoDB tables at a detailed level.
In this section, you will learn:
How InnoDB implements transactions, and how the inner
workings of transactions compare compare with other database systems you might be familiar with.
How InnoDB implements 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.
The physical layout of InnoDB-related objects on disk,
such as tables, indexes, tablespaces, undo logs, and the redo log.