Shulou(Shulou.com)06/01 Report--

The solution to the mysql deadlock? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

MySQL has two ways to handle deadlocks:

● waits until it times out (innodb_lock_wait_timeout=50s) and automatically rolls back the transaction.

● initiates deadlock detection and actively rolls back one transaction to allow other transactions to continue (innodb_deadlock_detect=on).

Due to performance reasons, deadlock detection is generally used to deal with deadlocks.

Deadlock detection

The principle of deadlock detection is to construct a directed graph with transaction as vertex and lock as edge to judge whether there is a loop in the directed graph.

Roll back

After a deadlock is detected, select the transaction rollback with the least number of rows inserted, updated or deleted, based on the trx_weight field in the INFORMATION_SCHEMA.INNODB_TRX table.

Thank you for reading! After reading the above, do you have a general understanding of the solution to the mysql deadlock? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.