Unwrap text
Report abuse
mysql> show processlist;
+------+---------+-----------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+---------+-----------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 182 | root | localhost | loadmax4 | Sleep | 761 | NULL | NULL |
| 8129 | root | localhost | rhp | Sleep | 302 | NULL | NULL |
| 8231 | web2_u1 | localhost | web2_db1 | Query | 46 | Locked | UPDATE loads SET deleted=1 where UserID=4724 and VendorCode='PEB1GW8198523' |
| 8262 | web2_u1 | localhost | web2_db1 | Query | 56 | Locked | UPDATE loads
SET
ShipAfterDate = '2007-06-14',
ShipBeforeDate = '2007-06-19',
|
| 8264 | web2_u1 | localhost | web2_db1 | Query | 44 | Locked | UPDATE loads SET deleted=1 where UserID=3200 and VendorCode='PEB1BNT57044' |
| 8265 | web4_u1 | localhost | web4_db1 | Sleep | 62 | NULL | NULL |
| 8266 | web2_u1 | localhost | web2_db1 | Query | 14 | Locked | UPDATE loads SET deleted=1 where UserID=1912 and VendorCode='PEB19TY187369' |
| 8269 | web2_u1 | localhost | web2_db1 | Sleep | 139 | NULL | NULL |
| 8270 | web2_u1 | localhost | web2_db1 | Query | 56 | Locked | SELECT LoadID FROM loads WHERE VendorCode = 'PEB14NX142996' |
| 8274 | web2_u1 | localhost | web2_db1 | Sleep | 139 | NULL | NULL |
| 8276 | web4_u1 | localhost | web4_db1 | Sleep | 198 | NULL | NULL |
| 8277 | web2_u1 | localhost | web2_db1 | Sleep | 139 | NULL | NULL |
| 8278 | web2_u1 | localhost | web2_db1 | Query | 1 | Locked | SELECT LoadID FROM loads WHERE VendorCode = 'PEB1B3H109014' |
| 8279 | web2_u1 | localhost | web2_db1 | Sleep | 139 | NULL | NULL |
| 8280 | web2_u1 | localhost | web2_db1 | Query | 52 | Locked | UPDATE loads SET deleted=1 where UserID=1653 and VendorCode='PEB129F155211' |
| 8281 | web2_u1 | localhost | web2_db1 | Sleep | 123 | NULL | NULL |
| 8282 | web2_u1 | localhost | web2_db1 | Query | 41 | Locked | SELECT LoadID FROM loads WHERE VendorCode = 'PEB1JCT157466' |
| 8283 | web4_u1 | localhost | web4_db1 | Sleep | 60 | NULL | NULL |
| 8284 | web4_u1 | localhost | web4_db1 | Sleep | 3 | NULL | NULL |
| 8285 | root | localhost | web2_db1 | Query | 12 | Writing to net | SELECT /*!40001 SQL_NO_CACHE */ * FROM `pelog` |
| 8286 | web4_u1 | localhost | web4_db1 | Sleep | 28 | NULL | NULL |
| 8287 | web4_u1 | localhost | web4_db1 | Sleep | 55 | NULL | NULL |
| 8288 | web4_u1 | localhost | web4_db1 | Sleep | 51 | NULL | NULL |
| 8289 | web4_u1 | localhost | web4_db1 | Sleep | 24 | NULL | NULL |
| 8290 | web4_u1 | localhost | web4_db1 | Sleep | 5 | NULL | NULL |
| 8291 | web2_u1 | localhost | web2_db1 | Query | 22 | Locked | UPDATE loads SET deleted=1 where UserID=1220 and VendorCode='PEB134X138269' |
| 8292 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+------+---------+-----------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
27 rows in set (0.00 sec)
Pastie << self Blog
