Killing transactions in databases (deadlock detection and resolution)
Ben Dicken · 13:07 · Watch on YouTube
Two concurrent transactions that update the same rows in opposite order can deadlock: each holds a lock the other needs, so neither can commit. MySQL and PostgreSQL both break that cycle by aborting one transaction, a...