## mark a section (Learn more)

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)

This paste will be private.