Transaction Isolation Level Index
R | S
READ COMMITTED
- Section 14.6.4, “Consistent Nonlocking Reads”
- Section 18.1.5.1, “Differences Between the NDB and InnoDB Storage Engines”
- Section 14.6.9, “How to Cope with Deadlocks”
- Section 14.6.2, “InnoDB Record, Gap, and Next-Key Locks”
- Section 14.15, “InnoDB Startup Options and System Variables”
- Section 14.6, “InnoDB Transaction Model and Locking”
- Section 18.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
- Section 14.6.6, “Locks Set by Different SQL Statements in InnoDB”
- Section A.1, “MySQL 5.5 FAQ: General”
- Section A.10, “MySQL FAQ: MySQL 5.5 and MySQL Cluster”
- Section 18.1.5.3, “NDB and InnoDB Feature Usage Summary”
- Section 8.5.2, “Optimizing InnoDB Transaction Management”
- Section 13.3.6, “SET TRANSACTION Syntax”
- Section 5.2.4.2, “Setting The Binary Log Format”
REPEATABLE READ
- Section 14.6.4, “Consistent Nonlocking Reads”
- Section 14.6.2, “InnoDB Record, Gap, and Next-Key Locks”
- Section 14.6, “InnoDB Transaction Model and Locking”
- Section 18.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 13.3.6, “SET TRANSACTION Syntax”
- Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 13.3.7, “XA Transactions”
SERIALIZABLE
- Section 14.6.4, “Consistent Nonlocking Reads”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 14.6, “InnoDB Transaction Model and Locking”
- Section 18.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
- Section 14.6.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 13.3.6, “SET TRANSACTION Syntax”
- Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 13.3.7, “XA Transactions”