🔒 Blocking
-
Queries wait for each other
-
Slow performance
-
Not fatal
✔ How to Fix Blocking
-
Correct indexing
-
Reduce long transactions
-
Avoid row locks with better filters
💥 Deadlocks
-
Two queries wait on each other
-
SQL kills one session
-
Returns error 1205
✔ Fix Deadlocks
-
Always access tables in SAME ORDER
-
Keep transactions very short
-
Use correct indexing to reduce lock footprint