Transaction Management and Isolation Levels

MySQL Tutorials - Herong's Tutorial Examples

∟Transaction Management and Isolation Levels

This chapter provides tutorial notes on transactions. Topics include introduction of transactions, transaction management in MySQL, transaction isolation levels: Read Uncommitted, Read Committed, Repeatable Read, Serializable.

These sections are omitted from this Web preview version. To view the full content, see information on how to obtain the full version this book.

What Is a Transaction

Transaction Management in MySQL

Transaction Isolation Levels

"Read Uncommitted" Isolation Level

"Read Committed" Isolation Level

"Repeatable Read" Isolation Level

Takeaways:

A transaction is a sequence of executions of DML statements to be treated as single unit.
Transaction management are supported by InnoDB and BDB storage engines in MySQL.
4 levels of transaction isolation are supported: Read Uncommitted, Read Committed, Repeatable Read, Serializable.