How does the InnoDB storage engine handle deadlocks when they are detected?
Both the affected transactions will be rolled back.
The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
One of the affected transactions will be rolled back, the other is allowed to proceed.
The transaction isolation level determines which transaction is rolled back.
The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
Submit