+------+------+-----------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------------+------+---------+------+-------+------------------+
| 4362 | root | localhost | cp | Query | 0 | NULL | show processlist |
| 4491 | root | localhost:51806 | cp | Sleep | 248 | | NULL |
| 4499 | root | localhost:51821 | cp | Sleep | 244 | | NULL |
| 4506 | root | localhost:51835 | cp | Sleep | 241 | | NULL |
| 4513 | root | localhost:51847 | cp | Sleep | 237 | | NULL |
| 4538 | root | localhost:51895 | cp | Sleep | 228 | | NULL |
| 4540 | root | localhost:51900 | cp | Sleep | 225 | | NULL |
| 4542 | root | localhost:51904 | cp | Sleep | 223 | | NULL |
| 4543 | root | localhost:51905 | cp | Sleep | 223 | | NULL |
| 4551 | root | localhost:51921 | cp | Sleep | 221 | | NULL |
| 4554 | root | localhost:51927 | cp | Sleep | 220 | | NULL |
| 4558 | root | localhost:51934 | cp | Sleep | 219 | | NULL |
| 4561 | root | localhost:51941 | cp | Sleep | 216 | | NULL |
| 4565 | root | localhost:51952 | cp | Sleep | 213 | | NULL |
| 4566 | root | localhost:51953 | cp | Sleep | 213 | | NULL |
| 4569 | root | localhost:51956 | cp | Sleep | 213 | | NULL |
| 4576 | root | localhost:51973 | cp | Sleep | 210 | | NULL |
| 4578 | root | localhost:51977 | cp | Sleep | 210 | | NULL |
| 4582 | root | localhost:51985 | cp | Sleep | 205 | | NULL |
| 4583 | root | localhost:51987 | cp | Sleep | 205 | | NULL |
| 4585 | root | localhost:51991 | cp | Sleep | 202 | | NULL |
| 4586 | root | localhost:51992 | cp | Sleep | 202 | | NULL |
| 4590 | root | localhost:52000 | cp | Sleep | 202 | | NULL |
| 4591 | root | localhost:52002 | cp | Sleep | 202 | | NULL |
| 4602 | root | localhost:52024 | cp | Sleep | 200 | | NULL |
| 4605 | root | localhost:52030 | cp | Sleep | 199 | | NULL |
| 4609 | root | localhost:52041 | cp | Sleep | 195 | | NULL |
| 4613 | root | localhost:52051 | cp | Sleep | 192 | | NULL |
| 4616 | root | localhost:52057 | cp | Sleep | 189 | | NULL |
| 4620 | root | localhost:52064 | cp | Sleep | 188 | | NULL |
| 4626 | root | localhost:52076 | cp | Sleep | 183 | | NULL |
| 4640 | root | localhost:52106 | cp | Sleep | 175 | | NULL |
| 4643 | root | localhost:52114 | cp | Sleep | 173 | | NULL |
| 4650 | root | localhost:52130 | cp | Sleep | 171 | | NULL |
| 4651 | root | localhost:52131 | cp | Sleep | 171 | | NULL |
| 4652 | root | localhost:52135 | cp | Sleep | 170 | | NULL |
| 4663 | root | localhost:52159 | cp | Sleep | 165 | | NULL |
| 4667 | root | localhost:52171 | cp | Sleep | 161 | | NULL |
以上是show processlist的结果,经常会出现很多这种"空线程"状态,就是info项没有显示执行任何sql语句,而且time也都持续了很长时间了,我想请问mysql这是在干什么?我没有使用长连接,不知为什么会出现这种情况。
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------------+------+---------+------+-------+------------------+
| 4362 | root | localhost | cp | Query | 0 | NULL | show processlist |
| 4491 | root | localhost:51806 | cp | Sleep | 248 | | NULL |
| 4499 | root | localhost:51821 | cp | Sleep | 244 | | NULL |
| 4506 | root | localhost:51835 | cp | Sleep | 241 | | NULL |
| 4513 | root | localhost:51847 | cp | Sleep | 237 | | NULL |
| 4538 | root | localhost:51895 | cp | Sleep | 228 | | NULL |
| 4540 | root | localhost:51900 | cp | Sleep | 225 | | NULL |
| 4542 | root | localhost:51904 | cp | Sleep | 223 | | NULL |
| 4543 | root | localhost:51905 | cp | Sleep | 223 | | NULL |
| 4551 | root | localhost:51921 | cp | Sleep | 221 | | NULL |
| 4554 | root | localhost:51927 | cp | Sleep | 220 | | NULL |
| 4558 | root | localhost:51934 | cp | Sleep | 219 | | NULL |
| 4561 | root | localhost:51941 | cp | Sleep | 216 | | NULL |
| 4565 | root | localhost:51952 | cp | Sleep | 213 | | NULL |
| 4566 | root | localhost:51953 | cp | Sleep | 213 | | NULL |
| 4569 | root | localhost:51956 | cp | Sleep | 213 | | NULL |
| 4576 | root | localhost:51973 | cp | Sleep | 210 | | NULL |
| 4578 | root | localhost:51977 | cp | Sleep | 210 | | NULL |
| 4582 | root | localhost:51985 | cp | Sleep | 205 | | NULL |
| 4583 | root | localhost:51987 | cp | Sleep | 205 | | NULL |
| 4585 | root | localhost:51991 | cp | Sleep | 202 | | NULL |
| 4586 | root | localhost:51992 | cp | Sleep | 202 | | NULL |
| 4590 | root | localhost:52000 | cp | Sleep | 202 | | NULL |
| 4591 | root | localhost:52002 | cp | Sleep | 202 | | NULL |
| 4602 | root | localhost:52024 | cp | Sleep | 200 | | NULL |
| 4605 | root | localhost:52030 | cp | Sleep | 199 | | NULL |
| 4609 | root | localhost:52041 | cp | Sleep | 195 | | NULL |
| 4613 | root | localhost:52051 | cp | Sleep | 192 | | NULL |
| 4616 | root | localhost:52057 | cp | Sleep | 189 | | NULL |
| 4620 | root | localhost:52064 | cp | Sleep | 188 | | NULL |
| 4626 | root | localhost:52076 | cp | Sleep | 183 | | NULL |
| 4640 | root | localhost:52106 | cp | Sleep | 175 | | NULL |
| 4643 | root | localhost:52114 | cp | Sleep | 173 | | NULL |
| 4650 | root | localhost:52130 | cp | Sleep | 171 | | NULL |
| 4651 | root | localhost:52131 | cp | Sleep | 171 | | NULL |
| 4652 | root | localhost:52135 | cp | Sleep | 170 | | NULL |
| 4663 | root | localhost:52159 | cp | Sleep | 165 | | NULL |
| 4667 | root | localhost:52171 | cp | Sleep | 161 | | NULL |
以上是show processlist的结果,经常会出现很多这种"空线程"状态,就是info项没有显示执行任何sql语句,而且time也都持续了很长时间了,我想请问mysql这是在干什么?我没有使用长连接,不知为什么会出现这种情况。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货