Why table locked on delete?
---TRANSACTION 0 476648265, ACTIVE 530 sec, process no 13965, OS thread id
3152999360 updating or deleting, thread declared inside InnoDB 293
mysql tables in use 1,* locked 1*
11090 lock struct(s), heap size 634176, undo log entries 930711
MySQL thread id 16831, query id 11504020 localhost 127.0.0.1 root updating
delete from t_outgoing_sms_3t where month(out_sms_time)=1
mysql> insert into t_outgoing_sms_3t (out_sms_dest) values ('1');
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
------------
TRANSACTIONS
------------
Trx id counter 0 476676328
Purge done for trx's n:o < 0 476646787 undo n:o < 0 607975
History list length 7751
Total number of lock structs in row lock hash table 11089
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 476675339, not started, process no 13965, OS thread id
3092185536
MySQL thread id 17088, query id 11546298 10.1.30.70 webreport
---TRANSACTION 0 476675015, not started, process no 13965, OS thread id
3152409920
MySQL thread id 17087, query id 11545451 10.1.30.70 webreport
---TRANSACTION 0 476674717, not started, process no 13965, OS thread id
3160996544
MySQL thread id 17086, query id 11544918 10.1.30.70 webreport
---TRANSACTION 0 476673989, not started, process no 13965, OS thread id
3154309952
MySQL thread id 17085, query id 11543085 10.1.30.70 root
---TRANSACTION 0 476673192, not started, process no 13965, OS thread id
3012753088
MySQL thread id 13733, query id 11548354 10.1.20.10 root
---TRANSACTION 0 476673831, not started, process no 13965, OS thread id
3133078080
MySQL thread id 17083, query id 11542807 10.1.30.70 root
---TRANSACTION 0 476673945, not started, process no 13965, OS thread id
3089042752
MySQL thread id 17082, query id 11542976 10.1.30.70 root
---TRANSACTION 0 476673971, not started, process no 13965, OS thread id
3136485184
MySQL thread id 17081, query id 11548513 10.1.30.70 root
SHOW INNODB STATUS
---TRANSACTION 0 476673972, not started, process no 13965, OS thread id
3140678208
MySQL thread id 17080, query id 11543043 10.1.30.70 root
---TRANSACTION 0 476673981, not started, process no 13965, OS thread id
3031627200
MySQL thread id 17079, query id 11543057 10.1.30.70 root
---TRANSACTION 0 476672586, not started, process no 13965, OS thread id
3057712064
MySQL thread id 16348, query id 11548353 10.1.20.10 root
---TRANSACTION 0 476674015, not started, process no 13965, OS thread id
3146971840
MySQL thread id 17078, query id 11543259 10.1.30.70 root
---TRANSACTION 0 476675361, not started, process no 13965, OS thread id
3099786432
MySQL thread id 17073, query id 11546342 10.1.30.70 webreport
---TRANSACTION 0 476653631, not started, process no 13965, OS thread id
3020028480
MySQL thread id 17070, query id 11516390 10.1.30.70 webreport
---TRANSACTION 0 476673992, not started, process no 13965, OS thread id
3061118272
MySQL thread id 17068, query id 11543095 10.1.30.70 webreport
---TRANSACTION 0 476652727, not started, process no 13965, OS thread id
3061622976
MySQL thread id 17067, query id 11514351 10.1.30.70 webreport
---TRANSACTION 0 476652317, not started, process no 13965, OS thread id
3007901760
MySQL thread id 17066, query id 11513390 10.1.30.70 webreport
---TRANSACTION 0 476671899, not started, process no 13965, OS thread id
3130388032
MySQL thread id 17064, query id 11538944 10.1.30.70 webreport
---TRANSACTION 0 476674311, not started, process no 13965, OS thread id
3004560192
MySQL thread id 17063, query id 11543856 10.1.30.70 webreport
---TRANSACTION 0 476675025, not started, process no 13965, OS thread id
3034377920
MySQL thread id 17061, query id 11545472 10.1.30.70 root
---TRANSACTION 0 476674006, not started, process no 13965, OS thread id
3145268288
MySQL thread id 17060, query id 11543220 10.1.30.70 root
---TRANSACTION 0 476672791, not started, process no 13965, OS thread id
3144875328
MySQL thread id 17058, query id 11540631 10.1.30.70 root
---TRANSACTION 0 476673967, not started, process no 13965, OS thread id
3091792576
MySQL thread id 17057, query id 11543035 10.1.30.70 root
---TRANSACTION 0 476673955, not started, process no 13965, OS thread id
3086768320
MySQL thread id 17056, query id 11543015 10.1.30.70 root
---TRANSACTION 0 476674014, not started, process no 13965, OS thread id
3121804736
MySQL thread id 17055, query id 11543248 10.1.30.70 root
---TRANSACTION 0 476674009, not started, process no 13965, OS thread id
3060135872
MySQL thread id 17054, query id 11543241 10.1.30.70 root
---TRANSACTION 0 476673982, not started, process no 13965, OS thread id
3091989056
MySQL thread id 17053, query id 11543061 10.1.30.70 root
---TRANSACTION 0 476673912, not started, process no 13965, OS thread id
3088842176
MySQL thread id 17052, query id 11542915 10.1.30.70 root
---TRANSACTION 0 476645131, not started, process no 13965, OS thread id
3088449344
MySQL thread id 15781, query id 11548352 10.1.20.10 root
---TRANSACTION 0 476673975, not started, process no 13965, OS thread id
3149854272
MySQL thread id 17041, query id 11543049 10.1.30.70 root
---TRANSACTION 0 476655843, not started, process no 13965, OS thread id
3158699456
MySQL thread id 17033, query id 11521706 10.1.30.70 webreport
---TRANSACTION 0 476674375, not started, process no 13965, OS thread id
3000170688
MySQL thread id 17030, query id 11544007 localhost 127.0.0.1 root
---TRANSACTION 0 476654537, not started, process no 13965, OS thread id
3138974528
MySQL thread id 17031, query id 11518555 10.1.30.70 webreport
---TRANSACTION 0 476656342, not started, process no 13965, OS thread id
3081958848
MySQL thread id 17028, query id 11522839 10.1.30.70 webreport
---TRANSACTION 0 476675199, not started, process no 13965, OS thread id
3152213440
MySQL thread id 17024, query id 11545917 10.1.30.70 root
---TRANSACTION 0 476676015, not started, process no 13965, OS thread id
3154702912
MySQL thread id 17022, query id 11547738 10.1.30.70 webreport
---TRANSACTION 0 476673861, not started, process no 13965, OS thread id
3143364160
MySQL thread id 17020, query id 11542861 10.1.30.70 root
---TRANSACTION 0 476646292, not started, process no 13965, OS thread id
3154899392
MySQL thread id 17012, query id 11499168 10.1.30.70 webreport
---TRANSACTION 0 476672954, not started, process no 13965, OS thread id
3021403840
MySQL thread id 17010, query id 11540947 10.1.30.70 webreport
---TRANSACTION 0 476673921, not started, process no 13965, OS thread id
3088252864
MySQL thread id 17006, query id 11542930 10.1.30.70 root
---TRANSACTION 0 476673993, not started, process no 13965, OS thread id
3022189760
MySQL thread id 17005, query id 11543100 10.1.30.70 root
---TRANSACTION 0 476673786, not started, process no 13965, OS thread id
2984442432
MySQL thread id 17004, query id 11542736 10.1.30.70 root
---TRANSACTION 0 476673969, not started, process no 13965, OS thread id
3065378752
MySQL thread id 16996, query id 11543038 10.1.30.70 root
---TRANSACTION 0 476649065, not started, process no 13965, OS thread id
3142774720
MySQL thread id 16994, query id 11505695 10.1.30.70 webreport
---TRANSACTION 0 476675128, not started, process no 13965, OS thread id
3032806080
MySQL thread id 16355, query id 11548351 10.1.20.10 root
---TRANSACTION 0 476673998, not started, process no 13965, OS thread id
3073006784
MySQL thread id 16990, query id 11543109 10.1.30.70 root
---TRANSACTION 0 476486522, not started, process no 13965, OS thread id
3075865152
MySQL thread id 15482, query id 11548349 10.1.20.10 root
---TRANSACTION 0 476476137, not started, process no 13965, OS thread id
3020617920
MySQL thread id 16326, query id 11548348 10.1.20.10 root
---TRANSACTION 0 476281141, not started, process no 13965, OS thread id
3063869888
MySQL thread id 13721, query id 11548346 10.1.20.10 root
---TRANSACTION 0 476478330, not started, process no 13965, OS thread id
3072719808
MySQL thread id 16298, query id 11548347 10.1.20.10 root
---TRANSACTION 0 476675236, not started, process no 13965, OS thread id
3128880960
MySQL thread id 16604, query id 11546105 10.1.20.10 root
---TRANSACTION 0 476651725, not started, process no 13965, OS thread id
3112852672
MySQL thread id 16577, query id 11547752 10.1.20.10 root
---TRANSACTION 0 476675043, not started, process no 13965, OS thread id
3116956096
MySQL thread id 16583, query id 11545520 10.1.20.10 root
---TRANSACTION 0 476675451, not started, process no 13965, OS thread id
3123378112
MySQL thread id 16587, query id 11546495 10.1.20.10 root
---TRANSACTION 0 476674389, not started, process no 13965, OS thread id
3014492864
MySQL thread id 16552, query id 11544049 10.1.20.10 root
---TRANSACTION 0 476655976, not started, process no 13965, OS thread id
3123574592
MySQL thread id 16588, query id 11544023 10.1.20.10 root
---TRANSACTION 0 476655740, not started, process no 13965, OS thread id
3112368960
MySQL thread id 16580, query id 11543922 10.1.20.10 root
---TRANSACTION 0 476675476, not started, process no 13965, OS thread id
3128291520
MySQL thread id 16601, query id 11546549 10.1.20.10 root
---TRANSACTION 0 476675311, not started, process no 13965, OS thread id
3126587968
MySQL thread id 16598, query id 11546262 10.1.20.10 root
---TRANSACTION 0 476672118, not started, process no 13965, OS thread id
3126391488
MySQL thread id 16597, query id 11544265 10.1.20.10 root
---TRANSACTION 0 476649572, not started, process no 13965, OS thread id
3126195008
MySQL thread id 16596, query id 11546349 10.1.20.10 root
---TRANSACTION 0 476675958, not started, process no 13965, OS thread id
3124753472
MySQL thread id 16594, query id 11547664 10.1.20.10 root
---TRANSACTION 0 476641184, not started, process no 13965, OS thread id
3042176448
MySQL thread id 16546, query id 11546443 10.1.20.10 root
---TRANSACTION 0 476673764, not started, process no 13965, OS thread id
3112565440
MySQL thread id 16581, query id 11548473 10.1.20.10 root
---TRANSACTION 0 476655775, not started, process no 13965, OS thread id
3117349056
MySQL thread id 16585, query id 11543952 10.1.20.10 root
---TRANSACTION 0 476674321, not started, process no 13965, OS thread id
3117152576
MySQL thread id 16584, query id 11543885 10.1.20.10 root
---TRANSACTION 0 476674371, not started, process no 13965, OS thread id
3116759616
MySQL thread id 16582, query id 11543987 10.1.20.10 root
---TRANSACTION 0 476675463, not started, process no 13965, OS thread id
3123771072
MySQL thread id 16589, query id 11546519 10.1.20.10 root
---TRANSACTION 0 476674179, not started, process no 13965, OS thread id
2978541632
MySQL thread id 16567, query id 11543658 10.1.20.10 root
---TRANSACTION 0 476653256, not started, process no 13965, OS thread id
3094540224
MySQL thread id 16570, query id 11542811 10.1.20.10 root
---TRANSACTION 0 476654068, not started, process no 13965, OS thread id
3048730560
MySQL thread id 16562, query id 11542991 10.1.20.10 root
---TRANSACTION 0 476672933, not started, process no 13965, OS thread id
3056531776
MySQL thread id 16540, query id 11546179 10.1.20.10 root
---TRANSACTION 0 476675254, not started, process no 13965, OS thread id
3085300416
MySQL thread id 16539, query id 11546132 10.1.20.10 root
---TRANSACTION 0 476656085, not started, process no 13965, OS thread id
3033788480
MySQL thread id 16541, query id 11544166 10.1.20.10 root
---TRANSACTION 0 476674017, not started, process no 13965, OS thread id
3056332608
MySQL thread id 16544, query id 11543263 10.1.20.10 root
---TRANSACTION 0 476037873, not started, process no 13965, OS thread id
3015475264
MySQL thread id 13719, query id 11548342 10.1.20.10 root
---TRANSACTION 0 476675034, not started, process no 13965, OS thread id
3116563392
MySQL thread id 16579, query id 11545497 10.1.20.10 root
---TRANSACTION 0 476652171, not started, process no 13965, OS thread id
3095129664
MySQL thread id 16573, query id 11547450 10.1.20.10 root
---TRANSACTION 0 476675897, not started, process no 13965, OS thread id
3094933184
MySQL thread id 16572, query id 11547528 10.1.20.10 root
---TRANSACTION 0 476648729, not started, process no 13965, OS thread id
3094736704
MySQL thread id 16571, query id 11545722 10.1.20.10 root
---TRANSACTION 0 476647472, not started, process no 13965, OS thread id
3071212864
MySQL thread id 16564, query id 11544938 10.1.20.10 root
---TRANSACTION 0 476676205, not started, process no 13965, OS thread id
3010391744
MySQL thread id 16559, query id 11548076 10.1.20.10 root
---TRANSACTION 0 476654296, not started, process no 13965, OS thread id
3052599488
MySQL thread id 16550, query id 11543313 10.1.20.10 root
---TRANSACTION 0 476653182, not started, process no 13965, OS thread id
3042966464
MySQL thread id 16547, query id 11548360 10.1.20.10 root
---TRANSACTION 0 476672563, not started, process no 13965, OS thread id
3034577600
MySQL thread id 16538, query id 11545423 10.1.20.10 root
---TRANSACTION 0 476655855, not started, process no 13965, OS thread id
2991321408
MySQL thread id 16558, query id 11544223 10.1.20.10 root
---TRANSACTION 0 476652974, not started, process no 13965, OS thread id
3014689344
MySQL thread id 16555, query id 11547903 10.1.20.10 root
---TRANSACTION 0 476675085, not started, process no 13965, OS thread id
2998860096
MySQL thread id 16553, query id 11545611 10.1.20.10 root
---TRANSACTION 0 476661870, not started, process no 13965, OS thread id
3021010880
MySQL thread id 16551, query id 11545692 10.1.20.10 root
---TRANSACTION 0 476674113, not started, process no 13965, OS thread id
3069376448
MySQL thread id 16548, query id 11543541 10.1.20.10 root
---TRANSACTION 0 476648421, not started, process no 13965, OS thread id
3057908544
MySQL thread id 16543, query id 11545565 10.1.20.10 root
---TRANSACTION 0 476674005, not started, process no 13965, OS thread id
3032216640
MySQL thread id 16536, query id 11543122 10.1.20.10 root
---TRANSACTION 0 476647742, not started, process no 13965, OS thread id
3013340608
MySQL thread id 16535, query id 11545014 10.1.20.10 root
---TRANSACTION 0 476653736, not started, process no 13965, OS thread id
3078158144
MySQL thread id 16534, query id 11542846 10.1.20.10 root
---TRANSACTION 0 476656992, not started, process no 13965, OS thread id
3029014976
MySQL thread id 16521, query id 11544423 10.1.20.10 root
---TRANSACTION 0 476675494, not started, process no 13965, OS thread id
3063280448
MySQL thread id 16528, query id 11546594 10.1.20.10 root
---TRANSACTION 0 476669687, not started, process no 13965, OS thread id
3082351808
MySQL thread id 16524, query id 11546610 10.1.20.10 root
---TRANSACTION 0 476654057, not started, process no 13965, OS thread id
2984833472
MySQL thread id 16523, query id 11543064 10.1.20.10 root
---TRANSACTION 0 476674052, not started, process no 13965, OS thread id
3102414528
MySQL thread id 16519, query id 11543311 10.1.20.10 root
---TRANSACTION 0 476656213, not started, process no 13965, OS thread id
2995973568
MySQL thread id 16513, query id 11544207 10.1.20.10 root
---TRANSACTION 0 476639434, not started, process no 13965, OS thread id
3016457664
MySQL thread id 16516, query id 11546206 10.1.20.10 root
---TRANSACTION 0 476653774, not started, process no 13965, OS thread id
3065968192
MySQL thread id 16517, query id 11542932 10.1.20.10 root
---TRANSACTION 0 476672561, not started, process no 13965, OS thread id
3069965888
MySQL thread id 16515, query id 11545405 10.1.20.10 root
---TRANSACTION 0 476675382, not started, process no 13965, OS thread id
2998071488
MySQL thread id 16507, query id 11546380 10.1.20.10 root
---TRANSACTION 0 476654344, not started, process no 13965, OS thread id
2998467136
MySQL thread id 16511, query id 11543321 10.1.20.10 root
---TRANSACTION 0 476674058, not started, process no 13965, OS thread id
3051289152
MySQL thread id 16510, query id 11543451 10.1.20.10 root
---TRANSACTION 0 476647789, not started, process no 13965, OS thread id
2984638912
MySQL thread id 16509, query id 11545057 10.1.20.10 root
---TRANSACTION 0 476657182, not started, process no 13965, OS thread id
3039622208
MySQL thread id 16506, query id 11544846 10.1.20.10 root
---TRANSACTION 0 476675212, not started, process no 13965, OS thread id
3033199040
MySQL thread id 16502, query id 11546056 10.1.20.10 root
---TRANSACTION 0 476669306, not started, process no 13965, OS thread id
3022975680
MySQL thread id 16499, query id 11546557 10.1.20.10 root
---TRANSACTION 0 476657204, not started, process no 13965, OS thread id
3041194048
MySQL thread id 16501, query id 11544844 10.1.20.10 root
---TRANSACTION 0 476653432, not started, process no 13965, OS thread id
3038246848
MySQL thread id 16500, query id 11542772 10.1.20.10 root
---TRANSACTION 0 476675568, not started, process no 13965, OS thread id
2985228352
MySQL thread id 16476, query id 11546725 10.1.20.10 root
---TRANSACTION 0 475710768, not started, process no 13965, OS thread id
2946291392
MySQL thread id 16183, query id 11548333 10.1.20.10 root
---TRANSACTION 0 476026997, not started, process no 13965, OS thread id
3100768832
MySQL thread id 16336, query id 11548341 10.1.20.10 root
---TRANSACTION 0 476656476, not started, process no 13965, OS thread id
3091596096
MySQL thread id 16431, query id 11544343 10.1.20.10 root
---TRANSACTION 0 476675688, not started, process no 13965, OS thread id
3087287616
MySQL thread id 16426, query id 11546934 10.1.20.10 root
---TRANSACTION 0 476647982, not started, process no 13965, OS thread id
2998663616
MySQL thread id 16384, query id 11545179 10.1.20.10 root
---TRANSACTION 0 476654828, not started, process no 13965, OS thread id
3066910784
MySQL thread id 16420, query id 11543569 10.1.20.10 root
---TRANSACTION 0 476656875, not started, process no 13965, OS thread id
3028482880
MySQL thread id 16414, query id 11544633 10.1.20.10 root
---TRANSACTION 0 476653591, not started, process no 13965, OS thread id
3015085376
MySQL thread id 16410, query id 11542788 10.1.20.10 root
---TRANSACTION 0 476617266, not started, process no 13965, OS thread id
3000561728
MySQL thread id 16404, query id 11545270 10.1.20.10 root
---TRANSACTION 0 476674182, not started, process no 13965, OS thread id
3010195264
MySQL thread id 16406, query id 11543670 10.1.20.10 root
---TRANSACTION 0 476648710, not started, process no 13965, OS thread id
3009605568
MySQL thread id 16405, query id 11545708 10.1.20.10 root
---TRANSACTION 0 476649525, not started, process no 13965, OS thread id
2993877312
MySQL thread id 16402, query id 11546387 10.1.20.10 root
---TRANSACTION 0 476669730, not started, process no 13965, OS thread id
2982707776
MySQL thread id 16400, query id 11546673 10.1.20.10 root
---TRANSACTION 0 476656018, not started, process no 13965, OS thread id
2987324864
MySQL thread id 16399, query id 11544092 10.1.20.10 root
---TRANSACTION 0 476654641, not started, process no 13965, OS thread id
3012949568
MySQL thread id 16395, query id 11543484 10.1.20.10 root
---TRANSACTION 0 476673756, not started, process no 13965, OS thread id
3034770880
MySQL thread id 16394, query id 11548406 10.1.20.10 root
---TRANSACTION 0 476644801, not started, process no 13965, OS thread id
3122590656
MySQL thread id 16386, query id 11543084 10.1.20.10 root
---TRANSACTION 0 476675166, not started, process no 13965, OS thread id
3047355200
MySQL thread id 16392, query id 11545873 10.1.20.10 root
---TRANSACTION 0 476650562, not started, process no 13965, OS thread id
3045193920
MySQL thread id 16391, query id 11546578 10.1.20.10 root
---TRANSACTION 0 476670950, not started, process no 13965, OS thread id
3078354624
MySQL thread id 16390, query id 11548018 10.1.20.10 root
---TRANSACTION 0 476656953, not started, process no 13965, OS thread id
3024744000
MySQL thread id 16366, query id 11544385 10.1.20.10 root
---TRANSACTION 0 476048712, not started, process no 13965, OS thread id
3040408128
MySQL thread id 15719, query id 11548339 10.1.20.10 root
---TRANSACTION 0 476647286, not started, process no 13965, OS thread id
3037067968
MySQL thread id 16296, query id 11544804 10.1.20.10 root
---TRANSACTION 0 476656131, not started, process no 13965, OS thread id
2975978432
MySQL thread id 16285, query id 11544189 10.1.20.10 root
---TRANSACTION 0 476674743, not started, process no 13965, OS thread id
2988831936
MySQL thread id 16284, query id 11544979 10.1.20.10 root
---TRANSACTION 0 476656371, not started, process no 13965, OS thread id
3038443328
MySQL thread id 16283, query id 11544319 10.1.20.10 root
---TRANSACTION 0 476672939, not started, process no 13965, OS thread id
3040211648
MySQL thread id 16282, query id 11546243 10.1.20.10 root
---TRANSACTION 0 476673384, not started, process no 13965, OS thread id
3030193728
MySQL thread id 16280, query id 11547509 10.1.20.10 root
---TRANSACTION 0 476672215, not started, process no 13965, OS thread id
2994270016
MySQL thread id 16256, query id 11544364 10.1.20.10 root
---TRANSACTION 0 476675812, not started, process no 13965, OS thread id
3056922048
MySQL thread id 16278, query id 11547376 10.1.20.10 root
---TRANSACTION 0 476649562, not started, process no 13965, OS thread id
3052795968
MySQL thread id 16274, query id 11546315 10.1.20.10 root
---TRANSACTION 0 476672820, not started, process no 13965, OS thread id
3075668672
MySQL thread id 16273, query id 11545892 10.1.20.10 root
---TRANSACTION 0 476656972, not started, process no 13965, OS thread id
3026386112
MySQL thread id 16272, query id 11544901 10.1.20.10 root
---TRANSACTION 0 476675811, not started, process no 13965, OS thread id
3090809536
MySQL thread id 16270, query id 11547366 10.1.20.10 root
---TRANSACTION 0 476673450, not started, process no 13965, OS thread id
3089632192
MySQL thread id 16269, query id 11547414 10.1.20.10 root
---TRANSACTION 0 476672551, not started, process no 13965, OS thread id
2978934592
MySQL thread id 16268, query id 11545371 10.1.20.10 root
---TRANSACTION 0 476675725, not started, process no 13965, OS thread id
3020421440
MySQL thread id 16264, query id 11547106 10.1.20.10 root
---TRANSACTION 0 476675381, not started, process no 13965, OS thread id
3058497984
MySQL thread id 15824, query id 11548356 10.1.20.10 root
---TRANSACTION 0 476676323, not started, process no 13965, OS thread id
3026582592
MySQL thread id 16219, query id 11548499 10.1.20.40 smssender
---TRANSACTION 0 476676322, not started, process no 13965, OS thread id
2978345152
MySQL thread id 16218, query id 11548497 10.1.20.40 smssender
---TRANSACTION 0 476676287, not started, process no 13965, OS thread id
3021600320
MySQL thread id 16217, query id 11548438 10.1.20.40 smssender
---TRANSACTION 0 474894552, not started, process no 13965, OS thread id
3023172160
MySQL thread id 16180, query id 11548315 10.1.20.10 root
---TRANSACTION 0 476674640, not started, process no 13965, OS thread id
3029800768
MySQL thread id 16189, query id 11544782 10.1.20.10 root
---TRANSACTION 0 476674441, not started, process no 13965, OS thread id
3011967168
MySQL thread id 16173, query id 11544129 10.1.20.10 root
---TRANSACTION 0 476676085, not started, process no 13965, OS thread id
3049717056
MySQL thread id 16163, query id 11547844 10.1.20.10 root
---TRANSACTION 0 476673484, not started, process no 13965, OS thread id
1107294016
MySQL thread id 16162, query id 11547594 10.1.20.10 root
---TRANSACTION 0 476653364, not started, process no 13965, OS thread id
3095789888
MySQL thread id 16147, query id 11542699 10.1.20.10 root
---TRANSACTION 0 476675654, not started, process no 13965, OS thread id
3010591808
MySQL thread id 16127, query id 11546869 10.1.20.10 root
---TRANSACTION 0 476675574, not started, process no 13965, OS thread id
2976567872
MySQL thread id 16132, query id 11546740 10.1.20.10 root
---TRANSACTION 0 476675627, not started, process no 13965, OS thread id
3040801088
MySQL thread id 16140, query id 11546817 10.1.20.10 root
---TRANSACTION 0 476652022, not started, process no 13965, OS thread id
3037264448
MySQL thread id 16136, query id 11547128 10.1.20.10 root
---TRANSACTION 0 476653621, not started, process no 13965, OS thread id
3040997568
MySQL thread id 16133, query id 11542823 10.1.20.10 root
---TRANSACTION 0 476676184, not started, process no 13965, OS thread id
2946487872
MySQL thread id 16131, query id 11548041 10.1.20.10 root
---TRANSACTION 0 476655266, not started, process no 13965, OS thread id
3037657408
MySQL thread id 16129, query id 11543863 10.1.20.10 root
---TRANSACTION 0 476653944, not started, process no 13965, OS thread id
3025141056
MySQL thread id 16126, query id 11543004 10.1.20.10 root
---TRANSACTION 0 476674879, not started, process no 13965, OS thread id
3034971456
MySQL thread id 16118, query id 11545225 10.1.20.10 root
---TRANSACTION 0 476675262, not started, process no 13965, OS thread id
3005149632
MySQL thread id 16124, query id 11546159 10.1.20.10 root
---TRANSACTION 0 476671592, not started, process no 13965, OS thread id
3044997440
MySQL thread id 16117, query id 11543454 10.1.20.10 root
---TRANSACTION 0 476656060, not started, process no 13965, OS thread id
2991517888
MySQL thread id 16111, query id 11544176 10.1.20.10 root
---TRANSACTION 0 476675120, not started, process no 13965, OS thread id
3077961664
MySQL thread id 16110, query id 11545670 10.1.20.10 root
---TRANSACTION 0 476675647, not started, process no 13965, OS thread id
2976371392
MySQL thread id 16107, query id 11546852 10.1.20.10 root
---TRANSACTION 0 476674848, not started, process no 13965, OS thread id
2986538944
MySQL thread id 16101, query id 11545174 10.1.20.10 root
---TRANSACTION 0 476655811, not started, process no 13965, OS thread id
2948527040
MySQL thread id 16093, query id 11543996 10.1.20.10 root
---TRANSACTION 0 474657321, not started, process no 13965, OS thread id
3044800960
MySQL thread id 13734, query id 11548320 10.1.20.10 root
---TRANSACTION 0 476651302, not started, process no 13965, OS thread id
3071012288
MySQL thread id 15834, query id 11547407 10.1.20.10 root
---TRANSACTION 0 476674451, not started, process no 13965, OS thread id
3049913536
MySQL thread id 15829, query id 11544154 10.1.20.10 root
---TRANSACTION 0 474340061, not started, process no 13965, OS thread id
3100965312
MySQL thread id 15541, query id 11548307 10.1.20.10 root
---TRANSACTION 0 474335452, not started, process no 13965, OS thread id
3046372800
MySQL thread id 15676, query id 11548306 10.1.20.10 root
---TRANSACTION 0 474210031, not started, process no 13965, OS thread id
3014296384
MySQL thread id 15563, query id 11548304 10.1.20.10 root
---TRANSACTION 0 476675729, not started, process no 13965, OS thread id
3026975552
MySQL thread id 15579, query id 11547118 10.1.20.10 root
---TRANSACTION 0 476651466, not started, process no 13965, OS thread id
3056725568
MySQL thread id 15336, query id 11547614 10.1.20.10 root
---TRANSACTION 0 476675221, not started, process no 13965, OS thread id
3037853888
MySQL thread id 15247, query id 11546078 10.1.20.10 root
---TRANSACTION 0 476655151, not started, process no 13965, OS thread id
3082744768
MySQL thread id 15176, query id 11543808 10.1.20.10 root
---TRANSACTION 0 476676310, not started, process no 13965, OS thread id
3060528832
MySQL thread id 15152, query id 11548482 10.1.20.10 root
---TRANSACTION 0 476675481, not started, process no 13965, OS thread id
3021207360
MySQL thread id 15150, query id 11546565 10.1.20.10 root
---TRANSACTION 0 476675690, not started, process no 13965, OS thread id
3053188928
MySQL thread id 15148, query id 11546944 10.1.20.10 root
---TRANSACTION 0 476675394, not started, process no 13965, OS thread id
2998270656
MySQL thread id 15142, query id 11546401 10.1.20.10 root
---TRANSACTION 0 476675780, not started, process no 13965, OS thread id
3038639808
MySQL thread id 15125, query id 11547310 10.1.20.10 root
---TRANSACTION 0 476675682, not started, process no 13965, OS thread id
3019635520
MySQL thread id 15123, query id 11546916 10.1.20.10 root
---TRANSACTION 0 476675310, not started, process no 13965, OS thread id
3095986240
MySQL thread id 15120, query id 11546261 10.1.20.10 root
---TRANSACTION 0 476675930, not started, process no 13965, OS thread id
3000956608
MySQL thread id 15118, query id 11547601 10.1.20.10 root
---TRANSACTION 0 476675422, not started, process no 13965, OS thread id
3046569280
MySQL thread id 15107, query id 11546451 10.1.20.10 root
---TRANSACTION 0 476675841, not started, process no 13965, OS thread id
3090416576
MySQL thread id 15106, query id 11547430 10.1.20.10 root
---TRANSACTION 0 476675858, not started, process no 13965, OS thread id
3050895936
MySQL thread id 15089, query id 11547464 10.1.20.10 root
---TRANSACTION 0 476675352, not started, process no 13965, OS thread id
3007508800
MySQL thread id 15088, query id 11546324 10.1.20.10 root
---TRANSACTION 0 476675894, not started, process no 13965, OS thread id
3016064704
MySQL thread id 15087, query id 11547518 10.1.20.10 root
---TRANSACTION 0 476675487, not started, process no 13965, OS thread id
3082548288
MySQL thread id 14911, query id 11546587 10.1.20.10 root
---TRANSACTION 0 476675367, not started, process no 13965, OS thread id
3002856640
MySQL thread id 14909, query id 11546358 10.1.20.10 root
---TRANSACTION 0 476675507, not started, process no 13965, OS thread id
3054171328
MySQL thread id 14827, query id 11546618 10.1.20.10 root
---TRANSACTION 0 476674995, not started, process no 13965, OS thread id
3065771712
MySQL thread id 14578, query id 11545434 10.1.20.10 root
---TRANSACTION 0 476675189, not started, process no 13965, OS thread id
3082155328
MySQL thread id 14574, query id 11545906 10.1.20.10 root
---TRANSACTION 0 476675735, not started, process no 13965, OS thread id
3122394176
MySQL thread id 14568, query id 11547136 10.1.20.10 root
---TRANSACTION 0 476675289, not started, process no 13965, OS thread id
3042769984
MySQL thread id 13857, query id 11546215 10.1.20.10 root
---TRANSACTION 0 476675140, not started, process no 13965, OS thread id
3050699456
MySQL thread id 13856, query id 11545703 10.1.20.10 root
---TRANSACTION 0 476675115, not started, process no 13965, OS thread id
3000367168
MySQL thread id 13804, query id 11545656 10.1.20.10 root
---TRANSACTION 0 476675147, not started, process no 13965, OS thread id
3057319104
MySQL thread id 13070, query id 11545732 10.1.20.10 root
---TRANSACTION 0 476674980, not started, process no 13965, OS thread id
3019242560
MySQL thread id 13028, query id 11545415 10.1.20.10 root
---TRANSACTION 0 476675538, not started, process no 13965, OS thread id
3032020160
MySQL thread id 12969, query id 11546681 10.1.20.10 root
---TRANSACTION 0 476676269, not started, process no 13965, OS thread id
3032609600
MySQL thread id 12966, query id 11548419 10.1.20.10 root
---TRANSACTION 0 476675056, not started, process no 13965, OS thread id
3096240576
MySQL thread id 12835, query id 11545544 10.1.20.10 root
---TRANSACTION 0 476675280, not started, process no 13965, OS thread id
3065575232
MySQL thread id 12809, query id 11546188 10.1.20.10 root
---TRANSACTION 0 476675257, not started, process no 13965, OS thread id
3090221632
MySQL thread id 12807, query id 11546147 10.1.20.10 root
---TRANSACTION 0 476674967, not started, process no 13965, OS thread id
2978148672
MySQL thread id 12806, query id 11545388 10.1.20.10 root
---TRANSACTION 0 476675835, not started, process no 13965, OS thread id
3004363712
MySQL thread id 12704, query id 11547422 10.1.20.10 root
---TRANSACTION 0 476676239, not started, process no 13965, OS thread id
3047551680
MySQL thread id 12383, query id 11548368 10.1.20.10 root
---TRANSACTION 0 476675148, not started, process no 13965, OS thread id
3046176320
MySQL thread id 12137, query id 11545733 10.1.20.10 root
---TRANSACTION 0 476675937, not started, process no 13965, OS thread id
3002267200
MySQL thread id 12020, query id 11547622 10.1.20.10 root
---TRANSACTION 0 476676177, not started, process no 13965, OS thread id
3009801792
MySQL thread id 11753, query id 11548032 10.1.20.10 root
---TRANSACTION 0 476675907, not started, process no 13965, OS thread id
3048534080
MySQL thread id 11686, query id 11547550 10.1.20.10 root
---TRANSACTION 0 476674909, not started, process no 13965, OS thread id
3047944640
MySQL thread id 11607, query id 11545278 10.1.20.10 root
---TRANSACTION 0 476647769, not started, process no 13965, OS thread id
3029997248
MySQL thread id 11548, query id 11545025 10.1.20.10 root
---TRANSACTION 0 476676122, not started, process no 13965, OS thread id
3060332352
MySQL thread id 11547, query id 11547914 10.1.20.10 root
---TRANSACTION 0 476656658, not started, process no 13965, OS thread id
2996370624
MySQL thread id 11535, query id 11544352 10.1.20.10 root
---TRANSACTION 0 476648505, not started, process no 13965, OS thread id
3008294592
MySQL thread id 11534, query id 11545645 10.1.20.10 root
---TRANSACTION 0 476671774, not started, process no 13965, OS thread id
3033395520
MySQL thread id 11528, query id 11543734 10.1.20.10 root
---TRANSACTION 0 476675638, not started, process no 13965, OS thread id
3087089856
MySQL thread id 11526, query id 11546835 10.1.20.10 root
---TRANSACTION 0 476650800, not started, process no 13965, OS thread id
3090613056
MySQL thread id 11520, query id 11546908 10.1.20.10 root
---TRANSACTION 0 476675071, not started, process no 13965, OS thread id
3102218048
MySQL thread id 11519, query id 11545577 10.1.20.10 root
---TRANSACTION 0 476674565, not started, process no 13965, OS thread id
3045390400
MySQL thread id 11513, query id 11544400 10.1.20.10 root
---TRANSACTION 0 476657048, not started, process no 13965, OS thread id
3022779200
MySQL thread id 11510, query id 11544595 10.1.20.10 root
---TRANSACTION 0 476647675, not started, process no 13965, OS thread id
3076258112
MySQL thread id 11506, query id 11544956 10.1.20.10 root
---TRANSACTION 0 476676028, not started, process no 13965, OS thread id
3021993280
MySQL thread id 11505, query id 11547760 10.1.20.10 root
---TRANSACTION 0 476675908, not started, process no 13965, OS thread id
3085693248
MySQL thread id 11496, query id 11547560 10.1.20.10 root
---TRANSACTION 0 476676159, not started, process no 13965, OS thread id
2989028416
MySQL thread id 11494, query id 11547985 10.1.20.10 root
---TRANSACTION 0 476652469, not started, process no 13965, OS thread id
3101825088
MySQL thread id 11484, query id 11547541 10.1.20.10 root
---TRANSACTION 0 476670432, not started, process no 13965, OS thread id
2996763584
MySQL thread id 11483, query id 11546936 10.1.20.10 root
---TRANSACTION 0 476674257, not started, process no 13965, OS thread id
3053581888
MySQL thread id 11480, query id 11543772 10.1.20.10 root
---TRANSACTION 0 476676215, not started, process no 13965, OS thread id
3122197696
MySQL thread id 11473, query id 11548212 10.1.20.10 root
---TRANSACTION 0 476672521, not started, process no 13965, OS thread id
3007705280
MySQL thread id 11471, query id 11545154 10.1.20.10 root
---TRANSACTION 0 476647405, not started, process no 13965, OS thread id
2990928448
MySQL thread id 11469, query id 11544872 10.1.20.10 root
---TRANSACTION 0 476675078, not started, process no 13965, OS thread id
3000760128
MySQL thread id 11457, query id 11545594 10.1.20.10 root
---TRANSACTION 0 476647167, not started, process no 13965, OS thread id
3038836288
MySQL thread id 11456, query id 11544440 10.1.20.10 root
---TRANSACTION 0 476674955, not started, process no 13965, OS thread id
3046765760
MySQL thread id 11450, query id 11545362 10.1.20.10 root
---TRANSACTION 0 476675536, not started, process no 13965, OS thread id
3078551104
MySQL thread id 11449, query id 11546669 10.1.20.10 root
---TRANSACTION 0 476676161, not started, process no 13965, OS thread id
3003053120
MySQL thread id 11445, query id 11547988 10.1.20.10 root
---TRANSACTION 0 476674797, not started, process no 13965, OS thread id
3098275264
MySQL thread id 11440, query id 11545094 10.1.20.10 root
---TRANSACTION 0 476648410, not started, process no 13965, OS thread id
3009998272
MySQL thread id 11438, query id 11545534 10.1.20.10 root
---TRANSACTION 0 476675943, not started, process no 13965, OS thread id
3022386240
MySQL thread id 11426, query id 11547639 10.1.20.10 root
---TRANSACTION 0 476674378, not started, process no 13965, OS thread id
2981035200
MySQL thread id 11417, query id 11544019 10.1.20.10 root
---TRANSACTION 0 476672137, not started, process no 13965, OS thread id
2982513728
MySQL thread id 11416, query id 11544330 10.1.20.10 root
---TRANSACTION 0 471299087, not started, process no 13965, OS thread id
3042377024
MySQL thread id 2652, query id 11547299 10.1.20.10 smssender
---TRANSACTION 0 476675827, not started, process no 13965, OS thread id
2983103168
MySQL thread id 59, query id 11548452 10.1.20.10 smssender
---TRANSACTION 0 476676289, not started, process no 13965, OS thread id
2950659776
MySQL thread id 19, query id 11548443 10.1.20.40 smssender
---TRANSACTION 0 476676302, not started, process no 13965, OS thread id
2954004032
MySQL thread id 36, query id 11548511 10.1.20.40 smssender
---TRANSACTION 0 476676162, not started, process no 13965, OS thread id
2980441664
MySQL thread id 52, query id 11547995 10.1.20.10 smssender
---TRANSACTION 0 476676314, not started, process no 13965, OS thread id
2952235712
MySQL thread id 27, query id 11548489 10.1.20.40 smssender
---TRANSACTION 0 476676305, not started, process no 13965, OS thread id
2975585472
MySQL thread id 39, query id 11548498 10.1.20.40 smssender
---TRANSACTION 0 476676308, not started, process no 13965, OS thread id
2954396992
MySQL thread id 38, query id 11548485 10.1.20.40 smssender
---TRANSACTION 0 476676307, not started, process no 13965, OS thread id
2949312960
MySQL thread id 13, query id 11548466 10.1.20.40 smssender
---TRANSACTION 0 476676313, not started, process no 13965, OS thread id
2951052736
MySQL thread id 21, query id 11548488 10.1.20.40 smssender
---TRANSACTION 0 476676288, not started, process no 13965, OS thread id
2952825152
MySQL thread id 30, query id 11548487 10.1.20.40 smssender
---TRANSACTION 0 476676316, not started, process no 13965, OS thread id
2952039232
MySQL thread id 26, query id 11548491 10.1.20.40 smssender
---TRANSACTION 0 476676299, not started, process no 13965, OS thread id
2953414592
MySQL thread id 33, query id 11548455 10.1.20.40 smssender
---TRANSACTION 0 476676303, not started, process no 13965, OS thread id
2952432192
MySQL thread id 28, query id 11548501 10.1.20.40 smssender
---TRANSACTION 0 476676312, not started, process no 13965, OS thread id
2954200512
MySQL thread id 37, query id 11548484 10.1.20.40 smssender
---TRANSACTION 0 476676290, not started, process no 13965, OS thread id
2950070336
MySQL thread id 16, query id 11548509 10.1.20.40 smssender
---TRANSACTION 0 476676301, not started, process no 13965, OS thread id
2951253312
MySQL thread id 22, query id 11548457 10.1.20.40 smssender
---TRANSACTION 0 476676293, not started, process no 13965, OS thread id
2950856256
MySQL thread id 20, query id 11548467 10.1.20.40 smssender
---TRANSACTION 0 476676326, not started, process no 13965, OS thread id
2953021632
MySQL thread id 31, query id 11548508 10.1.20.40 smssender
---TRANSACTION 0 476676291, not started, process no 13965, OS thread id
2953611072
MySQL thread id 34, query id 11548505 10.1.20.40 smssender
---TRANSACTION 0 476676295, not started, process no 13965, OS thread id
2951646272
MySQL thread id 24, query id 11548486 10.1.20.40 smssender
---TRANSACTION 0 476676306, not started, process no 13965, OS thread id
2951842752
MySQL thread id 25, query id 11548465 10.1.20.40 smssender
---TRANSACTION 0 476676292, not started, process no 13965, OS thread id
2949677376
MySQL thread id 14, query id 11548503 10.1.20.40 smssender
---TRANSACTION 0 476676327, not started, process no 13965, OS thread id
2975781952
MySQL thread id 40, query id 11548510 10.1.20.40 smssender
---TRANSACTION 0 476676296, not started, process no 13965, OS thread id
2953807552
MySQL thread id 35, query id 11548507 10.1.20.40 smssender
---TRANSACTION 0 476676324, not started, process no 13965, OS thread id
2952628672
MySQL thread id 29, query id 11548500 10.1.20.40 smssender
---TRANSACTION 0 476676286, not started, process no 13965, OS thread id
2951449792
MySQL thread id 23, query id 11548439 10.1.20.40 smssender
---TRANSACTION 0 476676315, not started, process no 13965, OS thread id
2950463296
MySQL thread id 18, query id 11548490 10.1.20.40 smssender
---TRANSACTION 0 476676298, not started, process no 13965, OS thread id
2950266816
MySQL thread id 17, query id 11548502 10.1.20.40 smssender
---TRANSACTION 0 476676325, not started, process no 13965, OS thread id
2953218112
MySQL thread id 32, query id 11548512 10.1.20.40 smssender
---TRANSACTION 0 476676320, not started, process no 13965, OS thread id
2949873856
MySQL thread id 15, query id 11548495 10.1.20.40 smssender
---TRANSACTION 0 476676304, not started, process no 13965, OS thread id
2949116480
MySQL thread id 12, query id 11548461 10.1.20.40 smssender
---TRANSACTION 0 476676311, not started, process no 13965, OS thread id
2948920000
MySQL thread id 11, query id 11548483 10.1.20.40 smssender
---TRANSACTION 0 476676319, not started, process no 13965, OS thread id
2948723520
MySQL thread id 10, query id 11548494 10.1.20.40 smssender
---TRANSACTION 0 476648265, ACTIVE 530 sec, process no 13965, OS thread id
3152999360 updating or deleting, thread declared inside InnoDB 293
mysql tables in use 1, locked 1
11090 lock struct(s), heap size 634176, undo log entries 930711
MySQL thread id 16831, query id 11504020 localhost 127.0.0.1 root updating
delete from t_outgoing_sms_3t where month(out_sms_time)=1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
