The T_Recep table had not modify. The server version is 5.0.52. The result of SHOW INNODB STATUS\G is: *************************** 1. row *************************** Status: ===================================== 090626 15:43:38 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 31 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4795385, signal count 4474563 Mutex spin waits 0, rounds 146095269, OS waits 1673859 RW-shared spins 6107784, OS waits 1664131; RW-excl spins 4792176, OS waits 1068161 ------------------------ LATEST DETECTED DEADLOCK ------------------------ 090626 11:11:35 *** (1) TRANSACTION: TRANSACTION 12 783368801, ACTIVE 0 sec, process no 30827, OS thread id 152689568 fetching rows mysql tables in use 1, locked 1 LOCK WAIT 14 lock struct(s), heap size 1024, undo log entries 306 MySQL thread id 129374, query id 69137355 84.55.154.2 mastercom4 updating DELETE FROM gprs_v2.T_Recep WHERE rcflagtrait=140 and rcCLientCode=1073 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 913135 n bits 184 index `GEN_CLUST_INDEX` of table `gprs_v2/T_Recep` trx id 12 783368801 lock_mode X waiting Record lock, heap no 92 PHYSICAL RECORD: n_fields 32; compact format; info bits 0 0: len 6; hex 00014d5cb44e; asc M\ N;; 1: len 6; hex 000c2eb14273; asc . Bs;; 2: len 7; hex 000005000c06d2; asc ;; 3: len 4; hex 00000cdc; asc ;; 4: len 4; hex 00000006; asc ;; 5: len 1; hex 00; asc ;; 6: len 4; hex 00000000; asc ;; 7: len 1; hex 00; asc ;; 8: len 8; hex 80001245b6a1a875; asc E u;; 9: len 1; hex fc; asc ;; 10: len 15; hex 343635393036303030202020202020; asc 465906000 ;; 11: len 15; hex 303635333439303130202020202020; asc 065349010 ;; 12: len 6; hex 303030303041; asc 00000A;; 13: len 4; hex 00000000; asc ;; 14: len 1; hex 04; asc ;; 15: len 2; hex 0126; asc &;; 16: len 1; hex 08; asc ;; 17: len 1; hex 00; asc ;; 18: len 1; hex 00; asc ;; 19: len 1; hex ef; asc ;; 20: len 1; hex 7f; asc ;; 21: len 3; hex 800000; asc ;; 22: len 3; hex 800000; asc ;; 23: len 3; hex 800000; asc ;; 24: len 3; hex 800000; asc ;; 25: len 3; hex 800000; asc ;; 26: len 4; hex 00000000; asc ;; 27: len 1; hex d3; asc ;; 28: len 4; hex 00000000; asc ;; 29: len 8; hex 80001245b6a1f69f; asc E ;; 30: len 8; hex 80001245b6a1a87d; asc E };; 31: SQL NULL; *** (2) TRANSACTION: TRANSACTION 12 783368819, ACTIVE 0 sec, process no 30827, OS thread id 60615584 fetching rows, thread declared inside InnoDB 494 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1024, undo log entries 3 MySQL thread id 11947, query id 69137368 195.7.104.189 mastercom7 Updating UPDATE gprs_v2.T_Recep set rcflagtrait=211 WHERE rcCLientCode=3292 AND rcFlagTrait in(0,211) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 913135 n bits 184 index `GEN_CLUST_INDEX` of table `gprs_v2/T_Recep` trx id 12 783368819 lock_mode X locks rec but not gap Record lock, heap no 92 PHYSICAL RECORD: n_fields 32; compact format; info bits 0 0: len 6; hex 00014d5cb44e; asc M\ N;; 1: len 6; hex 000c2eb14273; asc . Bs;; 2: len 7; hex 000005000c06d2; asc ;; 3: len 4; hex 00000cdc; asc ;; 4: len 4; hex 00000006; asc ;; 5: len 1; hex 00; asc ;; 6: len 4; hex 00000000; asc ;; 7: len 1; hex 00; asc ;; 8: len 8; hex 80001245b6a1a875; asc E u;; 9: len 1; hex fc; asc ;; 10: len 15; hex 343635393036303030202020202020; asc 465906000 ;; 11: len 15; hex 303635333439303130202020202020; asc 065349010 ;; 12: len 6; hex 303030303041; asc 00000A;; 13: len 4; hex 00000000; asc ;; 14: len 1; hex 04; asc ;; 15: len 2; hex 0126; asc &;; 16: len 1; hex 08; asc ;; 17: len 1; hex 00; asc ;; 18: len 1; hex 00; asc ;; 19: len 1; hex ef; asc ;; 20: len 1; hex 7f; asc ;; 21: len 3; hex 800000; asc ;; 22: len 3; hex 800000; asc ;; 23: len 3; hex 800000; asc ;; 24: len 3; hex 800000; asc ;; 25: len 3; hex 800000; asc ;; 26: len 4; hex 00000000; asc ;; 27: len 1; hex d3; asc ;; 28: len 4; hex 00000000; asc ;; 29: len 8; hex 80001245b6a1f69f; asc E ;; 30: len 8; hex 80001245b6a1a87d; asc E };; 31: SQL NULL; Record lock, heap no 93 PHYSICAL RECORD: n_fields 32; compact format; info bits 0 0: len 6; hex 00014d5cb450; asc M\ P;; 1: len 6; hex 000c2eb14273; asc . Bs;; 2: len 7; hex 000005000c071e; asc ;; 3: len 4; hex 00000cdc; asc ;; 4: len 4; hex 00000006; asc ;; 5: len 1; hex 00; asc ;; 6: len 4; hex 00000000; asc ;; 7: len 1; hex 00; asc ;; 8: len 8; hex 80001245b6a1a875; asc E u;; 9: len 1; hex fc; asc ;; 10: len 15; hex 343635393036303030202020202020; asc 465906000 ;; 11: len 15; hex 303635333439303130202020202020; asc 065349010 ;; 12: len 6; hex 303030303033; asc 000003;; 13: len 4; hex 00000000; asc ;; 14: len 1; hex 04; asc ;; 15: len 2; hex 0126; asc &;; 16: len 1; hex 08; asc ;; 17: len 1; hex 00; asc ;; 18: len 1; hex 00; asc ;; 19: len 1; hex f0; asc ;; 20: len 1; hex 7f; asc ;; 21: len 3; hex 800000; asc ;; 22: len 3; hex 800000; asc ;; 23: len 3; hex 800000; asc ;; 24: len 3; hex 800000; asc ;; 25: len 3; hex 800000; asc ;; 26: len 4; hex 00000000; asc ;; 27: len 1; hex d3; asc ;; 28: len 4; hex 00000000; asc ;; 29: len 8; hex 80001245b6a1f69f; asc E ;; 30: len 8; hex 80001245b6a1a87d; asc E };; 31: SQL NULL; Record lock, heap no 94 PHYSICAL RECORD: n_fields 32; compact format; info bits 0 0: len 6; hex 00014d5cb451; asc M\ Q;; 1: len 6; hex 000c2eb14273; asc . Bs;; 2: len 7; hex 000005000c076a; asc j;; 3: len 4; hex 00000cdc; asc ;; 4: len 4; hex 00000006; asc ;; 5: len 1; hex 00; asc ;; 6: len 4; hex 00000000; asc ;; 7: len 1; hex 00; asc ;; 8: len 8; hex 80001245b6a1a875; asc E u;; 9: len 1; hex 04; asc ;; 10: len 15; hex 343635393036303030202020202020; asc 465906000 ;; 11: len 15; hex 303635333439303130202020202020; asc 065349010 ;; 12: len 6; hex 303039626565; asc 009bee;; 13: len 4; hex 00000000; asc ;; 14: len 1; hex 04; asc ;; 15: len 2; hex 0126; asc &;; 16: len 1; hex 08; asc ;; 17: len 1; hex 00; asc ;; 18: len 1; hex 00; asc ;; 19: len 1; hex f1; asc ;; 20: len 1; hex 7f; asc ;; 21: len 3; hex 800000; asc ;; 22: len 3; hex 800000; asc ;; 23: len 3; hex 800000; asc ;; 24: len 3; hex 800000; asc ;; 25: len 3; hex 800000; asc ;; 26: len 4; hex 00000000; asc ;; 27: len 1; hex d3; asc ;; 28: len 4; hex 00000000; asc ;; 29: len 8; hex 80001245b6a1f69f; asc E ;; 30: len 8; hex 80001245b6a1a87d; asc E };; 31: SQL NULL; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 913135 n bits 184 index `GEN_CLUST_INDEX` of table `gprs_v2/T_Recep` trx id 12 783368819 lock_mode X locks rec but not gap waiting Record lock, heap no 84 PHYSICAL RECORD: n_fields 32; compact format; info bits 0 0: len 6; hex 00014d5cb446; asc M\ F;; 1: len 6; hex 000c2eb14202; asc . B ;; 2: len 7; hex 800004c0080110; asc ;; 3: len 4; hex 00000cdc; asc ;; 4: len 4; hex 0000001b; asc ;; 5: len 1; hex 00; asc ;; 6: len 4; hex 00000000; asc ;; 7: len 1; hex 00; asc ;; 8: len 8; hex 80001245b6a1a68a; asc E ;; 9: len 1; hex 02; asc ;; 10: len 15; hex 343730303131303530202020202020; asc 470011050 ;; 11: len 15; hex 303635323030303930202020202020; asc 065200090 ;; 12: len 6; hex 303030303030; asc 000000;; 13: len 4; hex 00000000; asc ;; 14: len 1; hex 00; asc ;; 15: len 2; hex 0000; asc ;; 16: len 1; hex 08; asc ;; 17: len 1; hex 00; asc ;; 18: len 1; hex 00; asc ;; 19: len 1; hex 57; asc W;; 20: len 1; hex 6b; asc k;; 21: len 3; hex 800000; asc ;; 22: len 3; hex 800000; asc ;; 23: len 3; hex 800000; asc ;; 24: len 3; hex 800000; asc ;; 25: len 3; hex 800000; asc ;; 26: len 4; hex 00000000; asc ;; 27: len 1; hex 00; asc ;; 28: len 4; hex 00000000; asc ;; 29: len 8; hex 80001245b6a1f69f; asc E ;; 30: len 8; hex 80001245b6a1a87a; asc E z;; 31: SQL NULL; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 12 809647808 Purge done for trx's n:o < 12 809635860 undo n:o < 0 0 History list length 2446 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 12 809647547, not started, process no 30827, OS thread id 49081248 MySQL thread id 204808, query id 93226129 195.7.104.217 mastercom3 ---TRANSACTION 12 809646643, not started, process no 30827, OS thread id 144214944 MySQL thread id 204807, query id 93225305 195.7.104.217 mastercom3 ---TRANSACTION 12 809644702, not started, process no 30827, OS thread id 143010720 MySQL thread id 204797, query id 93223545 195.7.104.217 mastercom3 ---TRANSACTION 12 809647331, not started, process no 30827, OS thread id 82484128 MySQL thread id 204794, query id 93225933 195.7.104.197 mastercom2 ---TRANSACTION 12 809643736, not started, process no 30827, OS thread id 75742112 MySQL thread id 204793, query id 93222666 195.7.104.197 mastercom2 ---TRANSACTION 12 809647725, not started, process no 30827, OS thread id 154966944 MySQL thread id 204792, query id 93226286 195.7.104.197 mastercom2 ---TRANSACTION 12 809647408, not started, process no 30827, OS thread id 70032288 MySQL thread id 204791, query id 93226000 195.7.104.197 mastercom2 ---TRANSACTION 12 809646443, not started, process no 30827, OS thread id 151686048 MySQL thread id 204790, query id 93225122 195.7.104.197 mastercom2 ---TRANSACTION 12 809647726, not started, process no 30827, OS thread id 76344224 MySQL thread id 204789, query id 93226288 195.7.104.197 mastercom2 ---TRANSACTION 12 809642181, not started, process no 30827, OS thread id 157174688 MySQL thread id 204781, query id 93221335 195.7.104.195 mastercom1 ---TRANSACTION 12 809644682, not started, process no 30827, OS thread id 67824544 MySQL thread id 204762, query id 93223525 195.7.104.217 mastercom3 ---TRANSACTION 12 809642413, not started, process no 30827, OS thread id 152488864 MySQL thread id 204759, query id 93221536 195.7.104.195 mastercom1 ---TRANSACTION 12 809647539, not started, process no 30827, OS thread id 143211424 MySQL thread id 204758, query id 93226124 195.7.104.217 mastercom3 ---TRANSACTION 12 809642344, not started, process no 30827, OS thread id 68627360 MySQL thread id 204757, query id 93221479 195.7.104.195 mastercom1 ---TRANSACTION 12 809642968, not started, process no 30827, OS thread id 145017760 MySQL thread id 204756, query id 93221990 195.7.104.195 mastercom1 ---TRANSACTION 12 809644037, not started, process no 30827, OS thread id 60615584 MySQL thread id 204748, query id 93222942 84.55.154.2 mastercom4 ---TRANSACTION 12 809643239, not started, process no 30827, OS thread id 72285088 MySQL thread id 204747, query id 93222217 84.55.154.2 mastercom4 ---TRANSACTION 12 809646517, not started, process no 30827, OS thread id 145218464 MySQL thread id 204746, query id 93225189 84.55.154.2 mastercom4 ---TRANSACTION 12 809642583, not started, process no 30827, OS thread id 70232992 MySQL thread id 204743, query id 93221681 195.7.104.204 mastercom6 ---TRANSACTION 12 809647805, not started, process no 30827, OS thread id 72084384 MySQL thread id 204742, query id 93226363 195.7.104.204 mastercom6 ---TRANSACTION 12 809647787, not started, process no 30827, OS thread id 150682528 MySQL thread id 204741, query id 93226347 195.7.104.204 mastercom6 ---TRANSACTION 12 809647768, not started, process no 30827, OS thread id 60816288 MySQL thread id 204740, query id 93226331 195.7.104.204 mastercom6 ---TRANSACTION 12 809647788, not started, process no 30827, OS thread id 159026080 MySQL thread id 204739, query id 93226348 195.7.104.204 mastercom6 ---TRANSACTION 12 809647670, not started, process no 30827, OS thread id 151284640 MySQL thread id 204738, query id 93226237 195.7.104.204 mastercom6 ---TRANSACTION 12 809647487, not started, process no 30827, OS thread id 152288160 MySQL thread id 204728, query id 93226075 84.55.154.28 mastercom5 ---TRANSACTION 12 809647431, not started, process no 30827, OS thread id 144817056 MySQL thread id 204727, query id 93226021 84.55.154.28 mastercom5 ---TRANSACTION 12 809647575, not started, process no 30827, OS thread id 151485344 MySQL thread id 204726, query id 93226157 84.55.154.28 mastercom5 ---TRANSACTION 12 809647712, not started, process no 30827, OS thread id 159427488 MySQL thread id 204725, query id 93226272 84.55.154.28 mastercom5 ---TRANSACTION 12 809640648, not started, process no 30827, OS thread id 153090976 MySQL thread id 204707, query id 93219932 195.7.104.217 mastercom3 ---TRANSACTION 0 0, not started, process no 30827, OS thread id 146668448 MySQL thread id 204678, query id 93226365 localhost root SHOW INNODB STATUS ---TRANSACTION 12 809647249, not started, process no 30827, OS thread id 78441376 MySQL thread id 204680, query id 93225855 84.55.154.28 mastercom5 ---TRANSACTION 12 809645525, not started, process no 30827, OS thread id 60414880 MySQL thread id 204679, query id 93224288 84.55.154.28 mastercom5 ---TRANSACTION 12 809646977, not started, process no 30827, OS thread id 71883680 MySQL thread id 204668, query id 93225608 195.7.104.217 mastercom3 ---TRANSACTION 12 809647650, not started, process no 30827, OS thread id 80276384 MySQL thread id 204655, query id 93226218 195.7.104.204 mastercom6 ---TRANSACTION 12 809647638, not started, process no 30827, OS thread id 73489312 MySQL thread id 204654, query id 93226211 195.7.104.204 mastercom6 ---TRANSACTION 12 809647686, not started, process no 30827, OS thread id 156171168 MySQL thread id 204653, query id 93226250 195.7.104.204 mastercom6 ---TRANSACTION 12 809647777, not started, process no 30827, OS thread id 149478304 MySQL thread id 204652, query id 93226337 195.7.104.204 mastercom6 ---TRANSACTION 12 809612679, not started, process no 30827, OS thread id 149879712 MySQL thread id 204628, query id 93194885 195.7.104.217 mastercom3 ---TRANSACTION 12 809644187, not started, process no 30827, OS thread id 156973984 MySQL thread id 204552, query id 93223079 84.55.154.2 mastercom4 ---TRANSACTION 12 809647675, not started, process no 30827, OS thread id 152087456 MySQL thread id 204505, query id 93226241 195.7.104.197 mastercom2 ---TRANSACTION 12 809645732, not started, process no 30827, OS thread id 150281120 MySQL thread id 204500, query id 93224474 195.7.104.195 mastercom1 ---TRANSACTION 12 809645720, not started, process no 30827, OS thread id 67222432 MySQL thread id 204499, query id 93224464 195.7.104.195 mastercom1 ---TRANSACTION 12 809645708, not started, process no 30827, OS thread id 158423968 MySQL thread id 204498, query id 93224453 195.7.104.195 mastercom1 ---TRANSACTION 12 809645858, not started, process no 30827, OS thread id 75942816 MySQL thread id 204497, query id 93224589 195.7.104.195 mastercom1 ---TRANSACTION 12 809643916, not started, process no 30827, OS thread id 81480608 MySQL thread id 204440, query id 93222835 84.55.154.2 mastercom4 ---TRANSACTION 12 809647609, not started, process no 30827, OS thread id 155569056 MySQL thread id 204433, query id 93226189 84.55.154.28 mastercom5 ---TRANSACTION 12 809647512, not started, process no 30827, OS thread id 85830560 MySQL thread id 204432, query id 93226100 84.55.154.28 mastercom5 ---TRANSACTION 12 809645520, not started, process no 30827, OS thread id 81882016 MySQL thread id 204389, query id 93224285 84.55.154.2 mastercom4 ---TRANSACTION 12 809645694, not started, process no 30827, OS thread id 46136224 MySQL thread id 204387, query id 93224440 84.55.154.2 mastercom4 ---TRANSACTION 12 809646597, not started, process no 30827, OS thread id 78642080 MySQL thread id 204386, query id 93225257 84.55.154.2 mastercom4 ---TRANSACTION 12 809646586, not started, process no 30827, OS thread id 75541408 MySQL thread id 204385, query id 93225247 84.55.154.2 mastercom4 ---TRANSACTION 12 809646575, not started, process no 30827, OS thread id 151083936 MySQL thread id 204384, query id 93225235 84.55.154.2 mastercom4 ---TRANSACTION 12 809646646, not started, process no 30827, OS thread id 155167648 MySQL thread id 204237, query id 93225308 195.7.104.217 mastercom3 ---TRANSACTION 12 809643183, not started, process no 30827, OS thread id 155769760 MySQL thread id 204072, query id 93222171 195.7.104.195 mastercom1 ---TRANSACTION 12 809586419, not started, process no 30827, OS thread id 159226784 MySQL thread id 204007, query id 93170999 195.7.104.189 mastercom7 ---TRANSACTION 12 809645521, not started, process no 30827, OS thread id 156773280 MySQL thread id 203950, query id 93224286 84.55.154.28 mastercom5 ---TRANSACTION 12 809647545, not started, process no 30827, OS thread id 75340704 MySQL thread id 203822, query id 93226128 195.7.104.197 mastercom2 ---TRANSACTION 12 809646003, not started, process no 30827, OS thread id 163339168 MySQL thread id 203637, query id 93224724 195.7.104.197 mastercom2 ---TRANSACTION 12 809647037, not started, process no 30827, OS thread id 70634400 MySQL thread id 203010, query id 93225664 84.55.154.28 mastercom5 ---TRANSACTION 12 809484269, not started, process no 30827, OS thread id 76143520 MySQL thread id 202722, query id 93077640 195.7.104.189 mastercom7 ---TRANSACTION 12 807376554, not started, process no 30827, OS thread id 144014240 MySQL thread id 202568, query id 91155986 83.68.101.162 dbadmin ---TRANSACTION 12 809613191, not started, process no 30827, OS thread id 48880544 MySQL thread id 201976, query id 93195337 195.7.104.195 mastercom1 ---TRANSACTION 12 809644925, not started, process no 30827, OS thread id 150883232 MySQL thread id 199016, query id 93223744 195.7.104.197 mastercom2 ---TRANSACTION 12 809647424, not started, process no 30827, OS thread id 73890720 MySQL thread id 198916, query id 93226016 84.55.154.28 mastercom5 ---TRANSACTION 12 809646450, not started, process no 30827, OS thread id 68828064 MySQL thread id 195803, query id 93225127 84.55.154.2 mastercom4 ---TRANSACTION 12 800125508, not started, process no 30827, OS thread id 68025248 MySQL thread id 195409, query id 84532505 83.68.101.162 dbadmin ---TRANSACTION 12 809646484, not started, process no 30827, OS thread id 80075680 MySQL thread id 193699, query id 93225163 195.7.104.189 mastercom7 ---TRANSACTION 12 809647466, not started, process no 30827, OS thread id 154565536 MySQL thread id 185341, query id 93226057 195.7.104.204 mastercom6 ---TRANSACTION 12 809588815, not started, process no 30827, OS thread id 144415648 MySQL thread id 179833, query id 93173155 195.7.104.197 mastercom2 ---TRANSACTION 12 809621362, not started, process no 30827, OS thread id 72686496 MySQL thread id 179535, query id 93202857 84.55.154.2 mastercom4 ---TRANSACTION 12 809609316, not started, process no 30827, OS thread id 158624672 MySQL thread id 179364, query id 93191854 84.55.154.2 mastercom4 ---TRANSACTION 12 809646873, not started, process no 30827, OS thread id 150481824 MySQL thread id 179084, query id 93225514 195.7.104.217 mastercom3 ---TRANSACTION 12 809647795, not started, process no 30827, OS thread id 152890272 MySQL thread id 178573, query id 93226355 195.7.104.204 mastercom6 ---TRANSACTION 12 809647432, not started, process no 30827, OS thread id 82082720 MySQL thread id 177673, query id 93226022 84.55.154.2 mastercom4 ---TRANSACTION 12 809646566, not started, process no 30827, OS thread id 78039968 MySQL thread id 177508, query id 93225229 195.7.104.189 mastercom7 ---TRANSACTION 0 0, not started, process no 30827, OS thread id 72887200 MySQL thread id 167404, query id 93220698 83.68.101.162 dbadmin ---TRANSACTION 12 809646413, not started, process no 30827, OS thread id 151886752 MySQL thread id 174668, query id 93225097 195.7.104.197 mastercom2 ---TRANSACTION 12 809646417, not started, process no 30827, OS thread id 158825376 MySQL thread id 174589, query id 93225099 84.55.154.2 mastercom4 ---TRANSACTION 12 809647415, not started, process no 30827, OS thread id 68426656 MySQL thread id 174443, query id 93226007 195.7.104.197 mastercom2 ---TRANSACTION 12 809646610, not started, process no 30827, OS thread id 159628192 MySQL thread id 174342, query id 93225272 84.55.154.28 mastercom5 ---TRANSACTION 12 809618115, not started, process no 30827, OS thread id 86031264 MySQL thread id 174322, query id 93199844 195.7.104.197 mastercom2 ---TRANSACTION 12 809587447, not started, process no 30827, OS thread id 155970464 MySQL thread id 174266, query id 93171936 195.7.104.217 mastercom3 ---TRANSACTION 12 809645036, not started, process no 30827, OS thread id 149277600 MySQL thread id 173474, query id 93223847 195.7.104.204 mastercom6 ---TRANSACTION 12 809647341, not started, process no 30827, OS thread id 69831584 MySQL thread id 168774, query id 93225942 195.7.104.217 mastercom3 ---TRANSACTION 12 809623573, not started, process no 30827, OS thread id 70433696 MySQL thread id 168655, query id 93204790 84.55.154.2 mastercom4 ---TRANSACTION 12 809647192, not started, process no 30827, OS thread id 78240672 MySQL thread id 167907, query id 93225805 195.7.104.217 mastercom3 ---TRANSACTION 12 809645899, not started, process no 30827, OS thread id 163740576 MySQL thread id 166873, query id 93224631 84.55.154.28 mastercom5 ---TRANSACTION 12 809646972, not started, process no 30827, OS thread id 80477088 MySQL thread id 165964, query id 93225603 84.55.154.2 mastercom4 ---TRANSACTION 12 809645548, not started, process no 30827, OS thread id 88730528 MySQL thread id 164289, query id 93224310 195.7.104.204 mastercom6 ---TRANSACTION 12 809647167, not started, process no 30827, OS thread id 156371872 MySQL thread id 160458, query id 93225784 84.55.154.28 mastercom5 ---TRANSACTION 12 809647172, not started, process no 30827, OS thread id 69229472 MySQL thread id 157968, query id 93225790 195.7.104.204 mastercom6 ---TRANSACTION 12 809646169, not started, process no 30827, OS thread id 73087904 MySQL thread id 156758, query id 93224871 195.7.104.217 mastercom3 ---TRANSACTION 12 809646380, not started, process no 30827, OS thread id 67423136 MySQL thread id 154104, query id 93225068 195.7.104.197 mastercom2 ---TRANSACTION 12 809604583, not started, process no 30827, OS thread id 73288608 MySQL thread id 153851, query id 93187428 195.7.104.217 mastercom3 ---TRANSACTION 12 809645702, not started, process no 30827, OS thread id 68225952 MySQL thread id 149638, query id 93224446 195.7.104.217 mastercom3 ---TRANSACTION 12 809616367, not started, process no 30827, OS thread id 156572576 MySQL thread id 146017, query id 93198261 195.7.104.217 mastercom3 ---TRANSACTION 12 809628717, not started, process no 30827, OS thread id 160230304 MySQL thread id 140308, query id 93209247 195.7.104.217 mastercom3 ---TRANSACTION 12 809644163, not started, process no 30827, OS thread id 142609312 MySQL thread id 138070, query id 93223058 195.7.104.197 mastercom2 ---TRANSACTION 12 809646438, not started, process no 30827, OS thread id 160029600 MySQL thread id 135321, query id 93225118 195.7.104.204 mastercom6 ---TRANSACTION 12 809646908, not started, process no 30827, OS thread id 163138464 MySQL thread id 134685, query id 93225545 195.7.104.217 mastercom3 ---TRANSACTION 12 809646333, not started, process no 30827, OS thread id 69430176 MySQL thread id 134546, query id 93225028 195.7.104.197 mastercom2 ---TRANSACTION 12 809647624, not started, process no 30827, OS thread id 66821024 MySQL thread id 134409, query id 93226199 195.7.104.217 mastercom3 ---TRANSACTION 12 809647763, not started, process no 30827, OS thread id 142408608 MySQL thread id 134286, query id 93226325 84.55.154.28 mastercom5 ---TRANSACTION 12 809599026, not started, process no 30827, OS thread id 160431008 MySQL thread id 133789, query id 93182438 195.7.104.217 mastercom3 ---TRANSACTION 12 809646337, not started, process no 30827, OS thread id 226401184 MySQL thread id 132529, query id 93225031 195.7.104.217 mastercom3 ---TRANSACTION 12 809623579, not started, process no 30827, OS thread id 88529824 MySQL thread id 130647, query id 93204795 195.7.104.217 mastercom3 ---TRANSACTION 12 809646708, not started, process no 30827, OS thread id 152689568 MySQL thread id 129374, query id 93225367 84.55.154.2 mastercom4 ---TRANSACTION 12 809647797, not started, process no 30827, OS thread id 148675488 MySQL thread id 118857, query id 93226357 195.7.104.204 mastercom6 ---TRANSACTION 12 809647254, not started, process no 30827, OS thread id 159828896 MySQL thread id 118233, query id 93225863 84.55.154.28 mastercom5 ---TRANSACTION 12 809646816, not started, process no 30827, OS thread id 67623840 MySQL thread id 117583, query id 93225460 195.7.104.204 mastercom6 ---TRANSACTION 12 809646391, not started, process no 30827, OS thread id 143813536 MySQL thread id 115041, query id 93225076 195.7.104.204 mastercom6 ---TRANSACTION 12 809647798, not started, process no 30827, OS thread id 149679008 MySQL thread id 114748, query id 93226358 195.7.104.204 mastercom6 ---TRANSACTION 12 809647647, not started, process no 30827, OS thread id 150080416 MySQL thread id 106557, query id 93226216 195.7.104.204 mastercom6 ---TRANSACTION 12 809646716, not started, process no 30827, OS thread id 81681312 MySQL thread id 83281, query id 93225375 195.7.104.217 mastercom3 ---TRANSACTION 12 809647641, not started, process no 30827, OS thread id 142207904 MySQL thread id 11949, query id 93226213 195.7.104.189 mastercom7 ---TRANSACTION 12 809647252, not started, process no 30827, OS thread id 73690016 MySQL thread id 11916, query id 93225859 195.7.104.189 web ---TRANSACTION 12 809647026, not started, process no 30827, OS thread id 143412128 MySQL thread id 11867, query id 93225652 195.7.104.189 mastercom7 ---TRANSACTION 12 809647736, not started, process no 30827, OS thread id 72485792 MySQL thread id 11865, query id 93226300 195.7.104.189 mastercom7 ---TRANSACTION 12 809646872, not started, process no 30827, OS thread id 81079200 MySQL thread id 11843, query id 93225513 195.7.104.189 mastercom7 ---TRANSACTION 12 809647228, not started, process no 30827, OS thread id 80677792 MySQL thread id 11780, query id 93225838 195.7.104.189 mastercom7 ---TRANSACTION 12 809592702, not started, process no 30827, OS thread id 88931232 MySQL thread id 727, query id 93176710 195.7.104.195 web ---TRANSACTION 0 0, not started, process no 30827, OS thread id 64523168 MySQL thread id 224, query id 93168494 78.155.135.4 dbadmin ---TRANSACTION 12 809586899, not started, process no 30827, OS thread id 80878496 MySQL thread id 221, query id 93171437 195.7.104.197 web ---TRANSACTION 12 809646579, not started, process no 30827, OS thread id 67021728 MySQL thread id 169, query id 93225239 195.7.104.189 web ---TRANSACTION 12 809647718, not started, process no 30827, OS thread id 81279904 MySQL thread id 109, query id 93226279 195.7.104.197 mastercom2 ---TRANSACTION 12 809647723, not started, process no 30827, OS thread id 82283424 MySQL thread id 98, query id 93226282 84.55.154.28 mastercom5 ---TRANSACTION 12 809647488, not started, process no 30827, OS thread id 76544928 MySQL thread id 94, query id 93226076 195.7.104.195 mastercom1 ---TRANSACTION 12 809647696, not started, process no 30827, OS thread id 142810016 MySQL thread id 81, query id 93226257 195.7.104.217 mastercom3 ---TRANSACTION 12 809647351, not started, process no 30827, OS thread id 144616352 MySQL thread id 72, query id 93225950 195.7.104.197 mastercom2 ---TRANSACTION 12 809647735, not started, process no 30827, OS thread id 143612832 MySQL thread id 77, query id 93226299 84.55.154.2 mastercom4 ---TRANSACTION 12 809646916, not started, process no 30827, OS thread id 146869152 MySQL thread id 66, query id 93225551 195.7.104.189 mastercom7 ---TRANSACTION 12 809646847, not started, process no 30827, OS thread id 147069856 MySQL thread id 65, query id 93225490 195.7.104.189 mastercom7 ---TRANSACTION 12 809646805, not started, process no 30827, OS thread id 147270560 MySQL thread id 64, query id 93225452 195.7.104.189 mastercom7 ---TRANSACTION 12 809647396, not started, process no 30827, OS thread id 147471264 MySQL thread id 63, query id 93225989 195.7.104.189 mastercom7 ---TRANSACTION 12 809647202, not started, process no 30827, OS thread id 147671968 MySQL thread id 62, query id 93225814 195.7.104.189 mastercom7 ---TRANSACTION 12 809646554, not started, process no 30827, OS thread id 145419168 MySQL thread id 68, query id 93225221 195.7.104.204 mastercom6 ---TRANSACTION 12 809647373, not started, process no 30827, OS thread id 147872672 MySQL thread id 61, query id 93225971 195.7.104.217 mastercom3 ---TRANSACTION 12 809647799, not started, process no 30827, OS thread id 148274080 MySQL thread id 59, query id 93226359 195.7.104.217 mastercom3 ---TRANSACTION 12 809647576, not started, process no 30827, OS thread id 148876192 MySQL thread id 56, query id 93226158 195.7.104.217 mastercom3 ---TRANSACTION 12 809646175, not started, process no 30827, OS thread id 148073376 MySQL thread id 60, query id 93224879 195.7.104.217 mastercom3 ---TRANSACTION 12 809647420, not started, process no 30827, OS thread id 149076896 MySQL thread id 55, query id 93226013 195.7.104.217 mastercom3 ---TRANSACTION 12 809647333, not started, process no 30827, OS thread id 148474784 MySQL thread id 58, query id 93225935 195.7.104.217 mastercom3 ---TRANSACTION 12 809647569, not started, process no 30827, OS thread id 155368352 MySQL thread id 29, query id 93226153 195.7.104.197 mastercom2 ---TRANSACTION 12 809647507, not started, process no 30827, OS thread id 154364832 MySQL thread id 34, query id 93226097 195.7.104.217 mastercom3 ---TRANSACTION 12 809647140, not started, process no 30827, OS thread id 154766240 MySQL thread id 32, query id 93225761 195.7.104.217 mastercom3 ---TRANSACTION 12 809647806, not started, process no 30827, OS thread id 163539872 MySQL thread id 4, query id 93226364 195.7.104.204 mastercom6 ---TRANSACTION 12 809647801, not started, process no 30827, OS thread id 163941280 MySQL thread id 3, query id 93226360 Has read all relay log; waiting for the slave I/O thread to update it -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 3400 OS file reads, 85309927 OS file writes, 144147 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 1511.76 writes/s, 1.90 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5, seg size 7, 0 inserts, 0 merged recs, 0 merges Hash table size 8850487, used cells 10333, node heap has 11 buffer(s) 17553.43 hash searches/s, 16873.71 non-hash searches/s --- LOG --- Log sequence number 3209 4274704740 Log flushed up to 3209 4274551708 Last checkpoint at 3209 4225255874 0 pending log writes, 0 pending chkp writes 85199739 log i/o's done, 1510.73 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2340474392; in additional pool allocated 1048576 Buffer pool size 131072 Free buffers 122236 Database pages 8825 Modified db pages 944 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 3483, created 5342, written 710281 0.00 reads/s, 0.03 creates/s, 20.93 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 30827, id 760302496, state: sleeping Number of rows inserted 25582139, updated 23286503, deleted 25105307, read 1575727564 457.99 inserts/s, 412.57 updates/s, 455.60 deletes/s, 23849.88 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ And the result of SHOW CREATE TABLE T_Recep\G is: *************************** 1. row *************************** Table: T_Recep Create Table: CREATE TABLE `T_Recep` ( `RcClientCode` int(3) unsigned NOT NULL default '1', `RcMCUCode` int(3) unsigned NOT NULL default '0', `RcCommCode` tinyint(1) unsigned NOT NULL default '0', `RcCommInd` int(2) unsigned NOT NULL default '0', `RcRetCode` tinyint(1) unsigned default '0', `RcEventDate` datetime default '0000-00-00 00:00:00', `RcEventState` tinyint(1) unsigned NOT NULL default '0', `RcChLongitude` char(15) default '0', `RcChLatitude` char(15) default '0', `RcDriverKey` char(6) default '0', `RcKms` float default '0', `RcSpeed` tinyint(1) unsigned NOT NULL default '0', `RcDirection` smallint(2) unsigned default '0', `RcNumSat` tinyint(1) unsigned default '0', `RcAlarmFlagIO` tinyint(1) unsigned default '0', `RcAlarmInd` tinyint(1) unsigned default '0', `RcQualGSM` tinyint(1) unsigned default NULL, `RcHdop` tinyint(1) unsigned NOT NULL default '0', `RcDurationDriving` time NOT NULL default '00:00:00', `RcDurationRest` time NOT NULL default '00:00:00', `RcDurationWork` time NOT NULL default '00:00:00', `RcDurationCurrDriving` time NOT NULL default '00:00:00', `RcDurationCurrRest` time NOT NULL default '00:00:00', `RcMission` int(2) unsigned NOT NULL default '0', `RcFlagTrait` tinyint(1) unsigned NOT NULL default '0', `RcReceiveBits` int(1) unsigned NOT NULL default '0', `RcInsert` datetime default NULL, `RcCnxAT` datetime default NULL, `RcExtraData` longblob, KEY `PrimaryKey` (`RcEventDate`,`RcMCUCode`,`RcCommCode`,`RcClientCode`,`RcCommInd`), KEY `CLE_1` (`RcClientCode`), KEY `CLE_2` (`RcFlagTrait`,`RcClientCode`), KEY `CLE_3` (`RcClientCode`,`RcMCUCode`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Thanks for your help.