Transaction Isolation Level Index

R | S

R

[index top]

READ COMMITTED

Section 14.7.2.3, “Consistent Nonlocking Reads”
Section 21.1.6.1, “Differences Between the NDB and InnoDB Storage Engines”
Section 17.7.2, “Group Replication Limitations”
Section 14.7.5.3, “How to Minimize and Handle Deadlocks”
Section 14.7.1, “InnoDB Locking”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 21.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 14.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section A.1, “MySQL 5.7 FAQ: General”
Section A.10, “MySQL 5.7 FAQ: NDB Cluster”
Section 21.1.6.3, “NDB and InnoDB Feature Usage Summary”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 25.12.7.1, “The events_transactions_current Table”
Section 14.7.2.1, “Transaction Isolation Levels”
Section 13.1.34, “TRUNCATE TABLE Syntax”

READ UNCOMMITTED

Section 14.7.2.3, “Consistent Nonlocking Reads”
Section 14.8.11.1.4, “Including Delete-marked Records in Persistent Statistics Calculations”
Section 14.20.2, “InnoDB memcached Architecture”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 21.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 14.20.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 25.12.7.1, “The events_transactions_current Table”
Section 14.7.2.1, “Transaction Isolation Levels”
Section 13.1.34, “TRUNCATE TABLE Syntax”

READ-COMMITTED

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

READ-UNCOMMITTED

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

REPEATABLE READ

Section 14.7.2.3, “Consistent Nonlocking Reads”
Section 14.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 17.7.2, “Group Replication Limitations”
Section 14.7.1, “InnoDB Locking”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 21.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 4.5.6, “mysqlpump — A Database Backup Program”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 25.12.7, “Performance Schema Transaction Tables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 25.12.7.1, “The events_transactions_current Table”
Section 14.7.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 Syntax”

S

[index top]

SERIALIZABLE

Section 14.7.2.3, “Consistent Nonlocking Reads”
Section 17.7.2, “Group Replication Limitations”
Section 8.10.3.1, “How the Query Cache Operates”
Section 14.7.1, “InnoDB Locking”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 21.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 14.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 25.12.7, “Performance Schema Transaction Tables”
Section 5.1.6, “Server Command Options”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 25.12.7.1, “The events_transactions_current Table”
Section 14.7.2.1, “Transaction Isolation Levels”
Section 13.3.7, “XA Transactions”