show engine innodb status发现deadlock

show engine innodb status发现deadlock

mysql> show engine innodb status\G*************************** 1. row ***************************  Type: InnoDB  Name: Status: =====================================2014-06-20 15:07:49 7f975bb5c700 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 43 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 6060983 srv_active, 0 srv_shutdown, 26993 srv_idlesrv_master_thread log flush and writes: 6085668----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count 8720007498OS WAIT ARRAY INFO: signal count 8347597945Mutex spin waits 231539924988, rounds 2719968232096, OS waits 4633791667RW-shared spins 1593278807, rounds 27590420428, OS waits 804786677RW-excl spins 202775387, rounds 3052976458, OS waits 30388091Spin rounds per wait: -7004.65 mutex, 17.32 RW-shared, 15.06 RW-excl------------------------LATEST DETECTED DEADLOCK------------------------2014-05-27 18:29:00 7f958ae39700*** (1) TRANSACTION:TRANSACTION 603580589, ACTIVE 0 sec insertingmysql tables in use 1, locked 1LOCK WAIT 3 lock struct(s), heap size 376, 2 row lock(s)MySQL thread id 174548012, OS thread handle 0x7f9553d75700, query id 871733995 192.168.30.5 golo updateINSERT INTO `trip_record_tmp_b`(`uid`,`s_lat`,`s_lon`,`e_lat`,`e_lon`,`serial_no`,`sdate`,`edate`,`data`,`travel_id`,`issynchro`) VALUES('84bc2f352552a5241a600f661432bc2e','','','','','967790023150','2014-05-27 17:55:27','2014-05-27 18:15:59','null','3caae5f2-4c0f-461f-a7be-3fe9070732d6','1')*** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 15172 page no 237737 n bits 80 index `PRIMARY` of table `db_application`.`trip_record_tmp_b` trx id 603580589 lock_mode X locks rec but not gap waitingRecord lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 30; hex 383462633266333532353532613532343161363030663636313433326263; asc 84bc2f352552a5241a600f661432bc; (total 32 bytes); 1: len 6; hex 000023f9e8a7; asc   #   ;; 2: len 7; hex 46000028081c52; asc F  (  R;; 3: len 4; hex 6e756c6c; asc null;; 4: len 30; hex 33636161653566322d346330662d343631662d613762652d336665393037; asc 3caae5f2-4c0f-461f-a7be-3fe907; (total 36 bytes); 5: len 0; hex ; asc ;; 6: len 0; hex ; asc ;; 7: len 0; hex ; asc ;; 8: len 0; hex ; asc ;; 9: len 5; hex 9992f71ddb; asc      ;; 10: len 5; hex 9992f723fb; asc    # ;; 11: len 12; hex 393637373930303233313530; asc 967790023150;; 12: len 4; hex 00000001; asc     ;;*** (2) TRANSACTION:TRANSACTION 603580587, ACTIVE 0 sec insertingmysql tables in use 1, locked 13 lock struct(s), heap size 376, 2 row lock(s)MySQL thread id 174940322, OS thread handle 0x7f958ae39700, query id 871733992 192.168.30.5 golo updateINSERT INTO `trip_record_tmp_b`(`uid`,`s_lat`,`s_lon`,`e_lat`,`e_lon`,`serial_no`,`sdate`,`edate`,`data`,`travel_id`,`issynchro`) VALUES('84bc2f352552a5241a600f661432bc2e','22.563603','113.89169','22.584672','113.86702','967790023150','2014-05-27 17:55:27','2014-05-27 18:15:59','[{\"Latitude\":\"22.563603\",\"Longitude\":\"113.89169\"},{\"Latitude\":\"22.563213\",\"Longitude\":\"113.89181\"},{\"Latitude\":\"22.563020\",\"Longitude\":\"113.89158\"},{\"Latitude\":\"22.563082\",\"Longitude\":\"113.89128\"},{\"Latitude\":\"22.563298\",\"Longitude\":\"113.89098\"},{\"Latitude\":\"22.563590\",\"Longitude\":\"113.89104\"},{\"Latitude\":\"22.563842\",\"Longitude\":\"113.89083\"},{\"Latitude\":\"22.564328\",\"Longitude\":\"113.89016\"},{\"Latitude\":\"22.564692\",\"Longitude\":\"113.88978\"},{\"Latitude\":\"22.565124\",\"Longitude\":\"113.88929\"},{\"Latitude\":\"22.565547\",\"Longitude\":\"113.88887\"},{\"Latitude*** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 15172 page no 237737 n bits 80 index `PRIMARY` of table `db_application`.`trip_record_tmp_b` trx id 603580587 lock mode S locks rec but not gapRecord lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 30; hex 383462633266333532353532613532343161363030663636313433326263; asc 84bc2f352552a5241a600f661432bc; (total 32 bytes); 1: len 6; hex 000023f9e8a7; asc   #   ;; 2: len 7; hex 46000028081c52; asc F  (  R;; 3: len 4; hex 6e756c6c; asc null;; 4: len 30; hex 33636161653566322d346330662d343631662d613762652d336665393037; asc 3caae5f2-4c0f-461f-a7be-3fe907; (total 36 bytes); 5: len 0; hex ; asc ;; 6: len 0; hex ; asc ;; 7: len 0; hex ; asc ;; 8: len 0; hex ; asc ;; 9: len 5; hex 9992f71ddb; asc      ;; 10: len 5; hex 9992f723fb; asc    # ;; 11: len 12; hex 393637373930303233313530; asc 967790023150;; 12: len 4; hex 00000001; asc     ;;*** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 15172 page no 237737 n bits 80 index `PRIMARY` of table `db_application`.`trip_record_tmp_b` trx id 603580587 lock_mode X locks rec but not gap waitingRecord lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 30; hex 383462633266333532353532613532343161363030663636313433326263; asc 84bc2f352552a5241a600f661432bc; (total 32 bytes); 1: len 6; hex 000023f9e8a7; asc   #   ;; 2: len 7; hex 46000028081c52; asc F  (  R;; 3: len 4; hex 6e756c6c; asc null;; 4: len 30; hex 33636161653566322d346330662d343631662d613762652d336665393037; asc 3caae5f2-4c0f-461f-a7be-3fe907; (total 36 bytes); 5: len 0; hex ; asc ;; 6: len 0; hex ; asc ;; 7: len 0; hex ; asc ;; 8: len 0; hex ; asc ;; 9: len 5; hex 9992f71ddb; asc      ;; 10: len 5; hex 9992f723fb; asc    # ;; 11: len 12; hex 393637373930303233313530; asc 967790023150;; 12: len 4; hex 00000001; asc     ;;*** WE ROLL BACK TRANSACTION (2)------------TRANSACTIONS------------Trx id counter 1070470523Purge done for trx's n:o < 1070470521 undo n:o < 0 state: running but idleHistory list length 2311LIST OF TRANSACTIONS FOR EACH SESSION:---TRANSACTION 0, not startedMySQL thread id 324245045, OS thread handle 0x7f9552bf0700, query id 1601328902 192.168.30.2 golo cleaning up---TRANSACTION 0, not startedMySQL thread id 323103860, OS thread handle 0x7f975bb5c700, query id 1601328900 localhost root initshow engine innodb status---TRANSACTION 1070440054, not startedMySQL thread id 324188163, OS thread handle 0x7f9552cf4700, query id 1601280049 192.168.30.83 golo cleaning up---TRANSACTION 1070440060, not startedMySQL thread id 324188149, OS thread handle 0x7f975814c700, query id 1601280080 192.168.30.83 golo cleaning up---TRANSACTION 1070467755, not startedMySQL thread id 324169376, OS thread handle 0x7f9751e20700, query id 1601323957 192.168.30.81 golo cleaning up---TRANSACTION 1070460753, not startedMySQL thread id 324158238, OS thread handle 0x7f975294c700, query id 1601314632 192.168.30.81 golo cleaning up---TRANSACTION 1070468351, not startedMySQL thread id 324145850, OS thread handle 0x7f95881ca700, query id 1601325052 192.168.30.81 golo cleaning up---TRANSACTION 1070464368, not startedMySQL thread id 324066670, OS thread handle 0x7f97580ca700, query id 1601319626 192.168.30.80 golo cleaning up---TRANSACTION 1070462151, not startedMySQL thread id 324064818, OS thread handle 0x7f9589c73700, query id 1601317045 192.168.30.80 golo cleaning up---TRANSACTION 1070469584, not startedMySQL thread id 324048910, OS thread handle 0x7f955328a700, query id 1601327292 192.168.30.81 golo cleaning up---TRANSACTION 1070461303, not startedMySQL thread id 324044580, OS thread handle 0x7f955a34e700, query id 1601315602 192.168.30.81 golo cleaning up---TRANSACTION 1070469095, not startedMySQL thread id 324040723, OS thread handle 0x7f958a24a700, query id 1601326457 192.168.30.81 golo cleaning up---TRANSACTION 1070424669, not startedMySQL thread id 324026147, OS thread handle 0x7f9589d77700, query id 1601270601 192.168.30.80 golo cleaning up---TRANSACTION 1070462337, not startedMySQL thread id 324025340, OS thread handle 0x7f958aebb700, query id 1601317353 192.168.30.80 golo cleaning up---TRANSACTION 1070392027, not startedMySQL thread id 324021109, OS thread handle 0x7f95589a9700, query id 1601231292 192.168.30.81 golo cleaning up---TRANSACTION 1070317177, not startedMySQL thread id 324019747, OS thread handle 0x7f9588c33700, query id 1601086454 192.168.30.81 golo cleaning up---TRANSACTION 1070464317, not startedMySQL thread id 324019274, OS thread handle 0x7f9588f80700, query id 1601319591 192.168.30.80 golo cleaning up---TRANSACTION 1070464407, not startedMySQL thread id 324019261, OS thread handle 0x7f958ba28700, query id 1601319654 192.168.30.80 golo cleaning up---TRANSACTION 1070458274, not startedMySQL thread id 324019214, OS thread handle 0x7f9588db9700, query id 1601310253 192.168.30.81 golo cleaning up---TRANSACTION 1070469575, not startedMySQL thread id 324018903, OS thread handle 0x7f95596dd700, query id 1601327279 192.168.30.81 golo cleaning up---TRANSACTION 1070430739, not startedMySQL thread id 324018585, OS thread handle 0x7f955a8e4700, query id 1601279466 192.168.30.80 golo cleaning up---TRANSACTION 1070469211, not startedMySQL thread id 324018544, OS thread handle 0x7f9550b2f700, query id 1601326672 192.168.30.80 golo cleaning up---TRANSACTION 1070469583, not startedMySQL thread id 324018422, OS thread handle 0x7f958abf0700, query id 1601327282 192.168.30.81 golo cleaning up---TRANSACTION 1070462360, not startedMySQL thread id 324018244, OS thread handle 0x7f95585da700, query id 1601317364 192.168.30.80 golo cleaning up---TRANSACTION 1070459911, not startedMySQL thread id 324018088, OS thread handle 0x7f9551598700, query id 1601313158 192.168.30.81 golo cleaning up---TRANSACTION 1070462363, not startedMySQL thread id 324017553, OS thread handle 0x7f955bbef700, query id 1601317388 192.168.30.80 golo cleaning up---TRANSACTION 1070469079, not startedMySQL thread id 323037712, OS thread handle 0x7f955161a700, query id 1601326435 192.168.30.60 xmpp cleaning up---TRANSACTION 1070446154, not startedMySQL thread id 322754879, OS thread handle 0x7f955b4d3700, query id 1601290918 192.168.30.60 xmpp cleaning up---TRANSACTION 1070456817, not startedMySQL thread id 322593679, OS thread handle 0x7f958a75e700, query id 1601307649 192.168.30.60 xmpp cleaning up---TRANSACTION 1070444417, not startedMySQL thread id 322593678, OS thread handle 0x7f975bada700, query id 1601288051 192.168.30.60 xmpp cleaning up---TRANSACTION 1070469841, not startedMySQL thread id 322111135, OS thread handle 0x7f9752a91700, query id 1601327742 192.168.30.60 xmpp cleaning up---TRANSACTION 1070388741, not startedMySQL thread id 321995454, OS thread handle 0x7f97518cb700, query id 1601199830 192.168.30.60 xmpp cleaning up---TRANSACTION 1070469814, not startedMySQL thread id 320882470, OS thread handle 0x7f955aaec700, query id 1601327705 192.168.30.61 xmpp cleaning up---TRANSACTION 1070461058, not startedMySQL thread id 320882469, OS thread handle 0x7f9753270700, query id 1601315215 192.168.30.61 xmpp cleaning up---TRANSACTION 1070461102, not startedMySQL thread id 320882468, OS thread handle 0x7f9558aad700, query id 1601315292 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469263, not startedMySQL thread id 320882471, OS thread handle 0x7f958bcf3700, query id 1601326747 192.168.30.61 xmpp cleaning up---TRANSACTION 1070463623, not startedMySQL thread id 320882466, OS thread handle 0x7f975bb1b700, query id 1601319054 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469637, not startedMySQL thread id 320882467, OS thread handle 0x7f9751272700, query id 1601327385 192.168.30.61 xmpp cleaning up---TRANSACTION 1070464268, not startedMySQL thread id 320882465, OS thread handle 0x7f9558c33700, query id 1601319551 192.168.30.61 xmpp cleaning up---TRANSACTION 1070463931, not startedMySQL thread id 320882438, OS thread handle 0x7f9551147700, query id 1601319300 192.168.30.61 xmpp cleaning up---TRANSACTION 1070459670, not startedMySQL thread id 320882436, OS thread handle 0x7f9559c32700, query id 1601312775 192.168.30.61 xmpp cleaning up---TRANSACTION 1070463601, not startedMySQL thread id 320882437, OS thread handle 0x7f958aa29700, query id 1601319034 192.168.30.61 xmpp cleaning up---TRANSACTION 1070463600, not startedMySQL thread id 320882434, OS thread handle 0x7f955334d700, query id 1601319033 192.168.30.61 xmpp cleaning up---TRANSACTION 1070461193, not startedMySQL thread id 320882435, OS thread handle 0x7f958b186700, query id 1601315440 192.168.30.61 xmpp cleaning up---TRANSACTION 1070461259, not startedMySQL thread id 320882433, OS thread handle 0x7f975006b700, query id 1601315539 192.168.30.61 xmpp cleaning up---TRANSACTION 1070462569, not startedMySQL thread id 320882420, OS thread handle 0x7f9752334700, query id 1601317755 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469631, not startedMySQL thread id 320882419, OS thread handle 0x7f9750d5e700, query id 1601327369 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469160, not startedMySQL thread id 320882417, OS thread handle 0x7f95531c7700, query id 1601326577 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469193, not startedMySQL thread id 320882415, OS thread handle 0x7f9559aac700, query id 1601326642 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469630, not startedMySQL thread id 320882416, OS thread handle 0x7f9553e38700, query id 1601327368 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469232, not startedMySQL thread id 320882418, OS thread handle 0x7f9829c02700, query id 1601326699 192.168.30.61 xmpp cleaning up---TRANSACTION 1070464585, not startedMySQL thread id 320882394, OS thread handle 0x7f958bb2c700, query id 1601319804 192.168.30.61 xmpp cleaning up---TRANSACTION 1070460833, not startedMySQL thread id 320882392, OS thread handle 0x7f9558599700, query id 1601314788 192.168.30.61 xmpp cleaning up---TRANSACTION 1070464651, not startedMySQL thread id 320882391, OS thread handle 0x7f9559f3e700, query id 1601319880 192.168.30.61 xmpp cleaning up---TRANSACTION 1070464741, not startedMySQL thread id 320882393, OS thread handle 0x7f9753374700, query id 1601319993 192.168.30.61 xmpp cleaning up---TRANSACTION 1070462494, not startedMySQL thread id 320882390, OS thread handle 0x7f975157e700, query id 1601317645 192.168.30.61 xmpp cleaning up---TRANSACTION 1070460844, not startedMySQL thread id 320882389, OS thread handle 0x7f958ae39700, query id 1601314824 192.168.30.61 xmpp cleaning up---TRANSACTION 1070461240, not startedMySQL thread id 320388300, OS thread handle 0x7f95883d2700, query id 1601315514 192.168.30.60 xmpp cleaning up---TRANSACTION 1070455246, not startedMySQL thread id 318289563, OS thread handle 0x7f975bb9d700, query id 1601304755 192.168.30.60 xmpp cleaning up---TRANSACTION 1070431949, not startedMySQL thread id 318289562, OS thread handle 0x7f95528e4700, query id 1601268805 192.168.30.60 xmpp cleaning up---TRANSACTION 1070457142, not startedMySQL thread id 318289561, OS thread handle 0x7f955b38e700, query id 1601308187 192.168.30.60 xmpp cleaning up---TRANSACTION 1070466912, not startedMySQL thread id 316814334, OS thread handle 0x7f9553d34700, query id 1601322496 192.168.30.60 xmpp cleaning up---TRANSACTION 1070460149, not startedMySQL thread id 316814333, OS thread handle 0x7f9552b6e700, query id 1601313606 192.168.30.60 xmpp cleaning up---TRANSACTION 1070457957, not startedMySQL thread id 316814332, OS thread handle 0x7f9829bc1700, query id 1601309665 192.168.30.60 xmpp cleaning up---TRANSACTION 1070458005, not startedMySQL thread id 316814331, OS thread handle 0x7f955b410700, query id 1601309737 192.168.30.60 xmpp cleaning up---TRANSACTION 1070398229, not startedMySQL thread id 316292792, OS thread handle 0x7f97521ae700, query id 1601214382 192.168.30.60 xmpp cleaning up---TRANSACTION 1070367049, not startedMySQL thread id 315542217, OS thread handle 0x7f9751b96700, query id 1601163050 192.168.30.60 xmpp cleaning up---TRANSACTION 1070324250, not startedMySQL thread id 315542216, OS thread handle 0x7f955a3d0700, query id 1601095693 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470240, not startedMySQL thread id 314143414, OS thread handle 0x7f955269b700, query id 1601328422 192.168.30.61 xmpp cleaning up---TRANSACTION 1070463956, not startedMySQL thread id 314143415, OS thread handle 0x7f9589d36700, query id 1601319318 192.168.30.61 xmpp cleaning up---TRANSACTION 1070463621, not startedMySQL thread id 314143412, OS thread handle 0x7f97511f0700, query id 1601319053 192.168.30.61 xmpp cleaning up---TRANSACTION 1070459646, not startedMySQL thread id 314143391, OS thread handle 0x7f958a69b700, query id 1601312741 192.168.30.61 xmpp cleaning up---TRANSACTION 1070461192, not startedMySQL thread id 314143390, OS thread handle 0x7f95890c5700, query id 1601315439 192.168.30.61 xmpp cleaning up---TRANSACTION 1070461230, not startedMySQL thread id 314143392, OS thread handle 0x7f958abaf700, query id 1601315501 192.168.30.61 xmpp cleaning up---TRANSACTION 1070462519, not startedMySQL thread id 314143367, OS thread handle 0x7f9751ee3700, query id 1601317684 192.168.30.61 xmpp cleaning up---TRANSACTION 1070460834, not startedMySQL thread id 314143334, OS thread handle 0x7f955b9a6700, query id 1601314789 192.168.30.61 xmpp cleaning up---TRANSACTION 1070462446, not startedMySQL thread id 314143336, OS thread handle 0x7f9552597700, query id 1601317565 192.168.30.61 xmpp cleaning up---TRANSACTION 1070393828, not startedMySQL thread id 314056482, OS thread handle 0x7f9551926700, query id 1601206090 192.168.30.60 xmpp cleaning up---TRANSACTION 1070433350, not startedMySQL thread id 314056479, OS thread handle 0x7f97530ea700, query id 1601271249 192.168.30.60 xmpp cleaning up---TRANSACTION 1070468574, not startedMySQL thread id 314056483, OS thread handle 0x7f958a515700, query id 1601325441 192.168.30.60 xmpp cleaning up---TRANSACTION 1070457875, not startedMySQL thread id 314056480, OS thread handle 0x7f9559b6f700, query id 1601309538 192.168.30.60 xmpp cleaning up---TRANSACTION 1070462447, not startedMySQL thread id 313953810, OS thread handle 0x7f9558efe700, query id 1601317566 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469722, not startedMySQL thread id 313953808, OS thread handle 0x7f95582ce700, query id 1601327536 192.168.30.61 xmpp cleaning up---TRANSACTION 1070466875, not startedMySQL thread id 312868188, OS thread handle 0x7f95518a4700, query id 1601322384 192.168.30.60 xmpp cleaning up---TRANSACTION 1070460107, not startedMySQL thread id 312868189, OS thread handle 0x7f975147a700, query id 1601313521 192.168.30.60 xmpp cleaning up---TRANSACTION 1070469111, not startedMySQL thread id 312868187, OS thread handle 0x7f9751231700, query id 1601326498 192.168.30.60 xmpp cleaning up---TRANSACTION 1070462225, not startedMySQL thread id 312868186, OS thread handle 0x7f9588aee700, query id 1601317176 192.168.30.60 xmpp cleaning up---TRANSACTION 1070469161, not startedMySQL thread id 311706786, OS thread handle 0x7f955a083700, query id 1601326578 192.168.30.61 xmpp cleaning up---TRANSACTION 1070462182, not startedMySQL thread id 310850324, OS thread handle 0x7f958befb700, query id 1601317100 192.168.30.60 xmpp cleaning up---TRANSACTION 1070399001, not startedMySQL thread id 310801655, OS thread handle 0x7f9589390700, query id 1601215738 192.168.30.60 xmpp cleaning up---TRANSACTION 1070428532, not startedMySQL thread id 310801651, OS thread handle 0x7f9588bf2700, query id 1601262685 192.168.30.60 xmpp cleaning up---TRANSACTION 1070269398, not startedMySQL thread id 310801650, OS thread handle 0x7f9552f7e700, query id 1601010851 192.168.30.60 xmpp cleaning up---TRANSACTION 1070442617, not startedMySQL thread id 310801649, OS thread handle 0x7f958b145700, query id 1601284732 192.168.30.60 xmpp cleaning up---TRANSACTION 1070383279, not startedMySQL thread id 310708348, OS thread handle 0x7f955279f700, query id 1601189444 192.168.30.60 xmpp cleaning up---TRANSACTION 1070464247, not startedMySQL thread id 309183152, OS thread handle 0x7f9552aec700, query id 1601319537 192.168.30.61 xmpp cleaning up---TRANSACTION 1070469672, not startedMySQL thread id 309182757, OS thread handle 0x7f975b954700, query id 1601327443 192.168.30.61 xmpp cleaning up---TRANSACTION 1070464586, not startedMySQL thread id 307726396, OS thread handle 0x7f9589cb4700, query id 1601319805 192.168.30.61 xmpp cleaning up---TRANSACTION 1070385559, not startedMySQL thread id 306492572, OS thread handle 0x7f955aaab700, query id 1601193423 192.168.30.60 xmpp cleaning up---TRANSACTION 1070343148, not startedMySQL thread id 294691150, OS thread handle 0x7f98282a6700, query id 1601125614 192.168.30.60 xmpp cleaning up---TRANSACTION 1070467716, not startedMySQL thread id 145183823, OS thread handle 0x7f95889a9700, query id 1601323904 192.168.30.60 xmpp cleaning up---TRANSACTION 1070469255, not startedMySQL thread id 145183822, OS thread handle 0x7f97532b1700, query id 1601326734 192.168.30.60 xmpp cleaning up---TRANSACTION 1070417764, not startedMySQL thread id 145183821, OS thread handle 0x7f955a1c8700, query id 1601246688 192.168.30.60 xmpp cleaning up---TRANSACTION 1070462284, not startedMySQL thread id 145183820, OS thread handle 0x7f9558f80700, query id 1601317280 192.168.30.60 xmpp cleaning up---TRANSACTION 1070383441, not startedMySQL thread id 145183819, OS thread handle 0x7f958be38700, query id 1601189753 192.168.30.60 xmpp cleaning up---TRANSACTION 1070396195, not startedMySQL thread id 145183818, OS thread handle 0x7f958a042700, query id 1601210722 192.168.30.60 xmpp cleaning up---TRANSACTION 1070429671, not startedMySQL thread id 145183817, OS thread handle 0x7f9588dfa700, query id 1601264736 192.168.30.60 xmpp cleaning up---TRANSACTION 1070430793, not startedMySQL thread id 145175054, OS thread handle 0x7f9828120700, query id 1601266760 192.168.30.60 xmpp cleaning up---TRANSACTION 1070407812, not startedMySQL thread id 145175052, OS thread handle 0x7f958be79700, query id 1601228850 192.168.30.60 xmpp cleaning up---TRANSACTION 1070416589, not startedMySQL thread id 145174943, OS thread handle 0x7f9751ddf700, query id 1601244964 192.168.30.60 xmpp cleaning up---TRANSACTION 1070452547, not startedMySQL thread id 145162074, OS thread handle 0x7f95535d7700, query id 1601300135 192.168.30.60 xmpp cleaning up---TRANSACTION 1070462453, not startedMySQL thread id 145127933, OS thread handle 0x7f9751f24700, query id 1601317581 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470517, not startedMySQL thread id 145124571, OS thread handle 0x7f9553b6d700, query id 1601328895 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470122, not startedMySQL thread id 145124570, OS thread handle 0x7f958b6db700, query id 1601328241 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470081, not startedMySQL thread id 145124569, OS thread handle 0x7f958b38e700, query id 1601328170 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470388, not startedMySQL thread id 145124568, OS thread handle 0x7f9829f4f700, query id 1601328696 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470417, not startedMySQL thread id 145124567, OS thread handle 0x7f9750b97700, query id 1601328743 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470367, not startedMySQL thread id 145124563, OS thread handle 0x7f975b78d700, query id 1601328666 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470341, not startedMySQL thread id 145111664, OS thread handle 0x7f9553410700, query id 1601328606 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470434, not startedMySQL thread id 145111663, OS thread handle 0x7f97512f4700, query id 1601328771 192.168.30.60 xmpp cleaning up---TRANSACTION 1070469944, not startedMySQL thread id 145106910, OS thread handle 0x7f955b2cb700, query id 1601327945 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470229, not startedMySQL thread id 145056839, OS thread handle 0x7f9558085700, query id 1601328403 192.168.30.60 xmpp cleaning up---TRANSACTION 1070470521, ACTIVE 0 sec insertingmysql tables in use 1, locked 1MySQL thread id 322593677, OS thread handle 0x7f9558391700, query id 1601328903 192.168.30.60 xmpp updateinsert into connection_log values(null, "1037855", "online", "192.168.30.60:10207", "android", "address:::ffff:121.33.207.162 user-agent:golo/3.1.2/android/19", "2014-06-20 15:07:49")--------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 (read thread)I/O thread 4 state: waiting for i/o request (read thread)I/O thread 5 state: waiting for i/o request (read thread)I/O thread 6 state: waiting for i/o request (write thread)I/O thread 7 state: waiting for i/o request (write thread)I/O thread 8 state: waiting for i/o request (write thread)I/O thread 9 state: waiting for i/o request (write thread)Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0Pending flushes (fsync) log: 0; buffer pool: 0519478111 OS file reads, 475571232 OS file writes, 405080434 OS fsyncs25.65 reads/s, 16384 avg bytes/read, 156.16 writes/s, 156.16 fsyncs/s-------------------------------------INSERT BUFFER AND ADAPTIVE HASH INDEX-------------------------------------Ibuf: size 1, free list len 7778, seg size 7780, 20096289 mergesmerged operations: insert 21258675, delete mark 4422649, delete 378053discarded operations: insert 5, delete mark 0, delete 0Hash table size 4730647, node heap has 955 buffer(s)3196.53 hash searches/s, 746.75 non-hash searches/s---LOG---Log sequence number 224036232063Log flushed up to   224036231846Pages flushed up to 224029757156Last checkpoint at  2240297571560 pending log writes, 0 pending chkp writes341386815 log i/o's done, 156.16 log i/o's/second----------------------BUFFER POOL AND MEMORY----------------------Total memory allocated 2197815296; in additional pool allocated 0Dictionary memory allocated 9119775Buffer pool size   131064Free buffers       8188Database pages     121921Old database pages 44843Modified db pages  3048Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 5805713280, not young 370943670422.95 youngs/s, 697.59 non-youngs/sPages read 542477273, created 3579928, written 15962774625.65 reads/s, 0.98 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 13 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 121921, unzip_LRU len: 0I/O sum[9304]:cur[24], unzip sum[0]:cur[0]----------------------INDIVIDUAL BUFFER POOL INFO-------------------------BUFFER POOL 0Buffer pool size   16383Free buffers       1022Database pages     15240Old database pages 5606Modified db pages  500Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 746573182, not young 4549775572.60 youngs/s, 48.53 non-youngs/sPages read 67686047, created 498875, written 238894642.60 reads/s, 0.05 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 5 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15240, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]---BUFFER POOL 1Buffer pool size   16383Free buffers       1024Database pages     15239Old database pages 5605Modified db pages  385Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 745312523, not young 4840354094.65 youngs/s, 158.09 non-youngs/sPages read 66102931, created 479874, written 178729454.09 reads/s, 0.12 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 29 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15239, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]---BUFFER POOL 2Buffer pool size   16383Free buffers       1024Database pages     15246Old database pages 5607Modified db pages  265Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 738031948, not young 5350110022.26 youngs/s, 3.42 non-youngs/sPages read 71570303, created 365905, written 119296741.93 reads/s, 0.02 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15246, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]---BUFFER POOL 3Buffer pool size   16383Free buffers       1023Database pages     15240Old database pages 5606Modified db pages  372Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 747680440, not young 4999799872.95 youngs/s, 138.51 non-youngs/sPages read 74678009, created 452183, written 299560083.88 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 18 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15240, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]---BUFFER POOL 4Buffer pool size   16383Free buffers       1024Database pages     15245Old database pages 5607Modified db pages  385Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 712059936, not young 4252994102.05 youngs/s, 1.93 non-youngs/sPages read 67580487, created 416983, written 243248711.30 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15245, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]---BUFFER POOL 5Buffer pool size   16383Free buffers       1023Database pages     15240Old database pages 5605Modified db pages  279Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 668418980, not young 4110167652.58 youngs/s, 171.48 non-youngs/sPages read 62837956, created 391469, written 146844475.09 reads/s, 0.30 creates/s, 0.00 writes/sBuffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 47 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15240, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]---BUFFER POOL 6Buffer pool size   16383Free buffers       1024Database pages     15238Old database pages 5604Modified db pages  311Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 728371220, not young 4464121001.72 youngs/s, 66.86 non-youngs/sPages read 65762204, created 454944, written 167265793.16 reads/s, 0.02 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 15 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15238, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]---BUFFER POOL 7Buffer pool size   16383Free buffers       1024Database pages     15233Old database pages 5603Modified db pages  551Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 719265051, not young 4527044744.14 youngs/s, 108.76 non-youngs/sPages read 66259336, created 519695, written 202437583.58 reads/s, 0.47 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 10 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 15233, unzip_LRU len: 0I/O sum[1163]:cur[3], unzip sum[0]:cur[0]--------------ROW OPERATIONS--------------0 queries inside InnoDB, 0 queries in queue0 read views open inside InnoDBMain thread process no. 4565, id 140291497711360, state: sleepingNumber of rows inserted 80799106, updated 263372036, deleted 16848113, read 159873624886116.02 inserts/s, 140.18 updates/s, 0.07 deletes/s, 54663.38 reads/s----------------------------END OF INNODB MONITOR OUTPUT============================1 row in set (0.04 sec)mysql>