Locking and Concurrency Control

Explore locking and concurrency control in relational database management systems through this PHP UK Conference talk. Delve into essential concepts such as table and row locks, multiversion concurrency control (MVCC), deadlocks, lock waits, transactions, and isolation levels. Gain a deeper understanding of various database errors and learn how applications should handle them. While examples focus on MySQL 5.6, acquire theoretical knowledge applicable to most databases. Discover upcoming features, explore backup strategies, and participate in interactive sessions on shared locking and deadlock detection. Examine the differences between optimistic and pessimistic concurrency, and understand application responsibilities in managing database interactions. Investigate internal locking mechanisms, scalability concerns, and advanced topics like triggers, raw metadata, and thread deadlocks. Learn to diagnose and resolve concurrency issues to optimize database performance and maintain data integrity in your PHP applications.

Introduction
Upcoming features
Agenda
Table Locks
Backups
mysqldump
backup
multiversion concurrency
demo
answer
shared locking
interactive session
deadlock
lockweight
deadlock detection
potential solutions
isolation lock step
scalability
optimistic vs pessimistic concurrency
database errors
deadlocking
error handling
Atomicity
Consistency
Isolation
Buffers
Summary
Application Responsibilities
Internal Locks
Multiple Servers
Serializable
Raw Metadata
Repeatable Reads
Triggers
Internal Locking
Memory Locking
Pages
Thread deadlocks
Mutex concurrency
Hot locks
Lock vs Mutex
Diagnosis
How do locks work