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

This article mainly introduces how to avoid mysql deadlock, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

How to avoid deadlocks whenever possible:

1. Access tables and rows in a fixed order. For example, for two transactions that update data, transaction A updates data in the order of 1mem2, and transaction B updates data in the order of 2mem1. This is more likely to cause a deadlock.

2. Big transactions are divided into small ones. Large transactions tend to be deadlocks, and if the business allows, large transactions will be split into smaller ones.

3. In the same transaction, try to lock all the resources needed at once to reduce the probability of deadlock.

4. Lower the isolation level. If the business allows, lowering the isolation level is also a better choice. For example, changing the isolation level from RR to RC can avoid many deadlocks caused by gap locks.

5. Add a reasonable index to the table. You can see that if you don't move the index, you will add a lock to each row of the table, which greatly increases the probability of deadlock.

Thank you for reading this article carefully. I hope it is helpful for everyone to share how to avoid mysql deadlock. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you have any problems. Detailed solutions are waiting for you to learn!

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.