How to implement process deadlock in Mysql

It is believed that many inexperienced people don't know what to do about how to realize the process jam operation in Mysql. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Show full processlist

/ list the current operation process, you will generally see a lot of waiting process, indicating that there are already stuck proces, we are going to kill these proces!

Kill processid; / / processid means that the id of process, such as kill 3301, will kill the process with an id of 3301.

After reading the above, have you mastered the method of how to achieve process deadlock in Mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!