The conditions of deadlock generated by mysq and the basic methods of dealing with deadlock

This article introduces the relevant knowledge of "the conditions for mysq to produce deadlocks and the basic methods to deal with deadlocks". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Mutually exclusive condition: a resource can only be used by one process at a time.

2. Request and hold conditions.

When a process is blocked by a request for resources, it holds on to the resources it has acquired.

3. Do not deprive the conditions.

The resources that have been acquired by the process cannot be forcibly deprived until they are finally used up.

4. Loop waiting condition.

A circular waiting resource relationship is formed between several processes.

The basic method of dealing with deadlock

Prevent deadlock: destroy the necessary conditions for deadlock by setting some restrictions.

Avoid deadlock: in the process of resource allocation, use a certain method to avoid the system from entering an unsafe state and avoid deadlock.

Detect deadlocks: allow deadlocks to occur, but after passing the system detection, take some measures to remove the deadlocks.

Unlock: this method is used in conjunction with detecting deadlocks.

This is the end of the content of "the conditions for mysq to produce deadlocks and the basic methods to deal with deadlocks". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!