MySQL :: MySQL 8.3 Reference Manual :: Transaction Isolation Level Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 8.3

8.0 current
5.7

MySQL 8.3 Reference Manual / Indexes / Transaction Isolation Level Index

Transaction Isolation Level Index

R | S

R

READ COMMITTED

Section 17.7.2.3, “Consistent Nonlocking Reads”
Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
Section 25.2.6.1, “Differences Between the NDB and InnoDB Storage Engines”
Section 20.3.2, “Group Replication Limitations”
Section 17.7.5.3, “How to Minimize and Handle Deadlocks”
Section 17.7.1, “InnoDB Locking”
Section 25.2.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 17.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section A.1, “MySQL 8.3 FAQ: General”
Section A.10, “MySQL 8.3 FAQ: NDB Cluster”
Section 25.2.6.3, “NDB and InnoDB Feature Usage Summary”
Section 10.5.2, “Optimizing InnoDB Transaction Management”
Section 15.3.7, “SET TRANSACTION Statement”
Section 7.4.4.2, “Setting The Binary Log Format”
Section 29.12.7.1, “The events_transactions_current Table”
Section 17.7.2.1, “Transaction Isolation Levels”

READ UNCOMMITTED

Section 17.7.2.3, “Consistent Nonlocking Reads”
Section 17.8.10.1.4, “Including Delete-marked Records in Persistent Statistics Calculations”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 25.2.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 15.3.7, “SET TRANSACTION Statement”
Section 7.4.4.2, “Setting The Binary Log Format”
Section 29.12.7.1, “The events_transactions_current Table”
Section 17.7.2.1, “Transaction Isolation Levels”

READ-COMMITTED

Section 7.1.7, “Server Command Options”
Section 15.3.7, “SET TRANSACTION Statement”

READ-UNCOMMITTED

Section 7.1.7, “Server Command Options”
Section 15.3.7, “SET TRANSACTION Statement”

REPEATABLE READ

Section 17.7.2.3, “Consistent Nonlocking Reads”
Section 20.3.2, “Group Replication Limitations”
Section 17.7.1, “InnoDB Locking”
Section 25.2.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 6.5.6, “mysqlpump — A Database Backup Program”
Section 10.5.2, “Optimizing InnoDB Transaction Management”
Section 29.12.7, “Performance Schema Transaction Tables”
Section 15.3.7, “SET TRANSACTION Statement”
Section 15.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 29.12.7.1, “The events_transactions_current Table”
Section 17.7.2.1, “Transaction Isolation Levels”
Section 15.3.8, “XA Transactions”

REPEATABLE-READ

Section 7.1.7, “Server Command Options”
Section 7.1.8, “Server System Variables”
Section 15.3.7, “SET TRANSACTION Statement”

S

SERIALIZABLE

Section 20.3.2, “Group Replication Limitations”
Section 17.7.1, “InnoDB Locking”
Section 25.2.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 17.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 29.12.7, “Performance Schema Transaction Tables”
Section 7.1.7, “Server Command Options”
Section 15.3.7, “SET TRANSACTION Statement”
Section 15.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 29.12.7.1, “The events_transactions_current Table”
Section 17.7.2.1, “Transaction Isolation Levels”
Section 15.3.8, “XA Transactions”

PREV HOME UP NEXT