Transaction Isolation Level Index

R | S

R

[index top]

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”

READ UNCOMMITTED

Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 13.2.9, “The InnoDB Transaction Model and Locking”

READ-COMMITTED

Section 5.1.2, “Server Command Options”
Section 12.3.6, “SET TRANSACTION Syntax”

READ-UNCOMMITTED

Section 5.1.2, “Server Command Options”
Section 12.3.6, “SET TRANSACTION Syntax”

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”

REPEATABLE-READ

Section 5.1.2, “Server Command Options”
Section 12.3.6, “SET TRANSACTION Syntax”

S

[index top]

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”