How to deal with MySQL deadlocks | Sysadmin tips | Scoop.it
A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable.