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. InnoDB automatically detects transaction deadlocks, rollbacks a transaction immediately and returns an error. It uses a metric to pick the [&]

The post How to deal with MySQL deadlocks appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/28/how-to-deal-with-mysql-deadlocks/