MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

© Jesper Wisborg Krogh 2021

J. W. KroghMySQL Concurrencyhttps://doi.org/10.1007/978-1-4842-6652-6_11

11. Transactions

Jesper Wisborg Krogh¹  

(1)

Hornsby, NSW, Australia

 

Transactions are the big brother of statements. They group multiple changes together whether in a single statement or several statements, so they are applied or abandoned as a single unit. Mostly transactions are not much more than an afterthought and just considered when it is necessary to apply several statements together. That is a bad way to consider transactions. They are very important to ensure data integrity, and when used wrong, they can cause severe performance issues.

This chapter starts out discussing what transactions and the ACID concept are and then moves on to discussing ...