Transaction Isolation Level Index

Transaction Isolation Level Index
Prev		Next

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.3.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 13.7.8, “The InnoDB Transaction Model and Locking”

`READ UNCOMMITTED`

Section 12.3.6, “SET TRANSACTION Syntax”
Section 13.7.8, “The InnoDB Transaction Model and Locking”

`READ-COMMITTED`

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

`READ-UNCOMMITTED`

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

`REPEATABLE READ`

Section 13.7.8.4, “InnoDB Record, Gap, and Next-Key Locks”
Section 13.6.6, “Maria Statement Concurrency”
Section 13.6.5, “Maria Usage Notes”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 13.7.8.2, “Consistent Nonlocking Reads”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 13.7.8, “The InnoDB Transaction Model and Locking”
Section 12.3.7, “XA Transactions”

`REPEATABLE-READ`

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

`SERIALIZABLE`

Section 12.3.6, “SET TRANSACTION Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 13.7.8.2, “Consistent Nonlocking Reads”
Section 7.5.5.1, “How the Query Cache Operates”
Section 13.7.8.6, “Locks Set by Different SQL Statements in InnoDB”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.1.2, “Server Command Options”
Section 13.7.8, “The InnoDB Transaction Model and Locking”
Section 12.3.7, “XA Transactions”

Prev		Next
`INFORMATION_SCHEMA` Index	Home	`JOIN` Types Index