what is the meaning of sleep in mysql proccess and how could avoid it because of highload?
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
here is highload:
top - 00:31:35 up 21 days, 9:27, 1 user, load average: 12.67, 6.68, 2.94
Tasks: 97 total, 1 running, 96 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.3%us, 0.6%sy, 0.0%ni, 94.3%id, 3.8%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1022732k total, 614528k used, 408204k free, 84316k buffers
Swap: 0k total, 0k used, 0k free, 135992k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
322 mysql 20 0 413m 173m 7452 S 99 17.4 97:42.25 mysqld
1 root 20 0 8356 688 560 S 0 0.1 0:15.61 init