Type Name Status InnoDB ===================================== 090607 23:44:03 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 18 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 444661448, signal count 281000857 Mutex spin waits 0, rounds 182929501185, OS waits 253100239 RW-shared spins 241708921, OS waits 70486268; RW-excl spins 596545448, OS waits 50547167 ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 090528 20:45:36 Transaction: TRANSACTION 9 3529847459, ACTIVE 0 sec, process no 1633, OS thread id 1186240832 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 848119, query id 1248428649 10.0.0.6 spaces update INSERT INTO spaces_mail_data_1 SET contact_id='327928', flags='1', ctime=NOW() Foreign key constraint fails for table `spaces_mail`.`spaces_mail_data_1`: , CONSTRAINT `spaces_mail_data_1` FOREIGN KEY (`contact_id`) REFERENCES `spaces_mail_contact_list_1` (`nid`) ON DELETE CASCADE Trying to add in child table, in index `contact_id` tuple: DATA TUPLE: 2 fields; 0: len 4; hex 800500f8; asc ;; 1: len 4; hex 807388f6; asc s ;; But in parent table `spaces_mail`.`spaces_mail_contact_list_1`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 14; compact format; info bits 0 0: len 4; hex 800500f9; asc ;; 1: len 6; hex 0009d2606a7f; asc `j ;; 2: len 7; hex 00000021870416; asc ! ;; 3: len 4; hex 80025fdc; asc _ ;; 4: len 4; hex 8003ca6e; asc n;; 5: len 4; hex 80000001; asc ;; 6: len 4; hex 80000002; asc ;; 7: len 4; hex 80000000; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 1; hex 80; asc ;; 10: len 1; hex 80; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex ca1ebea7; asc ;; 13: len 30; hex 447264696d6d202020202020202020202020202020202020202020202020; asc Drdimm ;...(truncated); ------------------------ LATEST DETECTED DEADLOCK ------------------------ 090607 18:15:02 *** (1) TRANSACTION: TRANSACTION 10 1088993421, ACTIVE 0 sec, process no 1633, OS thread id 1253476672 starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1216, 2 row lock(s) MySQL thread id 2609969, query id 4208100978 10.0.0.3 spaces Updating UPDATE spaces_guests SET flags = (flags | '1') WHERE sid='7979565997698377' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 1524174 n bits 112 index `GEN_CLUST_INDEX` of table `spaces`.`spaces_guests` trx id 10 1088993421 lock_mode X locks rec but not gap waiting Record lock, heap no 34 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3f1; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db11eb; asc ;; 3: len 4; hex 81e1457c; asc E|;; 4: len 20; hex 3739373935363539393736393833373720202020; asc 7979565997698377 ;; 5: len 8; hex 80001245b5811a74; asc E t;; 6: len 16; hex 37392e3132342e3138362e3134352020; asc 79.124.186.145 ;; 7: len 30; hex 4e6f6b6961353331305870726573734d7573696320202020202020202020; asc Nokia5310XpressMusic ;...(truncated); 8: len 30; hex 4e6f6b696120202020202020202020202020202020202020202020202020; asc Nokia ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000005; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; *** (2) TRANSACTION: TRANSACTION 10 1088992971, ACTIVE 0 sec, process no 1633, OS thread id 1153325376 updating or deleting, thread declared inside InnoDB 15 mysql tables in use 1, locked 1 112 lock struct(s), heap size 14320, 3297 row lock(s), undo log entries 806 MySQL thread id 2610370, query id 4208100426 10.0.0.5 spaces updating DELETE FROM spaces_guests WHERE mtime > FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()) - '3600') *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 1524174 n bits 112 index `GEN_CLUST_INDEX` of table `spaces`.`spaces_guests` trx id 10 1088992971 lock_mode X Record lock, heap no 2 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b39c; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4da3609; asc 6 ;; 3: len 4; hex 81e14554; asc ET;; 4: len 20; hex 3935383838353037353936393637313620202020; asc 9588850759696716 ;; 5: len 8; hex 80001245b5811a46; asc E F;; 6: len 16; hex 37392e3132342e3138342e3231362020; asc 79.124.184.216 ;; 7: len 30; hex 4e6f6b6961363330302f322e30202830362e3031292050726f66696c652f; asc Nokia6300/2.0 (06.01) Profile/;...(truncated); 8: len 30; hex 4e6f6b696120363330302020202020202020202020202020202020202020; asc Nokia 6300 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000004; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 3 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b39d; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4da375e; asc 7^;; 3: len 4; hex 81e14555; asc EU;; 4: len 20; hex 3631303737383133383935303535333320202020; asc 6107781389505533 ;; 5: len 8; hex 80001245b5811a46; asc E F;; 6: len 16; hex 39302e3133392e3234332e3131312020; asc 90.139.243.111 ;; 7: len 30; hex 4e6f6b696133313130632020202020202020202020202020202020202020; asc Nokia3110c ;...(truncated); 8: len 30; hex 4e6f6b6961203331313020636c6173736963202020202020202020202020; asc Nokia 3110 classic ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000006; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 4 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3a0; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4da38b3; asc 8 ;; 3: len 4; hex 81e14556; asc EV;; 4: len 20; hex 3936303533343538383239353933353520202020; asc 9605345882959355 ;; 5: len 8; hex 80001245b5811a46; asc E F;; 6: len 16; hex 37392e3132342e3135312e3232392020; asc 79.124.151.229 ;; 7: len 30; hex 536f6e794572696373736f6e54363530692f523741412042726f77736572; asc SonyEricssonT650i/R7AA Browser;...(truncated); 8: len 30; hex 536f6e794572696373736f6e205436353069202020202020202020202020; asc SonyEricsson T650i ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000006; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 6 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3a4; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4da3a0b; asc : ;; 3: len 4; hex 81e14558; asc EX;; 4: len 20; hex 3736313637303838303334343632393820202020; asc 7616708803446298 ;; 5: len 8; hex 80001245b5811a46; asc E F;; 6: len 16; hex 37372e35322e36342e31323420202020; asc 77.52.64.124 ;; 7: len 30; hex 4d6f7a696c6c612f352e30202853796d6269616e4f532f392e333b20553b; asc Mozilla/5.0 (SymbianOS/9.3; U;;...(truncated); 8: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000007; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 7 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3dd; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0f3e; asc >;; 3: len 4; hex 81e14576; asc Ev;; 4: len 20; hex 3939303430353730303537373533323220202020; asc 9904057005775322 ;; 5: len 8; hex 80001245b5811a72; asc E r;; 6: len 16; hex 39352e35392e33372e31303820202020; asc 95.59.37.108 ;; 7: len 30; hex 4f706572612f392e3634202857696e646f7773204e5420352e313b20553b; asc Opera/9.64 (Windows NT 5.1; U;;...(truncated); 8: len 30; hex d0b2d0b0d188d0b5d0b920d0bcd0bed0b1d0b8d0bbd18b20202020202020; asc ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000005; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3aa; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4da3b63; asc ;c;; 3: len 4; hex 81e1455a; asc EZ;; 4: len 20; hex 3138333030363839303136323838303420202020; asc 1830068901628804 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 3231332e38372e38372e313937202020; asc 213.87.87.197 ;; 7: len 30; hex 536f6e794572696373736f6e4b383130692f52314b472042726f77736572; asc SonyEricssonK810i/R1KG Browser;...(truncated); 8: len 30; hex 536f6e794572696373736f6e204b38313069202020202020202020202020; asc SonyEricsson K810i ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000001; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 9 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3ab; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4da3cb8; asc < ;; 3: len 4; hex 81e1455b; asc E[;; 4: len 20; hex 3834333736373930333535333236323720202020; asc 8437679035532627 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 3231372e3131382e39302e3136332020; asc 217.118.90.163 ;; 7: len 30; hex 4e6f6b696136303835202020202020202020202020202020202020202020; asc Nokia6085 ;...(truncated); 8: len 30; hex 4e6f6b696120363038352020202020202020202020202020202020202020; asc Nokia 6085 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000007; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 10 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3db; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0de9; asc ;; 3: len 4; hex 81e14575; asc Eu;; 4: len 20; hex 3339393334383435383334343630383720202020; asc 3993484583446087 ;; 5: len 8; hex 80001245b5811a72; asc E r;; 6: len 16; hex 3231372e3131382e36362e3136202020; asc 217.118.66.16 ;; 7: len 30; hex 53414d53554e472d5347482d553830302020202020202020202020202020; asc SAMSUNG-SGH-U800 ;...(truncated); 8: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000000; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 13 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3b1; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4da3e0d; asc > ;; 3: len 4; hex 81e1455f; asc E_;; 4: len 20; hex 3935363734303830313037363833373520202020; asc 9567408010768375 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 37372e35322e39312e32303020202020; asc 77.52.91.200 ;; 7: len 30; hex 536f6e794572696373736f6e57383930692f523146412042726f77736572; asc SonyEricssonW890i/R1FA Browser;...(truncated); 8: len 30; hex 536f6e792020202020202020202020202020202020202020202020202020; asc Sony ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000003; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 14 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3b2; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0038; asc 8;; 3: len 4; hex 81e14560; asc E`;; 4: len 20; hex 3238343335333239393736363137343720202020; asc 2843532997661747 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 3231372e3134382e35312e3132312020; asc 217.148.51.121 ;; 7: len 30; hex 536f6e794572696373736f6e4a333030692f523242412053454d432d4272; asc SonyEricssonJ300i/R2BA SEMC-Br;...(truncated); 8: len 30; hex 536f6e794572696373736f6e204a33303069202020202020202020202020; asc SonyEricsson J300i ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000002; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 15 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3b3; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0190; asc ;; 3: len 4; hex 81e14561; asc Ea;; 4: len 20; hex 3434393937363031303532303237383920202020; asc 4499760105202789 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 3231332e3232362e3133312e31333320; asc 213.226.131.133 ;; 7: len 30; hex 4e6f6b6961363330302f322e30202830352e3530292050726f66696c652f; asc Nokia6300/2.0 (05.50) Profile/;...(truncated); 8: len 30; hex 4e6f6b696120363330302020202020202020202020202020202020202020; asc Nokia 6300 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000005; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 16 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3da; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0d90; asc ;; 3: len 4; hex 81e14574; asc Et;; 4: len 20; hex 3733343330323030333632333939313620202020; asc 7343020036239916 ;; 5: len 8; hex 80001245b5811a72; asc E r;; 6: len 16; hex 3139342e31312e32302e343320202020; asc 194.11.20.43 ;; 7: SQL NULL; 8: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000007; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 17 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3b5; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db02e5; asc ;; 3: len 4; hex 81e14563; asc Ec;; 4: len 20; hex 3339313534303430303738323639323520202020; asc 3915404007826925 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 31302e31352e3133352e313139202020; asc 10.15.135.119 ;; 7: len 30; hex 4e6f6b6961353330302f322e30202830352e3531292050726f66696c652f; asc Nokia5300/2.0 (05.51) Profile/;...(truncated); 8: len 30; hex 4e6f6b696120353330302020202020202020202020202020202020202020; asc Nokia 5300 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000005; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 18 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3b6; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db043a; asc :;; 3: len 4; hex 81e14564; asc Ed;; 4: len 20; hex 3836393630393234303430383134373720202020; asc 8696092404081477 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 39352e3130392e3134302e3931202020; asc 95.109.140.91 ;; 7: len 30; hex 53414d53554e472d5347482d453230302f312e302050726f66696c652f4d; asc SAMSUNG-SGH-E200/1.0 Profile/M;...(truncated); 8: len 30; hex 53616d73756e67205347482d453230302020202020202020202020202020; asc Samsung SGH-E200 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000000; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 19 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3b7; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db058f; asc ;; 3: len 4; hex 81e14565; asc Ee;; 4: len 20; hex 3836303734303336343331353030343820202020; asc 8607403643150048 ;; 5: len 8; hex 80001245b5811a47; asc E G;; 6: len 16; hex 39352e3130392e3133302e3135322020; asc 95.109.130.152 ;; 7: len 30; hex 536f6e794572696373736f6e4b383530692f523146412042726f77736572; asc SonyEricssonK850i/R1FA Browser;...(truncated); 8: len 30; hex 536f6e794572696373736f6e204b38353069202020202020202020202020; asc SonyEricsson K850i ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000001; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 21 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3be; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db06e4; asc ;; 3: len 4; hex 81e14567; asc Eg;; 4: len 20; hex 3334323336393934353235383230313520202020; asc 3423699452582015 ;; 5: len 8; hex 80001245b5811a70; asc E p;; 6: len 16; hex 39332e39332e3133372e363720202020; asc 93.93.137.67 ;; 7: len 30; hex 4e6f6b6961353331305870726573734d757369632f322e30202830352e38; asc Nokia5310XpressMusic/2.0 (05.8;...(truncated); 8: len 30; hex 4e6f6b696120202020202020202020202020202020202020202020202020; asc Nokia ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000000; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 23 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3c5; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db083c; asc <;; 3: len 4; hex 81e14569; asc Ei;; 4: len 20; hex 3633323232343831333235333231393720202020; asc 6322248132532197 ;; 5: len 8; hex 80001245b5811a70; asc E p;; 6: len 16; hex 38332e3134392e332e31302020202020; asc 83.149.3.10 ;; 7: len 30; hex 5345432d534748443834302f312e30204e657446726f6e742f332e322050; asc SEC-SGHD840/1.0 NetFront/3.2 P;...(truncated); 8: len 30; hex 53616d73756e67205347482d443834302020202020202020202020202020; asc Samsung SGH-D840 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000007; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 24 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3d9; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0c3b; asc ;;; 3: len 4; hex 81e14573; asc Es;; 4: len 20; hex 3536303530353733333331343532313420202020; asc 5605057333145214 ;; 5: len 8; hex 80001245b5811a72; asc E r;; 6: len 16; hex 37372e35322e38362e31373920202020; asc 77.52.86.179 ;; 7: len 30; hex 4e6f6b6961333235302f322e30202830332e3234292053796d6269616e4f; asc Nokia3250/2.0 (03.24) SymbianO;...(truncated); 8: len 30; hex 4e6f6b696120333235302020202020202020202020202020202020202020; asc Nokia 3250 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000005; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 25 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3d7; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0ae6; asc ;; 3: len 4; hex 81e14572; asc Er;; 4: len 20; hex 3438383339383735353235373032393320202020; asc 4883987552570293 ;; 5: len 8; hex 80001245b5811a72; asc E r;; 6: len 16; hex 3139352e34372e3235352e3234372020; asc 195.47.255.247 ;; 7: len 30; hex 4e6f6b6961353232305870726573734d757369632f322e30202830342e38; asc Nokia5220XpressMusic/2.0 (04.8;...(truncated); 8: len 30; hex 4e6f6b696120202020202020202020202020202020202020202020202020; asc Nokia ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000000; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 28 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3cc; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db0991; asc ;; 3: len 4; hex 81e1456e; asc En;; 4: len 20; hex 3231313439343535363038313938343420202020; asc 2114945560819844 ;; 5: len 8; hex 80001245b5811a71; asc E q;; 6: len 16; hex 37392e3132342e3231342e3536202020; asc 79.124.214.56 ;; 7: len 30; hex 536f6e794572696373736f6e4b3535306920202020202020202020202020; asc SonyEricssonK550i ;...(truncated); 8: len 30; hex 536f6e794572696373736f6e204b35353069202020202020202020202020; asc SonyEricsson K550i ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000002; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 33 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3ee; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db1096; asc ;; 3: len 4; hex 81e1457b; asc E{;; 4: len 20; hex 3034393331353532343037303939313820202020; asc 0493155240709918 ;; 5: len 8; hex 80001245b5811a74; asc E t;; 6: len 16; hex 39302e3133382e3135322e3231382020; asc 90.138.152.218 ;; 7: len 30; hex 4e6f6b69614e373220202020202020202020202020202020202020202020; asc NokiaN72 ;...(truncated); 8: len 30; hex 4e6f6b6961204e3732202020202020202020202020202020202020202020; asc Nokia N72 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000005; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000001; asc ;; Record lock, heap no 34 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 00001922b3f1; asc " ;; 1: len 6; hex 000a40e8b6cb; asc @ ;; 2: len 7; hex 00000ec4db11eb; asc ;; 3: len 4; hex 81e1457c; asc E|;; 4: len 20; hex 3739373935363539393736393833373720202020; asc 7979565997698377 ;; 5: len 8; hex 80001245b5811a74; asc E t;; 6: len 16; hex 37392e3132342e3138362e3134352020; asc 79.124.186.145 ;; 7: len 30; hex 4e6f6b6961353331305870726573734d7573696320202020202020202020; asc Nokia5310XpressMusic ;...(truncated); 8: len 30; hex 4e6f6b696120202020202020202020202020202020202020202020202020; asc Nokia ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000005; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 1534326 n bits 424 index `sid` of table `spaces`.`spaces_guests` trx id 10 1088992971 lock_mode X locks rec but not gap waiting Record lock, heap no 104 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 20; hex 3739373935363539393736393833373720202020; asc 7979565997698377 ;; 1: len 6; hex 00001922b3f1; asc " ;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 10 1165311431 Purge done for trx's n:o < 10 1165304036 undo n:o < 0 0 History list length 336 ... truncated... ting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667309, query id 4318634352 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='552988' ---TRANSACTION 10 1165311402, ACTIVE 879 sec, process no 1633, OS thread id 1158142272 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2664386, query id 4318634347 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '738559' Trx read view will not see trx with id >= 10 1165311403, sees < 10 1165303995 ---TRANSACTION 10 1165311401, ACTIVE 879 sec, process no 1633, OS thread id 1199888704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667284, query id 4318634342 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1700063' Trx read view will not see trx with id >= 10 1165311402, sees < 10 1165303995 ---TRANSACTION 10 1165311400, ACTIVE 879 sec, process no 1633, OS thread id 1222166848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667770, query id 4318634327 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8149742263272618' ---TRANSACTION 10 1165311399, ACTIVE 879 sec, process no 1633, OS thread id 1254078784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2664268, query id 4318634322 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '715006' Trx read view will not see trx with id >= 10 1165311400, sees < 10 1165303995 ---TRANSACTION 10 1165311398, ACTIVE 879 sec, process no 1633, OS thread id 1152321856 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2662953, query id 4318634316 10.0.0.7 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1798347' Trx read view will not see trx with id >= 10 1165311399, sees < 10 1165303995 ---TRANSACTION 10 1165311397, ACTIVE 879 sec, process no 1633, OS thread id 1183631680 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2666583, query id 4318634309 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2678109005145939' ---TRANSACTION 10 1165311396, ACTIVE 879 sec, process no 1633, OS thread id 1209121088 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667668, query id 4318634302 10.0.0.7 spaces statistics SELECT * FROM spaces_users WHERE name='Anarhist' ---TRANSACTION 10 1165311395, ACTIVE 879 sec, process no 1633, OS thread id 1223170368 waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2667244, query id 4318634297 10.0.0.6 spaces Sending data SELECT spaces_diary_topics.options,spaces_diary_topics.header,spaces_diary_topics.user_id,spaces_diary_topics.topic_id,spaces_diary_topics.comments,spaces_diary_topics.ctime,spaces_diary_topics.mtime, spaces_diary_topics.user_id,spaces_diary_topics.subject, spaces_diary_topics.pic,spaces_diary_topics.file, spaces_diary_topics.new_count,spaces_friend_list.user_id AS user_id_from_friend FROM spaces_diary_topics LEFT JOIN spaces_friend_list ON (spaces_friend_list.user_id = 792872 AND spaces_diary_topics.user_id = spaces_friend_list.friend_id) WHERE (spaces_diary_topics.options = 0 OR spaces_diary Trx read view will not see trx with id >= 10 1165311396, sees < 10 1165303995 ---TRANSACTION 10 1165311394, ACTIVE 879 sec, process no 1633, OS thread id 1205909824 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667454, query id 4318634296 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_7 WHERE nid='202858' AND user_id='714908' Trx read view will not see trx with id >= 10 1165311395, sees < 10 1165303995 ---TRANSACTION 10 1165311393, ACTIVE 879 sec, process no 1633, OS thread id 1164765504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2664256, query id 4318634285 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8161611199339826' ---TRANSACTION 10 1165311392, ACTIVE 879 sec, process no 1633, OS thread id 1225177408 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667786, query id 4318634280 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='hristova_lilya' ---TRANSACTION 10 1165311391, ACTIVE 879 sec, process no 1633, OS thread id 1164364096 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667354, query id 4318634279 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE L2 = '1742' ORDER BY ctime DESC LIMIT 15,5 Trx read view will not see trx with id >= 10 1165311392, sees < 10 1165303995 ---TRANSACTION 10 1165311390, ACTIVE 879 sec, process no 1633, OS thread id 1255885120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667751, query id 4318634271 10.0.0.7 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='790400' ---TRANSACTION 10 1165311389, ACTIVE 879 sec, process no 1633, OS thread id 1153726784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667788, query id 4318634270 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='aana9a' ---TRANSACTION 10 1165311388, ACTIVE 879 sec, process no 1633, OS thread id 1232202048 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667230, query id 4318634264 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2829542810394370' ---TRANSACTION 10 1165311387, ACTIVE 879 sec, process no 1633, OS thread id 1167776064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667383, query id 4318634253 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5784113211749857' ---TRANSACTION 10 1165311386, ACTIVE 879 sec, process no 1633, OS thread id 1142888768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667304, query id 4318634251 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9605516781615400' ---TRANSACTION 10 1165311385, ACTIVE 879 sec, process no 1633, OS thread id 1251871040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667390, query id 4318634247 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='655208' ---TRANSACTION 10 1165311384, ACTIVE 879 sec, process no 1633, OS thread id 1236416832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667785, query id 4318634238 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_7 WHERE user_id='775747' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 10 1165311385, sees < 10 1165303995 ---TRANSACTION 10 1165311383, ACTIVE 879 sec, process no 1633, OS thread id 1183430976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667190, query id 4318634228 10.0.0.6 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '374376' AND shzone = 1 Trx read view will not see trx with id >= 10 1165311384, sees < 10 1165303995 ---TRANSACTION 10 1165311382, ACTIVE 879 sec, process no 1633, OS thread id 1169582400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2663095, query id 4318634225 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='0024235736516614' ---TRANSACTION 10 1165311381, ACTIVE 879 sec, process no 1633, OS thread id 1163360576 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667193, query id 4318634220 10.0.0.6 spaces Sending data SELECT * from spaces_pictures_albums WHERE album_id='153117' Trx read view will not see trx with id >= 10 1165311382, sees < 10 1165303995 ---TRANSACTION 10 1165311380, ACTIVE 879 sec, process no 1633, OS thread id 1212934464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667767, query id 4318634219 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='3585774319742909' ---TRANSACTION 10 1165311379, ACTIVE 879 sec, process no 1633, OS thread id 1195473216 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2660200, query id 4318634218 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1384179' Trx read view will not see trx with id >= 10 1165311380, sees < 10 1165303995 ---TRANSACTION 10 1165311378, ACTIVE 879 sec, process no 1633, OS thread id 1233205568 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667780, query id 4318634212 10.0.0.6 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '34901' Trx read view will not see trx with id >= 10 1165311379, sees < 10 1165303995 ---TRANSACTION 10 1165311377, ACTIVE 879 sec, process no 1633, OS thread id 1229793600 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667778, query id 4318634198 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_0 WHERE nid='565024' AND user_id='61911' Trx read view will not see trx with id >= 10 1165311378, sees < 10 1165303995 ---TRANSACTION 10 1165311376, ACTIVE 879 sec, process no 1633, OS thread id 1186240832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667376, query id 4318634192 10.0.0.6 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235346409' Trx read view will not see trx with id >= 10 1165311377, sees < 10 1165303995 ---TRANSACTION 10 1165311375, ACTIVE 879 sec, process no 1633, OS thread id 1248459072 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667625, query id 4318634191 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='kartelo9' ---TRANSACTION 10 1165311374, ACTIVE 879 sec, process no 1633, OS thread id 1182026048 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667581, query id 4318634188 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5896056523135708' ---TRANSACTION 10 1165311373, ACTIVE 879 sec, process no 1633, OS thread id 1144293696 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667329, query id 4318634187 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='0348851450532149' ---TRANSACTION 10 1165311372, ACTIVE 879 sec, process no 1633, OS thread id 1201895744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667779, query id 4318634177 10.0.0.6 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '417772' AND forum = 1 Trx read view will not see trx with id >= 10 1165311373, sees < 10 1165303995 ---TRANSACTION 10 1165311371, ACTIVE 879 sec, process no 1633, OS thread id 1181825344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667189, query id 4318634158 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '24' ORDER BY rate DESC LIMIT 35,5 Trx read view will not see trx with id >= 10 1165311372, sees < 10 1165303995 ---TRANSACTION 10 1165311370, ACTIVE 879 sec, process no 1633, OS thread id 1233004864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667204, query id 4318634156 10.0.0.6 spaces Sending data SELECT * FROM spaces_comm_users WHERE user_id = '649295' ---TRANSACTION 10 1165311369, ACTIVE 879 sec, process no 1633, OS thread id 1148909888 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667278, query id 4318634155 10.0.0.6 spaces Sending data SELECT * FROM spaces_diary_stat WHERE topic_id='1235345299' ---TRANSACTION 10 1165311368, ACTIVE 879 sec, process no 1633, OS thread id 1184434496 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667746, query id 4318634150 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='329668' ---TRANSACTION 10 1165311367, ACTIVE 879 sec, process no 1633, OS thread id 1182427456 waiting in InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 2667589, query id 4318634149 10.0.0.3 spaces Sorting result SELECT user_id,topic_id,comment_id,user,ctime,mtime,text,reply, UNIX_TIMESTAMP(ctime) AS unix_ctime from spaces_diary_comments WHERE user_id = '592241' AND topic_id = '1235346282' ORDER BY ctime LIMIT 8,4 Trx read view will not see trx with id >= 10 1165311368, sees < 10 1165303995 ---TRANSACTION 10 1165311366, ACTIVE 879 sec, process no 1633, OS thread id 1143290176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667611, query id 4318634148 10.0.0.3 spaces Sorting result SELECT * FROM spaces_pictures_comments WHERE picture_id = '1868742' ORDER BY ctime DESC LIMIT 0,4 Trx read view will not see trx with id >= 10 1165311367, sees < 10 1165303995 ---TRANSACTION 10 1165311365, ACTIVE 879 sec, process no 1633, OS thread id 1231599936 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667521, query id 4318634147 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_pictures_comments WHERE picture_id = '1661698' Trx read view will not see trx with id >= 10 1165311366, sees < 10 1165303995 ---TRANSACTION 10 1165311363, ACTIVE 879 sec, process no 1633, OS thread id 1143691584, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 2667237, query id 4318634145 10.0.0.6 spaces end UPDATE spaces_chat_users SET last_time='1244402964' WHERE room_id='12' AND user_id='752567' ---TRANSACTION 10 1165311361, ACTIVE 879 sec, process no 1633, OS thread id 1188448576 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667293, query id 4318634143 10.0.0.6 spaces statistics SELECT * FROM spaces_shared_zone_files WHERE file_id = '1450443' AND source = '2' AND com_id = 0 Trx read view will not see trx with id >= 10 1165311362, sees < 10 1165303995 ---TRANSACTION 10 1165311357, ACTIVE 879 sec, process no 1633, OS thread id 1155733824 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667340, query id 4318634138 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1706841' Trx read view will not see trx with id >= 10 1165311358, sees < 10 1165303995 ---TRANSACTION 10 1165311355, ACTIVE 879 sec, process no 1633, OS thread id 1234409792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2662294, query id 4318634134 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '106894' Trx read view will not see trx with id >= 10 1165311356, sees < 10 1165303995 ---TRANSACTION 10 1165311354, ACTIVE 879 sec, process no 1633, OS thread id 1204504896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667348, query id 4318634133 10.0.0.6 spaces Sending data SELECT new_count FROM spaces_myfiles WHERE user_id='746074' AND new_count != 0 Trx read view will not see trx with id >= 10 1165311355, sees < 10 1165303995 ---TRANSACTION 10 1165311353, ACTIVE 879 sec, process no 1633, OS thread id 1173997888 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667655, query id 4318634131 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '6' ORDER BY rate DESC LIMIT 0,5 Trx read view will not see trx with id >= 10 1165311354, sees < 10 1165303995 ---TRANSACTION 10 1165311352, ACTIVE 879 sec, process no 1633, OS thread id 1222768960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667506, query id 4318634130 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='367617' ---TRANSACTION 10 1165311351, ACTIVE 879 sec, process no 1633, OS thread id 1211128128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667497, query id 4318634128 10.0.0.3 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='432267' AND forum_id='20302' Trx read view will not see trx with id >= 10 1165311352, sees < 10 1165303995 ---TRANSACTION 10 1165311350, ACTIVE 879 sec, process no 1633, OS thread id 1222969664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667508, query id 4318634127 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '1506181' Trx read view will not see trx with id >= 10 1165311351, sees < 10 1165303995 ---TRANSACTION 10 1165311349, ACTIVE 879 sec, process no 1633, OS thread id 1156536640 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667549, query id 4318634126 10.0.0.3 spaces Sending data SELECT new_count FROM spaces_diary_topics WHERE user_id='652496' AND new_count != 0 Trx read view will not see trx with id >= 10 1165311350, sees < 10 1165303995 ---TRANSACTION 10 1165311348, ACTIVE 879 sec, process no 1633, OS thread id 1155131712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667631, query id 4318634120 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='746983' ---TRANSACTION 10 1165311347, ACTIVE 879 sec, process no 1633, OS thread id 1145096512 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667188, query id 4318634119 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '987873' Trx read view will not see trx with id >= 10 1165311348, sees < 10 1165303995 ---TRANSACTION 10 1165311346, ACTIVE 879 sec, process no 1633, OS thread id 1215543616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2666384, query id 4318634117 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2767065753015958' ---TRANSACTION 10 1165311338, ACTIVE 879 sec, process no 1633, OS thread id 1244846400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667391, query id 4318634103 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='12' AND user_id='764414' ---TRANSACTION 10 1165311336, ACTIVE 879 sec, process no 1633, OS thread id 1228589376 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667328, query id 4318634100 10.0.0.6 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='199424' AND forum_id='46285' Trx read view will not see trx with id >= 10 1165311337, sees < 10 1165303995 ---TRANSACTION 10 1165311335, ACTIVE 879 sec, process no 1633, OS thread id 1161554240 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667499, query id 4318634099 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='293489' ---TRANSACTION 10 1165311334, ACTIVE 879 sec, process no 1633, OS thread id 1145497920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667626, query id 4318634098 10.0.0.3 spaces Sending data SELECT new_count FROM spaces_diary_topics WHERE user_id='795908' AND new_count != 0 Trx read view will not see trx with id >= 10 1165311335, sees < 10 1165303995 ---TRANSACTION 10 1165311333, ACTIVE 879 sec, process no 1633, OS thread id 1187645760 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667610, query id 4318634097 10.0.0.3 spaces Sending data SELECT COUNT(DISTINCT user_id) FROM spaces_favorites WHERE type_id='0' AND object_id='1640728' AND closed != 1 Trx read view will not see trx with id >= 10 1165311334, sees < 10 1165303995 ---TRANSACTION 10 1165311331, ACTIVE 879 sec, process no 1633, OS thread id 1158342976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667486, query id 4318634093 10.0.0.3 spaces Sending data SELECT * FROM spaces_comm_users WHERE user_id = '346799' Trx read view will not see trx with id >= 10 1165311351, sees < 10 1165303995 ---TRANSACTION 10 1165311325, ACTIVE 879 sec, process no 1633, OS thread id 1216948544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667624, query id 4318634082 10.0.0.3 spaces Sorting result SELECT * FROM spaces_lenta_0 USE INDEX(user_id) WHERE user_id='55002' AND author_id=393442 ORDER BY nid DESC LIMIT 0, 15 ---TRANSACTION 10 1165311324, ACTIVE 879 sec, process no 1633, OS thread id 1234008384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667335, query id 4318634081 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1850504' Trx read view will not see trx with id >= 10 1165311325, sees < 10 1165303995 ---TRANSACTION 10 1165311320, ACTIVE 879 sec, process no 1633, OS thread id 1167575360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667198, query id 4318634068 10.0.0.6 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235346631' Trx read view will not see trx with id >= 10 1165311321, sees < 10 1165303995 ---TRANSACTION 10 1165311315, ACTIVE 879 sec, process no 1633, OS thread id 1150114112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667219, query id 4318634054 10.0.0.6 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='193110' AND forum_id='365' Trx read view will not see trx with id >= 10 1165311316, sees < 10 1165303995 ---TRANSACTION 10 1165311313, ACTIVE 879 sec, process no 1633, OS thread id 1144092992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667761, query id 4318634052 10.0.0.3 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='3056' AND forum_id='64003' Trx read view will not see trx with id >= 10 1165311314, sees < 10 1165303995 ---TRANSACTION 10 1165311310, ACTIVE 879 sec, process no 1633, OS thread id 1172994368 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667666, query id 4318634051 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_data_3 WHERE contact_id='277446' ORDER BY nid DESC LIMIT 0,10 Trx read view will not see trx with id >= 10 1165311311, sees < 10 1165303995 ---TRANSACTION 10 1165311309, ACTIVE 879 sec, process no 1633, OS thread id 1247054144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2663915, query id 4318634050 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1481714' Trx read view will not see trx with id >= 10 1165311310, sees < 10 1165303995 ---TRANSACTION 10 1165311305, ACTIVE 879 sec, process no 1633, OS thread id 1187244352 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667380, query id 4318634048 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1505980' Trx read view will not see trx with id >= 10 1165311306, sees < 10 1165303995 ---TRANSACTION 10 1165311299, ACTIVE 879 sec, process no 1633, OS thread id 1175202112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667490, query id 4318633981 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1735' ORDER BY rate DESC LIMIT 140,5 Trx read view will not see trx with id >= 10 1165311300, sees < 10 1165303995 ---TRANSACTION 10 1165311298, ACTIVE 879 sec, process no 1633, OS thread id 1228790080 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667765, query id 4318633983 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 10 1165311299, sees < 10 1165303995 ---TRANSACTION 10 1165311256, ACTIVE 879 sec, process no 1633, OS thread id 1179617600 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667392, query id 4318633938 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1735' ORDER BY rate DESC LIMIT 5,5 Trx read view will not see trx with id >= 10 1165311257, sees < 10 1165303995 ---TRANSACTION 10 1165311233, ACTIVE 880 sec, process no 1633, OS thread id 1178413376 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667223, query id 4318633856 10.0.0.6 spaces Sending data SELECT * FROM spaces_comm_users WHERE user_id = '300933' Trx read view will not see trx with id >= 10 1165311234, sees < 10 1165303995 ---TRANSACTION 10 1165311232, ACTIVE 880 sec, process no 1633, OS thread id 1185036608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667295, query id 4318633852 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 10 1165311233, sees < 10 1165303995 ---TRANSACTION 10 1165311225, ACTIVE 880 sec, process no 1633, OS thread id 1163561280 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2666539, query id 4318633807 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 10 1165311226, sees < 10 1165303995 ---TRANSACTION 10 1165311204, ACTIVE 880 sec, process no 1633, OS thread id 1218955584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667642, query id 4318633845 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 10 1165311205, sees < 10 1165303995 ---TRANSACTION 10 1165311203, ACTIVE 880 sec, process no 1633, OS thread id 1189452096 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667726, query id 4318633801 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 10 1165311204, sees < 10 1165303995 ---TRANSACTION 10 1165311199, ACTIVE 880 sec, process no 1633, OS thread id 1176406336, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2667308, query id 4318633777 10.0.0.6 spaces end UPDATE spaces_comm_users SET atime = NOW() WHERE com_id = '4615' AND user_id = '247390' ---TRANSACTION 10 1165311195, ACTIVE 880 sec, process no 1633, OS thread id 1142085952, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 2667311, query id 4318633784 10.0.0.6 spaces end UPDATE spaces_users_anketa SET anketa_level='1244402850' WHERE user_id='503588' ---TRANSACTION 10 1165311183, ACTIVE 880 sec, process no 1633, OS thread id 1170585920, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667280, query id 4318633824 10.0.0.6 spaces end DELETE FROM spaces_guestbook WHERE comment_id = '1590879' AND user_id = '39261' ---TRANSACTION 10 1165311178, ACTIVE 880 sec, process no 1633, OS thread id 1226983744, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667743, query id 4318633819 10.0.0.6 spaces end UPDATE spaces_users_events SET mail_new = 0 WHERE user_id='403116' AND mail_new != 0 ---TRANSACTION 10 1165311175, ACTIVE 880 sec, process no 1633, OS thread id 1184233792, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 2667255, query id 4318633816 10.0.0.6 spaces end UPDATE spaces_chat_users SET last_time='1244402963' WHERE room_id='158' AND user_id='504585' ---TRANSACTION 10 1165311170, ACTIVE 880 sec, process no 1633, OS thread id 1159346496, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 2667542, query id 4318633808 10.0.0.3 spaces end UPDATE spaces_chat_users SET last_time='1244402963' WHERE room_id='7916' AND user_id='109515' ---TRANSACTION 10 1165311162, ACTIVE 880 sec, process no 1633, OS thread id 1210726720, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2667460, query id 4318633679 10.0.0.6 spaces end UPDATE spaces_comm_users SET atime = NOW() WHERE com_id = '5323' AND user_id = '630914' ---TRANSACTION 10 1165311161, ACTIVE 880 sec, process no 1633, OS thread id 1188247872 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667632, query id 4318633678 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 10 1165311162, sees < 10 1165303995 ---TRANSACTION 10 1165311156, ACTIVE 880 sec, process no 1633, OS thread id 1147906368 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2667522, query id 4318633773 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 10 1165311158, sees < 10 1165303995 ---TRANSACTION 10 1165311125, ACTIVE 880 sec, process no 1633, OS thread id 1216547136, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667265, query id 4318633740 10.0.0.6 spaces end UPDATE spaces_pictures_tracking SET page='4',comments_cnt='61', last_comment_id='2947996' WHERE user_id='507071' AND object_id='1344057' ---TRANSACTION 10 1165311116, ACTIVE 880 sec, process no 1633, OS thread id 1238624576, thread declared inside InnoDB 495 mysql tables in use 1, locked 1 7 lock struct(s), heap size 1216, 9 row lock(s), undo log entries 1 MySQL thread id 2667495, query id 4318633656 10.0.0.3 spaces end UPDATE spaces_journal SET flags = (flags & ~(1)) WHERE user_id='603418' ---TRANSACTION 10 1165311089, ACTIVE 880 sec, process no 1633, OS thread id 1256085824, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667538, query id 4318633714 10.0.0.3 spaces end UPDATE spaces_diary_stat SET guests = guests + 1 WHERE topic_id = '1235190537' ---TRANSACTION 10 1165311035, ACTIVE 880 sec, process no 1633, OS thread id 1164564800, thread declared inside InnoDB 50 mysql tables in use 1, locked 1 397 lock struct(s), heap size 63472, 898 row lock(s), undo log entries 2 MySQL thread id 2667774, query id 4318633628 10.0.0.6 spaces end UPDATE spaces_journal SET flags = (flags & ~(1)) WHERE user_id='716876' ---TRANSACTION 10 1165311008, ACTIVE 881 sec, process no 1633, OS thread id 1194670400, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2667678, query id 4318633597 10.0.0.7 spaces update INSERT INTO spaces_files_tracking SET user_id='502574', object_id='1507827', page=1, comments_cnt='0', last_comment_id='0' ---TRANSACTION 10 1165310969, ACTIVE 881 sec, process no 1633, OS thread id 1227184448, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2667599, query id 4318633558 10.0.0.3 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='19' WHERE user_id='468630' ---TRANSACTION 10 1165310942, ACTIVE 881 sec, process no 1633, OS thread id 1201695040, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 2667554, query id 4318633522 10.0.0.3 spaces end DELETE FROM spaces_guests WHERE sid='8978353827782646' ---TRANSACTION 10 1165310909, ACTIVE 881 sec, process no 1633, OS thread id 1174600000, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2666387, query id 4318633478 10.0.0.7 spaces update INSERT INTO spaces_files_tracking SET user_id='388327', object_id='990593', page=1, comments_cnt='3', last_comment_id='860171' ---TRANSACTION 10 1165310894, ACTIVE 881 sec, process no 1633, OS thread id 1228187968 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2667586, query id 4318633464 10.0.0.3 spaces end UPDATE spaces_diary_tracking SET page='1',comments_cnt='14', last_comment_id='7494540' WHERE user_id='641977' AND topic_id='1235346240' Trx read view will not see trx with id >= 10 1165310895, sees < 10 1165303995 ---TRANSACTION 10 1165310892, ACTIVE 881 sec, process no 1633, OS thread id 1177008448, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2667312, query id 4318633461 10.0.0.6 spaces update INSERT INTO spaces_users_anketa_views SET user_id='712481', viewer_id='124089', ctime=NOW() ---TRANSACTION 10 1165310878, ACTIVE 881 sec, process no 1633, OS thread id 1244244288, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667663, query id 4318633444 10.0.0.3 spaces end UPDATE spaces_pictures_tracking SET page='1',comments_cnt='4', last_comment_id='766268' WHERE user_id='53902' AND object_id='260159' ---TRANSACTION 10 1165310534, ACTIVE 881 sec, process no 1633, OS thread id 1147705664, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2667300, query id 4318632976 10.0.0.6 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='5' WHERE user_id='446682' ---TRANSACTION 10 1165310518, ACTIVE 881 sec, process no 1633, OS thread id 1142688064, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2667629, query id 4318632961 10.0.0.3 spaces update INSERT INTO spaces_lenta_0 SET user_id='38334', author_id='209895', event_id='4096', source_id='1869392' ---TRANSACTION 10 1165309825, ACTIVE 881 sec, process no 1633, OS thread id 1223772480, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667560, query id 4318631853 10.0.0.3 spaces end UPDATE spaces_users SET last_time = '1244402963', online_time = online_time + '104' WHERE nid = '672688' ---TRANSACTION 10 1165309572, ACTIVE 881 sec, process no 1633, OS thread id 1204705600, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2667639, query id 4318631490 10.0.0.3 spaces update INSERT INTO spaces_users_anketa_views SET user_id='255768', viewer_id='417823', ctime=NOW() ---TRANSACTION 10 1165309521, ACTIVE 881 sec, process no 1633, OS thread id 1197078848, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2667647, query id 4318631413 10.0.0.3 spaces update INSERT INTO spaces_lenta_4 SET user_id='454498', author_id='602577', event_id='4096', source_id='1869391' ---TRANSACTION 10 1165309452, ACTIVE 881 sec, process no 1633, OS thread id 1176004928, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2667757, query id 4318631322 10.0.0.6 spaces end UPDATE spaces_complaints SET state='1', moder_id='91097' WHERE nid='48825' ---TRANSACTION 10 1165309432, ACTIVE 881 sec, process no 1633, OS thread id 1156737344, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 2667597, query id 4318631270 10.0.0.3 spaces end DELETE FROM spaces_guests WHERE sid='3737772668817316' ---TRANSACTION 10 1165309411, ACTIVE 881 sec, process no 1633, OS thread id 1206110528, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2662134, query id 4318631247 10.0.0.7 spaces update INSERT INTO spaces_music_downloads SET user_id='351931', file_id='387999', ctime=NOW(), owner_id='155573' ---TRANSACTION 10 1165309344, ACTIVE 881 sec, process no 1633, OS thread id 1210124608, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2667769, query id 4318631181 10.0.0.7 spaces update INSERT INTO spaces_files_tracking SET user_id='656637', object_id='1195037', page=1, comments_cnt='9', last_comment_id='902079' ---TRANSACTION 10 1165309328, ACTIVE 881 sec, process no 1633, OS thread id 1187043648, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667600, query id 4318631159 10.0.0.3 spaces end UPDATE spaces_users SET last_time = '1244402963', online_time = online_time + '106' WHERE nid = '435297' ---TRANSACTION 10 1165309310, ACTIVE 881 sec, process no 1633, OS thread id 1255483712, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 2667398, query id 4318631124 10.0.0.6 spaces end UPDATE spaces_users_events SET mail_new = 0 WHERE user_id='568979' ---TRANSACTION 10 1165309306, ACTIVE 881 sec, process no 1633, OS thread id 1241233728, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 2667214, query id 4318631103 10.0.0.6 spaces update INSERT INTO spaces_guests SET sid='2542801221751011', mtime=NOW(), ip_address='94.153.122.240', user_agent='Nokia3250/2.0 (04.14) SymbianOS/9.1 Series60/3.0 Profile/MIDP-2.0 Configuration/CLDC-1.1', mobile_device='Nokia 3250', reklama_cursor='2', flags='0' ---TRANSACTION 10 1165309103, ACTIVE 881 sec, process no 1633, OS thread id 1157740864, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 2667362, query id 4318630742 10.0.0.6 spaces end UPDATE spaces_users_anketa SET anketa_level='1244402941' WHERE user_id='349069' ---TRANSACTION 10 1165308415, ACTIVE 881 sec, process no 1633, OS thread id 1149110592, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2667289, query id 4318629745 10.0.0.6 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='161154' ---TRANSACTION 10 1165303995, ACTIVE 882 sec, process no 1633, OS thread id 1233807680 waiting in InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 2667526, query id 4318623073 10.0.0.3 spaces Copying to tmp table SELECT * FROM spaces_forums_filters JOIN spaces_forums ON (spaces_forums_filters.user_id=217707 AND spaces_forums_filters.cat_id = spaces_forums.category_id) JOIN spaces_forums_topics ON (spaces_forums.forum_id = spaces_forums_topics.forum_id) ORDER BY ctime DESC LIMIT 0,30 Trx read view will not see trx with id >= 10 1165304010, sees < 10 1165301734 -------- 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: 1 22560034 OS file reads, 14036619 OS file writes, 2096252 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 77.47 writes/s, 8.05 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 287, seg size 289, 1977566 inserts, 2206426 merged recs, 1249943 merges Hash table size 53124517, node heap has 132323 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 582 1620670645 Log flushed up to 582 1620670645 Last checkpoint at 582 223100646 0 pending log writes, 0 pending chkp writes 1643498 log i/o's done, 1.95 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 29414537938; in additional pool allocated 16777216 Dictionary memory allocated 1328816 Buffer pool size 1638400 Free buffers 0 Database pages 1506074 Modified db pages 222388 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 26453122, created 982756, written 23760687 0.00 reads/s, 0.00 creates/s, 233.57 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 32 queries inside InnoDB, 121 queries in queue 67 read views open inside InnoDB Main thread process no. 1633, id 1140881728, state: making checkpoint Number of rows inserted 72827563, updated 233965780, deleted 28092117, read 319303904848 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================