R

[index top]

READ COMMITTED

Section 16.5.2.3, “Consistent Nonlocking Reads”

Section 16.5.5.3, “How to Minimize and Handle Deadlocks”

Section 16.5.1, “InnoDB Locking”

Section 16.13, “InnoDB Startup Options and System Variables”

Section 16.5.3, “Locks Set by Different SQL Statements in InnoDB”

Section A.1, “MySQL 8.0 FAQ: General”

Section 9.5.2, “Optimizing InnoDB Transaction Management”

Section 6.4.4.2, “Setting The Binary Log Format”

Section 23.10.7.1, “The events_transactions_current Table”

Section 16.5.2.1, “Transaction Isolation Levels”

Section 14.1.30, “TRUNCATE TABLE Syntax”

READ UNCOMMITTED

Section 16.5.2.3, “Consistent Nonlocking Reads”

Section 16.6.10.1.4, “Including Delete-marked Records in Persistent Statistics Calculations”

Section 16.19.2, “InnoDB memcached Architecture”

Section 16.13, “InnoDB Startup Options and System Variables”

Section 16.19.6.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”

Section 6.4.4.2, “Setting The Binary Log Format”

Section 23.10.7.1, “The events_transactions_current Table”

Section 16.5.2.1, “Transaction Isolation Levels”

Section 14.1.30, “TRUNCATE TABLE Syntax”

READ-COMMITTED

Section 6.1.4, “Server Command Options”

Section 14.3.6, “SET TRANSACTION Syntax”

READ-UNCOMMITTED

Section 6.1.4, “Server Command Options”

Section 14.3.6, “SET TRANSACTION Syntax”

REPEATABLE READ

Section 16.5.2.3, “Consistent Nonlocking Reads”

Section 16.19.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

Section 16.5.1, “InnoDB Locking”

Section 16.13, “InnoDB Startup Options and System Variables”

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 23.10.7, “Performance Schema Transaction Tables”

Section 14.3.6, “SET TRANSACTION Syntax”

Section 14.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

Section 23.10.7.1, “The events_transactions_current Table”

Section 16.5.2.1, “Transaction Isolation Levels”

Section 14.3.7, “XA Transactions”

REPEATABLE-READ

Section 6.1.4, “Server Command Options”

Section 6.1.5, “Server System Variables”

Section 14.3.6, “SET TRANSACTION Syntax”

S

[index top]

SERIALIZABLE

Section 16.5.2.3, “Consistent Nonlocking Reads”

Section 9.10.3.1, “How the Query Cache Operates”

Section 16.5.1, “InnoDB Locking”

Section 16.13, “InnoDB Startup Options and System Variables”

Section 16.5.3, “Locks Set by Different SQL Statements in InnoDB”

Section 6.4.4.3, “Mixed Binary Logging Format”

Section 23.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 23.10.7.1, “The events_transactions_current Table”

Section 16.5.2.1, “Transaction Isolation Levels”

Section 14.3.7, “XA Transactions”