SyntaxPilot
Courses/SQL and Databases/Lesson 58
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

SQL and Databases · Lesson 58 of 90

Locking 2: deadlocks, optimistic and pessimistic locking

deadlockwait-for graphdeadlock detectionvictimlock timeoutconsistent lock orderingpessimistic lockingoptimistic lockingversion columncompare-and-set updategap locknext-key lock (InnoDB)advisory lock

Detailed notes for this lesson are being written. They appear here together with the video.