Transaction Isolation Level Index

R | S

R

[index top]

READ COMMITTED

Section 14.10.2.3, “Consistent Nonlocking Reads”
Section 18.1.6.1, “Differences Between the NDB and InnoDB Storage Engines”
Section 14.10.5.3, “How to Minimize and Handle Deadlocks”
Section 14.10.1, “InnoDB Locking”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 18.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 14.10.3, “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 NDB Cluster”
Section 18.1.6.3, “NDB and InnoDB Feature Usage Summary”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 13.3.6, “SET TRANSACTION Statement”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 14.10.2.1, “Transaction Isolation Levels”
Section 13.1.33, “TRUNCATE TABLE Statement”

READ UNCOMMITTED

Section 14.10.2.3, “Consistent Nonlocking Reads”
Section 18.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 13.3.6, “SET TRANSACTION Statement”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 14.10.2.1, “Transaction Isolation Levels”
Section 13.1.33, “TRUNCATE TABLE Statement”

READ-COMMITTED

Section 5.1.6, “Server Command Options”
Section 13.3.6, “SET TRANSACTION Statement”

READ-UNCOMMITTED

Section 5.1.6, “Server Command Options”
Section 13.3.6, “SET TRANSACTION Statement”

REPEATABLE READ

Section 14.10.2.3, “Consistent Nonlocking Reads”
Section 14.10.1, “InnoDB Locking”
Section 18.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 13.3.6, “SET TRANSACTION Statement”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 14.10.2.1, “Transaction Isolation Levels”
Section 13.3.7, “XA Transactions”

REPEATABLE-READ

Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Statement”

S

[index top]

SERIALIZABLE

Section 14.10.2.3, “Consistent Nonlocking Reads”
Section 8.10.3.1, “How the Query Cache Operates”
Section 18.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 14.10.3, “Locks Set by Different SQL Statements in InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 5.1.6, “Server Command Options”
Section 13.3.6, “SET TRANSACTION Statement”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 14.10.2.1, “Transaction Isolation Levels”
Section 13.3.7, “XA Transactions”