#MySQL 1 post

Optimistic vs Pessimistic Locking, and DeadlocksDB Concurrency Control (DB Series 1/4)

The first post in a database series: deadlocks and livelocks, how to choose between pessimistic and optimistic locking, and an UPDATE without a WHERE that logged out every user.