- 论坛徽章:
- 0
|
这两天网站运行速度经常极慢,用show processlist; 查了下,好像好多空的连接,但是不知道是哪个程序有问题,请大家帮我看看:
mysql> show processlist;
+----------+------+-----------+--------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+------+-----------+--------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 19885100 | root | localhost | NULL | Sleep | 204 | | NULL |
| 19885331 | root | localhost | NULL | Sleep | 226 | | NULL |
| 19885454 | root | localhost | NULL | Sleep | 208 | | NULL |
| 19885499 | root | localhost | NULL | Sleep | 194 | | NULL |
| 19885679 | root | localhost | NULL | Sleep | 168 | | NULL |
| 19886058 | root | localhost | NULL | Sleep | 105 | | NULL |
| 19886111 | root | localhost | discuz | Sleep | 1 | | NULL |
| 19886116 | root | localhost | discuz | Query | 3 | Writing to net | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 19886138 | root | localhost | discuz | Sleep | 1 | | NULL |
|