Transaction Isolation Level Index
R | S
READ COMMITTED
- Section 14.2.4.5, “
InnoDB Record, Gap, and Next-Key Locks” - Section 14.2.7, “
InnoDB Startup Options and System Variables” - Section 13.3.6, “
SET TRANSACTION Syntax” - Section 14.2.4.3, “Consistent Nonlocking Reads”
- Section 14.2.4.10, “How to Cope with Deadlocks”
- Section 14.2.4.7, “Locks Set by Different SQL Statements in
InnoDB” - Section 8.5.2, “Optimizing
InnoDB Transaction Management” - Section 14.2.4.1, “The
InnoDB Transaction Model and Locking”
REPEATABLE READ
- Section 14.2.4.5, “
InnoDB Record, Gap, and Next-Key Locks” - Section 13.3.6, “
SET TRANSACTION Syntax” - Section 13.3.1, “
START TRANSACTION,
COMMIT, and
ROLLBACK Syntax” - Section 14.2.4.3, “Consistent Nonlocking Reads”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 8.5.2, “Optimizing
InnoDB Transaction Management” - Section 14.2.4.1, “The
InnoDB Transaction Model and Locking” - Section 13.3.7, “XA Transactions”
SERIALIZABLE
- Section 13.3.6, “
SET TRANSACTION Syntax” - Section 13.3.1, “
START TRANSACTION,
COMMIT, and
ROLLBACK Syntax” - Section 14.2.4.3, “Consistent Nonlocking Reads”
- Section 8.9.3.1, “How the Query Cache Operates”
- Section 14.2.4.7, “Locks Set by Different SQL Statements in
InnoDB” - Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 5.1.3, “Server Command Options”
- Section 14.2.4.1, “The
InnoDB Transaction Model and Locking” - Section 13.3.7, “XA Transactions”