Introduction In this article, we are going to see how a deadlock
can occur in a relational database system, and how Oracle, SQL
Server, PostgreSQL, or MySQL recover from a deadlock situation.
Database locking Relational database systems use various locks to
guarantee transaction ACID properties. For instance, no matter
what relational database system you are using, locks will always
be acquired when modifying (e.g., UPDATE or DELETE) a certain
table record. Without locking a row that was modified by a
currently running transaction, Atomicity would be compromised.
Using locking for controlling access... Read
More
The post A beginner’s guide to database deadlock
appeared first on Vlad Mihalcea.