Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Locking and Concurrency Control

PHP UK Conference via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

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

Reviews

Start your review of Locking and Concurrency Control

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.