EmergencyEMERGENCY? Get 24/7 Help Now!

How to deal with MySQL deadlocks

 | October 28, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona Server for MySQL

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 […]

Read More