Transaction Isolation Level Index

R

[index top]

READ COMMITTED

Section 14.3.9.4, “InnoDB Record, Gap, and Next-Key Locks”

Section 14.3.4, “InnoDB Startup Options and System Variables”

Section 17.1.5.3, “NDB and InnoDB Feature Usage Summary”

Section 13.3.6, “SET TRANSACTION Syntax”

Section 14.3.9.2, “Consistent Nonlocking Reads”

Section 17.1.5.1, “Differences Between the NDB and InnoDB Storage Engines”

Section 14.3.9.9, “How to Cope with Deadlocks”

Section 17.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”

Section 14.3.9.6, “Locks Set by Different SQL Statements in InnoDB”

Section 8.5.2, “Optimizing InnoDB Transaction Management”

Section 5.2.4.2, “Setting The Binary Log Format”

Section 14.3.9, “The InnoDB Transaction Model and Locking”

READ UNCOMMITTED

Section 13.3.6, “SET TRANSACTION Syntax”

Section 14.3.9.2, “Consistent Nonlocking Reads”

Section 17.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”

Section 5.2.4.2, “Setting The Binary Log Format”

Section 14.3.9, “The InnoDB Transaction Model and Locking”

READ-COMMITTED

Section 13.3.6, “SET TRANSACTION Syntax”

Section 5.1.3, “Server Command Options”

READ-UNCOMMITTED

Section 13.3.6, “SET TRANSACTION Syntax”

Section 5.1.3, “Server Command Options”

REPEATABLE READ

Section 14.3.9.4, “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.3.9.2, “Consistent Nonlocking Reads”

Section 17.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”

Section 5.2.4.3, “Mixed Binary Logging Format”

Section 8.5.2, “Optimizing InnoDB Transaction Management”

Section 14.3.9, “The InnoDB Transaction Model and Locking”

Section 13.3.7, “XA Transactions”

REPEATABLE-READ

Section 13.3.6, “SET TRANSACTION Syntax”

Section 5.1.3, “Server Command Options”

Section 5.1.4, “Server System Variables”

S

[index top]

SERIALIZABLE

Section 13.3.6, “SET TRANSACTION Syntax”

Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

Section 14.3.9.2, “Consistent Nonlocking Reads”

Section 8.9.3.1, “How the Query Cache Operates”

Section 17.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”

Section 14.3.9.6, “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.3.9, “The InnoDB Transaction Model and Locking”

Section 13.3.7, “XA Transactions”