"Fossies" - the Fresh Open Source Software Archive

Member "refman-8.0-en.html-chapter/dynindex-isolevel.html" (28 Oct 2020, 16461 Bytes) of package /linux/misc/mysql-refman/mysql-refman-8.0-en.html-chapter.tar.gz:


Caution: In this restricted "Fossies" environment the current HTML page may not be correctly presentated and may have some non-functional links. You can here alternatively try to browse the pure source code or just view or download the uninterpreted raw source code. If the rendering is insufficient you may try to find and view the page on the project site itself.

Transaction Isolation Level Index

R | S

R

[index top]

READ COMMITTED

Section 15.7.2.3, “Consistent Nonlocking Reads”
Section 22.1.6.1, “Differences Between the NDB and InnoDB Storage Engines”
Section 18.9.2, “Group Replication Limitations”
Section 15.7.5.3, “How to Minimize and Handle Deadlocks”
Section 15.7.1, “InnoDB Locking”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 22.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 15.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section A.1, “MySQL 8.0 FAQ: General”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 22.1.6.3, “NDB and InnoDB Feature Usage Summary”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 13.3.7, “SET TRANSACTION Statement”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 26.12.7.1, “The events_transactions_current Table”
Section 15.7.2.1, “Transaction Isolation Levels”
Section 13.1.37, “TRUNCATE TABLE Statement”
Section 1.3, “What Is New in MySQL 8.0”

READ UNCOMMITTED

Section 15.7.2.3, “Consistent Nonlocking Reads”
Section 15.8.10.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 22.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 15.20.6.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 13.3.7, “SET TRANSACTION Statement”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 26.12.7.1, “The events_transactions_current Table”
Section 15.7.2.1, “Transaction Isolation Levels”
Section 13.1.37, “TRUNCATE TABLE Statement”

READ-COMMITTED

Section 5.1.7, “Server Command Options”
Section 13.3.7, “SET TRANSACTION Statement”

READ-UNCOMMITTED

Section 5.1.7, “Server Command Options”
Section 13.3.7, “SET TRANSACTION Statement”

REPEATABLE READ

Section 15.7.2.3, “Consistent Nonlocking Reads”
Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 18.9.2, “Group Replication Limitations”
Section 15.7.1, “InnoDB Locking”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 22.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 26.12.7, “Performance Schema Transaction Tables”
Section 13.3.7, “SET TRANSACTION Statement”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 26.12.7.1, “The events_transactions_current Table”
Section 15.7.2.1, “Transaction Isolation Levels”
Section 1.3, “What Is New in MySQL 8.0”
Section 13.3.8, “XA Transactions”

REPEATABLE-READ

Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 13.3.7, “SET TRANSACTION Statement”

S

[index top]

SERIALIZABLE

Section 18.9.2, “Group Replication Limitations”
Section 15.7.1, “InnoDB Locking”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 22.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 15.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 26.12.7, “Performance Schema Transaction Tables”
Section 5.1.7, “Server Command Options”
Section 13.3.7, “SET TRANSACTION Statement”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 26.12.7.1, “The events_transactions_current Table”
Section 15.7.2.1, “Transaction Isolation Levels”
Section 13.3.8, “XA Transactions”