mysql> show processlist; +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | 11864350 | tester | 63.221.156.44:35832 | tester | Sleep | 521 | | NULL | | 11864351 | tester | 63.221.156.44:21066 | tester | Sleep | 521 | | NULL | | 11877794 | tester_rep | 10.10.1.76:51067 | NULL | Binlog Dump | 97275 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 11906058 | pro-tester-1 | 10.10.1.36:51933 | tester | Sleep | 4 | | NULL | | 11906111 | pro-tester-1 | 10.10.1.36:52481 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='c37a8a40-e7bf-457c-9392-8dc3d1b543b | | 11906127 | pro-tester-1 | 10.10.1.36:52554 | tester | Query | 2 | Locked | select * from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11906130 | pro-tester-1 | 10.10.1.36:52561 | tester | Query | 2 | Locked | select * from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11906132 | pro-tester-1 | 10.10.1.36:52571 | tester | Sleep | 2 | | NULL | | 11907806 | pro-tester-1 | 10.10.1.36:50137 | tester | Sleep | 1 | | NULL | | 11907922 | pro-tester-1 | 10.10.1.36:51448 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11908016 | pro-tester-1 | 10.10.1.36:52345 | tester | Sleep | 5 | | NULL | | 11908560 | pro-tester-1 | 10.10.1.36:36784 | tester | Query | 2 | Locked | select * from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11908561 | pro-tester-1 | 10.10.1.36:37045 | tester | Sleep | 5 | | NULL | | 11909176 | pro-tester-1 | 10.10.1.36:52453 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='93d8eede-8dd0-492d-833c-1d940b080ad | | 11909178 | pro-tester-1 | 10.10.1.36:52460 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='93658aa7-8cdb-460e-a7c4-3570d43905c | | 11909182 | pro-tester-1 | 10.10.1.36:52474 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='1baa334c-1c1f-4e7f-af0e-9db86213586 | | 11909190 | pro-tester-1 | 10.10.1.36:52501 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='0806c923-7355-4532-8136-2ca99328253 | | 11909191 | pro-tester-1 | 10.10.1.36:52503 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='44eb1d22-989c-442c-a538-aac4e83c168 | | 11909196 | pro-tester-1 | 10.10.1.36:52521 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='81e3694f-2650-43bb-8026-25ad423c976 | | 11909211 | pro-tester-1 | 10.10.1.36:52567 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='1b56f985-af33-4b4d-b1d3-dda3bc546ab | | 11909235 | pro-tester-1 | 10.10.1.36:52656 | tester | Query | 3 | Locked | update session set activateTime=utc_timestamp() where sessionId='ace | | 11909242 | pro-tester-1 | 10.10.1.36:52676 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='8e6b827b-671c-40f9-95f2-a18bd2a772b | | 11909256 | pro-tester-1 | 10.10.1.36:53017 | tester | Query | 2 | Locked | select * from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11909258 | pro-tester-1 | 10.10.1.36:53023 | tester | Sleep | 0 | | NULL | | 11909283 | pro-tester-1 | 10.10.1.36:53663 | tester | Query | 2 | update | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11909322 | pro-tester-1 | 10.10.1.36:54227 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11909386 | pro-tester-1 | 10.10.1.36:54538 | tester | Sleep | 3 | | NULL | | 11909435 | pro-tester-1 | 10.10.1.36:55399 | tester | Query | 2 | end | update stream set publishStatus='Publishing' ,updat | | 11909438 | pro-tester-1 | 10.10.1.36:55456 | tester | Query | 2 | Locked | select * from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11909458 | pro-tester-1 | 10.10.1.36:56405 | tester | Query | 1 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11909461 | pro-tester-1 | 10.10.1.36:56417 | tester | Query | 2 | Locked | select * from ast where token='00000000000000000bb5d96ed385545698d4386fe48a594bcc | | 11909464 | pro-tester-1 | 10.10.1.36:56420 | tester | Query | 1 | Locked | select * from ast where token='00000000000000000a019b08220974076b6db1419bcc116226 | | 11909465 | pro-tester-1 | 10.10.1.36:56421 | tester | Query | 2 | Locked | select * from stream where streamGuid='aa4e5ce4-28e1-4fe5-b272-0706d52fe6d4' limit 1 | | 11909473 | pro-tester-1 | 10.10.1.36:56471 | tester | Query | 2 | Locked | select * from ast where token='0000000000000000001d4a312a5f84289a795ec9ecb49af86c | | 11909540 | pro-tester-1 | 10.10.1.36:50995 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='a9285f12-cfc1-4bc5-898b-04ba59ac3ff | | 11909552 | pro-tester-1 | 10.10.1.36:53293 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='00b6777c-cead-4471-aea1-be233ec1cf6 | | 11909553 | pro-tester-1 | 10.10.1.36:53294 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='2220a7a4-75ef-4299-9021-3d2d9c0d29e | | 11909554 | pro-tester-1 | 10.10.1.36:53299 | tester | Query | 3 | end | update session set activateTime=utc_timestamp() where sessionId='f3b | | 11909556 | pro-tester-1 | 10.10.1.36:53313 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='40498678-965b-4009-a782-d5b071d2eed | | 11909557 | pro-tester-1 | 10.10.1.36:53318 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='01f79431-1408-4b73-879b-44531dbc0e5 | | 11909559 | pro-tester-1 | 10.10.1.36:53323 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='31a10c0d-bcbf-4484-a36a-a69b4b74fc4 | | 11909560 | pro-tester-1 | 10.10.1.36:53325 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='52d1b0a3-eadf-430b-bb39-e8634916abb | | 11909561 | pro-tester-1 | 10.10.1.36:53328 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='dcb1a19a-4d40-487c-acc3-f06679c9dfb | | 11909663 | pro-tester-1 | 10.10.1.36:60389 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='a1ff0ad3-3b6b-4469-b016-4e19f9debde5' limit 1 | | 11909965 | pro-tester-1 | 10.10.1.36:44152 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='de6ad247-1f42-4479-b53e-8771fbb809e | | 11909966 | pro-tester-1 | 10.10.1.36:44158 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='47ad02ea-2b89-4d22-8efc-8a79f6456fb | | 11909968 | pro-tester-1 | 10.10.1.36:44162 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='086e5840-983d-4df4-a584-bdadd9f0578 | | 11909969 | pro-tester-1 | 10.10.1.36:44165 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='48713d4e-2253-432d-a3ce-489b3c6851f | | 11909971 | pro-tester-1 | 10.10.1.36:44177 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='d2ffeeb4-5fb0-4cf8-bb48-ae53253a2c3 | | 11910133 | pro-tester-1 | 10.10.1.36:58304 | tester | Sleep | 2 | | NULL | | 11910376 | pro-tester-1 | 10.10.1.36:51427 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='0d3cb912-1239-4618-8e28-5645df2dced | | 11910377 | pro-tester-1 | 10.10.1.36:51432 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='badabc4b-327d-4288-bc98-406e9bb64de | | 11910378 | pro-tester-1 | 10.10.1.36:51437 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='36f06b6a-3ea9-4e93-8a7c-5aebac35f9f | | 11910508 | pro-tester-1 | 10.10.1.36:56857 | tester | Query | 2 | Locked | select * from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11910568 | pro-tester-1 | 10.10.1.36:44775 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11910590 | pro-tester-1 | 10.10.1.36:51753 | tester | Query | 0 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11910674 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 11910690 | pro-tester-1 | 10.10.1.36:49026 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='71e1ebf5-fdea-4d99-aef5-80c30ac68406' limit 1 | | 11910698 | pro-tester-1 | 10.10.1.36:50471 | tester | Query | 2 | Locked | select * from stream where streamId=6754 limit 1 | | 11910754 | pro-tester-1 | 10.10.1.36:38777 | tester | Query | 2 | Locked | select * from ast where token='00000000000000000a019b08220974076b6db1419bcc116226 | | 11910784 | pro-tester-1 | 10.10.1.36:47063 | tester | Query | 3 | Locked | update session set activateTime=utc_timestamp() where sessionId='9d5 | | 11910785 | pro-tester-1 | 10.10.1.36:47071 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='d1134edd-bbb4-437a-b4b7-2f2b6ea3c2c | | 11910786 | pro-tester-1 | 10.10.1.36:47077 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='43cc2c39-476a-477e-bc49-e00f44b1566 | | 11910787 | pro-tester-1 | 10.10.1.36:47108 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='e55a1851-d733-435e-acc5-d55f200f49d | | 11910788 | pro-tester-1 | 10.10.1.36:47113 | tester | Query | 3 | Locked | select * from session where status='login' and sessionId='154b29b8-9db9-4a41-bf8f-a93a09c1261 | | 11910863 | pro-tester-1 | 10.10.1.36:42289 | tester | Sleep | 4 | | NULL | | 11910972 | pro-tester-1 | 10.10.1.36:51936 | tester | Query | 2 | Locked | select * from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11910973 | pro-tester-1 | 10.10.1.36:51942 | tester | Query | 2 | Locked | select * from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11910976 | pro-tester-1 | 10.10.1.36:52262 | tester | Sleep | 3 | | NULL | | 11911031 | pro-tester-1 | 10.10.1.86:41335 | tester | Query | 3 | update | insert into time_stream (streamId, duration, packetId, createTime) values (6000, 0, 0, | | 11911033 | pro-tester-1 | 10.10.1.36:41607 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='07c8b48d-7e47-4474-851d-6f5626db32a | | 11911034 | pro-tester-1 | 10.10.1.36:41618 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='e491235b-10ff-46b3-a9fa-48d6523341d | | 11911035 | pro-tester-1 | 10.10.1.36:41619 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='669618d6-5e33-4764-b173-87a1609ce18 | | 11911036 | pro-tester-1 | 10.10.1.36:41622 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='5cf66eee-8be8-4a73-a2f8-c40f0b03605 | | 11911037 | pro-tester-1 | 10.10.1.36:41623 | tester | Query | 2 | end | update ast set openTimes = 215545 where token='00000000000000000ed7d53bcf505440 | | 11911038 | pro-tester-1 | 10.10.1.36:41625 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='624a0f6b-3683-43e3-84b7-54153a09aa8 | | 11911039 | pro-tester-1 | 10.10.1.36:41629 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='316fef3a-e963-4337-a1fe-ac7fdadbfbb | | 11911040 | pro-tester-1 | 10.10.1.36:41634 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='13867278-8f6b-4c6c-9e1a-08069822cf2 | | 11911041 | pro-tester-1 | 10.10.1.36:41637 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='fe18e9ec-0619-4772-b29d-1e936b0f2df | | 11911042 | pro-tester-1 | 10.10.1.36:41639 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='ccca8453-8166-4e11-9e04-743a82b409c | | 11911043 | pro-tester-1 | 10.10.1.36:41641 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='5bf9c385-6bcd-4b2b-9f9d-89e6bf63e5a | | 11911044 | pro-tester-1 | 10.10.1.36:41646 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='336fb0a7-b0fe-4674-89d1-8b440e0bc76 | | 11911045 | pro-tester-1 | 10.10.1.36:41650 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='e3ac1287-de2e-444c-9970-15d212d9d5e | | 11911046 | pro-tester-1 | 10.10.1.36:41652 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='b6a3b344-b3ae-41d4-9e79-f9403a5616e | | 11911047 | pro-tester-1 | 10.10.1.36:41660 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='1775ac5a-1183-4f23-95bc-7ded0a39a28 | | 11911048 | pro-tester-1 | 10.10.1.36:41662 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='d568074b-9856-4d70-8a86-e2951dae576 | | 11911049 | pro-tester-1 | 10.10.1.36:41664 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='fbbbfa18-f8cb-471e-bb5c-41adc1920ad | | 11911050 | pro-tester-1 | 10.10.1.36:41667 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='a9d52920-4ad0-4de7-a3ed-617770db35e | | 11911051 | pro-tester-1 | 10.10.1.36:41673 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='15868183-7ae3-4cc9-82e8-bfa53d673d6 | | 11911052 | pro-tester-1 | 10.10.1.36:41677 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='102d17b2-5da4-4bbe-b929-a40ea941a18 | | 11911053 | pro-tester-1 | 10.10.1.36:41678 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='3f67e9c4-9a00-470a-a784-0665fa7b8924' limit 1 | | 11911054 | pro-tester-1 | 10.10.1.36:41682 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='399adcca-1ab5-4959-aa49-a96e1bdfc3d | | 11911055 | pro-tester-1 | 10.10.1.36:41687 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='50a68c93-2764-4ea6-b9ba-fb6af881794 | | 11911056 | pro-tester-1 | 10.10.1.36:41689 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='c8e111fd-c73f-4f4e-8e8b-d6f4ebe754e | | 11911057 | pro-tester-1 | 10.10.1.36:41691 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='6c446795-9315-475a-9654-7dddb12d022 | | 11911058 | pro-tester-1 | 10.10.1.36:41694 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='9dae225b-6f41-4bdb-ab7a-58d45bcb25e | | 11911059 | pro-tester-1 | 10.10.1.36:41698 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='38fd099f-7bf3-48ad-bc57-7f818d26b45 | | 11911060 | pro-tester-1 | 10.10.1.36:41701 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='60eb2bae-c45a-495a-a682-fdab1b56739 | | 11911061 | pro-tester-1 | 10.10.1.36:41702 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='3fee03ac-8ed9-4f09-8cfb-3a5189dd561 | | 11911062 | pro-tester-1 | 10.10.1.36:41705 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911063 | pro-tester-1 | 10.10.1.36:41707 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='8a25ea9f-157e-457f-be2f-5b6b1ad3f12 | | 11911064 | pro-tester-1 | 10.10.1.36:41709 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='6a9d1b54-8efd-46c5-a9f5-c8d85975ce4 | | 11911065 | pro-tester-1 | 10.10.1.36:41712 | tester | Query | 2 | Locked | update session set sessionId='ab524ed1-1d20-4ce0-a0c4-51517e4a3a29' , | | 11911066 | pro-tester-1 | 10.10.1.36:41719 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='f40cd095-4df6-4b5b-bc19-ea4bac4ffe2 | | 11911067 | pro-tester-1 | 10.10.1.36:41720 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='51ce3636-37d3-497a-81c1-517e2682613 | | 11911068 | pro-tester-1 | 10.10.1.36:41723 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='324c4322-cad6-4cc4-8ab5-202cc1bd524 | | 11911069 | pro-tester-1 | 10.10.1.36:41729 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='e6954acb-ef2d-459a-a22c-566157fff66 | | 11911070 | pro-tester-1 | 10.10.1.36:41741 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='29fe9fb3-baac-48f1-8f7f-224c3825442 | | 11911071 | pro-tester-1 | 10.10.1.36:41743 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='28fcbd12-8389-4de2-91ab-ec91a47fbe8 | | 11911072 | pro-tester-1 | 10.10.1.36:41746 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='a8e1616d-1d0d-46ea-87a9-8acbf1165c8 | | 11911073 | pro-tester-1 | 10.10.1.36:41750 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911074 | pro-tester-1 | 10.10.1.36:41753 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='a8e5b8a7-e402-4f09-8f72-ce02bd49d33 | | 11911075 | pro-tester-1 | 10.10.1.36:41757 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='f02ca23c-b0cd-4c10-9ab0-ff5d81816b0 | | 11911076 | pro-tester-1 | 10.10.1.36:41761 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='5d889d13-3280-4495-803a-806c04d4e4d | | 11911077 | pro-tester-1 | 10.10.1.36:41763 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='d73aa796-d5e2-4897-bd3c-fbd4e198c7e | | 11911078 | pro-tester-1 | 10.10.1.36:41765 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='e85034c8-6f10-461f-b3e1-fcea93e14b5 | | 11911079 | pro-tester-1 | 10.10.1.36:41768 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='1611c0f8-b65c-44f4-a748-862dd5afd6f | | 11911080 | pro-tester-1 | 10.10.1.36:41772 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='b5745182-9e02-416d-9e08-0fb33a7dd23 | | 11911081 | pro-tester-1 | 10.10.1.36:41774 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='073c3b17-b181-43c0-ad28-1444eaa1ce3 | | 11911082 | pro-tester-1 | 10.10.1.36:41777 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='4369b1ef-e1e1-4eb2-bca3-0ba1b0384ee | | 11911083 | pro-tester-1 | 10.10.1.36:41779 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='67f2a24c-a0e6-42bc-922a-37eac24bb4f | | 11911084 | pro-tester-1 | 10.10.1.36:41784 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='120e6b1f-7c3f-4d9d-9c41-600dca90cfd | | 11911085 | pro-tester-1 | 10.10.1.36:41785 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='553289ef-fb34-4d0e-bc60-35a651af9f3 | | 11911086 | pro-tester-1 | 10.10.1.36:41787 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911087 | pro-tester-1 | 10.10.1.36:41789 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='4d944381-bdd6-4c03-9a48-d84fb88e173 | | 11911088 | pro-tester-1 | 10.10.1.36:41792 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='3440773a-b070-410a-a9fb-93bcf8299cf | | 11911089 | pro-tester-1 | 10.10.1.36:41794 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='e487afb6-3fc8-44ef-b555-7cd948fa138 | | 11911090 | pro-tester-1 | 10.10.1.36:41796 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='fbba2f54-ab82-4866-a416-e89dc621b8c | | 11911091 | pro-tester-1 | 10.10.1.36:41800 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='4c6839f2-3222-4892-856c-f5f702c9974 | | 11911092 | pro-tester-1 | 10.10.1.36:41802 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911093 | pro-tester-1 | 10.10.1.36:41804 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='9dc70e75-fd6f-49b2-9de5-3e0975115ed | | 11911094 | pro-tester-1 | 10.10.1.36:41807 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='9310fc52-1ece-4228-93dc-ecb18ae73ea | | 11911095 | pro-tester-1 | 10.10.1.36:41809 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='4fa5925d-397e-4afc-8cd4-b0dd50514af | | 11911096 | pro-tester-1 | 10.10.1.36:41811 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='761a1b4a-7f73-4eca-9604-af85e1a9082 | | 11911097 | pro-tester-1 | 10.10.1.36:41813 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='29fe5a5c-b333-4b8f-99e2-a6b515859ce | | 11911098 | pro-tester-1 | 10.10.1.36:41817 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911099 | pro-tester-1 | 10.10.1.36:41818 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='6c9a4759-fe3f-42d9-b6f2-e14b691f235 | | 11911100 | pro-tester-1 | 10.10.1.36:41820 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='0716cfe7-da14-476b-8687-2412c555cdb | | 11911101 | pro-tester-1 | 10.10.1.36:41822 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911102 | pro-tester-1 | 10.10.1.36:41825 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='36ca9dff-4bc2-411a-a7d6-5749edfe3d9 | | 11911103 | pro-tester-1 | 10.10.1.36:41827 | tester | Query | 2 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911104 | pro-tester-1 | 10.10.1.36:41830 | tester | Query | 2 | Locked | select * from session where status='login' and sessionId='2fc0ff65-95a4-4a55-8d81-a6e1925ada4 | | 11911105 | pro-tester-1 | 10.10.1.36:41854 | tester | Query | 1 | Locked | select * from stream where streamGuid='8b8bd10c-f277-4cc1-95e8-e48fcd774de4' limit 1 | +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ 143 rows in set (0.00 sec) mysql> show processlist; +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | 11864350 | tester | 63.221.156.44:35832 | tester | Sleep | 526 | | NULL | | 11864351 | tester | 63.221.156.44:21066 | tester | Sleep | 526 | | NULL | | 11877794 | tester_rep | 10.10.1.76:51067 | NULL | Binlog Dump | 97280 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 11906058 | pro-tester-1 | 10.10.1.36:51933 | tester | Sleep | 1 | | NULL | | 11906111 | pro-tester-1 | 10.10.1.36:52481 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='c37a8a40-e7bf-457c-9392-8dc3d1b543b | | 11906127 | pro-tester-1 | 10.10.1.36:52554 | tester | Query | 7 | Locked | select * from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11906130 | pro-tester-1 | 10.10.1.36:52561 | tester | Query | 7 | Locked | select * from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11906132 | pro-tester-1 | 10.10.1.36:52571 | tester | Query | 5 | Locked | select * from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11907806 | pro-tester-1 | 10.10.1.36:50137 | tester | Sleep | 0 | | NULL | | 11907922 | pro-tester-1 | 10.10.1.36:51448 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11908016 | pro-tester-1 | 10.10.1.36:52345 | tester | Sleep | 4 | | NULL | | 11908560 | pro-tester-1 | 10.10.1.36:36784 | tester | Query | 7 | Locked | select * from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11908561 | pro-tester-1 | 10.10.1.36:37045 | tester | Sleep | 5 | | NULL | | 11909176 | pro-tester-1 | 10.10.1.36:52453 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='93d8eede-8dd0-492d-833c-1d940b080ad | | 11909178 | pro-tester-1 | 10.10.1.36:52460 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='93658aa7-8cdb-460e-a7c4-3570d43905c | | 11909182 | pro-tester-1 | 10.10.1.36:52474 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='1baa334c-1c1f-4e7f-af0e-9db86213586 | | 11909190 | pro-tester-1 | 10.10.1.36:52501 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='0806c923-7355-4532-8136-2ca99328253 | | 11909191 | pro-tester-1 | 10.10.1.36:52503 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='44eb1d22-989c-442c-a538-aac4e83c168 | | 11909196 | pro-tester-1 | 10.10.1.36:52521 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='81e3694f-2650-43bb-8026-25ad423c976 | | 11909211 | pro-tester-1 | 10.10.1.36:52567 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='1b56f985-af33-4b4d-b1d3-dda3bc546ab | | 11909235 | pro-tester-1 | 10.10.1.36:52656 | tester | Query | 8 | Locked | update session set activateTime=utc_timestamp() where sessionId='ace | | 11909242 | pro-tester-1 | 10.10.1.36:52676 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='8e6b827b-671c-40f9-95f2-a18bd2a772b | | 11909256 | pro-tester-1 | 10.10.1.36:53017 | tester | Query | 7 | Locked | select * from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11909258 | pro-tester-1 | 10.10.1.36:53023 | tester | Query | 5 | Locked | select * from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11909283 | pro-tester-1 | 10.10.1.36:53663 | tester | Query | 7 | update | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11909322 | pro-tester-1 | 10.10.1.36:54227 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11909386 | pro-tester-1 | 10.10.1.36:54538 | tester | Sleep | 3 | | NULL | | 11909435 | pro-tester-1 | 10.10.1.36:55399 | tester | Query | 7 | end | update stream set publishStatus='Publishing' ,updat | | 11909438 | pro-tester-1 | 10.10.1.36:55456 | tester | Query | 7 | Locked | select * from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11909458 | pro-tester-1 | 10.10.1.36:56405 | tester | Query | 6 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11909461 | pro-tester-1 | 10.10.1.36:56417 | tester | Query | 7 | Locked | select * from ast where token='00000000000000000bb5d96ed385545698d4386fe48a594bcc | | 11909464 | pro-tester-1 | 10.10.1.36:56420 | tester | Query | 6 | Locked | select * from ast where token='00000000000000000a019b08220974076b6db1419bcc116226 | | 11909465 | pro-tester-1 | 10.10.1.36:56421 | tester | Query | 7 | Locked | select * from stream where streamGuid='aa4e5ce4-28e1-4fe5-b272-0706d52fe6d4' limit 1 | | 11909473 | pro-tester-1 | 10.10.1.36:56471 | tester | Query | 7 | Locked | select * from ast where token='0000000000000000001d4a312a5f84289a795ec9ecb49af86c | | 11909540 | pro-tester-1 | 10.10.1.36:50995 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='a9285f12-cfc1-4bc5-898b-04ba59ac3ff | | 11909552 | pro-tester-1 | 10.10.1.36:53293 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='00b6777c-cead-4471-aea1-be233ec1cf6 | | 11909553 | pro-tester-1 | 10.10.1.36:53294 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='2220a7a4-75ef-4299-9021-3d2d9c0d29e | | 11909554 | pro-tester-1 | 10.10.1.36:53299 | tester | Query | 8 | end | update session set activateTime=utc_timestamp() where sessionId='f3b | | 11909556 | pro-tester-1 | 10.10.1.36:53313 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='40498678-965b-4009-a782-d5b071d2eed | | 11909557 | pro-tester-1 | 10.10.1.36:53318 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='01f79431-1408-4b73-879b-44531dbc0e5 | | 11909559 | pro-tester-1 | 10.10.1.36:53323 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='31a10c0d-bcbf-4484-a36a-a69b4b74fc4 | | 11909560 | pro-tester-1 | 10.10.1.36:53325 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='52d1b0a3-eadf-430b-bb39-e8634916abb | | 11909561 | pro-tester-1 | 10.10.1.36:53328 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='dcb1a19a-4d40-487c-acc3-f06679c9dfb | | 11909663 | pro-tester-1 | 10.10.1.36:60389 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='a1ff0ad3-3b6b-4469-b016-4e19f9debde5' limit 1 | | 11909965 | pro-tester-1 | 10.10.1.36:44152 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='de6ad247-1f42-4479-b53e-8771fbb809e | | 11909966 | pro-tester-1 | 10.10.1.36:44158 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='47ad02ea-2b89-4d22-8efc-8a79f6456fb | | 11909968 | pro-tester-1 | 10.10.1.36:44162 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='086e5840-983d-4df4-a584-bdadd9f0578 | | 11909969 | pro-tester-1 | 10.10.1.36:44165 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='48713d4e-2253-432d-a3ce-489b3c6851f | | 11909971 | pro-tester-1 | 10.10.1.36:44177 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='d2ffeeb4-5fb0-4cf8-bb48-ae53253a2c3 | | 11910133 | pro-tester-1 | 10.10.1.36:58304 | tester | Sleep | 2 | | NULL | | 11910376 | pro-tester-1 | 10.10.1.36:51427 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='0d3cb912-1239-4618-8e28-5645df2dced | | 11910377 | pro-tester-1 | 10.10.1.36:51432 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='badabc4b-327d-4288-bc98-406e9bb64de | | 11910378 | pro-tester-1 | 10.10.1.36:51437 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='36f06b6a-3ea9-4e93-8a7c-5aebac35f9f | | 11910508 | pro-tester-1 | 10.10.1.36:56857 | tester | Query | 7 | Locked | select * from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11910568 | pro-tester-1 | 10.10.1.36:44775 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11910590 | pro-tester-1 | 10.10.1.36:51753 | tester | Query | 5 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11910674 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 11910690 | pro-tester-1 | 10.10.1.36:49026 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='71e1ebf5-fdea-4d99-aef5-80c30ac68406' limit 1 | | 11910698 | pro-tester-1 | 10.10.1.36:50471 | tester | Query | 7 | Locked | select * from stream where streamId=6754 limit 1 | | 11910754 | pro-tester-1 | 10.10.1.36:38777 | tester | Query | 7 | Locked | select * from ast where token='00000000000000000a019b08220974076b6db1419bcc116226 | | 11910784 | pro-tester-1 | 10.10.1.36:47063 | tester | Query | 8 | Locked | update session set activateTime=utc_timestamp() where sessionId='9d5 | | 11910785 | pro-tester-1 | 10.10.1.36:47071 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='d1134edd-bbb4-437a-b4b7-2f2b6ea3c2c | | 11910786 | pro-tester-1 | 10.10.1.36:47077 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='43cc2c39-476a-477e-bc49-e00f44b1566 | | 11910787 | pro-tester-1 | 10.10.1.36:47108 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='e55a1851-d733-435e-acc5-d55f200f49d | | 11910788 | pro-tester-1 | 10.10.1.36:47113 | tester | Query | 8 | Locked | select * from session where status='login' and sessionId='154b29b8-9db9-4a41-bf8f-a93a09c1261 | | 11910863 | pro-tester-1 | 10.10.1.36:42289 | tester | Sleep | 4 | | NULL | | 11910972 | pro-tester-1 | 10.10.1.36:51936 | tester | Query | 7 | Locked | select * from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11910973 | pro-tester-1 | 10.10.1.36:51942 | tester | Query | 7 | Locked | select * from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11910976 | pro-tester-1 | 10.10.1.36:52262 | tester | Sleep | 3 | | NULL | | 11911031 | pro-tester-1 | 10.10.1.86:41335 | tester | Query | 8 | update | insert into time_stream (streamId, duration, packetId, createTime) values (6000, 0, 0, | | 11911033 | pro-tester-1 | 10.10.1.36:41607 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='07c8b48d-7e47-4474-851d-6f5626db32a | | 11911034 | pro-tester-1 | 10.10.1.36:41618 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='e491235b-10ff-46b3-a9fa-48d6523341d | | 11911035 | pro-tester-1 | 10.10.1.36:41619 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='669618d6-5e33-4764-b173-87a1609ce18 | | 11911036 | pro-tester-1 | 10.10.1.36:41622 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='5cf66eee-8be8-4a73-a2f8-c40f0b03605 | | 11911037 | pro-tester-1 | 10.10.1.36:41623 | tester | Query | 7 | end | update ast set openTimes = 215545 where token='00000000000000000ed7d53bcf505440 | | 11911038 | pro-tester-1 | 10.10.1.36:41625 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='624a0f6b-3683-43e3-84b7-54153a09aa8 | | 11911039 | pro-tester-1 | 10.10.1.36:41629 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='316fef3a-e963-4337-a1fe-ac7fdadbfbb | | 11911040 | pro-tester-1 | 10.10.1.36:41634 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='13867278-8f6b-4c6c-9e1a-08069822cf2 | | 11911041 | pro-tester-1 | 10.10.1.36:41637 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='fe18e9ec-0619-4772-b29d-1e936b0f2df | | 11911042 | pro-tester-1 | 10.10.1.36:41639 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='ccca8453-8166-4e11-9e04-743a82b409c | | 11911043 | pro-tester-1 | 10.10.1.36:41641 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='5bf9c385-6bcd-4b2b-9f9d-89e6bf63e5a | | 11911044 | pro-tester-1 | 10.10.1.36:41646 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='336fb0a7-b0fe-4674-89d1-8b440e0bc76 | | 11911045 | pro-tester-1 | 10.10.1.36:41650 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='e3ac1287-de2e-444c-9970-15d212d9d5e | | 11911046 | pro-tester-1 | 10.10.1.36:41652 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='b6a3b344-b3ae-41d4-9e79-f9403a5616e | | 11911047 | pro-tester-1 | 10.10.1.36:41660 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='1775ac5a-1183-4f23-95bc-7ded0a39a28 | | 11911048 | pro-tester-1 | 10.10.1.36:41662 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='d568074b-9856-4d70-8a86-e2951dae576 | | 11911049 | pro-tester-1 | 10.10.1.36:41664 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='fbbbfa18-f8cb-471e-bb5c-41adc1920ad | | 11911050 | pro-tester-1 | 10.10.1.36:41667 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='a9d52920-4ad0-4de7-a3ed-617770db35e | | 11911051 | pro-tester-1 | 10.10.1.36:41673 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='15868183-7ae3-4cc9-82e8-bfa53d673d6 | | 11911052 | pro-tester-1 | 10.10.1.36:41677 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='102d17b2-5da4-4bbe-b929-a40ea941a18 | | 11911053 | pro-tester-1 | 10.10.1.36:41678 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='3f67e9c4-9a00-470a-a784-0665fa7b8924' limit 1 | | 11911054 | pro-tester-1 | 10.10.1.36:41682 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='399adcca-1ab5-4959-aa49-a96e1bdfc3d | | 11911055 | pro-tester-1 | 10.10.1.36:41687 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='50a68c93-2764-4ea6-b9ba-fb6af881794 | | 11911056 | pro-tester-1 | 10.10.1.36:41689 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='c8e111fd-c73f-4f4e-8e8b-d6f4ebe754e | | 11911057 | pro-tester-1 | 10.10.1.36:41691 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='6c446795-9315-475a-9654-7dddb12d022 | | 11911058 | pro-tester-1 | 10.10.1.36:41694 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='9dae225b-6f41-4bdb-ab7a-58d45bcb25e | | 11911059 | pro-tester-1 | 10.10.1.36:41698 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='38fd099f-7bf3-48ad-bc57-7f818d26b45 | | 11911060 | pro-tester-1 | 10.10.1.36:41701 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='60eb2bae-c45a-495a-a682-fdab1b56739 | | 11911061 | pro-tester-1 | 10.10.1.36:41702 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='3fee03ac-8ed9-4f09-8cfb-3a5189dd561 | | 11911062 | pro-tester-1 | 10.10.1.36:41705 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911063 | pro-tester-1 | 10.10.1.36:41707 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='8a25ea9f-157e-457f-be2f-5b6b1ad3f12 | | 11911064 | pro-tester-1 | 10.10.1.36:41709 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='6a9d1b54-8efd-46c5-a9f5-c8d85975ce4 | | 11911065 | pro-tester-1 | 10.10.1.36:41712 | tester | Query | 7 | Locked | update session set sessionId='ab524ed1-1d20-4ce0-a0c4-51517e4a3a29' , | | 11911066 | pro-tester-1 | 10.10.1.36:41719 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='f40cd095-4df6-4b5b-bc19-ea4bac4ffe2 | | 11911067 | pro-tester-1 | 10.10.1.36:41720 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='51ce3636-37d3-497a-81c1-517e2682613 | | 11911068 | pro-tester-1 | 10.10.1.36:41723 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='324c4322-cad6-4cc4-8ab5-202cc1bd524 | | 11911069 | pro-tester-1 | 10.10.1.36:41729 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='e6954acb-ef2d-459a-a22c-566157fff66 | | 11911070 | pro-tester-1 | 10.10.1.36:41741 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='29fe9fb3-baac-48f1-8f7f-224c3825442 | | 11911071 | pro-tester-1 | 10.10.1.36:41743 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='28fcbd12-8389-4de2-91ab-ec91a47fbe8 | | 11911072 | pro-tester-1 | 10.10.1.36:41746 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='a8e1616d-1d0d-46ea-87a9-8acbf1165c8 | | 11911073 | pro-tester-1 | 10.10.1.36:41750 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911074 | pro-tester-1 | 10.10.1.36:41753 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='a8e5b8a7-e402-4f09-8f72-ce02bd49d33 | | 11911075 | pro-tester-1 | 10.10.1.36:41757 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='f02ca23c-b0cd-4c10-9ab0-ff5d81816b0 | | 11911076 | pro-tester-1 | 10.10.1.36:41761 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='5d889d13-3280-4495-803a-806c04d4e4d | | 11911077 | pro-tester-1 | 10.10.1.36:41763 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='d73aa796-d5e2-4897-bd3c-fbd4e198c7e | | 11911078 | pro-tester-1 | 10.10.1.36:41765 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='e85034c8-6f10-461f-b3e1-fcea93e14b5 | | 11911079 | pro-tester-1 | 10.10.1.36:41768 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='1611c0f8-b65c-44f4-a748-862dd5afd6f | | 11911080 | pro-tester-1 | 10.10.1.36:41772 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='b5745182-9e02-416d-9e08-0fb33a7dd23 | | 11911081 | pro-tester-1 | 10.10.1.36:41774 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='073c3b17-b181-43c0-ad28-1444eaa1ce3 | | 11911082 | pro-tester-1 | 10.10.1.36:41777 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='4369b1ef-e1e1-4eb2-bca3-0ba1b0384ee | | 11911083 | pro-tester-1 | 10.10.1.36:41779 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='67f2a24c-a0e6-42bc-922a-37eac24bb4f | | 11911084 | pro-tester-1 | 10.10.1.36:41784 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='120e6b1f-7c3f-4d9d-9c41-600dca90cfd | | 11911085 | pro-tester-1 | 10.10.1.36:41785 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='553289ef-fb34-4d0e-bc60-35a651af9f3 | | 11911086 | pro-tester-1 | 10.10.1.36:41787 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911087 | pro-tester-1 | 10.10.1.36:41789 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='4d944381-bdd6-4c03-9a48-d84fb88e173 | | 11911088 | pro-tester-1 | 10.10.1.36:41792 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='3440773a-b070-410a-a9fb-93bcf8299cf | | 11911089 | pro-tester-1 | 10.10.1.36:41794 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='e487afb6-3fc8-44ef-b555-7cd948fa138 | | 11911090 | pro-tester-1 | 10.10.1.36:41796 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='fbba2f54-ab82-4866-a416-e89dc621b8c | | 11911091 | pro-tester-1 | 10.10.1.36:41800 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='4c6839f2-3222-4892-856c-f5f702c9974 | | 11911092 | pro-tester-1 | 10.10.1.36:41802 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911093 | pro-tester-1 | 10.10.1.36:41804 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='9dc70e75-fd6f-49b2-9de5-3e0975115ed | | 11911094 | pro-tester-1 | 10.10.1.36:41807 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='9310fc52-1ece-4228-93dc-ecb18ae73ea | | 11911095 | pro-tester-1 | 10.10.1.36:41809 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='4fa5925d-397e-4afc-8cd4-b0dd50514af | | 11911096 | pro-tester-1 | 10.10.1.36:41811 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='761a1b4a-7f73-4eca-9604-af85e1a9082 | | 11911097 | pro-tester-1 | 10.10.1.36:41813 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='29fe5a5c-b333-4b8f-99e2-a6b515859ce | | 11911098 | pro-tester-1 | 10.10.1.36:41817 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911099 | pro-tester-1 | 10.10.1.36:41818 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='6c9a4759-fe3f-42d9-b6f2-e14b691f235 | | 11911100 | pro-tester-1 | 10.10.1.36:41820 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='0716cfe7-da14-476b-8687-2412c555cdb | | 11911101 | pro-tester-1 | 10.10.1.36:41822 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911102 | pro-tester-1 | 10.10.1.36:41825 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='36ca9dff-4bc2-411a-a7d6-5749edfe3d9 | | 11911103 | pro-tester-1 | 10.10.1.36:41827 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911104 | pro-tester-1 | 10.10.1.36:41830 | tester | Query | 7 | Locked | select * from session where status='login' and sessionId='2fc0ff65-95a4-4a55-8d81-a6e1925ada4 | | 11911105 | pro-tester-1 | 10.10.1.36:41854 | tester | Query | 6 | Locked | select * from stream where streamGuid='8b8bd10c-f277-4cc1-95e8-e48fcd774de4' limit 1 | | 11911106 | pro-tester-1 | 10.10.1.36:42076 | tester | Query | 5 | Locked | select * from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911107 | pro-tester-1 | 10.10.1.36:42077 | tester | Query | 5 | Locked | select * from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911108 | pro-tester-1 | 10.10.1.36:42080 | tester | Query | 5 | Locked | select * from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911109 | pro-tester-1 | 10.10.1.36:42098 | tester | Query | 5 | Locked | select * from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911110 | pro-tester-1 | 10.10.1.36:42099 | tester | Query | 5 | Locked | select * from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11911111 | pro-tester-1 | 10.10.1.36:42185 | tester | Query | 5 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911112 | pro-tester-1 | 10.10.1.36:42197 | tester | Query | 5 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911113 | pro-tester-1 | 10.10.1.36:42257 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911114 | pro-tester-1 | 10.10.1.36:42288 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11911115 | pro-tester-1 | 10.10.1.36:42290 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='a1ff0ad3-3b6b-4469-b016-4e19f9debde5' limit 1 | | 11911116 | pro-tester-1 | 10.10.1.36:42297 | tester | Query | 4 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911117 | pro-tester-1 | 10.10.1.36:42313 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11911118 | pro-tester-1 | 10.10.1.36:42324 | tester | Query | 1 | Locked | select * from stream where streamGuid='0b56d6b4-5677-4436-ab20-b920c6626a47' limit 1 | | 11911119 | pro-tester-1 | 10.10.1.36:42332 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11911120 | pro-tester-1 | 10.10.1.36:42341 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='3f67e9c4-9a00-470a-a784-0665fa7b8924' limit 1 | | 11911121 | pro-tester-1 | 10.10.1.36:42349 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911122 | pro-tester-1 | 10.10.1.36:42351 | tester | Query | 4 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911123 | pro-tester-1 | 10.10.1.36:42374 | tester | Query | 4 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911124 | pro-tester-1 | 10.10.1.36:42376 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911125 | pro-tester-1 | 10.10.1.36:42402 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911126 | pro-tester-1 | 10.10.1.36:42409 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911127 | pro-tester-1 | 10.10.1.36:42419 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911128 | pro-tester-1 | 10.10.1.36:42426 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911129 | pro-tester-1 | 10.10.1.36:42462 | tester | Query | 3 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911130 | pro-tester-1 | 10.10.1.36:42477 | tester | Query | 3 | Locked | select * from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11911131 | pro-tester-1 | 10.10.1.36:42687 | tester | Sleep | 0 | | NULL | | 11911132 | pro-tester-1 | 10.10.1.36:42716 | tester | Query | 2 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911134 | pro-tester-1 | 10.10.1.36:42763 | tester | Query | 1 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911135 | pro-tester-1 | 10.10.1.36:42776 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911136 | pro-tester-1 | 10.10.1.36:42797 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11911137 | pro-tester-1 | 10.10.1.36:42800 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='a1ff0ad3-3b6b-4469-b016-4e19f9debde5' limit 1 | | 11911138 | pro-tester-1 | 10.10.1.36:42839 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11911139 | pro-tester-1 | 10.10.1.36:42850 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11911140 | pro-tester-1 | 10.10.1.36:42864 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='3f67e9c4-9a00-470a-a784-0665fa7b8924' limit 1 | | 11911141 | pro-tester-1 | 10.10.1.36:42873 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911142 | pro-tester-1 | 10.10.1.36:42906 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911143 | pro-tester-1 | 10.10.1.36:42951 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911144 | pro-tester-1 | 10.10.1.36:42963 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911145 | pro-tester-1 | 10.10.1.36:42964 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911146 | pro-tester-1 | 10.10.1.36:42967 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911147 | pro-tester-1 | 10.10.1.36:42970 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ 184 rows in set (0.00 sec) mysql> show processlist; +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | 11864350 | tester | 63.221.156.44:35832 | tester | Sleep | 529 | | NULL | | 11864351 | tester | 63.221.156.44:21066 | tester | Sleep | 529 | | NULL | | 11877794 | tester_rep | 10.10.1.76:51067 | NULL | Binlog Dump | 97283 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 11906058 | pro-tester-1 | 10.10.1.36:51933 | tester | Query | 0 | NULL | select update_time updateTime from information_schema.tables where table_schema = 'tester' and tab | | 11906111 | pro-tester-1 | 10.10.1.36:52481 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='0224d56c-9dfb-4e32-8367-21f88d11c71 | | 11906127 | pro-tester-1 | 10.10.1.36:52554 | tester | Query | 10 | Locked | select * from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11906130 | pro-tester-1 | 10.10.1.36:52561 | tester | Query | 10 | Locked | select * from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11906132 | pro-tester-1 | 10.10.1.36:52571 | tester | Query | 8 | Locked | select * from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11907806 | pro-tester-1 | 10.10.1.36:50137 | tester | Sleep | 1 | | NULL | | 11907922 | pro-tester-1 | 10.10.1.36:51448 | tester | Sleep | 0 | | NULL | | 11908016 | pro-tester-1 | 10.10.1.36:52345 | tester | Query | 0 | Locked | select * from stream where streamGuid='5c1fce28-d9ff-4d12-9c63-95605a7c6010' limit 1 | | 11908560 | pro-tester-1 | 10.10.1.36:36784 | tester | Query | 10 | Locked | select * from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11908561 | pro-tester-1 | 10.10.1.36:37045 | tester | Query | 0 | Locked | select * from ast where token='0000000000000000025cc172bc80f4116a69aec54fcadce75d | | 11909176 | pro-tester-1 | 10.10.1.36:52453 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='3157d774-f100-46f6-9620-e100986d8e7 | | 11909178 | pro-tester-1 | 10.10.1.36:52460 | tester | Query | 1 | Locked | select * from session where status='login' and sessionId='fd0fc0b5-a720-435f-89f9-daf9a24aab6 | | 11909182 | pro-tester-1 | 10.10.1.36:52474 | tester | Query | 1 | Locked | select * from session where status='login' and sessionId='db6ccb22-9116-4706-b482-692d41c9e54 | | 11909190 | pro-tester-1 | 10.10.1.36:52501 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='e19d78e1-cac3-413c-aec1-57184dd5ccb | | 11909191 | pro-tester-1 | 10.10.1.36:52503 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='d6aa075e-0828-40dc-96d7-9b423a3416e | | 11909196 | pro-tester-1 | 10.10.1.36:52521 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='58980906-ceb8-4f48-9b0f-f68ddf89b75 | | 11909211 | pro-tester-1 | 10.10.1.36:52567 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='488ec4cd-5aa5-4d95-ae81-cdae0952c05 | | 11909235 | pro-tester-1 | 10.10.1.36:52656 | tester | Query | 1 | Locked | update session set activateTime=utc_timestamp() where sessionId='b8f | | 11909242 | pro-tester-1 | 10.10.1.36:52676 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='7c45ccb9-2668-46d1-80bb-f0aef8f570e | | 11909256 | pro-tester-1 | 10.10.1.36:53017 | tester | Query | 10 | Locked | select * from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11909258 | pro-tester-1 | 10.10.1.36:53023 | tester | Query | 8 | Locked | select * from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11909283 | pro-tester-1 | 10.10.1.36:53663 | tester | Query | 10 | update | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11909322 | pro-tester-1 | 10.10.1.36:54227 | tester | Sleep | 0 | | NULL | | 11909386 | pro-tester-1 | 10.10.1.36:54538 | tester | Sleep | 1 | | NULL | | 11909435 | pro-tester-1 | 10.10.1.36:55399 | tester | Query | 10 | end | update stream set publishStatus='Publishing' ,updat | | 11909438 | pro-tester-1 | 10.10.1.36:55456 | tester | Query | 10 | Locked | select * from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11909458 | pro-tester-1 | 10.10.1.36:56405 | tester | Query | 9 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11909461 | pro-tester-1 | 10.10.1.36:56417 | tester | Sleep | 0 | | NULL | | 11909464 | pro-tester-1 | 10.10.1.36:56420 | tester | Query | 9 | Locked | select * from ast where token='00000000000000000a019b08220974076b6db1419bcc116226 | | 11909465 | pro-tester-1 | 10.10.1.36:56421 | tester | Query | 10 | Locked | select * from stream where streamGuid='aa4e5ce4-28e1-4fe5-b272-0706d52fe6d4' limit 1 | | 11909473 | pro-tester-1 | 10.10.1.36:56471 | tester | Query | 10 | Locked | select * from ast where token='0000000000000000001d4a312a5f84289a795ec9ecb49af86c | | 11909540 | pro-tester-1 | 10.10.1.36:50995 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='032dbe8a-20e1-4ba0-a68e-3a1c959c152 | | 11909552 | pro-tester-1 | 10.10.1.36:53293 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='a9039faa-6996-43bc-ad7d-f3ff5528fd2 | | 11909553 | pro-tester-1 | 10.10.1.36:53294 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='1143abee-2b88-454f-ba65-ba05fb07aa6 | | 11909554 | pro-tester-1 | 10.10.1.36:53299 | tester | Query | 11 | end | update session set activateTime=utc_timestamp() where sessionId='f3b | | 11909556 | pro-tester-1 | 10.10.1.36:53313 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='0bbac530-2dd4-42ed-9036-a44ceb7f231 | | 11909557 | pro-tester-1 | 10.10.1.36:53318 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='3c4b8e99-af96-4564-ace8-979cb5efc3c | | 11909559 | pro-tester-1 | 10.10.1.36:53323 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='e698ac43-e7eb-4d54-8eee-853db82992c | | 11909560 | pro-tester-1 | 10.10.1.36:53325 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='cb882d3f-d0b0-4c1f-af28-529381dd0a9 | | 11909561 | pro-tester-1 | 10.10.1.36:53328 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='55bf1c90-5106-41e4-b0c1-e2c7d88d077 | | 11909663 | pro-tester-1 | 10.10.1.36:60389 | tester | Sleep | 0 | | NULL | | 11909965 | pro-tester-1 | 10.10.1.36:44152 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='bb4ed8d8-a73f-4818-b916-16ad6767f29 | | 11909966 | pro-tester-1 | 10.10.1.36:44158 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='8e766f79-9c2b-4a72-a13f-89d3e9d73e1 | | 11909968 | pro-tester-1 | 10.10.1.36:44162 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='39896fae-9596-4d8a-ba67-b7a91857d21 | | 11909969 | pro-tester-1 | 10.10.1.36:44165 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='6462cf4c-2ef3-4ac8-99de-ffdf5a19fbb | | 11909971 | pro-tester-1 | 10.10.1.36:44177 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='c6d0cb98-1cf6-438f-a46c-9b72d8dad47 | | 11910133 | pro-tester-1 | 10.10.1.36:58304 | tester | Sleep | 5 | | NULL | | 11910376 | pro-tester-1 | 10.10.1.36:51427 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='23909ea9-4789-4a39-b658-00673ed69af | | 11910377 | pro-tester-1 | 10.10.1.36:51432 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='a2f95ad4-1ad9-4ae3-b6d1-79edb7a154f | | 11910378 | pro-tester-1 | 10.10.1.36:51437 | tester | Query | 1 | Locked | select * from session where status='login' and sessionId='9cf42717-dd27-4edc-b536-23a72c8aac5 | | 11910508 | pro-tester-1 | 10.10.1.36:56857 | tester | Query | 10 | Locked | select * from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11910568 | pro-tester-1 | 10.10.1.36:44775 | tester | Sleep | 0 | | NULL | | 11910590 | pro-tester-1 | 10.10.1.36:51753 | tester | Query | 8 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11910674 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 11910690 | pro-tester-1 | 10.10.1.36:49026 | tester | Query | 0 | NULL | select now() | | 11910698 | pro-tester-1 | 10.10.1.36:50471 | tester | Query | 10 | Locked | select * from stream where streamId=6754 limit 1 | | 11910754 | pro-tester-1 | 10.10.1.36:38777 | tester | Query | 10 | Locked | select * from ast where token='00000000000000000a019b08220974076b6db1419bcc116226 | | 11910784 | pro-tester-1 | 10.10.1.36:47063 | tester | Query | 1 | Locked | update session set activateTime=utc_timestamp() where sessionId='791 | | 11910785 | pro-tester-1 | 10.10.1.36:47071 | tester | Query | 1 | Locked | select * from session where status='login' and sessionId='6e7b2002-991a-4f26-b8c7-633bdef7ae2 | | 11910786 | pro-tester-1 | 10.10.1.36:47077 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='29c5fcde-dbe1-435c-b3d5-e5a02ea0995 | | 11910787 | pro-tester-1 | 10.10.1.36:47108 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='cc69ece2-5e60-4611-89a1-94e4aef04bb | | 11910788 | pro-tester-1 | 10.10.1.36:47113 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='b4292caf-a986-45a4-871d-9cbdf3daf34 | | 11910863 | pro-tester-1 | 10.10.1.36:42289 | tester | Sleep | 2 | | NULL | | 11910972 | pro-tester-1 | 10.10.1.36:51936 | tester | Query | 10 | Locked | select * from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11910973 | pro-tester-1 | 10.10.1.36:51942 | tester | Query | 10 | Locked | select * from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11910976 | pro-tester-1 | 10.10.1.36:52262 | tester | Sleep | 1 | | NULL | | 11911031 | pro-tester-1 | 10.10.1.86:41335 | tester | Query | 11 | update | insert into time_stream (streamId, duration, packetId, createTime) values (6000, 0, 0, | | 11911033 | pro-tester-1 | 10.10.1.36:41607 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='2a53aa1f-9a66-4e5f-a3e0-367c34f526d | | 11911034 | pro-tester-1 | 10.10.1.36:41618 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='c0127b0e-1c49-4897-a203-9707401461b | | 11911035 | pro-tester-1 | 10.10.1.36:41619 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='5f62aad2-bf37-46ff-9f22-9aeca493f2a | | 11911036 | pro-tester-1 | 10.10.1.36:41622 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='02709b7f-caa7-4d87-887a-2f76bccefd1 | | 11911037 | pro-tester-1 | 10.10.1.36:41623 | tester | Query | 10 | end | update ast set openTimes = 215545 where token='00000000000000000ed7d53bcf505440 | | 11911038 | pro-tester-1 | 10.10.1.36:41625 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='9429f0a4-41ee-49ff-8483-2901cd75e98 | | 11911039 | pro-tester-1 | 10.10.1.36:41629 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='a5fd003e-94f5-4b5d-8bc8-3609f4fad8b | | 11911040 | pro-tester-1 | 10.10.1.36:41634 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='5517d706-11cf-4708-8c2a-9fe41225c25 | | 11911041 | pro-tester-1 | 10.10.1.36:41637 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='4497d0f8-c6ab-45bc-9c42-d850fdea2e0 | | 11911042 | pro-tester-1 | 10.10.1.36:41639 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='d81b4cb8-699e-495e-9514-919b5baaab5 | | 11911043 | pro-tester-1 | 10.10.1.36:41641 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='beb04536-f090-4bd2-86ea-dd2b8dc2fad | | 11911044 | pro-tester-1 | 10.10.1.36:41646 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='3c01b677-cbe0-4cfc-ab81-56a6f15b108 | | 11911045 | pro-tester-1 | 10.10.1.36:41650 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='028c4f6d-192e-44cd-bd51-76d2f917b29 | | 11911046 | pro-tester-1 | 10.10.1.36:41652 | tester | Query | 0 | Locked | select * from session where status='login' and sessionId='a774f6d7-f267-4e3e-a83e-7393ed17661 | | 11911047 | pro-tester-1 | 10.10.1.36:41660 | tester | Query | 0 | NULL | select * from session where status='login' and sessionId='974ea324-0b8f-4bb3-947a-96b7e05a607 | | 11911048 | pro-tester-1 | 10.10.1.36:41662 | tester | Query | 0 | NULL | select * from session where status='login' and sessionId='95d809bc-1a92-4bdf-ae5f-3ed846c49bb | | 11911049 | pro-tester-1 | 10.10.1.36:41664 | tester | Query | 0 | NULL | select * from session where status='login' and sessionId='4953f1a0-d709-4040-95b2-834d3d6c4a6 | | 11911050 | pro-tester-1 | 10.10.1.36:41667 | tester | Query | 0 | NULL | select now() | | 11911051 | pro-tester-1 | 10.10.1.36:41673 | tester | Query | 0 | NULL | select now() | | 11911052 | pro-tester-1 | 10.10.1.36:41677 | tester | Query | 0 | NULL | select now() | | 11911053 | pro-tester-1 | 10.10.1.36:41678 | tester | Query | 0 | NULL | select now() | | 11911054 | pro-tester-1 | 10.10.1.36:41682 | tester | Query | 0 | NULL | select now() | | 11911055 | pro-tester-1 | 10.10.1.36:41687 | tester | Query | 0 | NULL | select now() | | 11911056 | pro-tester-1 | 10.10.1.36:41689 | tester | Query | 0 | NULL | select now() | | 11911057 | pro-tester-1 | 10.10.1.36:41691 | tester | Query | 0 | NULL | select now() | | 11911058 | pro-tester-1 | 10.10.1.36:41694 | tester | Sleep | 0 | | NULL | | 11911059 | pro-tester-1 | 10.10.1.36:41698 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='38fd099f-7bf3-48ad-bc57-7f818d26b45 | | 11911060 | pro-tester-1 | 10.10.1.36:41701 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='60eb2bae-c45a-495a-a682-fdab1b56739 | | 11911061 | pro-tester-1 | 10.10.1.36:41702 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='3fee03ac-8ed9-4f09-8cfb-3a5189dd561 | | 11911062 | pro-tester-1 | 10.10.1.36:41705 | tester | Query | 10 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911063 | pro-tester-1 | 10.10.1.36:41707 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='8a25ea9f-157e-457f-be2f-5b6b1ad3f12 | | 11911064 | pro-tester-1 | 10.10.1.36:41709 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='6a9d1b54-8efd-46c5-a9f5-c8d85975ce4 | | 11911065 | pro-tester-1 | 10.10.1.36:41712 | tester | Query | 10 | Locked | update session set sessionId='ab524ed1-1d20-4ce0-a0c4-51517e4a3a29' , | | 11911066 | pro-tester-1 | 10.10.1.36:41719 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='f40cd095-4df6-4b5b-bc19-ea4bac4ffe2 | | 11911067 | pro-tester-1 | 10.10.1.36:41720 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='51ce3636-37d3-497a-81c1-517e2682613 | | 11911068 | pro-tester-1 | 10.10.1.36:41723 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='324c4322-cad6-4cc4-8ab5-202cc1bd524 | | 11911069 | pro-tester-1 | 10.10.1.36:41729 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='e6954acb-ef2d-459a-a22c-566157fff66 | | 11911070 | pro-tester-1 | 10.10.1.36:41741 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='29fe9fb3-baac-48f1-8f7f-224c3825442 | | 11911071 | pro-tester-1 | 10.10.1.36:41743 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='28fcbd12-8389-4de2-91ab-ec91a47fbe8 | | 11911072 | pro-tester-1 | 10.10.1.36:41746 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='a8e1616d-1d0d-46ea-87a9-8acbf1165c8 | | 11911073 | pro-tester-1 | 10.10.1.36:41750 | tester | Query | 10 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911074 | pro-tester-1 | 10.10.1.36:41753 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='a8e5b8a7-e402-4f09-8f72-ce02bd49d33 | | 11911075 | pro-tester-1 | 10.10.1.36:41757 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='f02ca23c-b0cd-4c10-9ab0-ff5d81816b0 | | 11911076 | pro-tester-1 | 10.10.1.36:41761 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='5d889d13-3280-4495-803a-806c04d4e4d | | 11911077 | pro-tester-1 | 10.10.1.36:41763 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='d73aa796-d5e2-4897-bd3c-fbd4e198c7e | | 11911078 | pro-tester-1 | 10.10.1.36:41765 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='e85034c8-6f10-461f-b3e1-fcea93e14b5 | | 11911079 | pro-tester-1 | 10.10.1.36:41768 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='1611c0f8-b65c-44f4-a748-862dd5afd6f | | 11911080 | pro-tester-1 | 10.10.1.36:41772 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='b5745182-9e02-416d-9e08-0fb33a7dd23 | | 11911081 | pro-tester-1 | 10.10.1.36:41774 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='073c3b17-b181-43c0-ad28-1444eaa1ce3 | | 11911082 | pro-tester-1 | 10.10.1.36:41777 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='4369b1ef-e1e1-4eb2-bca3-0ba1b0384ee | | 11911083 | pro-tester-1 | 10.10.1.36:41779 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='67f2a24c-a0e6-42bc-922a-37eac24bb4f | | 11911084 | pro-tester-1 | 10.10.1.36:41784 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='120e6b1f-7c3f-4d9d-9c41-600dca90cfd | | 11911085 | pro-tester-1 | 10.10.1.36:41785 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='553289ef-fb34-4d0e-bc60-35a651af9f3 | | 11911086 | pro-tester-1 | 10.10.1.36:41787 | tester | Query | 10 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911087 | pro-tester-1 | 10.10.1.36:41789 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='4d944381-bdd6-4c03-9a48-d84fb88e173 | | 11911088 | pro-tester-1 | 10.10.1.36:41792 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='3440773a-b070-410a-a9fb-93bcf8299cf | | 11911089 | pro-tester-1 | 10.10.1.36:41794 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='e487afb6-3fc8-44ef-b555-7cd948fa138 | | 11911090 | pro-tester-1 | 10.10.1.36:41796 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='fbba2f54-ab82-4866-a416-e89dc621b8c | | 11911091 | pro-tester-1 | 10.10.1.36:41800 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='4c6839f2-3222-4892-856c-f5f702c9974 | | 11911092 | pro-tester-1 | 10.10.1.36:41802 | tester | Query | 10 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911093 | pro-tester-1 | 10.10.1.36:41804 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='9dc70e75-fd6f-49b2-9de5-3e0975115ed | | 11911094 | pro-tester-1 | 10.10.1.36:41807 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='9310fc52-1ece-4228-93dc-ecb18ae73ea | | 11911095 | pro-tester-1 | 10.10.1.36:41809 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='4fa5925d-397e-4afc-8cd4-b0dd50514af | | 11911096 | pro-tester-1 | 10.10.1.36:41811 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='761a1b4a-7f73-4eca-9604-af85e1a9082 | | 11911097 | pro-tester-1 | 10.10.1.36:41813 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='29fe5a5c-b333-4b8f-99e2-a6b515859ce | | 11911098 | pro-tester-1 | 10.10.1.36:41817 | tester | Query | 10 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911099 | pro-tester-1 | 10.10.1.36:41818 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='6c9a4759-fe3f-42d9-b6f2-e14b691f235 | | 11911100 | pro-tester-1 | 10.10.1.36:41820 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='0716cfe7-da14-476b-8687-2412c555cdb | | 11911101 | pro-tester-1 | 10.10.1.36:41822 | tester | Query | 10 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911102 | pro-tester-1 | 10.10.1.36:41825 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='36ca9dff-4bc2-411a-a7d6-5749edfe3d9 | | 11911103 | pro-tester-1 | 10.10.1.36:41827 | tester | Query | 10 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911104 | pro-tester-1 | 10.10.1.36:41830 | tester | Query | 10 | Locked | select * from session where status='login' and sessionId='2fc0ff65-95a4-4a55-8d81-a6e1925ada4 | | 11911105 | pro-tester-1 | 10.10.1.36:41854 | tester | Query | 9 | Locked | select * from stream where streamGuid='8b8bd10c-f277-4cc1-95e8-e48fcd774de4' limit 1 | | 11911106 | pro-tester-1 | 10.10.1.36:42076 | tester | Query | 8 | Locked | select * from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911107 | pro-tester-1 | 10.10.1.36:42077 | tester | Query | 8 | Locked | select * from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911108 | pro-tester-1 | 10.10.1.36:42080 | tester | Query | 8 | Locked | select * from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911109 | pro-tester-1 | 10.10.1.36:42098 | tester | Query | 8 | Locked | select * from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911110 | pro-tester-1 | 10.10.1.36:42099 | tester | Query | 8 | Locked | select * from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11911111 | pro-tester-1 | 10.10.1.36:42185 | tester | Query | 8 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911112 | pro-tester-1 | 10.10.1.36:42197 | tester | Query | 8 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911113 | pro-tester-1 | 10.10.1.36:42257 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911114 | pro-tester-1 | 10.10.1.36:42288 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11911115 | pro-tester-1 | 10.10.1.36:42290 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='a1ff0ad3-3b6b-4469-b016-4e19f9debde5' limit 1 | | 11911116 | pro-tester-1 | 10.10.1.36:42297 | tester | Query | 7 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911117 | pro-tester-1 | 10.10.1.36:42313 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11911118 | pro-tester-1 | 10.10.1.36:42324 | tester | Query | 4 | Locked | select * from stream where streamGuid='0b56d6b4-5677-4436-ab20-b920c6626a47' limit 1 | | 11911119 | pro-tester-1 | 10.10.1.36:42332 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11911120 | pro-tester-1 | 10.10.1.36:42341 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='3f67e9c4-9a00-470a-a784-0665fa7b8924' limit 1 | | 11911121 | pro-tester-1 | 10.10.1.36:42349 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911122 | pro-tester-1 | 10.10.1.36:42351 | tester | Query | 7 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911123 | pro-tester-1 | 10.10.1.36:42374 | tester | Query | 7 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911124 | pro-tester-1 | 10.10.1.36:42376 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911125 | pro-tester-1 | 10.10.1.36:42402 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911126 | pro-tester-1 | 10.10.1.36:42409 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911127 | pro-tester-1 | 10.10.1.36:42419 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911128 | pro-tester-1 | 10.10.1.36:42426 | tester | Query | 7 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911129 | pro-tester-1 | 10.10.1.36:42462 | tester | Query | 6 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911130 | pro-tester-1 | 10.10.1.36:42477 | tester | Query | 6 | Locked | select * from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11911131 | pro-tester-1 | 10.10.1.36:42687 | tester | Sleep | 3 | | NULL | | 11911132 | pro-tester-1 | 10.10.1.36:42716 | tester | Query | 5 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911134 | pro-tester-1 | 10.10.1.36:42763 | tester | Query | 4 | Locked | insert into ast_20110907 (token,streamId,authRight,authIPRange,deviceID,timeout,aut | | 11911135 | pro-tester-1 | 10.10.1.36:42776 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911136 | pro-tester-1 | 10.10.1.36:42797 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11911137 | pro-tester-1 | 10.10.1.36:42800 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='a1ff0ad3-3b6b-4469-b016-4e19f9debde5' limit 1 | | 11911138 | pro-tester-1 | 10.10.1.36:42839 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11911139 | pro-tester-1 | 10.10.1.36:42850 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11911140 | pro-tester-1 | 10.10.1.36:42864 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='3f67e9c4-9a00-470a-a784-0665fa7b8924' limit 1 | | 11911141 | pro-tester-1 | 10.10.1.36:42873 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911142 | pro-tester-1 | 10.10.1.36:42906 | tester | Query | 4 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911143 | pro-tester-1 | 10.10.1.36:42951 | tester | Query | 3 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911144 | pro-tester-1 | 10.10.1.36:42963 | tester | Query | 3 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911145 | pro-tester-1 | 10.10.1.36:42964 | tester | Query | 3 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911146 | pro-tester-1 | 10.10.1.36:42967 | tester | Query | 3 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911147 | pro-tester-1 | 10.10.1.36:42970 | tester | Query | 3 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | | 11911148 | pro-tester-1 | 10.10.1.36:43373 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='d4635842-e68e-4a1f-98d6-6169246eafbd' limit 1 | | 11911149 | pro-tester-1 | 10.10.1.36:43376 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='a1ff0ad3-3b6b-4469-b016-4e19f9debde5' limit 1 | | 11911150 | pro-tester-1 | 10.10.1.36:43386 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='231cb755-c5e5-432e-878f-d46724e41497' limit 1 | | 11911151 | pro-tester-1 | 10.10.1.36:43415 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='cd28ade8-a098-44e7-b3f5-b7d906efd261' limit 1 | | 11911152 | pro-tester-1 | 10.10.1.36:43426 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='8384d31b-deba-4cc1-a510-9bca687ca81d' limit 1 | | 11911154 | pro-tester-1 | 10.10.1.36:43471 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='566930a4-2c42-437c-bea7-40c0f82bfcd4' limit 1 | | 11911167 | pro-tester-1 | 10.10.1.36:43529 | tester | Query | 1 | Locked | select *,now() nowTime from stream where streamGuid='d6801cdd-88c5-4caf-b0ee-223c89e22b1b' limit 1 | | 11911182 | pro-tester-1 | 10.10.1.36:43603 | tester | Query | 0 | Locked | select * from ast where token='000000000000000004a3d9caabc7d4c37a48e89e617d418e2f | | 11911186 | pro-tester-1 | 10.10.1.36:43610 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='b36625ff-3e7f-46d5-b89f-cffca9d595cb' limit 1 | | 11911189 | pro-tester-1 | 10.10.1.36:43625 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='3f67e9c4-9a00-470a-a784-0665fa7b8924' limit 1 | | 11911191 | pro-tester-1 | 10.10.1.36:43635 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='a66814e0-b0e7-45ea-8d1e-71316c1d99bb' limit 1 | | 11911192 | pro-tester-1 | 10.10.1.36:43641 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='0063fcd9-f9f1-41ec-a181-159a061c85a8' limit 1 | | 11911198 | pro-tester-1 | 10.10.1.36:43662 | tester | Query | 0 | Locked | select *,now() nowTime from stream where streamGuid='60a492e4-fcb0-4526-8175-2c71e1353dae' limit 1 | +----------+----------------+---------------------+----------+-------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ 197 rows in set (0.00 sec)