TA的每日心情 | 开心 2012-3-7 10:15 |
---|
签到天数: 11 天 [LV.3]偶尔看看II
|
最近在centos5上面部署了一套系统,采用mysql的version是5.1.4-log,系统采用c3p0作为连接池,系统运行后出现下面的记录:
+-----+--------+-----------------+------+---------+-------+-------------+----------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+--------+-----------------+------+---------+-------+-------------+----------------------------------+
| 19 | -| localhost:32931 | NULL | Connect | NULL | login | NULL |
| 75 | -| localhost:33231 | -| Query | 36500 | cleaning up | SHOW WARNINGS |
| 76 | -| localhost:33267 | -| Query | 36500 | cleaning up | SET character_set_results = NULL |
| 77 | -| localhost:33268 | -| Query | 36355 | NULL | NULL |
| 87 | -| localhost:33327 | -| Query | 34130 | NULL | NULL |
| 97 | -| localhost:33394 | -| Query | 28839 | executing | SHOW VARIABLES |
| 124 | -| localhost:33446 | -| Query | 15021 | NULL | NULL |
| 135 | -| localhost:33469 | -| Query | 8490 | cleaning up | SET character_set_results = NULL |
| 144 | -| localhost:33487 | -| Connect | NULL | login | NULL |上面红色的部分是怎么产生的?查了一些资料,没有得到结果;
而在其他的系统中运行正常情况下,都是如下:
+------+------+-----------------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------------+------+---------+------+-------+-----------------------+
| 6775 | - | localhost:49067 | - | Sleep | 64 | NULL | NULL |
| 6785 | - | localhost:55917 | - | Sleep | 406 | NULL | NULL |
| 6786 | - | localhost:46766 | - | Sleep | 388 | NULL | NULL | 不知是何故,望各位大虾指点,谢谢!
|
|