Loading…
Attending this event?
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Wednesday, May 12 • 15:00 - 16:00
Deep Dive into InnoDB Transactions

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


This talk will discuss RDBMS transactions in detail, including a discussion of all aspects of ACID compliant transactions, including how isolation levels affect SQL statements. Transaction isolation is perhaps the least understood aspect of transactions by many SQL developers, and the visibility of rows to writes, particularly in repeatable-read transaction isolation levels can be confusing.

This talk is inspired by MySQL bug 102752, which was verified by the MySQL bug verification team, but is not in fact a bug at all, but a misunderstanding of transaction isolation. At the time of the writing of this abstract, this bug remains verified. This talk will discuss locking, gap locks, visibility of rows to reads and writes, phantom reads, and all the other aspects of ACID compliance.

Speakers
JS

Justin Swanhart

CEO, LeapDB, LLC
Justin Swanhart has over 20 years of experience working with database technologies. He is the author of WarpSQL, Shard-Query, Flexviews, and PHP-SQL-Parser. Currently the CEO of LeapDB, LLC, a company developing software as a service MySQL and MariaDB solutions for materialized views... Read More →


Wednesday May 12, 2021 15:00 - 16:00 EDT
Room #2
Feedback form isn't open yet.