Understanding Deadlocks in MySQL & PostgreSQL
There are several types of locks but, the important thing about them, is how they interact with each other. Because two transactions cannot hold locks of conflicting modes on the same object at the same time. And a non minor detail, once acquired, a lock is normally held till end of transaction.
Appears in lists (1)
More like this (4)
The Cost of Useless Surrogate Keys in Relationship Tables — A look at the pros and...
When Postgres Blocks: 7 Tips for Dealing with Locks — We’re revisiting a classic post that...
The Difference Between SQL's JOIN .. ON Clause and the WHERE Clause — Are ON and...