Transaction Isolation Level Index

R | S

R

[index top]

READ COMMITTED

Section 15.3.2.3, “Consistent Nonlocking Reads”
Section 19.1.5.1, “Differences Between the NDB and InnoDB Storage Engines”
Section 15.3.5.3, “How to Minimize and Handle Deadlocks”
Section 15.3.1, “InnoDB Locking”
Section 15.12, “InnoDB Startup Options and System Variables”
Section 19.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 15.3.3, “Locks Set by Different SQL Statements in InnoDB”
Section A.1, “MySQL 5.7 FAQ: General”
Section 19.1.5.3, “NDB and InnoDB Feature Usage Summary”
Section 9.5.2, “Optimizing InnoDB Transaction Management”
Section 6.4.4.2, “Setting The Binary Log Format”
Section 15.3.2.1, “Transaction Isolation Levels”

READ UNCOMMITTED

Section 15.3.2.3, “Consistent Nonlocking Reads”
Section 15.18.2, “InnoDB memcached Architecture”
Section 15.12, “InnoDB Startup Options and System Variables”
Section 19.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 15.18.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 6.4.4.2, “Setting The Binary Log Format”
Section 15.3.2.1, “Transaction Isolation Levels”

READ-COMMITTED

Section 6.1.3, “Server Command Options”
Section 14.3.6, “SET TRANSACTION Syntax”

READ-UNCOMMITTED

Section 6.1.3, “Server Command Options”
Section 14.3.6, “SET TRANSACTION Syntax”

REPEATABLE READ

Section 15.3.2.3, “Consistent Nonlocking Reads”
Section 15.18.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.3.1, “InnoDB Locking”
Section 15.12, “InnoDB Startup Options and System Variables”
Section 19.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 9.5.2, “Optimizing InnoDB Transaction Management”
Section 14.3.6, “SET TRANSACTION Syntax”
Section 14.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 15.3.2.1, “Transaction Isolation Levels”
Section 14.3.7, “XA Transactions”

REPEATABLE-READ

Section 6.1.3, “Server Command Options”
Section 6.1.4, “Server System Variables”
Section 14.3.6, “SET TRANSACTION Syntax”

S

[index top]

SERIALIZABLE

Section 15.3.2.3, “Consistent Nonlocking Reads”
Section 9.10.3.1, “How the Query Cache Operates”
Section 15.3.1, “InnoDB Locking”
Section 15.12, “InnoDB Startup Options and System Variables”
Section 19.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 15.3.3, “Locks Set by Different SQL Statements in InnoDB”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 6.1.3, “Server Command Options”
Section 14.3.6, “SET TRANSACTION Syntax”
Section 14.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 15.3.2.1, “Transaction Isolation Levels”
Section 14.3.7, “XA Transactions”