How do we know that concurrent data modifications don't introduce corruption? From double-booked plane seats to crypto exchange bankruptcy, these errors can be costly. MySQL offers transaction isolation levels that balance performance and isolation guarantees. With live demos, we'll learn all about transactions, consistent nonlocking reads, InnoDB locking and MVCC, read phenomena, and isolation levels.
After this talk, you'll be able to spot and fix concurrency bugs in MySQL queries, and make informed decisions about performance tradeoffs in transactions.
