Transaction Isolation Level Index
R | S
READ COMMITTED
- Section 15.5.2.3, “Consistent Nonlocking Reads”
- Section 21.1.5.1, “Differences Between the NDB and InnoDB Storage Engines”
- Section 15.5.5.3, “How to Minimize and Handle Deadlocks”
- Section 15.5.1, “InnoDB Locking”
- Section 15.14, “InnoDB Startup Options and System Variables”
- Section 19.7.2, “Limitations”
- Section 21.1.6.3, “Limits Relating to Transaction Handling in NDB Cluster”
- Section 15.5.3, “Locks Set by Different SQL Statements in InnoDB”
- Section A.1, “MySQL 5.7 FAQ: General”
- Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
- Section 21.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 25.10.7.1, “The events_transactions_current Table”
- Section 15.5.2.1, “Transaction Isolation Levels”
- Section 14.1.34, “TRUNCATE TABLE Syntax”
READ UNCOMMITTED
- Section 15.5.2.3, “Consistent Nonlocking Reads”
- Section 15.6.12.1.4, “Including Delete-marked Records in Persistent Statistics Calculations”
- Section 15.20.2, “InnoDB memcached Architecture”
- Section 15.14, “InnoDB Startup Options and System Variables”
- Section 21.1.6.3, “Limits Relating to Transaction Handling in NDB Cluster”
- Section 15.20.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
- Section 6.4.4.2, “Setting The Binary Log Format”
- Section 25.10.7.1, “The events_transactions_current Table”
- Section 15.5.2.1, “Transaction Isolation Levels”
- Section 14.1.34, “TRUNCATE TABLE Syntax”
REPEATABLE READ
- Section 15.5.2.3, “Consistent Nonlocking Reads”
- Section 15.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
- Section 15.5.1, “InnoDB Locking”
- Section 15.14, “InnoDB Startup Options and System Variables”
- Section 19.7.2, “Limitations”
- Section 21.1.6.3, “Limits Relating to Transaction Handling in NDB Cluster”
- Section 6.4.4.3, “Mixed Binary Logging Format”
- Section 5.5.4, “mysqldump — A Database Backup Program”
- Section 5.5.6, “mysqlpump — A Database Backup Program”
- Section 9.5.2, “Optimizing InnoDB Transaction Management”
- Section 25.10.7, “Performance Schema Transaction Tables”
- Section 14.3.6, “SET TRANSACTION Syntax”
- Section 14.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 25.10.7.1, “The events_transactions_current Table”
- Section 15.5.2.1, “Transaction Isolation Levels”
- Section 14.3.7, “XA Transactions”
SERIALIZABLE
- Section 15.5.2.3, “Consistent Nonlocking Reads”
- Section 9.10.3.1, “How the Query Cache Operates”
- Section 15.5.1, “InnoDB Locking”
- Section 15.14, “InnoDB Startup Options and System Variables”
- Section 19.7.2, “Limitations”
- Section 21.1.6.3, “Limits Relating to Transaction Handling in NDB Cluster”
- Section 15.5.3, “Locks Set by Different SQL Statements in InnoDB”
- Section 6.4.4.3, “Mixed Binary Logging Format”
- Section 25.10.7, “Performance Schema Transaction Tables”
- Section 6.1.4, “Server Command Options”
- Section 14.3.6, “SET TRANSACTION Syntax”
- Section 14.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 25.10.7.1, “The events_transactions_current Table”
- Section 15.5.2.1, “Transaction Isolation Levels”
- Section 14.3.7, “XA Transactions”