Transaction Isolation Level Index
R | S
READ COMMITTED
- Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
- Section 13.2.9.2, “Consistent Nonlocking Reads”
- Section 13.2.9.9, “How to Cope with Deadlocks”
- Section 13.2.9.4, “InnoDB Record, Gap, and Next-Key Locks”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
- Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
- Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
- Section 12.3.6, “SET TRANSACTION Syntax”
- Section 13.2.9, “The InnoDB Transaction Model and Locking”
REPEATABLE READ
- Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
- Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
- Section 13.2.9.2, “Consistent Nonlocking Reads”
- Section 13.2.9.4, “InnoDB Record, Gap, and Next-Key Locks”
- Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
- Section 12.3.6, “SET TRANSACTION Syntax”
- Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 13.2.9, “The InnoDB Transaction Model and Locking”
SERIALIZABLE
- Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
- Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
- Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
- Section 7.5.3.1, “How the Query Cache Operates”
- Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
- Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
- Section 5.1.2, “Server Command Options”
- Section 12.3.6, “SET TRANSACTION Syntax”
- Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 13.2.9, “The InnoDB Transaction Model and Locking”