大量AUTO-INC LOCK 导致的DeadLOCK

本文主要是介绍大量AUTO-INC LOCK 导致的DeadLOCK，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

原文链接：http://steven1981.itpub.net/post/7967/494087

官方文档关于AUTO_INC锁说明

今天发现数据库报检查到死锁，而且有大量的回滚。
当时状态见：< show engine innodb status G 结果>

这个库压力比较大，但从STATUS看，都是 lock mode AUTO-INC waiting.
而且从应用开发了解到，都是简单的INSERT和select。没有交叉更新的事务。
如果是等待AUTO-INC锁，也不应该会产生死锁。因为AUTO-INC锁在某一时刻只会被一个事务/INSERT操作占有。INSERT一旦完成就会释放AUTO-INC锁。

那怎么会有死锁呢?

于是上bugs.mysql.com 报了个BUG：http://bugs.mysql.com/bug.php?id=49084

得到回复：
[25 Nov 5:38] Valeriy Kravchuk
Looks like a duplicate of bug #49001. Please, check.

http://bugs.mysql.com/bug.php?id=49084
===============================================
Description:
InnoDB aborts deadlock detection when it finds more than 200 locks in that section of the
lock graph. However, when it does this it records incorrect information in the LATEST
DETECTED DEADLOCK section.

How to repeat:
CREATE TABLE test.t1 (a int) ENGINE=InnoDB;
INSERT INTO test.t1 VALUES (5);
SET GLOBAL max_connections = 500;

for i in {1..200}; do ( yes "UPDATE test.t1 SET a=$i where a=5 ;" | mysql -uroot -h127.0.0.1 -S /tmp/mysql.sock test & ) ; done

In another connection do:

SHOW INNODB STATUSG
SHOW PROCESSLIST;
===============================================

虽然锁的类型不一样，但MYSQL的处理机制是一样的。
只要有超过200个锁的等待，MYSQL会把它当作死锁来处理，然后KILL掉某个进程。

关于AUTO-INC锁：
--------------------
innodb 在MySQL5.0里有时候的行为也是表锁：比如说当表里有一个auto_increment字段的时候，
innodb会在内存里保存一个计数器用来记录auto_increment的值，当插入一个新行数据时，
就会用一个表锁来锁住这个计数器，直到插入结束。
如果一行一行的插入数据则没有什么问题，但是如果大量的并发插入就废了，表锁会引起SQL堵塞，
不但影响效率，而且可能会瞬间达到max_connections而崩溃。

有一个方法就是使用MySQL5.1（推荐5.1.40），在这个版本里，虽然上面的问题仍然存在。
但他出现了一个新的配置选项：innodb_autoinc_lock_mode，它是专门用来在使用auto_increment的情况下调整锁策略的，目前有三种选择：
innodb_autoinc_lock_mode = 0 (“traditional” lock mode)
innodb_autoinc_lock_mode = 1 (“consecutive” lock mode)
innodb_autoinc_lock_mode = 2 (“interleaved” lock mode)
关于这个参数的具体含义见： http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html

---------------------------------------------------------------------------------------

(root@im_newlog4a:)[(none )]> show engine innodb status G
*************************** 1. row ***************************
Status:
=====================================
091124 18:07:27 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 55 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 568544859, signal count 410475613
--Thread 1211971936 has waited at ../include/log0log.ic line 315 for 0.00 seconds the semaphore:
Mutex at 0x2ac9b0b910 created file log0log.c line 744, lock var 1
waiters flag 0
--Thread 1247648096 has waited at ../include/log0log.ic line 315 for 0.00 seconds the semaphore:
Mutex at 0x2ac9b0b910 created file log0log.c line 744, lock var 1
waiters flag 0
Mutex spin waits 0, rounds 35626241599, OS waits 371074456
RW-shared spins 180954456, OS waits 88191643; RW-excl spins 91992164, OS waits 71197598
------------------------
LATEST DETECTED DEADLOCK
------------------------
091124 18:04:58
*** (1) TRANSACTION:
TRANSACTION 2 1757811763, ACTIVE 1 sec, process no 2289, OS thread id 1169373536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 368
MySQL thread id 1074298, query id 10176734566 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:41:33','cnalichnshowcorp','-1958381443','6.16.04','0')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811763 lock mode AUTO-INC waiting

*** (2) TRANSACTION:
TRANSACTION 2 1757809862, ACTIVE 13 sec, process no 2289, OS thread id 1273739616 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1071849, query id 10176734567 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 16:10:22','cntaobaosgf130','-212660782','6.16.04','0')
*** (2) HOLDS THE LOCK(S):
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757809862 lock mode AUTO-INC
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811877 lock mode AUTO-INC waiting
TOO DEEP OR LONG SEARCH IN THE LOCK TABLE WAITS-FOR GRAPH
*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 2 1757836657
Purge done for trx's n:o < 2 1750646447 undo n:o < 0 0
History list length 7
Total number of lock structs in row lock hash table 0
... truncated...
process no 2289, OS thread id 1186679136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074214, query id 10176886677 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cntaobao????????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835228 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835217, ACTIVE 6 sec, process no 2289, OS thread id 1244186976 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074334, query id 10176886545 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:21','cntaobao????jj','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835217 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835117, ACTIVE 7 sec, process no 2289, OS thread id 1176295776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074412, query id 10176885581 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cnalichnshzhongxin888','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835117 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835047, ACTIVE 7 sec, process no 2289, OS thread id 1171237216 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074246, query id 10176884932 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cntaobaotaylor1971','-956313635','1.00.00IMWEB_TB','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835047 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757835042, ACTIVE 7 sec, process no 2289, OS thread id 1214368096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074305, query id 10176884888 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:20','cntaobaodatoubao1985','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757835042 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834979, ACTIVE 7 sec, process no 2289, OS thread id 1196796256 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 2
MySQL thread id 1074253, query id 10176883881 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:19','cntaobao????????1','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834979 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834889, ACTIVE 8 sec, process no 2289, OS thread id 1276135776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074344, query id 10176888615 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobao?3????','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834889 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834850, ACTIVE 8 sec, process no 2289, OS thread id 1268414816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074254, query id 10176888485 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:19','cntaobao????????','613460700','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834850 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834819, ACTIVE 8 sec, process no 2289, OS thread id 1275070816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074417, query id 10176887838 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:19','cntaobaoroselight','-1829982403','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834819 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834761, ACTIVE 8 sec, process no 2289, OS thread id 1218095456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1071978, query id 10176887394 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:53','cntaobaomenqy','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834761 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834715, ACTIVE 8 sec, process no 2289, OS thread id 1184815456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074216, query id 10176886842 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobaofencysun','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834715 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834650, ACTIVE 9 sec, process no 2289, OS thread id 1291045216 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074333, query id 10176886458 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834650 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834636, ACTIVE 9 sec, process no 2289, OS thread id 1221024096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074355, query id 10176886082 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobao0o????o0','1329517130','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834636 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834571, ACTIVE 9 sec, process no 2289, OS thread id 1163250016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074251, query id 10176885595 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cnalichnzslabb','-650218883','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834571 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834529, ACTIVE 9 sec, process no 2289, OS thread id 1287317856 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074231, query id 10176885508 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:18','cntaobaolaokai0954','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834529 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834525, ACTIVE 9 sec, process no 2289, OS thread id 1197062496 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074268, query id 10176885490 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cntaobaoyuelinxiyin','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834525 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834486, ACTIVE 9 sec, process no 2289, OS thread id 1207179616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1071938, query id 10176885270 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:31','cntaobaolove_????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834486 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834479, ACTIVE 10 sec, process no 2289, OS thread id 1233271136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074392, query id 10176885120 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cnalichnyp5188','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834479 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834457, ACTIVE 10 sec, process no 2289, OS thread id 1289980256 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074244, query id 10176884998 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','cntaobaozhouzhan_009','-267734306','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834457 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834387, ACTIVE 10 sec, process no 2289, OS thread id 1256167776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074224, query id 10176884323 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cnalichnjury627','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834387 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834372, ACTIVE 10 sec, process no 2289, OS thread id 1191737696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 3
MySQL thread id 1074261, query id 10176884142 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cntaobaozhyh0517','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834372 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834335, ACTIVE 10 sec, process no 2289, OS thread id 1166444896 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074388, query id 10176883681 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cntaobaorenxidong','0','','1')
---TRANSACTION 2 1757834327, ACTIVE 10 sec, process no 2289, OS thread id 1258830176 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071974, query id 10176888983 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:01','cntaobao??????','744614779','6.16.20','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834327 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834295, ACTIVE 10 sec, process no 2289, OS thread id 1254037856 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074219, query id 10176888857 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:17','enaliintwzbest','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834295 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834227, ACTIVE 10 sec, process no 2289, OS thread id 1269746016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071975, query id 10176888551 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:39','cnalichnlijun85418','-939162917','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834227 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834224, ACTIVE 10 sec, process no 2289, OS thread id 1182951776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074320, query id 10176888474 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:16','cntaobaogracesubi','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834224 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757834042, ACTIVE 11 sec, process no 2289, OS thread id 1198127456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071930, query id 10176886257 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:25','cntaobaosunnyjj2003','1307566964','1.00.00IMWEB_TB','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757834042 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833897, ACTIVE 12 sec, process no 2289, OS thread id 1280928096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071960, query id 10176885137 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:59:11','cntaobao????????2008','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833897 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833870, ACTIVE 12 sec, process no 2289, OS thread id 1182153056 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074270, query id 10176884804 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:14','cntaobao????cisy','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833870 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833796, ACTIVE 12 sec, process no 2289, OS thread id 1206380896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1071958, query id 10176884171 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:58:56','cntaobao????_2005','-1705637155','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833796 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833795, ACTIVE 12 sec, process no 2289, OS thread id 1167243616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 4
MySQL thread id 1074225, query id 10176884090 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:14','cntaobaomanymary','-111284614','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833795 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833753, ACTIVE 12 sec, process no 2289, OS thread id 1282259296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074341, query id 10176889058 172.18.57.110 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:14','cnalichncenxelectang','-1911086471','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833753 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833735, ACTIVE 12 sec, process no 2289, OS thread id 1205582176 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074259, query id 10176888881 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:13','cnalichncdhfjjc','-586780042','6.10.30','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833735 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833647, ACTIVE 13 sec, process no 2289, OS thread id 1212770656 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074241, query id 10176888559 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:13','cntaobaoyuki197388','34834549','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833647 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757833185, ACTIVE 15 sec, process no 2289, OS thread id 1164048736 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 5
MySQL thread id 1074394, query id 10176884347 172.18.8.220 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:12','cntaobao????','753955965','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757833185 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832975, ACTIVE 16 sec, process no 2289, OS thread id 1250842976 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 6
MySQL thread id 1074250, query id 10176887178 172.18.8.158 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 18:07:10','cntaobaohuiyuan?????','-1448426275','6.16.20','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832975 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832590, ACTIVE 18 sec, process no 2289, OS thread id 1286252896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 7
MySQL thread id 1074032, query id 10176888702 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:45:46','cntaobaomwx????','-1890845322','6.10.30','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832590 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832536, ACTIVE 18 sec, process no 2289, OS thread id 1277999456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 7
MySQL thread id 1071977, query id 10176888123 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:48','cntaobao???????2008','446636665','6.10.36','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832536 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757832321, ACTIVE 19 sec, process no 2289, OS thread id 1272408416 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 7
MySQL thread id 1074281, query id 10176885418 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:21','cntaobaosongyao77','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757832321 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831621, ACTIVE 22 sec, process no 2289, OS thread id 1181886816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 9
MySQL thread id 1074291, query id 10176888415 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:46:25','cntaobaojqiy9oxl','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831621 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831549, ACTIVE 22 sec, process no 2289, OS thread id 1235933536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 9
MySQL thread id 1071942, query id 10176886762 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:58:08','cntaobao????','-273410444','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831549 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831428, ACTIVE 22 sec, process no 2289, OS thread id 1264687456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 9
MySQL thread id 1074294, query id 10176884436 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:50:08','cntaobaoc68331','-2055936547','6.16.05','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831428 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831046, ACTIVE 24 sec, process no 2289, OS thread id 1227680096 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 10
MySQL thread id 1074292, query id 10176885535 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:53:05','cntaobaotiantian176896513','675419196','6.16.05','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831046 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757831036, ACTIVE 24 sec, process no 2289, OS thread id 1181354336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 10
MySQL thread id 1074289, query id 10176885482 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:14','cntaobao????99','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757831036 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830982, ACTIVE 25 sec, process no 2289, OS thread id 1170438496 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 10
MySQL thread id 1071952, query id 10176884416 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:54','cnalichnluaidong888','967320957','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830982 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830715, ACTIVE 26 sec, process no 2289, OS thread id 1162185056 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1216, undo log entries 11
MySQL thread id 1071961, query id 10176885915 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:46','cntaobaoilovexk11','383272829','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830715 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830483, ACTIVE 27 sec, process no 2289, OS thread id 1237530976 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 12
MySQL thread id 1074300, query id 10176887664 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:00','cntaobaofangshengwen','-415282470','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830483 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830220, ACTIVE 28 sec, process no 2289, OS thread id 1274804576 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1071950, query id 10176888733 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:40','cntaobaochenfeiangle','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830220 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830145, ACTIVE 28 sec, process no 2289, OS thread id 1189341536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1074299, query id 10176886906 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:48','cntaobao???rose','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830145 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757830022, ACTIVE 29 sec, process no 2289, OS thread id 1273207136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 13
MySQL thread id 1071946, query id 10176885388 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:33','cntaobao?????????','-1855880836','6.10.01','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757830022 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757829820, ACTIVE 30 sec, process no 2289, OS thread id 1243122016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 14
MySQL thread id 1071971, query id 10176887970 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:27','cntaobao????????????','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757829820 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757829740, ACTIVE 30 sec, process no 2289, OS thread id 1234602336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 14
MySQL thread id 1074287, query id 10176887033 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:08','cntaobaocatchan','-972288135','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757829740 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757829276, ACTIVE 32 sec, process no 2289, OS thread id 1219692896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 15
MySQL thread id 1071934, query id 10176885823 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:20','cntaobaoyanling1980','343956338','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757829276 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828890, ACTIVE 34 sec, process no 2289, OS thread id 1206114656 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 16
MySQL thread id 1071976, query id 10176886822 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:14','cntaobaozcmlp320425','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828890 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828475, ACTIVE 36 sec, process no 2289, OS thread id 1261226336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 17
MySQL thread id 1071927, query id 10176887045 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:07','cntaobao??????????','-217026186','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828475 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828367, ACTIVE 36 sec, process no 2289, OS thread id 1223154016 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 17
MySQL thread id 1071973, query id 10176885066 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:57:01','cntaobao?????520','45857597','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828367 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757828259, ACTIVE 37 sec, process no 2289, OS thread id 1187211616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 18
MySQL thread id 1074099, query id 10176888646 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:53:32','cntaobaoningqinl','-455241411','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757828259 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757827272, ACTIVE 42 sec, process no 2289, OS thread id 1188542816 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 21
MySQL thread id 1071936, query id 10176888935 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:54','cntaobaomc????','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757827272 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757827197, ACTIVE 42 sec, process no 2289, OS thread id 1225017696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 21
MySQL thread id 1071939, query id 10176888405 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:47','cntaobaosarabowa2918','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757827197 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757826835, ACTIVE 44 sec, process no 2289, OS thread id 1248979296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 22
MySQL thread id 1071944, query id 10176888573 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:15','cntaobao??????0204','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757826835 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757826259, ACTIVE 47 sec, process no 2289, OS thread id 1172035936 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 23
MySQL thread id 1071981, query id 10176885013 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:08','cntaobao??????','-442508579','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757826259 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757825938, ACTIVE 49 sec, process no 2289, OS thread id 1239394656 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 24
MySQL thread id 1071926, query id 10176885835 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:56:00','cntaobao???????','-1540062597','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757825938 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757825933, ACTIVE 49 sec, process no 2289, OS thread id 1191471456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 24
MySQL thread id 1074290, query id 10176885607 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:29','cntaobaoshenchunling1','-412189059','6.10.08','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757825933 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757825031, ACTIVE 53 sec, process no 2289, OS thread id 1266817376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 27
MySQL thread id 1073729, query id 10176888688 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:42','cntaobao???????2008','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757825031 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824799, ACTIVE 54 sec, process no 2289, OS thread id 1171769696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 28
MySQL thread id 1071943, query id 10176888995 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:49','cntaobaotl19860311','1764006011','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824799 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824780, ACTIVE 55 sec, process no 2289, OS thread id 1208777056 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 28
MySQL thread id 1071945, query id 10176888867 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:42','cntaobao?????????','1527457149','6.10.08','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824780 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824664, ACTIVE 55 sec, process no 2289, OS thread id 1284655456 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 28
MySQL thread id 1073752, query id 10176886988 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:35','cnalichntiancifu88888','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824664 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757824063, ACTIVE 59 sec, process no 2289, OS thread id 1172568416 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 30
MySQL thread id 1074272, query id 10176887292 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:09','cntaobao??????','600904410','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757824063 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757823856, ACTIVE 60 sec, process no 2289, OS thread id 1185081696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 31
MySQL thread id 1071947, query id 10176888876 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:35','cntaobaoxuguoqiang1971','-1358609283','6.16.20','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757823856 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757823078, ACTIVE 64 sec, process no 2289, OS thread id 1275603296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 3024, undo log entries 33
MySQL thread id 1071937, query id 10176885356 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:24','cntaobaojaniceguo','193122172','6.10.30','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757823078 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757822575, ACTIVE 67 sec, process no 2289, OS thread id 1190406496 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 35
MySQL thread id 1074297, query id 10176885408 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:48:16','cntaobaosleepapple','-1475923909','6.05.11','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757822575 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757822498, ACTIVE 68 sec, process no 2289, OS thread id 1273473376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 35
MySQL thread id 1071948, query id 10176883717 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:16','cnalichnwokun1973','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757822498 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757821868, ACTIVE 72 sec, process no 2289, OS thread id 1239660896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 38
MySQL thread id 1071928, query id 10176885520 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:55:09','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757821868 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757821588, ACTIVE 74 sec, process no 2289, OS thread id 1234868576 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 39
MySQL thread id 1071963, query id 10176885083 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:57','cntaobao????????','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757821588 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757821346, ACTIVE 75 sec, process no 2289, OS thread id 1284389216 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 40
MySQL thread id 1074279, query id 10176884682 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:50:34','cntaobaozlnczg','-482971532','1.00.00IMWEB_TB','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757821346 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820983, ACTIVE 77 sec, process no 2289, OS thread id 1214634336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 42
MySQL thread id 1073462, query id 10176887630 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:44:16','cntaobao???_78','1210026101','6.10.08','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820983 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820473, ACTIVE 80 sec, process no 2289, OS thread id 1280129376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 44
MySQL thread id 1071951, query id 10176887811 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:41','cntaobaobj100600','0','','1')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820473 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820386, ACTIVE 81 sec, process no 2289, OS thread id 1186412896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 44
MySQL thread id 1074296, query id 10176885646 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:35','cntaobaointex???????','-359772803','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820386 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820095, ACTIVE 82 sec, process no 2289, OS thread id 1269479776 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 45
MySQL thread id 1071984, query id 10176886570 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:35','cntaobao????????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820095 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757820065, ACTIVE 83 sec, process no 2289, OS thread id 1278265696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 45
MySQL thread id 1071957, query id 10176885804 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:29','cntaobaolele8829','-1012372361','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757820065 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757816626, ACTIVE 109 sec, process no 2289, OS thread id 1288116576 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 60
MySQL thread id 1074030, query id 10176885945 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:49:53','cntaobaoy00050488','244902109','6.16.05','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757816626 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757814414, ACTIVE 128 sec, process no 2289, OS thread id 1199724896 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 6752, undo log entries 70
MySQL thread id 1071972, query id 10176885629 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:54:23','cntaobaohdjd1','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757814414 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811914, ACTIVE 149 sec, process no 2289, OS thread id 1218627936 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 90
MySQL thread id 1074363, query id 10176884564 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:46:12','cntaobaokaxi88','0','','1')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811914 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811913, ACTIVE 149 sec, process no 2289, OS thread id 1262557536 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 90
MySQL thread id 1074293, query id 10176884186 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:06','cntaobaorobert588','-192688263','6.10.30','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811913 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811912, ACTIVE 149 sec, process no 2289, OS thread id 1286785376 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 90
MySQL thread id 1074282, query id 10176883850 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:46:18','cntaobaoswpccy','-1763694467','6.16.04','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811912 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811896, ACTIVE 149 sec, process no 2289, OS thread id 1262291296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074288, query id 10176887281 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:45:45','cntaobaoeyesneverdie','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811896 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811893, ACTIVE 149 sec, process no 2289, OS thread id 1220757856 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074284, query id 10176887222 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:51:22','cntaobaoyiwunews','-1968783812','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811893 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811892, ACTIVE 149 sec, process no 2289, OS thread id 1241258336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074362, query id 10176887191 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:53:24','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811892 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811891, ACTIVE 149 sec, process no 2289, OS thread id 1190672736 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074276, query id 10176887266 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:32','cntaobaojxhzzcat','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811891 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811887, ACTIVE 149 sec, process no 2289, OS thread id 1168042336 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074285, query id 10176886054 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:42:32','cntaobaoyanfu2004','575292797','6.16.04','0')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811887 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811883, ACTIVE 149 sec, process no 2289, OS thread id 1291577696 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1074278, query id 10176885545 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:51:01','cntaobao??????15','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811883 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811876, ACTIVE 149 sec, process no 2289, OS thread id 1239927136 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 91
MySQL thread id 1071967, query id 10176884708 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:47:45','cntaobaocggyfjtg','382157790','6.10.11','0')
------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811876 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811821, ACTIVE 149 sec, process no 2289, OS thread id 1291843936 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 92
MySQL thread id 1074286, query id 10176888660 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:43:59','cntaobao????????','-2076636195','6.16.04','0')
------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811821 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811801, ACTIVE 150 sec, process no 2289, OS thread id 1169107296 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 92
MySQL thread id 1074274, query id 10176887057 172.18.8.219 aliim update
insert into im_user_sys_200911(TIME,LOGIN_ID,IP,CLIENT_VERSION,ACTION_TYPE) values('2009-11-24 15:51:43','cntaobao??????','0','','1')
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `ctulog/im_user_sys_200911` trx id 2 1757811801 lock mode AUTO-INC waiting
------------------
---TRANSACTION 2 1757811796, ACTIVE 150 sec, process no 2289, OS thread id 1253771616 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 14320, undo log entries 92
MySQL thread id 1074283, query id 10176886975 172.18.