mysqshow PROCESSLIST.txt：查询过多导致数据库连接数爆表问题分析

+------+------+-----------------+---------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
| Id   | User | Host            | db      | Command | Time  | State                           | Info                                                                                                 |
+------+------+-----------------+---------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
| 2113 | root | localhost:56879 | xyz | Query   | 37954 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:06:54.0', '1')      | 
| 2114 | root | localhost:56880 | xyz | Query   | 38275 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2574, '2013-07-09 23:01:33.0', '0')      | 
| 2115 | root | localhost:56881 | xyz | Query   | 37946 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:07:02.0', '1')      | 
| 2155 | root | localhost:56946 | xyz | Query   | 37969 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:06:39.0', '1')      | 
| 2160 | root | localhost:57012 | xyz | Query   | 38367 | Waiting for release of readlock | insert into MORALE_RESULT (DEPARTMENT_ID, COMPANY_ID, COMPANY_MARK, MORALE_VALUE, CYCLE, CYCLE_VALUE | 
| 2162 | root | localhost:57014 | xyz | Query   | 36568 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2170 | root | localhost:57099 | xyz | Query   | 38246 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2574, '2013-07-09 23:02:02.0', '0')      | 
| 2173 | root | localhost:57102 | xyz | Query   | 38367 | Waiting for release of readlock | insert into MORALE_RESULT (DEPARTMENT_ID, COMPANY_ID, COMPANY_MARK, MORALE_VALUE, CYCLE, CYCLE_VALUE | 
| 2175 | root | localhost       | NULL    | Query   | 38367 | Flushing tables                 | FLUSH TABLES WITH READ LOCK                                                                          | 
| 2176 | root | localhost:57109 | xyz | Query   | 36568 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2177 | root | localhost:57110 | xyz | Query   | 34768 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2178 | root | localhost:57113 | xyz | Query   | 37945 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:07:03.0', '1')      | 
| 2179 | root | localhost:57114 | xyz | Query   | 37902 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:07:46.0', '1')      | 
| 2180 | root | localhost:57115 | xyz | Query   | 37945 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:07:03.0', '1')      | 
| 2181 | root | localhost:57116 | xyz | Query   | 37923 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:07:25.0', '1')      | 
| 2182 | root | localhost:57117 | xyz | Query   | 37887 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4332, '2013-07-09 23:08:01.0', '1')      | 
| 2183 | root | localhost:57124 | xyz | Query   | 37888 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4332, '2013-07-09 23:08:00.0', '1')      | 
| 2184 | root | localhost:57125 | xyz | Query   | 37608 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:12:40.0', '1')      | 
| 2185 | root | localhost:57126 | xyz | Query   | 37888 | Opening tables                  | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4332, '2013-07-09 23:08:00.0', '1')      | 
| 2186 | root | localhost:57127 | xyz | Query   | 37890 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4332, '2013-07-09 23:07:58.0', '1')      | 
| 2187 | root | localhost:57128 | xyz | Query   | 37902 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4353, '2013-07-09 23:07:46.0', '1')      | 
| 2188 | root | localhost:57134 | xyz | Query   | 37581 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:13:07.0', '1')      | 
| 2189 | root | localhost:57135 | xyz | Query   | 37623 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:12:25.0', '1')      | 
| 2190 | root | localhost:57136 | xyz | Query   | 37886 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (4332, '2013-07-09 23:08:02.0', '1')      | 
| 2191 | root | localhost:57137 | xyz | Query   | 37634 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:12:14.0', '1')      | 
| 2192 | root | localhost:57138 | xyz | Query   | 37580 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:13:08.0', '1')      | 
| 2193 | root | localhost:57145 | xyz | Query   | 37539 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (3498, '2013-07-09 23:13:49.0', '1')      | 

| 2194 | root | localhost:57146 | xyz | Query   | 37543 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:13:45.0', '1')      | 
| 2195 | root | localhost:57147 | xyz | Query   | 37580 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:13:08.0', '1')      | 
| 2196 | root | localhost:57148 | xyz | Query   | 37484 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:14:44.0', '1')      | 
| 2197 | root | localhost:57149 | xyz | Query   | 37540 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (3498, '2013-07-09 23:13:48.0', '1')      | 
| 2198 | root | localhost:57157 | xyz | Query   | 37484 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:14:44.0', '1')      | 
| 2199 | root | localhost:57158 | xyz | Query   | 37532 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:13:56.0', '1')      | 
| 2200 | root | localhost:57159 | xyz | Query   | 37517 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:14:11.0', '1')      | 
| 2201 | root | localhost:57160 | xyz | Query   | 37471 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (3498, '2013-07-09 23:14:57.0', '1')      | 
| 2202 | root | localhost:57161 | xyz | Query   | 37484 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:14:44.0', '1')      | 
| 2205 | root | localhost:57172 | xyz | Query   | 37454 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:15:14.0', '1')      | 
| 2206 | root | localhost:57173 | xyz | Query   | 37345 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:17:03.0', '1')      | 
| 2207 | root | localhost:57175 | xyz | Query   | 37470 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (3498, '2013-07-09 23:14:58.0', '1')      | 
| 2208 | root | localhost:57176 | xyz | Query   | 37451 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:15:17.0', '1')      | 
| 2209 | root | localhost:57177 | xyz | Query   | 37451 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:15:17.0', '1')      | 
| 2211 | root | localhost:57185 | xyz | Query   | 37344 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:17:04.0', '1')      | 
| 2212 | root | localhost:57186 | xyz | Query   | 37451 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:15:17.0', '1')      | 
| 2213 | root | localhost:57187 | xyz | Query   | 37451 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:15:17.0', '1')      | 
| 2214 | root | localhost:57188 | xyz | Query   | 36909 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:24:19.0', '1')      | 
| 2216 | root | localhost:57196 | xyz | Query   | 36908 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:24:20.0', '1')      | 
| 2220 | root | localhost:57200 | xyz | Query   | 36908 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (2578, '2013-07-09 23:24:20.0', '1')      | 
| 2223 | root | localhost:57207 | xyz | Query   | 34767 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2224 | root | localhost:57208 | xyz | Query   | 34768 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2225 | root | localhost:57209 | xyz | Query   | 34767 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2226 | root | localhost:57210 | xyz | Query   | 34768 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2227 | root | localhost:57211 | xyz | Query   | 34768 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2240 | root | localhost:57226 | xyz | Query   | 32968 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2241 | root | localhost:57227 | xyz | Query   | 32968 | Waiting for release of readlock | insert into JOB_TASK_MONITOR (STATUS, START_TIMESTAMP, END_TIMESTAMP, DESCRIPTION, EXECUTOR, RUN_MOD | 
| 2244 | root | localhost:57233 | xyz | Query   | 33446 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (3552, '2013-07-10 00:22:02.0', '1')      | 
| 2245 | root | localhost:57234 | xyz | Query   | 33513 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (3554, '2013-07-10 00:20:55.0', '1')      | 
| 2246 | root | localhost:57235 | xyz | Query   | 33479 | Waiting for table               | insert into T_USER_LOGS (USER_ID, LOGIN_TIME, TYPE) values (3554, '2013-07-10 00:21:29.0', '1')      |