Transaction Isolation Level Index

R | S

R

[index top]

READ COMMITTED

Section 14.2.4, “Consistent Nonlocking Reads”
Section 14.2.12, “How to Cope with Deadlocks”
Section 14.2.6, “InnoDB Record, Gap, and Next-Key Locks”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.2.9, “Locks Set by Different SQL Statements in InnoDB”
Section A.1, “MySQL 5.7 FAQ: General”
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”
Section 14.2.2, “The InnoDB Transaction Model and Locking”

READ UNCOMMITTED

Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.4, “Consistent Nonlocking Reads”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.18.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.2.4.2, “Setting The Binary Log Format”
Section 14.2.2, “The InnoDB Transaction Model and Locking”

READ-COMMITTED

Section 5.1.3, “Server Command Options”
Section 13.3.6, “SET TRANSACTION Syntax”

READ-UNCOMMITTED

Section 5.1.3, “Server Command Options”
Section 13.3.6, “SET TRANSACTION Syntax”

REPEATABLE READ

Section 14.2.4, “Consistent Nonlocking Reads”
Section 14.18.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.2.6, “InnoDB Record, Gap, and Next-Key Locks”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 14.2.8, “Predicate Locking for Spatial Indexes”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 14.2.2, “The InnoDB Transaction Model and Locking”
Section 13.3.7, “XA Transactions”

REPEATABLE-READ

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”

S

[index top]

SERIALIZABLE

Section 14.2.4, “Consistent Nonlocking Reads”
Section 8.9.3.1, “How the Query Cache Operates”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.2.9, “Locks Set by Different SQL Statements in InnoDB”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 14.2.8, “Predicate Locking for Spatial Indexes”
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 14.2.2, “The InnoDB Transaction Model and Locking”
Section 13.3.7, “XA Transactions”