InnoDB: Warning: a long semaphore wait: --Thread 1158142272 has waited at row/row0mysql.c line 1720 for 241.00 seconds the semaphore: X-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 InnoDB: Warning: a long semaphore wait: --Thread 1169983808 has waited at row/row0mysql.c line 1685 for 241.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 InnoDB: Warning: a long semaphore wait: --Thread 1152321856 has waited at row/row0mysql.c line 1685 for 241.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 InnoDB: Warning: a long semaphore wait: --Thread 1195874624 has waited at row/row0mysql.c line 1685 for 241.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 090510 0:08:15 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 39 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 606768938, signal count 380802981 --Thread 1158142272 has waited at row/row0mysql.c line 1720 for 253.00 seconds the semaphore: X-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 --Thread 1169983808 has waited at row/row0mysql.c line 1685 for 253.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 --Thread 1152321856 has waited at row/row0mysql.c line 1685 for 253.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 --Thread 1195874624 has waited at row/row0mysql.c line 1685 for 253.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 --Thread 1140881728 has waited at row/row0mysql.c line 1685 for 251.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 --Thread 1237219648 has waited at row/row0mysql.c line 1720 for 36.00 seconds the semaphore: X-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1158142272) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0mysql.c line 1685 Last time write locked in file row/row0mysql.c line 1720 Mutex spin waits 0, rounds 199946609990, OS waits 345837082 RW-shared spins 300024779, OS waits 100897245; RW-excl spins 546248201, OS waits 60576966 ------------------------ LATEST DETECTED DEADLOCK ------------------------ 090509 17:24:03 *** (1) TRANSACTION: TRANSACTION 9 556403795, ACTIVE 0 sec, process no 29007, OS thread id 1186441536 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 2453279, query id 3056683688 10.0.0.6 spaces updating DELETE FROM spaces_guests WHERE sid='9242131585740961' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 412739 n bits 112 index `GEN_CLUST_INDEX` of table `spaces`.`spaces_guests` trx id 9 556403795 lock_mode X locks rec but not gap waiting Record lock, heap no 37 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba78; asc x;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e0d99; asc % ;; 3: len 4; hex 81672f25; asc g/%;; 4: len 20; hex 3932343231333135383537343039363120202020; asc 9242131585740961 ;; 5: len 8; hex 80001245afa99c8e; asc E ;; 6: len 16; hex 38312e32332e32322e32353120202020; asc 81.23.22.251 ;; 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 ;; *** (2) TRANSACTION: TRANSACTION 9 556401307, ACTIVE 1 sec, process no 29007, OS thread id 1191659840 updating or deleting, thread declared inside InnoDB 248 mysql tables in use 1, locked 1 15 lock struct(s), heap size 3024, 390 row lock(s), undo log entries 377 MySQL thread id 2454210, query id 3056679436 data.spaces.ru 10.0.0.5 spaces updating DELETE FROM spaces_guests WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(mtime)) > '300' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 412739 n bits 112 index `GEN_CLUST_INDEX` of table `spaces`.`spaces_guests` trx id 9 556401307 lock_mode X Record lock, heap no 2 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba40; asc @;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d2f13; asc % / ;; 3: len 4; hex 81672f01; asc g/ ;; 4: len 20; hex 3931333038343731333839343033353020202020; asc 9130847138940350 ;; 5: len 8; hex 80001245afa99c88; asc E ;; 6: len 16; hex 39312e3134332e342e31343720202020; asc 91.143.4.147 ;; 7: len 30; hex 536f6e794572696373736f6e4b363330692f523144412042726f77736572; asc SonyEricssonK630i/R1DA Browser;...(truncated); 8: len 30; hex 536f6e792020202020202020202020202020202020202020202020202020; asc Sony ;...(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 3 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba44; asc D;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d306b; asc % 0k;; 3: len 4; hex 81672f03; asc g/ ;; 4: len 20; hex 3937393638373835313338303330323220202020; asc 9796878513803022 ;; 5: len 8; hex 80001245afa99c88; asc E ;; 6: len 16; hex 3231372e382e3233362e313932202020; asc 217.8.236.192 ;; 7: len 30; hex 53414d53554e472d5347482d4d3631302f4d36313058454749342050726f; asc SAMSUNG-SGH-M610/M610XEGI4 Pro;...(truncated); 8: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000001; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 5 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba46; asc F;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d31c3; asc % 1 ;; 3: len 4; hex 81672f05; asc g/ ;; 4: len 20; hex 3334333938373733393232323030313720202020; asc 3439877392220017 ;; 5: len 8; hex 80001245afa99c88; asc E ;; 6: len 16; hex 3231372e36362e3134352e3132322020; asc 217.66.145.122 ;; 7: len 30; hex 4f706572612f392e3532202857696e646f7773204e5420352e313b20553b; asc Opera/9.52 (Windows NT 5.1; U;;...(truncated); 8: len 30; hex d0b2d0b0d188d0b5d0b920d0bcd0bed0b1d0b8d0bbd18b20202020202020; asc ;...(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 6 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba47; asc G;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d3318; asc % 3 ;; 3: len 4; hex 81672f06; asc g/ ;; 4: len 20; hex 3839383038363634373039303837333620202020; asc 8980866470908736 ;; 5: len 8; hex 80001245afa99c88; asc E ;; 6: len 16; hex 39312e3134342e3137302e3138302020; asc 91.144.170.180 ;; 7: len 30; hex 4d6f7a696c6c612f352e30202853796d6269616e4f532f392e323b20553b; asc Mozilla/5.0 (SymbianOS/9.2; 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 80000001; asc ;; Record lock, heap no 7 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba4c; asc L;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d346d; asc % 4m;; 3: len 4; hex 81672f07; asc g/ ;; 4: len 20; hex 3833373030343036373234353239313020202020; asc 8370040672452910 ;; 5: len 8; hex 80001245afa99c89; asc E ;; 6: len 16; hex 38312e32332e32322e32353120202020; asc 81.23.22.251 ;; 7: len 30; hex 536f6e794572696373736f6e4b353530692f2f523642432042726f777365; asc SonyEricssonK550i//R6BC Browse;...(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 80000000; asc ;; Record lock, heap no 8 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba4d; asc M;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d35c5; asc % 5 ;; 3: len 4; hex 81672f08; asc g/ ;; 4: len 20; hex 3039303431353136323638303633373620202020; asc 0904151626806376 ;; 5: len 8; hex 80001245afa99c89; asc E ;; 6: len 16; hex 39332e39332e3133372e323620202020; asc 93.93.137.26 ;; 7: len 30; hex 464c592d53583330352f322e30202830332e3135292050726f66696c652f; asc FLY-SX305/2.0 (03.15) Profile/;...(truncated); 8: len 30; hex 466c79205358333035202020202020202020202020202020202020202020; asc Fly SX305 ;...(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 9 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba4e; asc N;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d371d; asc % 7 ;; 3: len 4; hex 81672f09; asc g/ ;; 4: len 20; hex 3436383537373532323732303833333820202020; asc 4685775227208338 ;; 5: len 8; hex 80001245afa99c89; asc E ;; 6: len 16; hex 37392e3132342e3137332e3233342020; asc 79.124.173.234 ;; 7: len 30; hex 4f706572612f382e303120284a324d452f4d4944503b204f70657261204d; asc Opera/8.01 (J2ME/MIDP; Opera M;...(truncated); 8: len 30; hex 4f70657261204d696e692020202020202020202020202020202020202020; asc Opera Mini ;...(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 10 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba4f; asc O;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d3872; asc % 8r;; 3: len 4; hex 81672f0a; asc g/ ;; 4: len 20; hex 3131313237353634323535363638343520202020; asc 1112756425566845 ;; 5: len 8; hex 80001245afa99c89; asc E ;; 6: len 16; hex 38392e32302e39372e31393720202020; asc 89.20.97.197 ;; 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 80000003; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 11 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba50; asc P;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d39ca; asc % 9 ;; 3: len 4; hex 81672f0b; asc g/ ;; 4: len 20; hex 3839383131353338373335383130393220202020; asc 8981153873581092 ;; 5: len 8; hex 80001245afa99c89; asc E ;; 6: len 16; hex 37392e3132342e3138342e3136332020; asc 79.124.184.163 ;; 7: len 30; hex 5345432d534748453231302f312e30204e657446726f6e742f332e322050; asc SEC-SGHE210/1.0 NetFront/3.2 P;...(truncated); 8: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc ;...(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 13 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba53; asc S;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d3b1f; asc % ; ;; 3: len 4; hex 81672f0d; asc g/ ;; 4: len 20; hex 3137343738313936333031393438303220202020; asc 1747819630194802 ;; 5: len 8; hex 80001245afa99c8a; asc E ;; 6: len 16; hex 3230302e3134302e3139392e31373020; asc 200.140.199.170 ;; 7: len 30; hex 4d4f542d5a332f30382e30322e304352204d49422f424552322e32205072; asc MOT-Z3/08.02.0CR MIB/BER2.2 Pr;...(truncated); 8: len 30; hex 4d6f746f726f6c61205a3320202020202020202020202020202020202020; asc Motorola Z3 ;...(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 000016b3ba56; asc V;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259d3c77; asc % %;; 3: len 4; hex 81672f12; asc g/ ;; 4: len 20; hex 3234353034383835393036323532313920202020; asc 2450488590625219 ;; 5: len 8; hex 80001245afa99c8a; asc E ;; 6: len 16; hex 37372e35322e3132342e323120202020; asc 77.52.124.21 ;; 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 80000000; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 22 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba64; asc d;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e0038; asc % 8;; 3: len 4; hex 81672f16; asc g/ ;; 4: len 20; hex 3635383035353438363135323439303120202020; asc 6580554861524901 ;; 5: len 8; hex 80001245afa99c8c; asc E ;; 6: len 16; hex 3231322e35382e3138312e3136392020; asc 212.58.181.169 ;; 7: len 30; hex 536f6e794572696373736f6e4b3535306920202020202020202020202020; asc SonyEricssonK550i ;...(truncated); 8: len 30; hex 536f6e794572696373736f6e204b35353069202020202020202020202020; asc SonyEricsson K550i ;...(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 23 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba65; asc e;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e0190; asc % ;; 3: len 4; hex 81672f17; asc g/ ;; 4: len 20; hex 3136313934323238393235353833363320202020; asc 1619422892558363 ;; 5: len 8; hex 80001245afa99c8c; asc E ;; 6: len 16; hex 3231372e3131382e38312e3233372020; asc 217.118.81.237 ;; 7: len 30; hex 4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520; asc Mozilla/4.0 (compatible; MSIE ;...(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 80000001; asc ;; Record lock, heap no 24 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba66; asc f;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e02e5; asc % ;; 3: len 4; hex 81672f18; asc g/ ;; 4: len 20; hex 3435303031343830393735313633373020202020; asc 4500148097516370 ;; 5: len 8; hex 80001245afa99c8c; asc E ;; 6: len 16; hex 3231372e3131382e38312e3233352020; asc 217.118.81.235 ;; 7: len 30; hex 5345432d5347485536303020202020202020202020202020202020202020; asc SEC-SGHU600 ;...(truncated); 8: len 30; hex 53616d73756e67205347482d553630302020202020202020202020202020; asc Samsung SGH-U600 ;...(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 25 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba69; asc i;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e043a; asc % :;; 3: len 4; hex 81672f19; asc g/ ;; 4: len 20; hex 3438353838343939373131343335363320202020; asc 4858849971143563 ;; 5: len 8; hex 80001245afa99c8c; asc E ;; 6: len 16; hex 3231372e37342e3235312e3120202020; asc 217.74.251.1 ;; 7: len 30; hex 536f6e794572696373736f6e4b333230692f523447432042726f77736572; asc SonyEricssonK320i/R4GC Browser;...(truncated); 8: len 30; hex 536f6e794572696373736f6e204b33323069202020202020202020202020; asc SonyEricsson K320i ;...(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 26 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba6a; asc j;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e058f; asc % ;; 3: len 4; hex 81672f1a; asc g/ ;; 4: len 20; hex 3336353837353435393333333632383720202020; asc 3658754593336287 ;; 5: len 8; hex 80001245afa99c8c; asc E ;; 6: len 16; hex 38392e32302e39372e31333520202020; asc 89.20.97.135 ;; 7: len 30; hex 4d6f7a696c6c612f352e30202853796d6269616e4f532f392e343b20553b; asc Mozilla/5.0 (SymbianOS/9.4; U;;...(truncated); 8: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc ;...(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 32 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba71; asc q;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e06e7; asc % ;; 3: len 4; hex 81672f20; asc g/ ;; 4: len 20; hex 3636303634323832393531343632343420202020; asc 6606428295146244 ;; 5: len 8; hex 80001245afa99c8d; asc E ;; 6: len 16; hex 3231332e38372e38382e323030202020; asc 213.87.88.200 ;; 7: len 30; hex 53414d53554e472d5347482d4a3135302f4a31353058454844332050726f; asc SAMSUNG-SGH-J150/J150XEHD3 Pro;...(truncated); 8: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc ;...(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 33 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba73; asc s;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e083f; asc % ?;; 3: len 4; hex 81672f21; asc g/!;; 4: len 20; hex 3434353833303536303934353636373420202020; asc 4458305609456674 ;; 5: len 8; hex 80001245afa99c8e; asc E ;; 6: len 16; hex 3231372e37372e3136352e3337202020; asc 217.77.165.37 ;; 7: len 30; hex 4d6f7a696c6c612f352e30202853796d6269616e4f532f392e313b20553b; asc Mozilla/5.0 (SymbianOS/9.1; U;;...(truncated); 8: len 30; hex 4e6f6b6961204e3830202020202020202020202020202020202020202020; asc Nokia N80 ;...(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 34 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba74; asc t;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e0994; asc % ;; 3: len 4; hex 81672f22; asc g/";; 4: len 20; hex 3831393531333338353130343337303520202020; asc 8195133851043705 ;; 5: len 8; hex 80001245afa99c8e; asc E ;; 6: len 16; hex 38302e3235352e37332e353020202020; asc 80.255.73.50 ;; 7: len 30; hex 4d4f542d433338302f30422e44322e323352204d49422f322e322e312050; asc MOT-C380/0B.D2.23R MIB/2.2.1 P;...(truncated); 8: len 30; hex 4d6f746f726f6c6120433338302020202020202020202020202020202020; asc Motorola C380 ;...(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 35 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba75; asc u;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e0aec; asc % ;; 3: len 4; hex 81672f23; asc g/#;; 4: len 20; hex 3132353232303633313331383833343620202020; asc 1252206313188346 ;; 5: len 8; hex 80001245afa99c8e; asc E ;; 6: len 16; hex 39352e35322e3130352e313138202020; asc 95.52.105.118 ;; 7: len 30; hex 4d6f7a696c6c612f352e30202857696e646f77733b20553b2057696e646f; asc Mozilla/5.0 (Windows; U; Windo;...(truncated); 8: len 30; hex d0b2d0b0d188d0b5d0b920d0bcd0bed0b1d0b8d0bbd18b20202020202020; asc ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000003; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; Record lock, heap no 36 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba77; asc w;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e0c44; asc % D;; 3: len 4; hex 81672f24; asc g/$;; 4: len 20; hex 3437353434353635333831343431333620202020; asc 4754456538144136 ;; 5: len 8; hex 80001245afa99c8e; asc E ;; 6: len 16; hex 31302e3231382e3230332e3739202020; asc 10.218.203.79 ;; 7: len 30; hex 4e6f6b6961363330302f322e30202830372e3030292050726f66696c652f; asc Nokia6300/2.0 (07.00) 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 37 PHYSICAL RECORD: n_fields 13; compact format; info bits 32 0: len 6; hex 000016b3ba78; asc x;; 1: len 6; hex 0009212a029b; asc !* ;; 2: len 7; hex 000015259e0d99; asc % ;; 3: len 4; hex 81672f25; asc g/%;; 4: len 20; hex 3932343231333135383537343039363120202020; asc 9242131585740961 ;; 5: len 8; hex 80001245afa99c8e; asc E ;; 6: len 16; hex 38312e32332e32322e32353120202020; asc 81.23.22.251 ;; 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 ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 1687598 n bits 552 index `sid` of table `spaces`.`spaces_guests` trx id 9 556401307 lock_mode X locks rec but not gap waiting Record lock, heap no 413 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 20; hex 3932343231333135383537343039363120202020; asc 9242131585740961 ;; 1: len 6; hex 000016b3ba78; asc x;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 9 605429563 Purge done for trx's n:o < 9 605390532 undo n:o < 0 0 History list length 2515 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1237219648 MySQL thread id 2492232, query id 3140557841 localhost 127.0.0.1 root drop table if exists innodb_deadlock_killer ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1236617536 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492221, query id 3140557800 data.spaces.ru 10.0.0.5 spaces updating DELETE FROM spaces_guests WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(mtime)) > '300' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1156938048 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492217, query id 3140557789 data.spaces.ru 10.0.0.5 spaces Updating UPDATE spaces_users_remarks SET active=0 WHERE ctime < (FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()) - ban_time)) ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1240430912 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492216, query id 3140557786 data.spaces.ru 10.0.0.5 spaces updating DELETE FROM spaces_bans WHERE UNIX_TIMESTAMP(NOW()) > (UNIX_TIMESTAMP(ctime) + ban_time) ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1273747776 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492215, query id 3140557783 data.spaces.ru 10.0.0.5 spaces updating delete from spaces_zags where married=0 and (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(ctime)) > 1800 ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1233004864 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492211, query id 3140557767 spaces 10.0.0.3 spaces Updating UPDATE spaces_comm_users SET atime = NOW() WHERE com_id = '4842' AND user_id = '495835' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1225578816 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492189, query id 3140557713 10.0.0.6 spaces Sending data SELECT *,((UNIX_TIMESTAMP(ctime) + ban_time) - UNIX_TIMESTAMP(NOW())) AS time_wait FROM spaces_users_remarks WHERE user_id='167460' AND service_id='19' AND com_id='0' AND active != 0 ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1219156288 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492175, query id 3140557671 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='16' WHERE user_id='204194' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1275955520 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492138, query id 3140557542 spaces 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='662323' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1271339328 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492115, query id 3140557499 spaces 10.0.0.3 spaces update INSERT INTO spaces_files_downloads SET user_id='295662', file_id='1001979', ctime=NOW(), owner_id='509577', adult='1' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1180821824 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492095, query id 3140557429 10.0.0.6 spaces Updating UPDATE spaces_users_anketa SET anketa_level='1241899380' WHERE user_id='648040' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1175001408 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492083, query id 3140557394 spaces 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='25' WHERE user_id='130359' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1190254912 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492055, query id 3140557316 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='38' WHERE user_id='137972' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1169783104 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492057, query id 3140557315 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='3726' ---TRANSACTION 0 0, not started, process no 29007, OS thread id 1160550720 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492051, query id 3140557297 spaces 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='647580' ---TRANSACTION 9 605428782, not started, process no 29007, OS thread id 1203300672 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2492022, query id 3140557457 data.spaces.ru 10.0.0.5 spaces update INSERT INTO spaces_chat SET room_id='9', ctime=NOW(), user_id='11889', msg='Пpaвoнapyшeниe в литepaтype, мyзыкe (7 букв)', flags='0', private='0', dst='0' ---TRANSACTION 9 605425257, not started, process no 29007, OS thread id 1200290112 MySQL thread id 2492019, query id 3140549719 10.0.0.6 spaces ---TRANSACTION 9 605418263, not started, process no 29007, OS thread id 1212332352 MySQL thread id 2491883, query id 3140555943 spaces 10.0.0.3 spaces ---TRANSACTION 9 605403671, not started, process no 29007, OS thread id 1249864000 MySQL thread id 2491868, query id 3140556345 spaces 10.0.0.3 spaces ---TRANSACTION 9 605374299, not started, process no 29007, OS thread id 1258092864 MySQL thread id 2491899, query id 3140555937 spaces 10.0.0.3 spaces ---TRANSACTION 9 605390507, not started, process no 29007, OS thread id 1243441472 MySQL thread id 2492001, query id 3140487536 spaces 10.0.0.3 spaces ---TRANSACTION 9 605368488, not started, process no 29007, OS thread id 1172994368 MySQL thread id 2491573, query id 3140557003 10.0.0.6 spaces ---TRANSACTION 9 605367238, not started, process no 29007, OS thread id 1276959040 MySQL thread id 2491920, query id 3140556405 spaces 10.0.0.3 spaces ---TRANSACTION 9 605391172, not started, process no 29007, OS thread id 1204906304 MySQL thread id 2491897, query id 3140556198 spaces 10.0.0.3 spaces ---TRANSACTION 9 605428322, not started, process no 29007, OS thread id 1212934464 MySQL thread id 2491987, query id 3140554942 spaces 10.0.0.3 spaces ---TRANSACTION 9 605360078, not started, process no 29007, OS thread id 1144092992 MySQL thread id 2491887, query id 3140556248 spaces 10.0.0.3 spaces ---TRANSACTION 9 605426203, not started, process no 29007, OS thread id 1168779584 MySQL thread id 2491554, query id 3140556279 10.0.0.6 spaces ---TRANSACTION 9 605343636, not started, process no 29007, OS thread id 1185638720 MySQL thread id 2491921, query id 3140556502 spaces 10.0.0.3 spaces ---TRANSACTION 9 605409939, not started, process no 29007, OS thread id 1222166848 MySQL thread id 2491982, query id 3140522882 spaces 10.0.0.3 spaces ---TRANSACTION 9 605339616, not started, process no 29007, OS thread id 1157540160 MySQL thread id 2491979, query id 3140395076 10.0.0.6 spaces ---TRANSACTION 9 605335011, not started, process no 29007, OS thread id 1179216192 MySQL thread id 2491889, query id 3140557182 spaces 10.0.0.3 spaces ---TRANSACTION 9 605398523, not started, process no 29007, OS thread id 1210124608 MySQL thread id 2491716, query id 3140556296 10.0.0.6 spaces ---TRANSACTION 9 605405434, not started, process no 29007, OS thread id 1177409856 MySQL thread id 2491912, query id 3140556451 10.0.0.6 spaces ---TRANSACTION 9 605383578, not started, process no 29007, OS thread id 1201695040 MySQL thread id 2491692, query id 3140555993 10.0.0.6 spaces ---TRANSACTION 9 605414672, not started, process no 29007, OS thread id 1157339456 MySQL thread id 2491928, query id 3140555960 spaces 10.0.0.3 spaces ---TRANSACTION 9 605360794, not started, process no 29007, OS thread id 1145096512 MySQL thread id 2491914, query id 3140556351 spaces 10.0.0.3 spaces ---TRANSACTION 9 605422114, not started, process no 29007, OS thread id 1212131648 MySQL thread id 2491964, query id 3140544167 10.0.0.6 spaces ---TRANSACTION 9 605427245, not started, process no 29007, OS thread id 1164765504 MySQL thread id 2491963, query id 3140553008 spaces 10.0.0.3 spaces ---TRANSACTION 9 605388620, not started, process no 29007, OS thread id 1185839424 MySQL thread id 2491603, query id 3140554993 10.0.0.6 spaces ---TRANSACTION 9 605356184, not started, process no 29007, OS thread id 1275152704 MySQL thread id 2491842, query id 3140556534 spaces 10.0.0.3 spaces ---TRANSACTION 9 605421454, not started, process no 29007, OS thread id 1152121152 MySQL thread id 2491960, query id 3140542958 spaces 10.0.0.3 spaces ---TRANSACTION 9 605423532, not started, process no 29007, OS thread id 1199085888 MySQL thread id 2491957, query id 3140546811 spaces 10.0.0.3 spaces ---TRANSACTION 9 605365501, not started, process no 29007, OS thread id 1161152832 MySQL thread id 2491917, query id 3140556529 spaces 10.0.0.3 spaces ---TRANSACTION 9 605391271, not started, process no 29007, OS thread id 1176004928 MySQL thread id 2491954, query id 3140488846 10.0.0.6 spaces ---TRANSACTION 9 605392889, not started, process no 29007, OS thread id 1166772544 MySQL thread id 2491809, query id 3140556270 spaces 10.0.0.3 spaces ---TRANSACTION 9 605423653, not started, process no 29007, OS thread id 1197078848 MySQL thread id 2491112, query id 3140556601 spaces 10.0.0.3 spaces ---TRANSACTION 9 605305667, not started, process no 29007, OS thread id 1184033088 MySQL thread id 2491596, query id 3140556800 10.0.0.6 spaces ---TRANSACTION 9 605333321, not started, process no 29007, OS thread id 1209923904 MySQL thread id 2491714, query id 3140556254 10.0.0.6 spaces ---TRANSACTION 9 605410645, not started, process no 29007, OS thread id 1191057728 MySQL thread id 2491942, query id 3140524195 spaces 10.0.0.3 spaces ---TRANSACTION 9 605423921, not started, process no 29007, OS thread id 1186842944 MySQL thread id 2491941, query id 3140547418 10.0.0.6 spaces ---TRANSACTION 9 605413743, not started, process no 29007, OS thread id 1188047168 MySQL thread id 2491940, query id 3140529641 spaces 10.0.0.3 spaces ---TRANSACTION 9 605375112, not started, process no 29007, OS thread id 1194871104 MySQL thread id 2491939, query id 3140460039 10.0.0.6 spaces ---TRANSACTION 9 605310809, not started, process no 29007, OS thread id 1157941568 MySQL thread id 2491528, query id 3140557772 10.0.0.6 spaces ---TRANSACTION 9 605296826, not started, process no 29007, OS thread id 1211730240 MySQL thread id 2491848, query id 3140556438 spaces 10.0.0.3 spaces ---TRANSACTION 9 605306433, not started, process no 29007, OS thread id 1250064704 MySQL thread id 2491935, query id 3140334268 spaces 10.0.0.3 spaces ---TRANSACTION 9 605424427, not started, process no 29007, OS thread id 1226983744 MySQL thread id 2491934, query id 3140548277 spaces 10.0.0.3 spaces ---TRANSACTION 9 605346486, not started, process no 29007, OS thread id 1223371072 MySQL thread id 2491910, query id 3140555985 10.0.0.6 spaces ---TRANSACTION 9 605429091, not started, process no 29007, OS thread id 1172592960 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491918, query id 3140557111 spaces 10.0.0.3 spaces Updating UPDATE spaces_users_anketa SET last_view = NOW() WHERE user_id = '432975' ---TRANSACTION 9 605429105, not started, process no 29007, OS thread id 1182026048 MySQL thread id 2491913, query id 3140556707 spaces 10.0.0.3 spaces ---TRANSACTION 9 605409791, not started, process no 29007, OS thread id 1199487296 MySQL thread id 2491906, query id 3140522555 10.0.0.6 spaces ---TRANSACTION 9 605425278, not started, process no 29007, OS thread id 1150716224 MySQL thread id 2491908, query id 3140549731 10.0.0.6 spaces ---TRANSACTION 9 605429245, not started, process no 29007, OS thread id 1256888640 MySQL thread id 2491886, query id 3140556851 spaces 10.0.0.3 spaces ---TRANSACTION 9 605365964, not started, process no 29007, OS thread id 1202899264 MySQL thread id 2491446, query id 3140556180 10.0.0.7 spaces ---TRANSACTION 9 605419112, not started, process no 29007, OS thread id 1165568320 MySQL thread id 2491881, query id 3140539012 spaces 10.0.0.3 spaces ---TRANSACTION 9 605357914, not started, process no 29007, OS thread id 1153526080 MySQL thread id 2491878, query id 3140428451 10.0.0.6 spaces ---TRANSACTION 9 605346664, not started, process no 29007, OS thread id 1208518976 MySQL thread id 2491708, query id 3140557201 10.0.0.6 spaces ---TRANSACTION 9 605409911, not started, process no 29007, OS thread id 1204304192 MySQL thread id 2491873, query id 3140522857 10.0.0.7 spaces ---TRANSACTION 9 605386440, not started, process no 29007, OS thread id 1170987328 MySQL thread id 2491818, query id 3140555980 spaces 10.0.0.3 spaces ---TRANSACTION 9 605419409, not started, process no 29007, OS thread id 1235614016 MySQL thread id 2491475, query id 3140556087 10.0.0.6 spaces ---TRANSACTION 9 605419125, not started, process no 29007, OS thread id 1280371008 MySQL thread id 2491421, query id 3140557175 10.0.0.7 spaces ---TRANSACTION 9 605415842, not started, process no 29007, OS thread id 1211328832 MySQL thread id 2491869, query id 3140532976 spaces 10.0.0.3 spaces ---TRANSACTION 9 605369083, not started, process no 29007, OS thread id 1218554176 MySQL thread id 2491314, query id 3140556269 spaces 10.0.0.3 spaces ---TRANSACTION 9 605376990, not started, process no 29007, OS thread id 1270937920 MySQL thread id 2491862, query id 3140463301 10.0.0.6 spaces ---TRANSACTION 9 605410851, not started, process no 29007, OS thread id 1207515456 MySQL thread id 2491861, query id 3140524384 spaces 10.0.0.3 spaces ---TRANSACTION 9 605323217, not started, process no 29007, OS thread id 1230596416 MySQL thread id 2491462, query id 3140550845 10.0.0.6 spaces ---TRANSACTION 9 605240133, not started, process no 29007, OS thread id 1197279552 MySQL thread id 2491678, query id 3140557593 spaces 10.0.0.3 spaces ---TRANSACTION 9 605241410, not started, process no 29007, OS thread id 1158945088 MySQL thread id 2491660, query id 3140556386 10.0.0.6 spaces ---TRANSACTION 9 605325279, not started, process no 29007, OS thread id 1273948480 MySQL thread id 2491602, query id 3140556312 10.0.0.6 spaces ---TRANSACTION 9 605386174, not started, process no 29007, OS thread id 1255082304 MySQL thread id 2491855, query id 3140506374 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429156, not started, process no 29007, OS thread id 1235212608 MySQL thread id 2491847, query id 3140556763 spaces 10.0.0.3 spaces freeing items SELECT * FROM spaces_users_anketa WHERE user_id='638889' ---TRANSACTION 9 605348120, not started, process no 29007, OS thread id 1198483776 MySQL thread id 2491682, query id 3140556606 10.0.0.6 spaces ---TRANSACTION 9 605391545, not started, process no 29007, OS thread id 1211930944 MySQL thread id 2491720, query id 3140556397 10.0.0.6 spaces ---TRANSACTION 9 605312182, not started, process no 29007, OS thread id 1148909888 MySQL thread id 2491412, query id 3140556624 10.0.0.6 spaces ---TRANSACTION 9 605397812, not started, process no 29007, OS thread id 1159948608 MySQL thread id 2491816, query id 3140555932 spaces 10.0.0.3 spaces ---TRANSACTION 9 605379655, not started, process no 29007, OS thread id 1162758464 MySQL thread id 2491539, query id 3140556335 10.0.0.6 spaces ---TRANSACTION 9 605409300, not started, process no 29007, OS thread id 1251871040 MySQL thread id 2491440, query id 3140556008 10.0.0.7 spaces ---TRANSACTION 9 605421278, not started, process no 29007, OS thread id 1178011968 MySQL thread id 2491436, query id 3140555959 10.0.0.7 spaces ---TRANSACTION 9 605297766, not started, process no 29007, OS thread id 1260501312 MySQL thread id 2491428, query id 3140556306 10.0.0.7 spaces ---TRANSACTION 9 605409198, not started, process no 29007, OS thread id 1213536576 MySQL thread id 2491470, query id 3140556482 10.0.0.7 spaces ---TRANSACTION 9 605333248, not started, process no 29007, OS thread id 1177811264 MySQL thread id 2491771, query id 3140556506 spaces 10.0.0.3 spaces ---TRANSACTION 9 605426555, not started, process no 29007, OS thread id 1253476672 MySQL thread id 2491830, query id 3140551941 10.0.0.6 spaces ---TRANSACTION 9 605427958, not started, process no 29007, OS thread id 1278966080 MySQL thread id 2491829, query id 3140554440 spaces 10.0.0.3 spaces ---TRANSACTION 9 605369930, not started, process no 29007, OS thread id 1158342976 MySQL thread id 2491439, query id 3140556305 10.0.0.7 spaces ---TRANSACTION 9 605391841, not started, process no 29007, OS thread id 1146702144 MySQL thread id 2491388, query id 3140556221 10.0.0.6 spaces ---TRANSACTION 9 605423493, not started, process no 29007, OS thread id 1234008384 MySQL thread id 2491443, query id 3140557213 10.0.0.7 spaces ---TRANSACTION 9 605428575, not started, process no 29007, OS thread id 1154328896 MySQL thread id 2491519, query id 3140555978 10.0.0.6 spaces ---TRANSACTION 9 605400966, not started, process no 29007, OS thread id 1162156352 MySQL thread id 2491538, query id 3140556297 10.0.0.6 spaces ---TRANSACTION 9 605429358, not started, process no 29007, OS thread id 1160350016 MySQL thread id 2491059, query id 3140556894 spaces 10.0.0.3 spaces ---TRANSACTION 9 605428780, not started, process no 29007, OS thread id 1255885120 MySQL thread id 2491819, query id 3140555710 10.0.0.6 spaces ---TRANSACTION 9 605429283, not started, process no 29007, OS thread id 1204705600 MySQL thread id 2491817, query id 3140556901 spaces 10.0.0.3 spaces freeing items SELECT COUNT(*) FROM spaces_comm_users WHERE user_id = '542643' ---TRANSACTION 9 605428267, not started, process no 29007, OS thread id 1158744384 MySQL thread id 2491815, query id 3140555906 spaces 10.0.0.3 spaces ---TRANSACTION 9 605400038, not started, process no 29007, OS thread id 1201895744 MySQL thread id 2491693, query id 3140547593 10.0.0.6 spaces ---TRANSACTION 9 605425542, not started, process no 29007, OS thread id 1182828864 MySQL thread id 2491305, query id 3140555957 spaces 10.0.0.3 spaces ---TRANSACTION 9 605388388, not started, process no 29007, OS thread id 1261504832 MySQL thread id 2491341, query id 3140557169 10.0.0.7 spaces ---TRANSACTION 9 605424055, not started, process no 29007, OS thread id 1149311296 MySQL thread id 2491806, query id 3140547674 10.0.0.6 spaces ---TRANSACTION 9 605367414, not started, process no 29007, OS thread id 1283381568 MySQL thread id 2491390, query id 3140554337 10.0.0.6 spaces ---TRANSACTION 9 605360684, not started, process no 29007, OS thread id 1193265472 MySQL thread id 2491406, query id 3140556566 10.0.0.7 spaces ---TRANSACTION 9 605245837, not started, process no 29007, OS thread id 1208719680 MySQL thread id 2491709, query id 3140556396 10.0.0.6 spaces ---TRANSACTION 9 605354994, not started, process no 29007, OS thread id 1205909824 MySQL thread id 2491373, query id 3140556272 10.0.0.7 spaces ---TRANSACTION 9 605212195, not started, process no 29007, OS thread id 1178413376 MySQL thread id 2491587, query id 3140557196 10.0.0.6 spaces ---TRANSACTION 9 605428197, not started, process no 29007, OS thread id 1217149248 MySQL thread id 2491804, query id 3140554769 10.0.0.6 spaces ---TRANSACTION 9 605408808, not started, process no 29007, OS thread id 1256286528 MySQL thread id 2491801, query id 3140520779 10.0.0.6 spaces ---TRANSACTION 9 605421223, not started, process no 29007, OS thread id 1267124544 MySQL thread id 2491382, query id 3140556641 10.0.0.6 spaces ---TRANSACTION 9 605348246, not started, process no 29007, OS thread id 1195673920 MySQL thread id 2491545, query id 3140555998 10.0.0.6 spaces ---TRANSACTION 9 605376641, not started, process no 29007, OS thread id 1233205568 MySQL thread id 2491779, query id 3140462594 spaces 10.0.0.3 spaces ---TRANSACTION 9 605409957, not started, process no 29007, OS thread id 1254480192 MySQL thread id 2491447, query id 3140556182 10.0.0.7 spaces ---TRANSACTION 9 605426440, not started, process no 29007, OS thread id 1233807680 MySQL thread id 2491778, query id 3140551747 spaces 10.0.0.3 spaces ---TRANSACTION 9 605380553, not started, process no 29007, OS thread id 1179617600 MySQL thread id 2491589, query id 3140555975 10.0.0.6 spaces ---TRANSACTION 9 605171094, not started, process no 29007, OS thread id 1183230272 MySQL thread id 2491595, query id 3140557029 10.0.0.6 spaces ---TRANSACTION 9 605351162, not started, process no 29007, OS thread id 1260902720 MySQL thread id 2491336, query id 3140556242 10.0.0.7 spaces ---TRANSACTION 9 605395952, not started, process no 29007, OS thread id 1242638656 MySQL thread id 2491455, query id 3140555974 10.0.0.7 spaces ---TRANSACTION 9 605338864, not started, process no 29007, OS thread id 1282177344 MySQL thread id 2491365, query id 3140556605 10.0.0.7 spaces ---TRANSACTION 9 605419573, not started, process no 29007, OS thread id 1162959168 MySQL thread id 2491767, query id 3140539907 10.0.0.6 spaces ---TRANSACTION 9 605410510, not started, process no 29007, OS thread id 1161554240 MySQL thread id 2491766, query id 3140524036 10.0.0.6 spaces ---TRANSACTION 9 605422769, not started, process no 29007, OS thread id 1156737344 MySQL thread id 2491765, query id 3140545501 10.0.0.6 spaces ---TRANSACTION 9 605383920, not started, process no 29007, OS thread id 1181022528 MySQL thread id 2491350, query id 3140555783 10.0.0.7 spaces ---TRANSACTION 9 605354736, not started, process no 29007, OS thread id 1203099968 MySQL thread id 2491434, query id 3140556472 10.0.0.7 spaces ---TRANSACTION 9 605325493, not started, process no 29007, OS thread id 1186642240 MySQL thread id 2491401, query id 3140556201 10.0.0.7 spaces ---TRANSACTION 9 605410045, not started, process no 29007, OS thread id 1160952128 MySQL thread id 2491533, query id 3140555255 10.0.0.6 spaces ---TRANSACTION 9 605216088, not started, process no 29007, OS thread id 1195071808 MySQL thread id 2491425, query id 3140556572 10.0.0.6 spaces ---TRANSACTION 9 605375614, not started, process no 29007, OS thread id 1181624640 MySQL thread id 2491451, query id 3140556594 10.0.0.7 spaces ---TRANSACTION 9 605419534, not started, process no 29007, OS thread id 1151920448 MySQL thread id 2491468, query id 3140556176 10.0.0.7 spaces ---TRANSACTION 9 605395550, not started, process no 29007, OS thread id 1213937984 MySQL thread id 2491757, query id 3140496655 10.0.0.6 spaces ---TRANSACTION 9 605415735, not started, process no 29007, OS thread id 1245047104 MySQL thread id 2491756, query id 3140556803 10.0.0.6 spaces ---TRANSACTION 9 605411591, not started, process no 29007, OS thread id 1157138752 MySQL thread id 2491755, query id 3140525797 10.0.0.6 spaces ---TRANSACTION 9 605426264, not started, process no 29007, OS thread id 1172793664 MySQL thread id 2491754, query id 3140551518 10.0.0.7 spaces ---TRANSACTION 9 605320874, not started, process no 29007, OS thread id 1206511936 MySQL thread id 2491330, query id 3140556407 10.0.0.7 spaces ---TRANSACTION 9 605427935, not started, process no 29007, OS thread id 1141483840 MySQL thread id 2491379, query id 3140556084 10.0.0.7 spaces ---TRANSACTION 9 605148731, not started, process no 29007, OS thread id 1163561280 MySQL thread id 2491547, query id 3140556521 10.0.0.6 spaces ---TRANSACTION 9 605365163, not started, process no 29007, OS thread id 1192864064 MySQL thread id 2491344, query id 3140555979 10.0.0.7 spaces ---TRANSACTION 9 605401672, not started, process no 29007, OS thread id 1222568256 MySQL thread id 2491752, query id 3140507899 spaces 10.0.0.3 spaces ---TRANSACTION 9 605361105, not started, process no 29007, OS thread id 1202297152 MySQL thread id 2491748, query id 3140434205 10.0.0.6 spaces ---TRANSACTION 9 605331177, not started, process no 29007, OS thread id 1147705664 MySQL thread id 2491511, query id 3140556303 10.0.0.6 spaces ---TRANSACTION 9 605143737, not started, process no 29007, OS thread id 1207114048 MySQL thread id 2491453, query id 3140556200 10.0.0.7 spaces ---TRANSACTION 9 605141830, not started, process no 29007, OS thread id 1173596480 MySQL thread id 2491574, query id 3140556504 10.0.0.6 spaces ---TRANSACTION 9 605415667, not started, process no 29007, OS thread id 1187244352 MySQL thread id 2491606, query id 3140557627 10.0.0.6 spaces ---TRANSACTION 9 605422856, not started, process no 29007, OS thread id 1196878144 MySQL thread id 2491743, query id 3140545697 10.0.0.7 spaces ---TRANSACTION 9 605384881, not started, process no 29007, OS thread id 1191860544 MySQL thread id 2491621, query id 3140556302 10.0.0.6 spaces ---TRANSACTION 9 605275358, not started, process no 29007, OS thread id 1168177472 MySQL thread id 2491553, query id 3140556177 10.0.0.6 spaces ---TRANSACTION 9 605139464, not started, process no 29007, OS thread id 1246251328 MySQL thread id 2491372, query id 3140555776 10.0.0.7 spaces ---TRANSACTION 9 605425950, not started, process no 29007, OS thread id 1214941504 MySQL thread id 2491742, query id 3140551086 10.0.0.6 spaces ---TRANSACTION 9 605423847, not started, process no 29007, OS thread id 1170385216 MySQL thread id 2491741, query id 3140547281 10.0.0.6 spaces ---TRANSACTION 9 605286558, not started, process no 29007, OS thread id 1153927488 MySQL thread id 2491517, query id 3140557212 10.0.0.6 spaces ---TRANSACTION 9 605422425, not started, process no 29007, OS thread id 1215543616 MySQL thread id 2491734, query id 3140544812 10.0.0.6 spaces ---TRANSACTION 9 605422408, not started, process no 29007, OS thread id 1215142208 MySQL thread id 2491732, query id 3140544777 spaces 10.0.0.3 spaces ---TRANSACTION 9 605414874, not started, process no 29007, OS thread id 1214740800 MySQL thread id 2491728, query id 3140545093 10.0.0.6 spaces ---TRANSACTION 9 605409371, not started, process no 29007, OS thread id 1214339392 MySQL thread id 2491727, query id 3140521882 spaces 10.0.0.3 spaces ---TRANSACTION 9 605415293, not started, process no 29007, OS thread id 1213335872 MySQL thread id 2491723, query id 3140532124 10.0.0.7 spaces ---TRANSACTION 9 605429212, not started, process no 29007, OS thread id 1210325312 MySQL thread id 2491717, query id 3140556773 10.0.0.6 spaces freeing items SELECT * FROM spaces_myfiles WHERE file_id = '302928' ---TRANSACTION 9 605429184, not started, process no 29007, OS thread id 1231800640 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491705, query id 3140557202 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='30' WHERE user_id='655611' ---TRANSACTION 9 605429445, not started, process no 29007, OS thread id 1206712640 waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2491706, query id 3140557132 10.0.0.6 spaces Copying to tmp table SELECT SUM(activity) FROM (SELECT DISTINCT spaces_users.nid, activity FROM spaces_favorites LEFT JOIN spaces_users ON (spaces_favorites.user_id = spaces_users.nid) WHERE type_id='0' AND object_id='407151') AS aaa ---TRANSACTION 9 605374352, not started, process no 29007, OS thread id 1208920384 MySQL thread id 2491710, query id 3140458592 10.0.0.6 spaces ---TRANSACTION 9 605422445, not started, process no 29007, OS thread id 1206311232 MySQL thread id 2491702, query id 3140544860 10.0.0.6 spaces ---TRANSACTION 9 605408922, not started, process no 29007, OS thread id 1206110528 MySQL thread id 2491701, query id 3140520951 10.0.0.6 spaces ---TRANSACTION 9 605429249, not started, process no 29007, OS thread id 1203501376 MySQL thread id 2491696, query id 3140556835 10.0.0.6 spaces ---TRANSACTION 9 605378128, not started, process no 29007, OS thread id 1261906240 MySQL thread id 2491394, query id 3140555995 10.0.0.7 spaces ---TRANSACTION 9 605343875, not started, process no 29007, OS thread id 1202096448 MySQL thread id 2491694, query id 3140556237 10.0.0.6 spaces ---TRANSACTION 9 605424045, not started, process no 29007, OS thread id 1200691520 MySQL thread id 2491689, query id 3140547646 10.0.0.6 spaces ---TRANSACTION 9 605420992, not started, process no 29007, OS thread id 1152522560 MySQL thread id 2491409, query id 3140556614 10.0.0.7 spaces ---TRANSACTION 9 605419205, not started, process no 29007, OS thread id 1193867584 MySQL thread id 2491662, query id 3140539218 10.0.0.6 spaces ---TRANSACTION 9 605360427, not started, process no 29007, OS thread id 1171589440 MySQL thread id 2491396, query id 3140556288 10.0.0.7 spaces ---TRANSACTION 9 605356791, not started, process no 29007, OS thread id 1168578880 MySQL thread id 2491657, query id 3140426508 10.0.0.6 spaces ---TRANSACTION 9 605418378, not started, process no 29007, OS thread id 1214540096 MySQL thread id 2491656, query id 3140537571 10.0.0.7 spaces ---TRANSACTION 9 605341197, not started, process no 29007, OS thread id 1246452032 MySQL thread id 2491357, query id 3140555977 10.0.0.7 spaces ---TRANSACTION 9 605385232, not started, process no 29007, OS thread id 1173195072 MySQL thread id 2491345, query id 3140556604 10.0.0.7 spaces ---TRANSACTION 9 605395071, not started, process no 29007, OS thread id 1204504896 MySQL thread id 2491414, query id 3140556284 10.0.0.7 spaces ---TRANSACTION 9 605320465, not started, process no 29007, OS thread id 1178212672 MySQL thread id 2491650, query id 3140359954 10.0.0.6 spaces ---TRANSACTION 9 605379016, not started, process no 29007, OS thread id 1255684416 MySQL thread id 2491645, query id 3140466875 10.0.0.6 spaces ---TRANSACTION 9 605429047, not started, process no 29007, OS thread id 1236818240 MySQL thread id 2491644, query id 3140556440 10.0.0.6 spaces ---TRANSACTION 9 605420705, not started, process no 29007, OS thread id 1221163328 MySQL thread id 2491643, query id 3140541680 10.0.0.7 spaces ---TRANSACTION 9 605201370, not started, process no 29007, OS thread id 1266121024 MySQL thread id 2491410, query id 3140556503 10.0.0.7 spaces ---TRANSACTION 9 605419056, not started, process no 29007, OS thread id 1252874560 MySQL thread id 2491641, query id 3140538896 10.0.0.6 spaces ---TRANSACTION 9 605220919, not started, process no 29007, OS thread id 1189050688 MySQL thread id 2491612, query id 3140556617 10.0.0.6 spaces ---TRANSACTION 9 605407153, not started, process no 29007, OS thread id 1237621056 MySQL thread id 2491640, query id 3140517858 10.0.0.7 spaces ---TRANSACTION 9 605422536, not started, process no 29007, OS thread id 1175202112 MySQL thread id 2491639, query id 3140545058 10.0.0.7 spaces ---TRANSACTION 9 605423102, not started, process no 29007, OS thread id 1269934400 MySQL thread id 2491636, query id 3140546125 10.0.0.7 spaces ---TRANSACTION 9 605405814, not started, process no 29007, OS thread id 1189251392 MySQL thread id 2491613, query id 3140555174 10.0.0.6 spaces ---TRANSACTION 9 605349887, not started, process no 29007, OS thread id 1234409792 MySQL thread id 2491457, query id 3140556561 10.0.0.7 spaces ---TRANSACTION 9 605344267, not started, process no 29007, OS thread id 1205508416 MySQL thread id 2491630, query id 3140403485 10.0.0.7 spaces ---TRANSACTION 9 605422354, not started, process no 29007, OS thread id 1194469696 MySQL thread id 2491629, query id 3140544646 10.0.0.7 spaces ---TRANSACTION 9 605422489, not started, process no 29007, OS thread id 1160149312 MySQL thread id 2491628, query id 3140551043 10.0.0.7 spaces ---TRANSACTION 9 605409222, not started, process no 29007, OS thread id 1190857024 MySQL thread id 2491617, query id 3140556331 10.0.0.6 spaces ---TRANSACTION 9 605367227, not started, process no 29007, OS thread id 1240230208 MySQL thread id 2491627, query id 3140445351 10.0.0.7 spaces ---TRANSACTION 9 605422265, not started, process no 29007, OS thread id 1248258368 MySQL thread id 2491626, query id 3140544474 10.0.0.6 spaces ---TRANSACTION 9 605389701, not started, process no 29007, OS thread id 1193666880 MySQL thread id 2491625, query id 3140486292 10.0.0.7 spaces ---TRANSACTION 9 605363323, not started, process no 29007, OS thread id 1193064768 MySQL thread id 2491624, query id 3140438353 10.0.0.6 spaces ---TRANSACTION 9 605424982, not started, process no 29007, OS thread id 1192261952 MySQL thread id 2491622, query id 3140549305 10.0.0.7 spaces ---TRANSACTION 9 605429297, not started, process no 29007, OS thread id 1191659840 MySQL thread id 2491620, query id 3140556914 10.0.0.6 spaces freeing items SELECT nid FROM spaces_blacklist WHERE user_id = '195161' AND enemy_id = '622776' ---TRANSACTION 9 605429185, not started, process no 29007, OS thread id 1190656320 MySQL thread id 2491616, query id 3140556682 10.0.0.6 spaces freeing items SELECT * FROM spaces_journal WHERE user_id = '141136' ORDER BY mtime DESC LIMIT 0,8 ---TRANSACTION 9 605418558, not started, process no 29007, OS thread id 1191258432 MySQL thread id 2491618, query id 3140537868 10.0.0.6 spaces ---TRANSACTION 9 605427522, not started, process no 29007, OS thread id 1191459136 MySQL thread id 2491619, query id 3140553560 10.0.0.6 spaces ---TRANSACTION 9 605429299, not started, process no 29007, OS thread id 1187645760 MySQL thread id 2491608, query id 3140556920 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '89086' ---TRANSACTION 9 605399845, not started, process no 29007, OS thread id 1189853504 MySQL thread id 2491614, query id 3140504683 10.0.0.7 spaces ---TRANSACTION 9 605407833, not started, process no 29007, OS thread id 1188448576 MySQL thread id 2491611, query id 3140519118 10.0.0.7 spaces ---TRANSACTION 9 605414036, not started, process no 29007, OS thread id 1163159872 MySQL thread id 2491377, query id 3140556382 10.0.0.7 spaces ---TRANSACTION 9 605386861, not started, process no 29007, OS thread id 1174198592 MySQL thread id 2491576, query id 3140481195 10.0.0.6 spaces ---TRANSACTION 9 605416605, not started, process no 29007, OS thread id 1173797184 MySQL thread id 2491575, query id 3140534399 10.0.0.6 spaces ---TRANSACTION 9 605337490, not started, process no 29007, OS thread id 1150515520 MySQL thread id 2491513, query id 3140555961 10.0.0.6 spaces ---TRANSACTION 9 605420552, not started, process no 29007, OS thread id 1169381696 MySQL thread id 2491557, query id 3140541423 10.0.0.6 spaces ---TRANSACTION 9 605422084, not started, process no 29007, OS thread id 1169180992 MySQL thread id 2491556, query id 3140544109 10.0.0.6 spaces ---TRANSACTION 9 605185383, not started, process no 29007, OS thread id 1146501440 MySQL thread id 2491504, query id 3140557156 10.0.0.6 spaces ---TRANSACTION 9 605298959, not started, process no 29007, OS thread id 1164564800 MySQL thread id 2491548, query id 3140321256 10.0.0.6 spaces ---TRANSACTION 9 605413855, not started, process no 29007, OS thread id 1224173888 MySQL thread id 2491542, query id 3140529850 10.0.0.7 spaces ---TRANSACTION 9 605429295, not started, process no 29007, OS thread id 1161353536 MySQL thread id 2491535, query id 3140556910 10.0.0.6 spaces freeing items SELECT new_count FROM spaces_myfiles WHERE user_id='105043' AND new_count != 0 ---TRANSACTION 9 605426733, not started, process no 29007, OS thread id 1216547136 MySQL thread id 2491324, query id 3140556361 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429137, not started, process no 29007, OS thread id 1149110592 MySQL thread id 2491512, query id 3140556696 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_mylenta_userlist WHERE lenta_user_id = '236243' ---TRANSACTION 9 605429273, not started, process no 29007, OS thread id 1154128192 MySQL thread id 2491518, query id 3140556892 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_friend_list WHERE user_id = '248416' ---TRANSACTION 9 605418895, not started, process no 29007, OS thread id 1156135232 MySQL thread id 2491522, query id 3140538585 10.0.0.7 spaces ---TRANSACTION 9 605197990, not started, process no 29007, OS thread id 1207314752 MySQL thread id 2491058, query id 3140556002 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429145, not started, process no 29007, OS thread id 1257089344 MySQL thread id 2491509, query id 3140556459 10.0.0.6 spaces freeing items SELECT * FROM spaces_forums WHERE forum_id = '11185' ---TRANSACTION 9 605221052, not started, process no 29007, OS thread id 1250666816 MySQL thread id 2491393, query id 3140556610 10.0.0.6 spaces ---TRANSACTION 9 605419191, not started, process no 29007, OS thread id 1282578752 MySQL thread id 2491404, query id 3140556541 10.0.0.6 spaces ---TRANSACTION 9 605428741, not started, process no 29007, OS thread id 1143490880 MySQL thread id 2491497, query id 3140555637 10.0.0.7 spaces ---TRANSACTION 9 605403933, not started, process no 29007, OS thread id 1144293696 MySQL thread id 2491498, query id 3140511981 10.0.0.7 spaces ---TRANSACTION 9 605200487, not started, process no 29007, OS thread id 1265719616 MySQL thread id 2491459, query id 3140557154 10.0.0.6 spaces ---TRANSACTION 9 605368643, not started, process no 29007, OS thread id 1265920320 MySQL thread id 2491485, query id 3140522516 10.0.0.6 spaces ---TRANSACTION 9 605404507, not started, process no 29007, OS thread id 1276557632 MySQL thread id 2491484, query id 3140512997 10.0.0.6 spaces ---TRANSACTION 9 605429151, not started, process no 29007, OS thread id 1238423872 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491473, query id 3140557130 10.0.0.6 spaces Updating UPDATE spaces_chat_users SET last_time='1241899442' WHERE room_id='12' AND user_id='520628' ---TRANSACTION 9 605384270, not started, process no 29007, OS thread id 1170786624 MySQL thread id 2491477, query id 3140499535 10.0.0.7 spaces ---TRANSACTION 9 605429193, not started, process no 29007, OS thread id 1272342848 MySQL thread id 2491472, query id 3140556825 10.0.0.6 spaces ---TRANSACTION 9 605429291, not started, process no 29007, OS thread id 1180219712 MySQL thread id 2491469, query id 3140556841 10.0.0.7 spaces ---TRANSACTION 9 605420832, not started, process no 29007, OS thread id 1145698624 MySQL thread id 2491466, query id 3140541895 10.0.0.7 spaces ---TRANSACTION 9 605426167, not started, process no 29007, OS thread id 1161955648 MySQL thread id 2491465, query id 3140551348 10.0.0.7 spaces ---TRANSACTION 9 605417428, not started, process no 29007, OS thread id 1282779456 MySQL thread id 2491464, query id 3140535916 10.0.0.7 spaces ---TRANSACTION 9 605426169, not started, process no 29007, OS thread id 1151318336 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491461, query id 3140557222 10.0.0.6 spaces Updating UPDATE spaces_users_events SET mail_new = (mail_new + 1) WHERE user_id='83198' ---TRANSACTION 9 605303761, not started, process no 29007, OS thread id 1149913408 MySQL thread id 2491449, query id 3140556775 10.0.0.7 spaces ---TRANSACTION 9 605399079, not started, process no 29007, OS thread id 1241434432 MySQL thread id 2491463, query id 3140503132 10.0.0.6 spaces ---TRANSACTION 9 605402144, not started, process no 29007, OS thread id 1167173952 MySQL thread id 2491270, query id 3140556271 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429149, not started, process no 29007, OS thread id 1143691584 MySQL thread id 2491454, query id 3140556756 10.0.0.7 spaces freeing items SELECT * from spaces_pictures WHERE pic_id='1445927' ---TRANSACTION 9 605429063, not started, process no 29007, OS thread id 1159547200 MySQL thread id 2491452, query id 3140556669 10.0.0.7 spaces freeing items SELECT * FROM spaces_myfiles WHERE file_id = '1134753' ---TRANSACTION 9 605399054, not started, process no 29007, OS thread id 1242237248 MySQL thread id 2491294, query id 3140556466 spaces 10.0.0.3 spaces ---TRANSACTION 9 605427341, not started, process no 29007, OS thread id 1210726720 MySQL thread id 2491441, query id 3140553169 10.0.0.7 spaces ---TRANSACTION 9 605427100, not started, process no 29007, OS thread id 1185438016 MySQL thread id 2491431, query id 3140552778 10.0.0.6 spaces ---TRANSACTION 9 605409618, not started, process no 29007, OS thread id 1281976640 MySQL thread id 2491430, query id 3140522249 10.0.0.6 spaces ---TRANSACTION 9 605429066, not started, process no 29007, OS thread id 1260300608 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491424, query id 3140557114 10.0.0.6 spaces Updating UPDATE spaces_users SET last_time = '1241899442', online_time = online_time + '100' WHERE nid = '645987' ---TRANSACTION 9 605394182, not started, process no 29007, OS thread id 1245649216 MySQL thread id 2491337, query id 3140556512 10.0.0.7 spaces ---TRANSACTION 9 605428011, not started, process no 29007, OS thread id 1241835840 MySQL thread id 2491343, query id 3140557214 10.0.0.7 spaces ---TRANSACTION 9 605397659, not started, process no 29007, OS thread id 1170184512 MySQL thread id 2491422, query id 3140500432 10.0.0.7 spaces ---TRANSACTION 9 605421247, not started, process no 29007, OS thread id 1183832384 MySQL thread id 2491419, query id 3140542619 10.0.0.7 spaces ---TRANSACTION 9 605411823, not started, process no 29007, OS thread id 1149712704 MySQL thread id 2491363, query id 3140556265 10.0.0.7 spaces ---TRANSACTION 9 605374135, not started, process no 29007, OS thread id 1247254848 MySQL thread id 2491417, query id 3140458169 10.0.0.6 spaces ---TRANSACTION 9 605428908, not started, process no 29007, OS thread id 1148107072 MySQL thread id 2491348, query id 3140556042 10.0.0.7 spaces ---TRANSACTION 9 605419838, not started, process no 29007, OS thread id 1152723264 MySQL thread id 2491416, query id 3140540304 10.0.0.6 spaces ---TRANSACTION 9 605425540, not started, process no 29007, OS thread id 1206913344 MySQL thread id 2491415, query id 3140550141 10.0.0.6 spaces ---TRANSACTION 9 605429270, not started, process no 29007, OS thread id 1231399232 MySQL thread id 2491403, query id 3140556891 10.0.0.7 spaces freeing items SELECT COUNT(*) FROM spaces_diary_topics WHERE user_id = '8590' ---TRANSACTION 9 605429356, not started, process no 29007, OS thread id 1231198528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491405, query id 3140557079 10.0.0.6 spaces statistics SELECT *,((UNIX_TIMESTAMP(ctime) + ban_time) - UNIX_TIMESTAMP(NOW())) AS time_wait FROM spaces_bans WHERE user_id='439966' AND service_id='25' AND com_id='2458' ---TRANSACTION 9 605416126, not started, process no 29007, OS thread id 1225779520 MySQL thread id 2491380, query id 3140533540 10.0.0.7 spaces ---TRANSACTION 9 605429019, not started, process no 29007, OS thread id 1183029568 MySQL thread id 2491378, query id 3140556285 10.0.0.7 spaces ---TRANSACTION 9 605357637, not started, process no 29007, OS thread id 1187043648 MySQL thread id 2491374, query id 3140428025 10.0.0.7 spaces ---TRANSACTION 9 605427555, not started, process no 29007, OS thread id 1278765376 MySQL thread id 2491370, query id 3140553604 10.0.0.7 spaces ---TRANSACTION 9 605381327, not started, process no 29007, OS thread id 1205307712 MySQL thread id 2491332, query id 3140557174 10.0.0.7 spaces ---TRANSACTION 9 605387739, not started, process no 29007, OS thread id 1237018944 MySQL thread id 2491368, query id 3140482744 10.0.0.7 spaces ---TRANSACTION 9 605408281, not started, process no 29007, OS thread id 1218754880 MySQL thread id 2491367, query id 3140519858 10.0.0.7 spaces ---TRANSACTION 9 605429355, not started, process no 29007, OS thread id 1197480256 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491364, query id 3140557141 10.0.0.7 spaces update INSERT INTO spaces_guests SET sid='5048883231448396', mtime=NOW(), ip_address='90.139.241.101', user_agent='SonyEricssonW200i/R4JA Browser/NetFront/3.3 Profile/MIDP-2.0 Configuration/CLDC-1.1', mobile_device='SonyEricsson W200i', reklama_cursor='2', flags='0' ---TRANSACTION 9 605422975, not started, process no 29007, OS thread id 1188849984 MySQL thread id 2491359, query id 3140545913 10.0.0.7 spaces ---TRANSACTION 9 605393024, not started, process no 29007, OS thread id 1176406336 MySQL thread id 2491358, query id 3140492094 10.0.0.7 spaces ---TRANSACTION 9 605409589, not started, process no 29007, OS thread id 1173997888 MySQL thread id 2491353, query id 3140522267 10.0.0.7 spaces ---TRANSACTION 9 605429040, not started, process no 29007, OS thread id 1265318208 MySQL thread id 2491349, query id 3140556424 10.0.0.7 spaces ---TRANSACTION 9 605429274, not started, process no 29007, OS thread id 1261705536 MySQL thread id 2491342, query id 3140556893 10.0.0.7 spaces freeing items SELECT * FROM spaces_chat_users WHERE room_id='12' AND user_id='386380' ---TRANSACTION 9 605428983, not started, process no 29007, OS thread id 1195473216 MySQL thread id 2491334, query id 3140556342 10.0.0.7 spaces freeing items SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1715' ORDER BY rate DESC LIMIT 0,5 ---TRANSACTION 9 605429428, not started, process no 29007, OS thread id 1234209088 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491335, query id 3140557115 10.0.0.7 spaces updating DELETE FROM spaces_sessions WHERE user_id='119300' ---TRANSACTION 9 605404296, not started, process no 29007, OS thread id 1265518912 MySQL thread id 2491333, query id 3140512588 10.0.0.7 spaces ---TRANSACTION 9 605429286, not started, process no 29007, OS thread id 1216747840 MySQL thread id 2491301, query id 3140556886 spaces 10.0.0.3 spaces freeing items SELECT * FROM spaces_shared_zone_files WHERE file_id = '164663' AND source = '0' AND com_id = 0 ---TRANSACTION 9 605429359, not started, process no 29007, OS thread id 1190054208 MySQL thread id 2491304, query id 3140557012 spaces 10.0.0.3 spaces ---TRANSACTION 9 605399259, not started, process no 29007, OS thread id 1184233792 MySQL thread id 2491026, query id 3140555781 spaces 10.0.0.3 spaces ---TRANSACTION 9 605276699, not started, process no 29007, OS thread id 1172392256 MySQL thread id 2491109, query id 3140556267 spaces 10.0.0.3 spaces ---TRANSACTION 9 605376021, not started, process no 29007, OS thread id 1261304128 MySQL thread id 2491032, query id 3140556230 spaces 10.0.0.3 spaces ---TRANSACTION 9 605352669, not started, process no 29007, OS thread id 1239828800 MySQL thread id 2491147, query id 3140556211 spaces 10.0.0.3 spaces ---TRANSACTION 9 605410873, not started, process no 29007, OS thread id 1164364096 MySQL thread id 2491243, query id 3140524666 spaces 10.0.0.3 spaces ---TRANSACTION 9 605317867, not started, process no 29007, OS thread id 1199286592 MySQL thread id 2491127, query id 3140556313 spaces 10.0.0.3 spaces ---TRANSACTION 9 605398130, not started, process no 29007, OS thread id 1283983680 MySQL thread id 2491036, query id 3140556266 spaces 10.0.0.3 spaces ---TRANSACTION 9 605421715, not started, process no 29007, OS thread id 1155332416 MySQL thread id 2491217, query id 3140543474 spaces 10.0.0.3 spaces ---TRANSACTION 9 605297680, not started, process no 29007, OS thread id 1268128064 MySQL thread id 2490995, query id 3140551918 spaces 10.0.0.3 spaces ---TRANSACTION 9 605408923, not started, process no 29007, OS thread id 1196276032 MySQL thread id 2491215, query id 3140520953 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429072, not started, process no 29007, OS thread id 1227786560 MySQL thread id 2491214, query id 3140556674 spaces 10.0.0.3 spaces ---TRANSACTION 9 605427813, not started, process no 29007, OS thread id 1247455552 MySQL thread id 2491208, query id 3140554055 spaces 10.0.0.3 spaces ---TRANSACTION 9 605424338, not started, process no 29007, OS thread id 1234610496 MySQL thread id 2491197, query id 3140548154 spaces 10.0.0.3 spaces ---TRANSACTION 9 605426865, not started, process no 29007, OS thread id 1165769024 MySQL thread id 2491170, query id 3140552483 spaces 10.0.0.3 spaces ---TRANSACTION 9 605410841, not started, process no 29007, OS thread id 1266923840 MySQL thread id 2491132, query id 3140524526 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429107, not started, process no 29007, OS thread id 1280571712 MySQL thread id 2491106, query id 3140556709 spaces 10.0.0.3 spaces freeing items SELECT * FROM spaces_diary_comments WHERE comment_id = '6207156' ---TRANSACTION 9 605395585, not started, process no 29007, OS thread id 1167976768 MySQL thread id 2491087, query id 3140496697 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429341, not started, process no 29007, OS thread id 1173395776 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2491050, query id 3140557062 spaces 10.0.0.3 spaces Updating UPDATE spaces_files_tracking SET page='1',comments_cnt='94', last_comment_id='735071' WHERE user_id='350638' AND object_id='987105' ---TRANSACTION 9 605429398, not started, process no 29007, OS thread id 1250265408 MySQL thread id 2491029, query id 3140557066 spaces 10.0.0.3 spaces ---TRANSACTION 9 605429562, ACTIVE 36 sec, process no 29007, OS thread id 1237219648 dropping table MySQL thread id 2492232, query id 3140557841 localhost 127.0.0.1 root drop table if exists innodb_deadlock_killer ---TRANSACTION 9 605429561, ACTIVE 188 sec, process no 29007, OS thread id 1235814720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492219, query id 3140557797 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='170150150805.20040118201000' Trx read view will not see trx with id >= 9 605429562, sees < 9 605428911 ---TRANSACTION 9 605429560, ACTIVE 194 sec, process no 29007, OS thread id 1235413312 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492218, query id 3140557792 data.spaces.ru 10.0.0.5 spaces Sending data SELECT * FROM spaces_chat_rooms Trx read view will not see trx with id >= 9 605429561, sees < 9 605428911 ---TRANSACTION 9 605429559, ACTIVE 225 sec, process no 29007, OS thread id 1234811200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492213, query id 3140557780 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='tagiran' Trx read view will not see trx with id >= 9 605429560, sees < 9 605428911 ---TRANSACTION 9 605429558, ACTIVE 236 sec, process no 29007, OS thread id 1155934528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491521, query id 3140557773 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='allex345' Trx read view will not see trx with id >= 9 605429559, sees < 9 605428911 ---TRANSACTION 9 605429557, ACTIVE 242 sec, process no 29007, OS thread id 1159145792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491933, query id 3140557768 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_6 WHERE nid='147096' AND user_id='606936' ---TRANSACTION 9 605429556, ACTIVE 247 sec, process no 29007, OS thread id 1232402752 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492209, query id 3140557758 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_music WHERE file_id = '398326' ---TRANSACTION 9 605429555, ACTIVE 247 sec, process no 29007, OS thread id 1232001344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492207, query id 3140557753 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1735' ORDER BY rate DESC LIMIT 25,5 Trx read view will not see trx with id >= 9 605429556, sees < 9 605428911 ---TRANSACTION 9 605429554, ACTIVE 247 sec, process no 29007, OS thread id 1230797120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492204, query id 3140557752 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '5008' AND user_id = '405956' Trx read view will not see trx with id >= 9 605429555, sees < 9 605428911 ---TRANSACTION 9 605429553, ACTIVE 247 sec, process no 29007, OS thread id 1230395712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492203, query id 3140557750 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='377139' Trx read view will not see trx with id >= 9 605429554, sees < 9 605428911 ---TRANSACTION 9 605429552, ACTIVE 247 sec, process no 29007, OS thread id 1229994304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492201, query id 3140557745 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='10' AND user_id='589844' Trx read view will not see trx with id >= 9 605429553, sees < 9 605428911 ---TRANSACTION 9 605429551, ACTIVE 247 sec, process no 29007, OS thread id 1229592896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492199, query id 3140557735 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_guests WHERE ip_address='87.250.231.32' AND user_agent='Yandex/1.01.001 (compatible; Win16; I)' Trx read view will not see trx with id >= 9 605429552, sees < 9 605428911 ---TRANSACTION 9 605429550, ACTIVE 247 sec, process no 29007, OS thread id 1229191488 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492197, query id 3140557730 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='71310' ---TRANSACTION 9 605429549, ACTIVE 247 sec, process no 29007, OS thread id 1228589376 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492195, query id 3140557729 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='17ATATA71' Trx read view will not see trx with id >= 9 605429550, sees < 9 605428911 ---TRANSACTION 9 605429548, ACTIVE 247 sec, process no 29007, OS thread id 1228187968 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492193, query id 3140557724 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1097167' Trx read view will not see trx with id >= 9 605429549, sees < 9 605428911 ---TRANSACTION 9 605429547, ACTIVE 247 sec, process no 29007, OS thread id 1226783040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492191, query id 3140557714 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Rosse' Trx read view will not see trx with id >= 9 605429548, sees < 9 605428911 ---TRANSACTION 9 605429546, ACTIVE 247 sec, process no 29007, OS thread id 1225177408 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492187, query id 3140557708 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='12' AND user_id='564792' Trx read view will not see trx with id >= 9 605429547, sees < 9 605428911 ---TRANSACTION 9 605429545, ACTIVE 247 sec, process no 29007, OS thread id 1224374592 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492185, query id 3140557698 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='360367' ---TRANSACTION 9 605429544, ACTIVE 247 sec, process no 29007, OS thread id 1223170368 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492183, query id 3140557689 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_friend_list WHERE user_id = '87058' Trx read view will not see trx with id >= 9 605429545, sees < 9 605428911 ---TRANSACTION 9 605429543, ACTIVE 247 sec, process no 29007, OS thread id 1222768960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492181, query id 3140557688 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7038179648580361' ---TRANSACTION 9 605429542, ACTIVE 247 sec, process no 29007, OS thread id 1221364032 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492179, query id 3140557683 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='12' AND user_id='667794' Trx read view will not see trx with id >= 9 605429543, sees < 9 605428911 ---TRANSACTION 9 605429541, ACTIVE 247 sec, process no 29007, OS thread id 1219959104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492177, query id 3140557681 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='12' AND user_id='651655' Trx read view will not see trx with id >= 9 605429542, sees < 9 605428911 ---TRANSACTION 9 605429540, ACTIVE 247 sec, process no 29007, OS thread id 1219356992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492171, query id 3140557666 10.0.0.6 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '5008' AND user_id = '90969' Trx read view will not see trx with id >= 9 605429541, sees < 9 605428911 ---TRANSACTION 9 605429539, ACTIVE 247 sec, process no 29007, OS thread id 1218152768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492173, query id 3140557664 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='9' AND user_id='429960' Trx read view will not see trx with id >= 9 605429540, sees < 9 605428911 ---TRANSACTION 9 605429538, ACTIVE 247 sec, process no 29007, OS thread id 1144695104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492169, query id 3140557654 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1004943' Trx read view will not see trx with id >= 9 605429539, sees < 9 605428911 ---TRANSACTION 9 605429537, ACTIVE 247 sec, process no 29007, OS thread id 1148508480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492167, query id 3140557636 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8310991386058032' ---TRANSACTION 9 605429536, ACTIVE 247 sec, process no 29007, OS thread id 1272744256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492165, query id 3140557635 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='154974' ---TRANSACTION 9 605429535, ACTIVE 247 sec, process no 29007, OS thread id 1207916864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492160, query id 3140557631 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4582443300649268' ---TRANSACTION 9 605429534, ACTIVE 247 sec, process no 29007, OS thread id 1245448512 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492164, query id 3140557629 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_data_5 WHERE nid = '1083569' Trx read view will not see trx with id >= 9 605429535, sees < 9 605428911 ---TRANSACTION 9 605429533, ACTIVE 247 sec, process no 29007, OS thread id 1184635200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491597, query id 3140557628 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='lenacool8585' Trx read view will not see trx with id >= 9 605429534, sees < 9 605428911 ---TRANSACTION 9 605429532, ACTIVE 247 sec, process no 29007, OS thread id 1245247808 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492158, query id 3140557620 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='606735' ---TRANSACTION 9 605429531, ACTIVE 247 sec, process no 29007, OS thread id 1177209152 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492156, query id 3140557614 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='0604675858569219' ---TRANSACTION 9 605429530, ACTIVE 248 sec, process no 29007, OS thread id 1241233728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492154, query id 3140557607 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1382289' Trx read view will not see trx with id >= 9 605429531, sees < 9 605428911 ---TRANSACTION 9 605429529, ACTIVE 248 sec, process no 29007, OS thread id 1221765440 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491677, query id 3140557594 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235214041' Trx read view will not see trx with id >= 9 605429530, sees < 9 605428911 ---TRANSACTION 9 605429528, ACTIVE 248 sec, process no 29007, OS thread id 1175804224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492152, query id 3140557589 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='romec' Trx read view will not see trx with id >= 9 605429529, sees < 9 605428911 ---TRANSACTION 9 605429527, ACTIVE 248 sec, process no 29007, OS thread id 1175603520 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492146, query id 3140557584 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4808336453401349' ---TRANSACTION 9 605429526, ACTIVE 248 sec, process no 29007, OS thread id 1263913280 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492147, query id 3140557579 spaces 10.0.0.3 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='127115' Trx read view will not see trx with id >= 9 605429527, sees < 9 605428911 ---TRANSACTION 9 605429525, ACTIVE 248 sec, process no 29007, OS thread id 1203902784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492149, query id 3140557572 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_guests WHERE ip_address='85.140.63.227' AND user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10' Trx read view will not see trx with id >= 9 605429526, sees < 9 605428911 ---TRANSACTION 9 605429524, ACTIVE 248 sec, process no 29007, OS thread id 1167374656 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492144, query id 3140557562 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '106894' Trx read view will not see trx with id >= 9 605429525, sees < 9 605428911 ---TRANSACTION 9 605429523, ACTIVE 248 sec, process no 29007, OS thread id 1214138688 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492142, query id 3140557557 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='11' AND user_id='179246' Trx read view will not see trx with id >= 9 605429524, sees < 9 605428911 ---TRANSACTION 9 605429522, ACTIVE 248 sec, process no 29007, OS thread id 1183631680 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492140, query id 3140557555 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235060421' Trx read view will not see trx with id >= 9 605429523, sees < 9 605428911 ---TRANSACTION 9 605429521, ACTIVE 248 sec, process no 29007, OS thread id 1181825344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492136, query id 3140557541 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='3997222174380990' ---TRANSACTION 9 605429520, ACTIVE 248 sec, process no 29007, OS thread id 1168980288 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492134, query id 3140557540 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8385026494168810' ---TRANSACTION 9 605429519, ACTIVE 248 sec, process no 29007, OS thread id 1150114112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492132, query id 3140557531 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='0143295014416255' ---TRANSACTION 9 605429518, ACTIVE 248 sec, process no 29007, OS thread id 1190455616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492130, query id 3140557526 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1199882' Trx read view will not see trx with id >= 9 605429519, sees < 9 605428911 ---TRANSACTION 9 605429517, ACTIVE 249 sec, process no 29007, OS thread id 1256085824 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492126, query id 3140557516 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_friend_list WHERE user_id = '527621' Trx read view will not see trx with id >= 9 605429518, sees < 9 605428911 ---TRANSACTION 9 605429516, ACTIVE 249 sec, process no 29007, OS thread id 1200892224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492127, query id 3140557515 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='gedeminos87' Trx read view will not see trx with id >= 9 605429517, sees < 9 605428911 ---TRANSACTION 9 605429515, ACTIVE 249 sec, process no 29007, OS thread id 1166973248 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492125, query id 3140557510 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_5 WHERE nid='40820' AND user_id='558190' ---TRANSACTION 9 605429514, ACTIVE 249 sec, process no 29007, OS thread id 1212533056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492123, query id 3140557509 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_6 WHERE nid='157006' AND user_id='603137' ---TRANSACTION 9 605429513, ACTIVE 249 sec, process no 29007, OS thread id 1142085952 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492118, query id 3140557500 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_1 WHERE nid='58156' AND user_id='164217' Trx read view will not see trx with id >= 9 605429514, sees < 9 605428911 ---TRANSACTION 9 605429512, ACTIVE 249 sec, process no 29007, OS thread id 1196075328 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492114, query id 3140557497 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7455424214273177' ---TRANSACTION 9 605429511, ACTIVE 249 sec, process no 29007, OS thread id 1226381632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492109, query id 3140557496 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='9' AND user_id='414199' Trx read view will not see trx with id >= 9 605429512, sees < 9 605428911 ---TRANSACTION 9 605429510, ACTIVE 249 sec, process no 29007, OS thread id 1182226752 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492110, query id 3140557494 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '442603' Trx read view will not see trx with id >= 9 605429511, sees < 9 605428911 ---TRANSACTION 9 605429509, ACTIVE 249 sec, process no 29007, OS thread id 1250466112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492107, query id 3140557459 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Spaces330' Trx read view will not see trx with id >= 9 605429510, sees < 9 605428911 ---TRANSACTION 9 605429508, ACTIVE 249 sec, process no 29007, OS thread id 1273346368 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492105, query id 3140557458 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7613692982505024' ---TRANSACTION 9 605429507, ACTIVE 249 sec, process no 29007, OS thread id 1145297216 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492102, query id 3140557452 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Talee73' Trx read view will not see trx with id >= 9 605429508, sees < 9 605428911 ---TRANSACTION 9 605429506, ACTIVE 249 sec, process no 29007, OS thread id 1225980224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492101, query id 3140557451 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8590009533638540' ---TRANSACTION 9 605429505, ACTIVE 249 sec, process no 29007, OS thread id 1264515392 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492099, query id 3140557450 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Baks24' Trx read view will not see trx with id >= 9 605429506, sees < 9 605428911 ---TRANSACTION 9 605429504, ACTIVE 249 sec, process no 29007, OS thread id 1185237312 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492097, query id 3140557433 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1184941' Trx read view will not see trx with id >= 9 605429505, sees < 9 605428911 ---TRANSACTION 9 605429503, ACTIVE 249 sec, process no 29007, OS thread id 1233406272 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492091, query id 3140557426 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1041740' Trx read view will not see trx with id >= 9 605429504, sees < 9 605428911 ---TRANSACTION 9 605429502, ACTIVE 249 sec, process no 29007, OS thread id 1147906368 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492090, query id 3140557424 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1586846' Trx read view will not see trx with id >= 9 605429503, sees < 9 605428911 ---TRANSACTION 9 605429501, ACTIVE 249 sec, process no 29007, OS thread id 1154931008 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492089, query id 3140557423 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='TvOyADeVoShKa' Trx read view will not see trx with id >= 9 605429502, sees < 9 605428911 ---TRANSACTION 9 605429500, ACTIVE 249 sec, process no 29007, OS thread id 1186040128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492087, query id 3140557422 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='158' AND user_id='34388' Trx read view will not see trx with id >= 9 605429501, sees < 9 605428911 ---TRANSACTION 9 605429499, ACTIVE 250 sec, process no 29007, OS thread id 1166170432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492085, query id 3140557400 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='1119279332658897' ---TRANSACTION 9 605429498, ACTIVE 250 sec, process no 29007, OS thread id 1209321792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492073, query id 3140557399 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Aid7' Trx read view will not see trx with id >= 9 605429499, sees < 9 605428911 ---TRANSACTION 9 605429497, ACTIVE 250 sec, process no 29007, OS thread id 1192061248 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492079, query id 3140557389 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users_events WHERE user_id = '585995' ---TRANSACTION 9 605429496, ACTIVE 250 sec, process no 29007, OS thread id 1165969728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492081, query id 3140557388 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Stervo4ka21' Trx read view will not see trx with id >= 9 605429497, sees < 9 605428911 ---TRANSACTION 9 605429495, ACTIVE 250 sec, process no 29007, OS thread id 1220360512 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492076, query id 3140557379 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Tjmw0' Trx read view will not see trx with id >= 9 605429496, sees < 9 605428911 ---TRANSACTION 9 605429494, ACTIVE 250 sec, process no 29007, OS thread id 1174399296 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492075, query id 3140557378 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='6566457221620986' ---TRANSACTION 9 605429493, ACTIVE 250 sec, process no 29007, OS thread id 1220561216 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492071, query id 3140557366 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7871710930133809' ---TRANSACTION 9 605429492, ACTIVE 250 sec, process no 29007, OS thread id 1157740864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492069, query id 3140557349 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1089582' Trx read view will not see trx with id >= 9 605429493, sees < 9 605428911 ---TRANSACTION 9 605429491, ACTIVE 250 sec, process no 29007, OS thread id 1239226688 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492067, query id 3140557341 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE user_id = '160749' Trx read view will not see trx with id >= 9 605429492, sees < 9 605428911 ---TRANSACTION 9 605429490, ACTIVE 250 sec, process no 29007, OS thread id 1187846464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492065, query id 3140557334 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '714295' Trx read view will not see trx with id >= 9 605429491, sees < 9 605428911 ---TRANSACTION 9 605429489, ACTIVE 250 sec, process no 29007, OS thread id 1236416832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492063, query id 3140557328 10.0.0.6 spaces statistics SELECT * FROM spaces_mail WHERE nid = '77774017' AND user_id = '127628' LIMIT 1 Trx read view will not see trx with id >= 9 605429490, sees < 9 605428911 ---TRANSACTION 9 605429488, ACTIVE 250 sec, process no 29007, OS thread id 1275554112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492061, query id 3140557323 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='5' AND user_id='545565' Trx read view will not see trx with id >= 9 605429489, sees < 9 605428911 ---TRANSACTION 9 605429487, ACTIVE 250 sec, process no 29007, OS thread id 1164966208 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492059, query id 3140557321 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='3754454291068023' ---TRANSACTION 9 605429486, ACTIVE 251 sec, process no 29007, OS thread id 1144895808 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492053, query id 3140557298 spaces 10.0.0.3 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1592934' Trx read view will not see trx with id >= 9 605429487, sees < 9 605428911 ---TRANSACTION 9 605429485, ACTIVE 251 sec, process no 29007, OS thread id 1226180928 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492049, query id 3140557294 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1142595' Trx read view will not see trx with id >= 9 605429486, sees < 9 605428911 ---TRANSACTION 9 605429484, ACTIVE 251 sec, process no 29007, OS thread id 1240029504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492047, query id 3140557287 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8416576457597712' ---TRANSACTION 9 605429483, ACTIVE 251 sec, process no 29007, OS thread id 1171990848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492045, query id 3140557278 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='598516' ---TRANSACTION 9 605429482, ACTIVE 251 sec, process no 29007, OS thread id 1166371136 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492043, query id 3140557271 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7991703678398335' ---TRANSACTION 9 605429481, ACTIVE 251 sec, process no 29007, OS thread id 1179416896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492041, query id 3140557270 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='499047' ---TRANSACTION 9 605429480, ACTIVE 251 sec, process no 29007, OS thread id 1205709120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492039, query id 3140557261 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8310991386058032' ---TRANSACTION 9 605429479, ACTIVE 252 sec, process no 29007, OS thread id 1279568192 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492037, query id 3140557252 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Chinadoll ' Trx read view will not see trx with id >= 9 605429480, sees < 9 605428911 ---TRANSACTION 9 605429478, ACTIVE 252 sec, process no 29007, OS thread id 1147504960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492035, query id 3140557251 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_diary_comments WHERE topic_id = '1235214184' Trx read view will not see trx with id >= 9 605429479, sees < 9 605428911 ---TRANSACTION 9 605429477, ACTIVE 252 sec, process no 29007, OS thread id 1147103552 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492034, query id 3140557242 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail_contact_list_5 WHERE user_id='538798' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 ---TRANSACTION 9 605429476, ACTIVE 252 sec, process no 29007, OS thread id 1220761920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492030, query id 3140557241 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '810579' Trx read view will not see trx with id >= 9 605429477, sees < 9 605428911 ---TRANSACTION 9 605429475, ACTIVE 253 sec, process no 29007, OS thread id 1197881664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492028, query id 3140557230 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='403.63' Trx read view will not see trx with id >= 9 605429476, sees < 9 605428911 ---TRANSACTION 9 605429474, ACTIVE 253 sec, process no 29007, OS thread id 1240832320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492026, query id 3140557223 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5449469870721665' ---TRANSACTION 9 605429473, ACTIVE 253 sec, process no 29007, OS thread id 1168378176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491442, query id 3140557217 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_friend_list WHERE user_id = '274769' Trx read view will not see trx with id >= 9 605429474, sees < 9 605428911 ---TRANSACTION 9 605429472, ACTIVE 253 sec, process no 29007, OS thread id 1246853440 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491340, query id 3140557216 10.0.0.7 spaces statistics SELECT * FROM spaces_users WHERE name='MIER' Trx read view will not see trx with id >= 9 605429473, sees < 9 605428911 ---TRANSACTION 9 605429471, ACTIVE 253 sec, process no 29007, OS thread id 1153124672 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491516, query id 3140557215 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Dasha37' Trx read view will not see trx with id >= 9 605429472, sees < 9 605428911 ---TRANSACTION 9 605429470, ACTIVE 253 sec, process no 29007, OS thread id 1176205632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491580, query id 3140557200 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4077334740103882' ---TRANSACTION 9 605429469, ACTIVE 253 sec, process no 29007, OS thread id 1253878080 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491369, query id 3140557190 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '335164' Trx read view will not see trx with id >= 9 605429470, sees < 9 605428911 ---TRANSACTION 9 605429468, ACTIVE 253 sec, process no 29007, OS thread id 1248860480 waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2491888, query id 3140557184 spaces 10.0.0.3 spaces Copying to tmp table SELECT * FROM spaces_mylenta_userlist JOIN spaces_users ON (spaces_mylenta_userlist.user_id = spaces_users.nid) WHERE lenta_user_id = '426' ORDER BY name LIMIT 90,10 Trx read view will not see trx with id >= 9 605429469, sees < 9 605428911 ---TRANSACTION 9 605429467, ACTIVE 253 sec, process no 29007, OS thread id 1183430976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491331, query id 3140557178 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4222513164371348' ---TRANSACTION 9 605429466, ACTIVE 253 sec, process no 29007, OS thread id 1220159808 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491420, query id 3140557177 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2495807332336471' ---TRANSACTION 9 605429465, ACTIVE 253 sec, process no 29007, OS thread id 1150314816 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491338, query id 3140557176 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5531363137129492' ---TRANSACTION 9 605429464, ACTIVE 253 sec, process no 29007, OS thread id 1146100032 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491503, query id 3140557159 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='5' AND user_id='349350' Trx read view will not see trx with id >= 9 605429465, sees < 9 605428911 ---TRANSACTION 9 605429463, ACTIVE 253 sec, process no 29007, OS thread id 1262709056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491458, query id 3140557157 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8914056982162397' ---TRANSACTION 9 605429462, ACTIVE 253 sec, process no 29007, OS thread id 1160751424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491532, query id 3140557150 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '930397' Trx read view will not see trx with id >= 9 605429463, sees < 9 605428911 ---TRANSACTION 9 605429461, ACTIVE 253 sec, process no 29007, OS thread id 1142688064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491808, query id 3140557143 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '581471' Trx read view will not see trx with id >= 9 605429462, sees < 9 605428911 ---TRANSACTION 9 605429460, ACTIVE 253 sec, process no 29007, OS thread id 1177610560 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492024, query id 3140557142 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='ARDOS' Trx read view will not see trx with id >= 9 605429461, sees < 9 605428911 ---TRANSACTION 9 605429459, ACTIVE 253 sec, process no 29007, OS thread id 1247856960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491448, query id 3140557136 10.0.0.7 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='278658' ---TRANSACTION 9 605429458, ACTIVE 253 sec, process no 29007, OS thread id 1195874624 inserting, 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 2491758, query id 3140557067 spaces 10.0.0.3 spaces update INSERT INTO spaces_mail_data_6 SET contact_id='136183', flags='0', ctime=NOW() ---TRANSACTION 9 605429457, ACTIVE 253 sec, process no 29007, OS thread id 1188649280 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491659, query id 3140557135 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='664677' ---TRANSACTION 9 605429456, ACTIVE 253 sec, process no 29007, OS thread id 1218955584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491450, query id 3140557134 10.0.0.7 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '4600' AND user_id = '572870' Trx read view will not see trx with id >= 9 605429457, sees < 9 605428911 ---TRANSACTION 9 605429455, ACTIVE 253 sec, process no 29007, OS thread id 1211128128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491269, query id 3140557133 spaces 10.0.0.3 spaces Sending data SELECT new_count FROM spaces_pictures WHERE user_id='660625' AND new_count != 0 Trx read view will not see trx with id >= 9 605429456, sees < 9 605428911 ---TRANSACTION 9 605429454, ACTIVE 253 sec, process no 29007, OS thread id 1200089408 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491904, query id 3140557131 10.0.0.6 spaces Sorting result SELECT * FROM spaces_file_directories WHERE user_id='126088' AND parent_dir='85574' ORDER BY level Trx read view will not see trx with id >= 9 605429455, sees < 9 605428911 ---TRANSACTION 9 605429451, ACTIVE 253 sec, process no 29007, OS thread id 1174600000 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491988, query id 3140557129 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contacts WHERE user_id='479538' AND contact_id='522696' ---TRANSACTION 9 605429450, ACTIVE 253 sec, process no 29007, OS thread id 1154730304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491544, query id 3140557128 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_mail_contacts_archive WHERE user_id='466703' Trx read view will not see trx with id >= 9 605429451, sees < 9 605428911 ---TRANSACTION 9 605429449, ACTIVE 253 sec, process no 29007, OS thread id 1189652800 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491322, query id 3140557127 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_comm_pending_users WHERE com_id = '634' Trx read view will not see trx with id >= 9 605429450, sees < 9 605428911 ---TRANSACTION 9 605429448, ACTIVE 253 sec, process no 29007, OS thread id 1268529472 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491445, query id 3140557125 10.0.0.7 spaces Sorting result SELECT * FROM spaces_myfiles_comments WHERE file_id = '866405' ORDER BY ctime LIMIT 0,5 Trx read view will not see trx with id >= 9 605429449, sees < 9 605428911 ---TRANSACTION 9 605429447, ACTIVE 253 sec, process no 29007, OS thread id 1163360576 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491546, query id 3140557126 10.0.0.6 spaces statistics SELECT nid FROM spaces_blacklist WHERE user_id = '83799' AND enemy_id = '441575' Trx read view will not see trx with id >= 9 605429448, sees < 9 605428911 ---TRANSACTION 9 605429444, ACTIVE 253 sec, process no 29007, OS thread id 1251469632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491398, query id 3140557124 10.0.0.7 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='32690' Trx read view will not see trx with id >= 9 605429445, sees < 9 605428911 ---TRANSACTION 9 605429443, ACTIVE 253 sec, process no 29007, OS thread id 1271540032 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491402, query id 3140557123 10.0.0.6 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='14038' Trx read view will not see trx with id >= 9 605429444, sees < 9 605428911 ---TRANSACTION 9 605429442, ACTIVE 253 sec, process no 29007, OS thread id 1162557760 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491105, query id 3140557122 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_guestbook WHERE user_id = '576393' Trx read view will not see trx with id >= 9 605429443, sees < 9 605428911 ---TRANSACTION 9 605429441, ACTIVE 253 sec, process no 29007, OS thread id 1208318272 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491444, query id 3140557121 10.0.0.7 spaces statistics SELECT * FROM spaces_music WHERE file_id = '1578634' ---TRANSACTION 9 605429440, ACTIVE 253 sec, process no 29007, OS thread id 1176607040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491581, query id 3140557120 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_guestbook WHERE user_id = '668542' Trx read view will not see trx with id >= 9 605429441, sees < 9 605428911 ---TRANSACTION 9 605429439, ACTIVE 253 sec, process no 29007, OS thread id 1248057664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491339, query id 3140557119 10.0.0.7 spaces Sending data SELECT new_count FROM spaces_diary_topics WHERE user_id='598204' AND new_count != 0 Trx read view will not see trx with id >= 9 605429440, sees < 9 605428911 ---TRANSACTION 9 605429438, ACTIVE 253 sec, process no 29007, OS thread id 1155533120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491387, query id 3140557118 10.0.0.6 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='129776' Trx read view will not see trx with id >= 9 605429439, sees < 9 605428911 ---TRANSACTION 9 605429435, ACTIVE 253 sec, process no 29007, OS thread id 1152321856 updating or deleting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 2491894, query id 3140557056 spaces 10.0.0.3 spaces Updating UPDATE spaces_mail_contact_list_5 SET in_cnt=in_cnt+1, new_cnt=new_cnt+1, new=1, mtime='1241899442', contact_type=0 WHERE nid='66122' ---TRANSACTION 9 605429434, ACTIVE 253 sec, process no 29007, OS thread id 1209522496 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491712, query id 3140557117 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_diary_topics WHERE user_id = '209598' Trx read view will not see trx with id >= 9 605429435, sees < 9 605428911 ---TRANSACTION 9 605429433, ACTIVE 253 sec, process no 29007, OS thread id 1165367616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491551, query id 3140557116 10.0.0.6 spaces Sending data SELECT dir_id FROM spaces_file_directories WHERE parent_dir='61400' Trx read view will not see trx with id >= 9 605429434, sees < 9 605428911 ---TRANSACTION 9 605429432, ACTIVE 253 sec, process no 29007, OS thread id 1141885248 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491909, query id 3140557113 10.0.0.6 spaces Sending data SELECT COUNT(*) from spaces_pictures WHERE user_id = '2043' Trx read view will not see trx with id >= 9 605429433, sees < 9 605428911 ---TRANSACTION 9 605429431, ACTIVE 253 sec, process no 29007, OS thread id 1147304256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491389, query id 3140557112 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_guestbook WHERE user_id = '348191' Trx read view will not see trx with id >= 9 605429432, sees < 9 605428911 ---TRANSACTION 9 605429427, ACTIVE 253 sec, process no 29007, OS thread id 1221564736 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491882, query id 3140557110 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1286020' Trx read view will not see trx with id >= 9 605429428, sees < 9 605428911 ---TRANSACTION 9 605429426, ACTIVE 253 sec, process no 29007, OS thread id 1166571840 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491025, query id 3140557107 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='160261' ---TRANSACTION 9 605429425, ACTIVE 253 sec, process no 29007, OS thread id 1246050624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491391, query id 3140557105 10.0.0.6 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='37596' Trx read view will not see trx with id >= 9 605429426, sees < 9 605428911 ---TRANSACTION 9 605429424, ACTIVE 253 sec, process no 29007, OS thread id 1162357056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491293, query id 3140557103 spaces 10.0.0.3 spaces Sending data SELECT new_count FROM spaces_diary_topics WHERE user_id='493331' AND new_count != 0 Trx read view will not see trx with id >= 9 605429425, sees < 9 605428911 ---TRANSACTION 9 605429423, ACTIVE 253 sec, process no 29007, OS thread id 1180621120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491770, query id 3140557101 spaces 10.0.0.3 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1308333' Trx read view will not see trx with id >= 9 605429424, sees < 9 605428911 ---TRANSACTION 9 605429422, ACTIVE 253 sec, process no 29007, OS thread id 1189452096 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491438, query id 3140557099 10.0.0.7 spaces Sending data SELECT COUNT(DISTINCT user_id) FROM spaces_favorites WHERE type_id='1' AND object_id='783663' AND closed != 1 Trx read view will not see trx with id >= 9 605429423, sees < 9 605428911 ---TRANSACTION 9 605429421, ACTIVE 253 sec, process no 29007, OS thread id 1278363968 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491113, query id 3140557098 spaces 10.0.0.3 spaces Sending data SELECT new_count FROM spaces_myfiles WHERE user_id='635000' AND new_count != 0 Trx read view will not see trx with id >= 9 605429422, sees < 9 605428911 ---TRANSACTION 9 605429420, ACTIVE 253 sec, process no 29007, OS thread id 1227987264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491362, query id 3140557095 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '269239' Trx read view will not see trx with id >= 9 605429421, sees < 9 605428911 ---TRANSACTION 9 605429419, ACTIVE 253 sec, process no 29007, OS thread id 1227184448 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491435, query id 3140557092 10.0.0.7 spaces Sending data SELECT page,comments_cnt,last_comment_id FROM spaces_pictures_tracking WHERE user_id='545146' AND object_id='1593924' Trx read view will not see trx with id >= 9 605429420, sees < 9 605428911 ---TRANSACTION 9 605429417, ACTIVE 253 sec, process no 29007, OS thread id 1143892288 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491601, query id 3140557091 10.0.0.6 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='96474' Trx read view will not see trx with id >= 9 605429418, sees < 9 605428911 ---TRANSACTION 9 605429416, ACTIVE 253 sec, process no 29007, OS thread id 1159346496 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491437, query id 3140557090 10.0.0.7 spaces Sorting result SELECT * FROM spaces_myfiles_comments WHERE file_id = '426818' ORDER BY ctime LIMIT 0,5 Trx read view will not see trx with id >= 9 605429417, sees < 9 605428911 ---TRANSACTION 9 605429415, ACTIVE 253 sec, process no 29007, OS thread id 1163962688 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491456, query id 3140557089 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '731318' Trx read view will not see trx with id >= 9 605429416, sees < 9 605428911 ---TRANSACTION 9 605429414, ACTIVE 253 sec, process no 29007, OS thread id 1223571776 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491168, query id 3140557088 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_3 WHERE user_id='336207' AND user2_id='351535' ---TRANSACTION 9 605429413, ACTIVE 253 sec, process no 29007, OS thread id 1197680960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491413, query id 3140557085 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_favorites WHERE user_id = '567837' Trx read view will not see trx with id >= 9 605429414, sees < 9 605428911 ---TRANSACTION 9 605429412, ACTIVE 253 sec, process no 29007, OS thread id 1142888768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2492020, query id 3140557078 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='110121' Trx read view will not see trx with id >= 9 605429413, sees < 9 605428911 ---TRANSACTION 9 605429411, ACTIVE 253 sec, process no 29007, OS thread id 1245849920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2490994, query id 3140557072 spaces 10.0.0.3 spaces optimizing SELECT MAX(nid) FROM spaces_mail Trx read view will not see trx with id >= 9 605429412, sees < 9 605428911 ---TRANSACTION 9 605429410, ACTIVE 253 sec, process no 29007, OS thread id 1257691456 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491329, query id 3140557083 10.0.0.7 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='81308' Trx read view will not see trx with id >= 9 605429411, sees < 9 605428911 ---TRANSACTION 9 605429409, ACTIVE 253 sec, process no 29007, OS thread id 1216145728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491467, query id 3140557081 10.0.0.7 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='649840' ---TRANSACTION 9 605429408, ACTIVE 253 sec, process no 29007, OS thread id 1181223232 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491381, query id 3140557076 10.0.0.6 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='27963' Trx read view will not see trx with id >= 9 605429409, sees < 9 605428911 ---TRANSACTION 9 605429407, ACTIVE 253 sec, process no 29007, OS thread id 1281575232 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491919, query id 3140557075 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='20876' Trx read view will not see trx with id >= 9 605429408, sees < 9 605428911 ---TRANSACTION 9 605429404, ACTIVE 253 sec, process no 29007, OS thread id 1159747904 waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2491051, query id 3140557068 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) from spaces_diary_comments WHERE user_id = '433014' AND topic_id = '1235213988' Trx read view will not see trx with id >= 9 605429405, sees < 9 605428911 ---TRANSACTION 9 605429401, ACTIVE 253 sec, process no 29007, OS thread id 1161754944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491537, query id 3140557023 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 605429402, sees < 9 605428911 ---TRANSACTION 9 605429397, ACTIVE 253 sec, process no 29007, OS thread id 1171188032 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491567, query id 3140557014 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '446308' Trx read view will not see trx with id >= 9 605429398, sees < 9 605428911 ---TRANSACTION 9 605429395, ACTIVE 253 sec, process no 29007, OS thread id 1151519040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491376, query id 3140557024 10.0.0.7 spaces Sending data SELECT * FROM spaces_users WHERE nid='167509' Trx read view will not see trx with id >= 9 605429396, sees < 9 605428911 ---TRANSACTION 9 605429394, ACTIVE 253 sec, process no 29007, OS thread id 1181423936 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491841, query id 3140557019 spaces 10.0.0.3 spaces Sending data SELECT * from spaces_pictures_albums WHERE album_id='76328' Trx read view will not see trx with id >= 9 605429395, sees < 9 605428911 ---TRANSACTION 9 605429393, ACTIVE 253 sec, process no 29007, OS thread id 1249261888 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491347, query id 3140557018 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1286031' Trx read view will not see trx with id >= 9 605429394, sees < 9 605428911 ---TRANSACTION 9 605429391, ACTIVE 253 sec, process no 29007, OS thread id 1268930880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491715, query id 3140557063 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1593877' Trx read view will not see trx with id >= 9 605429392, sees < 9 605428911 ---TRANSACTION 9 605429385, ACTIVE 253 sec, process no 29007, OS thread id 1254680896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491915, query id 3140557050 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_shared_zone_files WHERE L4 = '779' ORDER BY rate DESC LIMIT 0,5 Trx read view will not see trx with id >= 9 605429386, sees < 9 605428911 ---TRANSACTION 9 605429374, ACTIVE 253 sec, process no 29007, OS thread id 1142487360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491890, query id 3140557035 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1694' ORDER BY rate DESC LIMIT 165,5 Trx read view will not see trx with id >= 9 605429375, sees < 9 605428911 ---TRANSACTION 9 605429370, ACTIVE 253 sec, process no 29007, OS thread id 1178814784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491588, query id 3140557031 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1735' ORDER BY rate DESC LIMIT 10,5 Trx read view will not see trx with id >= 9 605429371, sees < 9 605428911 ---TRANSACTION 9 605429368, ACTIVE 253 sec, process no 29007, OS thread id 1178614080, 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 2491426, query id 3140556926 10.0.0.7 spaces end UPDATE spaces_users_anketa SET business='8' WHERE user_id='665371' ---TRANSACTION 9 605429367, ACTIVE 253 sec, process no 29007, OS thread id 1179818304, 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 2491590, query id 3140556937 10.0.0.6 spaces end UPDATE spaces_users_events SET mail_new = 0 WHERE user_id='570313' ---TRANSACTION 9 605429366, ACTIVE 253 sec, process no 29007, OS thread id 1224976704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491371, query id 3140556885 10.0.0.7 spaces Sending data SELECT * FROM spaces_guestbook WHERE user_id = '388813' ORDER BY CTIME LIMIT 0,4 Trx read view will not see trx with id >= 9 605429367, sees < 9 605428911 ---TRANSACTION 9 605429364, ACTIVE 253 sec, process no 29007, OS thread id 1167776064, 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 2491395, query id 3140556903 10.0.0.7 spaces end UPDATE spaces_music SET artist='STING', title='Shape o me hebrt', album='', level = '50' WHERE file_id = '1578328' AND user_id = '643038' ---TRANSACTION 9 605429353, ACTIVE 253 sec, process no 29007, OS thread id 1224575296 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491411, query id 3140556874 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 605429354, sees < 9 605428911 ---TRANSACTION 9 605429329, ACTIVE 253 sec, process no 29007, OS thread id 1217349952 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491936, query id 3140556866 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_6 WHERE user_id='628721' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 605429330, sees < 9 605428911 ---TRANSACTION 9 605429324, ACTIVE 253 sec, process no 29007, OS thread id 1171790144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491569, query id 3140556839 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '52' ORDER BY rate DESC LIMIT 0,5 Trx read view will not see trx with id >= 9 605429325, sees < 9 605428911 ---TRANSACTION 9 605429322, ACTIVE 253 sec, process no 29007, OS thread id 1201494336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491691, query id 3140556965 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_directories WHERE parent_dir='0' AND com_id='1722'ORDER BY level Trx read view will not see trx with id >= 9 605429323, sees < 9 605428911 ---TRANSACTION 9 605429313, ACTIVE 253 sec, process no 29007, OS thread id 1151719744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491514, query id 3140556857 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='434647' AND msg_user_id='185557' ORDER BY ctime DESC LIMIT 0,15 Trx read view will not see trx with id >= 9 605429314, sees < 9 605428911 ---TRANSACTION 9 605429302, ACTIVE 253 sec, process no 29007, OS thread id 1261103424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491892, query id 3140556817 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '844' ORDER BY rate DESC LIMIT 45,5 Trx read view will not see trx with id >= 9 605429303, sees < 9 605428911 ---TRANSACTION 9 605429301, ACTIVE 253 sec, process no 29007, OS thread id 1199888704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491686, query id 3140556917 10.0.0.7 spaces Sending data SELECT * FROM spaces_mail_contact_list_1 WHERE user_id='157065' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 605429302, sees < 9 605428911 ---TRANSACTION 9 605429300, ACTIVE 253 sec, process no 29007, OS thread id 1169983808 updating or deleting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 2491560, query id 3140556845 10.0.0.7 spaces Updating UPDATE spaces_mail_contact_list_6 SET new=0,new_cnt=0 WHERE nid='94647' ---TRANSACTION 9 605429282, ACTIVE 253 sec, process no 29007, OS thread id 1275353408 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491392, query id 3140556898 10.0.0.7 spaces Sending data SELECT * FROM spaces_guestbook WHERE user_id = '568708' ORDER BY CTIME LIMIT 0,4 Trx read view will not see trx with id >= 9 605429283, sees < 9 605428911 ---TRANSACTION 9 605429258, ACTIVE 253 sec, process no 29007, OS thread id 1216948544, 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 2491400, query id 3140556796 10.0.0.7 spaces end UPDATE spaces_users_anketa SET anketa_level='1241895542' WHERE user_id='313042' ---TRANSACTION 9 605429256, ACTIVE 253 sec, process no 29007, OS thread id 1177008448, 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 2491911, query id 3140556872 10.0.0.6 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='19' WHERE user_id='654396' ---TRANSACTION 9 605429248, ACTIVE 253 sec, process no 29007, OS thread id 1284184384, 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 2491432, query id 3140556854 10.0.0.7 spaces end UPDATE spaces_mail_contacts SET new_cnt=0, last_read_msg_id='77774474' WHERE user_id='190917' AND contact_id='4839' ---TRANSACTION 9 605429247, ACTIVE 253 sec, process no 29007, OS thread id 1158142272 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 ROLLING BACK 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 85, query id 3140556806 data.spaces.ru 10.0.0.5 nagios update INSERT INTO nagios_programstatus SET instance_id='1', status_update_time=FROM_UNIXTIME(1241899442), program_start_time=FROM_UNIXTIME(1239881534), is_currently_running='1', process_id='30263', daemon_mode='1', last_command_check=FROM_UNIXTIME(1241899442), last_log_rotation=FROM_UNIXTIME(1241899200), notifications_enabled='1', active_service_checks_enabled='1', passive_service_checks_enabled='1', active_host_checks_enabled='1', passive_host_checks_enabled='1', event_handlers_enabled='1', flap_detection_enabled='1', failure_prediction_enabled='1', process_performance_data='1', obsess_over_hosts=' ---TRANSACTION 9 605429237, ACTIVE 253 sec, process no 29007, OS thread id 1184835904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491598, query id 3140556759 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='10' Trx read view will not see trx with id >= 9 605429239, sees < 9 605428911 ---TRANSACTION 9 605429219, ACTIVE 253 sec, process no 29007, OS thread id 1236216128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491356, query id 3140556826 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_chat WHERE room_id='9' AND ((private = 0 or private = '383242') OR user_id = '383242') Trx read view will not see trx with id >= 9 605429264, sees < 9 605428911 ---TRANSACTION 9 605429215, ACTIVE 253 sec, process no 29007, OS thread id 1188247872 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491610, query id 3140556766 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 605429217, sees < 9 605428911 ---TRANSACTION 9 605429208, ACTIVE 253 sec, process no 29007, OS thread id 1153325376, 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 2491137, query id 3140556767 spaces 10.0.0.3 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='19' WHERE user_id='650566' ---TRANSACTION 9 605429187, ACTIVE 253 sec, process no 29007, OS thread id 1204103488 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491896, query id 3140556745 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1693' ORDER BY rate DESC LIMIT 170,5 Trx read view will not see trx with id >= 9 605429188, sees < 9 605428911 ---TRANSACTION 9 605429165, ACTIVE 253 sec, process no 29007, OS thread id 1175402816, 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 2491927, query id 3140556710 spaces 10.0.0.3 spaces update INSERT INTO spaces_chat SET room_id='11', ctime=NOW(), user_id='623637', msg='ПРИВЕТ ЖЕКА! КАК ПРАЗДНИК?', flags='0', private='0', dst='0' ---TRANSACTION 9 605429132, ACTIVE 253 sec, process no 29007, OS thread id 1210526016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491827, query id 3140556683 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_data_0 WHERE contact_id='222755' ORDER BY nid DESC LIMIT 0,6 Trx read view will not see trx with id >= 9 605429133, sees < 9 605428911 ---TRANSACTION 9 605429102, ACTIVE 253 sec, process no 29007, OS thread id 1151117632, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 2492003, query id 3140556703 spaces 10.0.0.3 spaces update INSERT INTO spaces_mail_data_3 SET contact_id='122489', flags='1', ctime='2009-02-16 01:42:03' ---TRANSACTION 9 605429079, ACTIVE 253 sec, process no 29007, OS thread id 1198283072, 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 2491681, query id 3140556629 10.0.0.6 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='27' WHERE user_id='651282' ---TRANSACTION 9 605429074, ACTIVE 253 sec, process no 29007, OS thread id 1200490816, 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 2491407, query id 3140556631 10.0.0.7 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='20' WHERE user_id='658690' ---TRANSACTION 9 605429058, ACTIVE 253 sec, process no 29007, OS thread id 1141283136 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491867, query id 3140556465 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '53' ORDER BY rate DESC LIMIT 2245,5 Trx read view will not see trx with id >= 9 605429059, sees < 9 605428792 ---TRANSACTION 9 605429053, ACTIVE 253 sec, process no 29007, OS thread id 1217550656 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491735, query id 3140556649 10.0.0.7 spaces Sending data SELECT * FROM spaces_mail_contact_list_1 WHERE user_id='140113' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 605429054, sees < 9 605428792 ---TRANSACTION 9 605429035, ACTIVE 253 sec, process no 29007, OS thread id 1209723200 updating or deleting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 6 lock struct(s), heap size 1216, 42 row lock(s), undo log entries 21 MySQL thread id 2491746, query id 3140556408 10.0.0.6 spaces updating DELETE FROM spaces_mail_contact_list_4 WHERE nid='50457' AND user_id='462233' ---TRANSACTION 9 605429001, ACTIVE 253 sec, process no 29007, OS thread id 1167575360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491552, query id 3140556380 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '36' ORDER BY rate DESC LIMIT 15,5 Trx read view will not see trx with id >= 9 605429002, sees < 9 605428768 ---TRANSACTION 9 605429000, ACTIVE 253 sec, process no 29007, OS thread id 1203702080 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491035, query id 3140556377 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '846' ORDER BY rate DESC LIMIT 15,5 Trx read view will not see trx with id >= 9 605429001, sees < 9 605428768 ---TRANSACTION 9 605428931, ACTIVE 254 sec, process no 29007, OS thread id 1201293632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491690, query id 3140556086 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '36' ORDER BY rate DESC LIMIT 135,5 Trx read view will not see trx with id >= 9 605428932, sees < 9 605428768 ---TRANSACTION 9 605428911, ACTIVE 254 sec, process no 29007, OS thread id 1205107008 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2491898, query id 3140556036 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '52' ORDER BY rate DESC LIMIT 280,5 Trx read view will not see trx with id >= 9 605428912, sees < 9 605428768 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 112812909 OS file reads, 23965511 OS file writes, 2903283 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1255, free list len 3761, seg size 5017, 16071527 inserts, 15968087 merged recs, 3296823 merges Hash table size 25499819, node heap has 73084 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 529 2446729988 Log flushed up to 529 2446729978 Last checkpoint at 529 1305837073 0 pending log writes, 0 pending chkp writes 1019891 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 14169184058; in additional pool allocated 16777216 Dictionary memory allocated 1469384 Buffer pool size 786432 Free buffers 0 Database pages 713348 Modified db pages 113335 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 134913341, created 2433443, written 30903581 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 16 queries inside InnoDB, 198 queries in queue 131 read views open inside InnoDB Main thread process no. 29007, id 1140881728, state: purging Number of rows inserted 62242633, updated 174507313, deleted 30660476, read 262851076895 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================