在mysql过程中,睡眠的含义是什么?如何避免由于高负载而导致的睡眠?
Id User Host db Command Time State Info
93714 mydb localhost xyz Sleep 2 NULL
93715 root localhost NULL Query 0 NULL show full processlist
以下是高负载:
top - 00:31:35 up 21 days, 9:27, 1 user, load average: 12.67, 6.68, 2