Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

InnoDB Locking Explained With Stick Figures

InnoDB Locking Explained With Stick Figures

 20 April 11:10 AM - 12:00 PM @ Ballroom C
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Development
Topics:
MySQL
InnoDB
Monitoring

Description

When does InnoDB lock a row? Multiple rows? Why would it lock a gap? How do transactions affect these scenarios? Locking is one of the more opaque features of MySQL, but it’s very important for both developers and DBA’s to understand if they want their applications to work with high performance and concurrency. This is a creative presentation to illustrate the scenarios for locking in InnoDB and make these scenarios easier to visualize. I'll cover: key locks, table locks, gap locks, shared locks, exclusive locks, intention locks, insert locks, auto-inc locks, and also conditions for deadlocks. Also how to use MySQL diagnostics to monitor current locks and lock contention.

Speakers

Bill Karwin's picture

Bill Karwin

Senior Database Architect, SchoolMessenger

Biography:

Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

Share this talk