Chapter 10. Using Transactions with InnoDB Tables

In this chapter, we will cover transactions in MySQL. When dealing with practical examples, we will primarily look at the InnoDB table type, but nearly everything said here applies equally well to BerkeleyDB tables.

Specifically, we will look at the following:

• What transactions are

• Using transactions in MySQL

• The InnoDB transaction model and ACID compliance