Transaction Isolation Level Index
READ COMMITTED
- Section 13.7.8.4, “
InnoDB Record, Gap, and Next-Key Locks” - Section 13.7.3, “
InnoDB Startup Options and System Variables” - Section 12.4.6, “
SET TRANSACTION Syntax” - Section 13.7.8.2, “Consistent Nonlocking Reads”
- Section 13.7.8.9, “How to Cope with Deadlocks”
- Section 13.7.8.6, “Locks Set by Different SQL Statements in
InnoDB” - Section A.1, “MySQL 6.0 FAQ — General”
- Section A.10, “MySQL 6.0 FAQ — MySQL Cluster”
- Section 13.7.8, “The
InnoDB Transaction Model and Locking”
REPEATABLE READ
- Section 13.7.8.4, “
InnoDB Record, Gap, and Next-Key Locks” - Section 12.4.6, “
SET TRANSACTION Syntax” - Section 12.4.1, “
START TRANSACTION,
COMMIT, and
ROLLBACK Syntax” - Section 13.7.8.2, “Consistent Nonlocking Reads”
- Section 13.7.8, “The
InnoDB Transaction Model and Locking” - Section 12.4.7, “XA Transactions”