MySQL blocking problem cause

1. A deadlock condition has been ruled out.
2.show processlist; After nearly thousands of query processes are blocking.
3. Extract the two SQL that waits up to 1 seconds after it is executed alone.
We help analysis of what needs to be analyzed, one months have been three or four times blocked.

Reply content:

1. A deadlock condition has been ruled out.
2.show processlist; After nearly thousands of query processes are blocking.
3. Extract the two SQL that waits up to 1 seconds after it is executed alone.
We help analysis of what needs to be analyzed, one months have been three or four times blocked.

Consider slow query, turn on slow query log analysis SQL Find out why

