Home >Backend Development >PHP Tutorial >Mysql blocking problem causes
Mysql blocking problem causes
- WBOYOriginal
- 2016-10-12 09:50:141110browse
1. Deadlock situation has been ruled out.
2.show processlist; nearly a thousand query processes are blocked.
3. Extract the two most awaited SQL statements, which take nearly 1 second to execute individually.
Please help me analyze what else needs to be analyzed. It is blocked three or four times a month.
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MVC creates a class in the M layer, and the C layer new objects of the corresponding class, and then passes them to the V layer. The V layer uses the object to call the corresponding class method. Have you seen this pattern?Next article：MVC creates a class in the M layer, and the C layer new objects of the corresponding class, and then passes them to the V layer. The V layer uses the object to call the corresponding class method. Have you seen this pattern?