Overview
Syllabus
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
Taught by
PHP UK Conference