===================================== 090513 11:55:37 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 0 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 208904757, signal count 128498835 --Thread 1173395776 has waited at row/row0mysql.c line 1720 for 250.00 seconds the semaphore: X-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1173395776) 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 244.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1173395776) 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 77134291207, OS waits 115856630 RW-shared spins 104987798, OS waits 35050225; RW-excl spins 173277610, OS waits 20518971 ------------------------ LATEST DETECTED DEADLOCK ------------------------ 090512 18:22:05 *** (1) TRANSACTION: TRANSACTION 9 1032573192, ACTIVE 3 sec, process no 10361, OS thread id 1276758336 inserting mysql tables in use 1, locked 1 LOCK WAIT 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 466689, query id 718169260 spaces 10.0.0.3 spaces update INSERT INTO spaces_guests SET sid='7783186008199573', mtime=NOW(), ip_address='85.26.178.205, 10.218.119.44', user_agent='NokiaN73-1', mobile_device='Nokia N73', reklama_cursor='3', flags='0' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 630464 n bits 112 index `ip_address` of table `spaces`.`spaces_guests` trx id 9 1032573192 lock mode S waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 0: len 16; hex 38352e32362e3137382e3230352c2031; asc 85.26.178.205, 1;; 1: len 30; hex 4e6f6b69614e37332d312020202020202020202020202020202020202020; asc NokiaN73-1 ;...(truncated); 2: len 6; hex 000016f0e828; asc (;; *** (2) TRANSACTION: TRANSACTION 9 1032569369, ACTIVE 4 sec, process no 10361, OS thread id 1184033088 fetching rows, thread declared inside InnoDB 271 mysql tables in use 1, locked 1 67 lock struct(s), heap size 6752, 1834 row lock(s), undo log entries 479 MySQL thread id 466962, query id 718162607 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 630464 n bits 112 index `ip_address` of table `spaces`.`spaces_guests` trx id 9 1032569369 lock_mode X locks rec but not gap Record lock, heap no 2 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 0: len 16; hex 38352e32362e3137382e3230352c2031; asc 85.26.178.205, 1;; 1: len 30; hex 4e6f6b69614e37332d312020202020202020202020202020202020202020; asc NokiaN73-1 ;...(truncated); 2: len 6; hex 000016f0e828; asc (;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 808794 n bits 96 index `GEN_CLUST_INDEX` of table `spaces`.`spaces_guests` trx id 9 1032569369 lock_mode X waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 13; compact format; info bits 0 0: len 6; hex 000016f0f948; asc H;; 1: len 6; hex 00093d8bd108; asc = ;; 2: len 7; hex 80000006210110; asc ! ;; 3: len 4; hex 81785062; asc xPb;; 4: len 20; hex 3737383331383630303831393935373320202020; asc 7783186008199573 ;; 5: len 8; hex 80001245afd78bba; asc E ;; 6: len 16; hex 38352e32362e3137382e3230352c2031; asc 85.26.178.205, 1;; 7: len 30; hex 4e6f6b69614e37332d312020202020202020202020202020202020202020; asc NokiaN73-1 ;...(truncated); 8: len 30; hex 4e6f6b6961204e3733202020202020202020202020202020202020202020; asc Nokia N73 ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000003; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 9 1144471224 Purge done for trx's n:o < 9 1144457099 undo n:o < 0 0 History list length 869 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1212533056 MySQL thread id 621688, query id 905895868 localhost 127.0.0.1 root ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1155131712 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621686, query id 905895850 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 10361, OS thread id 1250867520 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621684, query id 905895843 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 10361, OS thread id 1256687936 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621672, query id 905895816 data.spaces.ru 10.0.0.5 spaces Updating UPDATE spaces_viktorina_state SET quest_id='27216',state=777,ctime=UNIX_TIMESTAMP(NOW()) WHERE user_id=0 ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1222367552 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621671, query id 905895811 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 10361, OS thread id 1197680960 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621654, query id 905895769 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='40' WHERE user_id='679651' ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1244244288 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621652, query id 905895766 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='25' WHERE user_id='320570' ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1270937920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621623, query id 905895688 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_sessions WHERE atime > FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()) - 300) ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1248659776 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621614, query id 905895667 10.0.0.6 spaces update INSERT INTO spaces_music_downloads SET user_id='682257', file_id='1304763', ctime=NOW(), owner_id='195050' ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1159948608 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621583, query id 905895578 spaces 10.0.0.3 spaces update INSERT INTO spaces_users_anketa_views SET user_id='83799', viewer_id='562423', ctime=NOW() ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1175001408 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621581, query id 905895577 spaces 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='24' WHERE user_id='115760' ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1218754880 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621579, query id 905895555 spaces 10.0.0.3 spaces update INSERT INTO spaces_users_anketa_views SET user_id='485720', viewer_id='682177', ctime=NOW() ---TRANSACTION 0 0, not started, process no 10361, OS thread id 1244444992 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621538, query id 905895441 spaces 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='24' WHERE user_id='651637' ---TRANSACTION 9 1144471059, not started, process no 10361, OS thread id 1210726720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621503, query id 905895246 spaces 10.0.0.3 spaces Sending data SELECT *,((UNIX_TIMESTAMP(ctime) + ban_time) - UNIX_TIMESTAMP(NOW())) AS time_wait FROM spaces_users_remarks WHERE user_id='195407' AND service_id='24' AND com_id='0' AND active != 0 ---TRANSACTION 9 1144470777, not started, process no 10361, OS thread id 1156335936 MySQL thread id 621505, query id 905894839 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470737, not started, process no 10361, OS thread id 1158543680 MySQL thread id 621502, query id 905894769 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470732, not started, process no 10361, OS thread id 1238825280 MySQL thread id 621496, query id 905894705 spaces 10.0.0.3 spaces freeing items SELECT * FROM spaces_myfiles WHERE file_id = '326523' ---TRANSACTION 9 1144469992, not started, process no 10361, OS thread id 1201293632 MySQL thread id 621493, query id 905893385 10.0.0.6 spaces ---TRANSACTION 9 1144469607, not started, process no 10361, OS thread id 1143290176 MySQL thread id 621360, query id 905892685 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144469405, not started, process no 10361, OS thread id 1173797184 MySQL thread id 621490, query id 905892244 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470773, not started, process no 10361, OS thread id 1185036608 MySQL thread id 621486, query id 905894806 spaces 10.0.0.3 spaces freeing items SELECT COUNT(*) FROM spaces_diary_tracking WHERE topic_id='1235227317' AND user_id != '578876' ---TRANSACTION 9 1144465269, not started, process no 10361, OS thread id 1198283072 MySQL thread id 621294, query id 905895083 10.0.0.6 spaces ---TRANSACTION 9 1144464070, not started, process no 10361, OS thread id 1237018944 MySQL thread id 621150, query id 905893443 10.0.0.6 spaces ---TRANSACTION 9 1144461466, not started, process no 10361, OS thread id 1141684544 MySQL thread id 621055, query id 905889242 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144453055, not started, process no 10361, OS thread id 1160149312 MySQL thread id 621448, query id 905895296 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144457581, not started, process no 10361, OS thread id 1188849984 MySQL thread id 621462, query id 905869901 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144445358, not started, process no 10361, OS thread id 1239628096 MySQL thread id 621171, query id 905892668 10.0.0.6 spaces ---TRANSACTION 9 1144443442, not started, process no 10361, OS thread id 1270335808 MySQL thread id 621339, query id 905851903 10.0.0.6 spaces ---TRANSACTION 9 1144440685, not started, process no 10361, OS thread id 1237821760 MySQL thread id 620962, query id 905892434 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144438310, not started, process no 10361, OS thread id 1151519040 MySQL thread id 621316, query id 905895724 10.0.0.6 spaces ---TRANSACTION 9 1144446260, not started, process no 10361, OS thread id 1177409856 MySQL thread id 621457, query id 905849135 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144462578, not started, process no 10361, OS thread id 1253878080 MySQL thread id 621451, query id 905879139 10.0.0.6 spaces ---TRANSACTION 9 1144461115, not started, process no 10361, OS thread id 1279367488 MySQL thread id 621450, query id 905876301 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470577, not started, process no 10361, OS thread id 1273747776 MySQL thread id 621449, query id 905894427 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144423825, not started, process no 10361, OS thread id 1274149184 MySQL thread id 621306, query id 905895276 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144459288, not started, process no 10361, OS thread id 1159346496 MySQL thread id 621381, query id 905892425 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144466203, not started, process no 10361, OS thread id 1142888768 MySQL thread id 621329, query id 905884498 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144471031, not started, process no 10361, OS thread id 1212332352 MySQL thread id 621434, query id 905895030 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144448946, not started, process no 10361, OS thread id 1231800640 MySQL thread id 621433, query id 905853853 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144447416, not started, process no 10361, OS thread id 1167374656 MySQL thread id 621432, query id 905851216 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144447628, not started, process no 10361, OS thread id 1252272448 MySQL thread id 620996, query id 905894194 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470357, not started, process no 10361, OS thread id 1225578816 MySQL thread id 621429, query id 905894070 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144451957, not started, process no 10361, OS thread id 1172994368 MySQL thread id 621428, query id 905859340 10.0.0.6 spaces ---TRANSACTION 9 1144465820, not started, process no 10361, OS thread id 1191860544 MySQL thread id 621424, query id 905885344 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144458072, not started, process no 10361, OS thread id 1192061248 MySQL thread id 621421, query id 905870841 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144468854, not started, process no 10361, OS thread id 1158945088 MySQL thread id 621336, query id 905894788 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144469974, not started, process no 10361, OS thread id 1215543616 MySQL thread id 621419, query id 905893293 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144457428, not started, process no 10361, OS thread id 1146501440 MySQL thread id 621096, query id 905892963 10.0.0.6 spaces ---TRANSACTION 9 1144392662, not started, process no 10361, OS thread id 1251871040 MySQL thread id 621345, query id 905893158 10.0.0.6 spaces ---TRANSACTION 9 1144469069, not started, process no 10361, OS thread id 1246853440 MySQL thread id 621415, query id 905891503 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144433869, not started, process no 10361, OS thread id 1150114112 MySQL thread id 621411, query id 905827196 10.0.0.6 spaces ---TRANSACTION 9 1144382134, not started, process no 10361, OS thread id 1261304128 MySQL thread id 621057, query id 905894221 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144454463, not started, process no 10361, OS thread id 1243642176 MySQL thread id 621402, query id 905863958 10.0.0.6 spaces ---TRANSACTION 9 1144458849, not started, process no 10361, OS thread id 1214339392 MySQL thread id 621049, query id 905894419 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144374902, not started, process no 10361, OS thread id 1170385216 MySQL thread id 621310, query id 905878386 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144389089, not started, process no 10361, OS thread id 1217952064 MySQL thread id 621397, query id 905746025 10.0.0.6 spaces ---TRANSACTION 9 1144470432, not started, process no 10361, OS thread id 1260501312 MySQL thread id 621393, query id 905894154 10.0.0.6 spaces freeing items SELECT * FROM spaces_mail_data_4 WHERE contact_id='115392' ORDER BY nid DESC LIMIT 0,10 ---TRANSACTION 9 1144471067, not started, process no 10361, OS thread id 1164364096 MySQL thread id 621386, query id 905895064 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144464904, not started, process no 10361, OS thread id 1211930944 MySQL thread id 621385, query id 905883517 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144398572, not started, process no 10361, OS thread id 1144293696 MySQL thread id 621384, query id 905894784 10.0.0.6 spaces ---TRANSACTION 9 1144366201, not started, process no 10361, OS thread id 1157740864 MySQL thread id 621382, query id 905703410 10.0.0.6 spaces ---TRANSACTION 9 1144363578, not started, process no 10361, OS thread id 1217349952 MySQL thread id 621377, query id 905698610 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470790, not started, process no 10361, OS thread id 1154128192 MySQL thread id 621359, query id 905894830 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums_topics WHERE topic_id = '458769' ---TRANSACTION 9 1144454533, not started, process no 10361, OS thread id 1174399296 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621347, query id 905895808 10.0.0.6 spaces update INSERT INTO spaces_mail SET user_id='225486', msg_user_id='321846',flags='0',direction='0',ctime=NOW(),text='Так что ты этим хотела сказать? ',new='0' ---TRANSACTION 9 1144441206, not started, process no 10361, OS thread id 1236818240 MySQL thread id 621349, query id 905840510 10.0.0.6 spaces ---TRANSACTION 9 1144448397, not started, process no 10361, OS thread id 1249663296 MySQL thread id 621337, query id 905852971 10.0.0.6 spaces ---TRANSACTION 9 1144359450, not started, process no 10361, OS thread id 1173195072 MySQL thread id 621333, query id 905691299 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144381919, not started, process no 10361, OS thread id 1141885248 MySQL thread id 621309, query id 905891746 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144356666, not started, process no 10361, OS thread id 1196677440 MySQL thread id 621317, query id 905686644 10.0.0.6 spaces ---TRANSACTION 9 1144471054, not started, process no 10361, OS thread id 1162758464 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 621289, query id 905895257 spaces 10.0.0.3 spaces Updating UPDATE spaces_guests SET flags = (flags | '1') WHERE sid='5763638731676721' ---TRANSACTION 9 1144442178, not started, process no 10361, OS thread id 1172592960 MySQL thread id 621290, query id 905895159 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144353823, not started, process no 10361, OS thread id 1227786560 MySQL thread id 620985, query id 905891946 10.0.0.6 spaces ---TRANSACTION 9 1144468003, not started, process no 10361, OS thread id 1192663360 MySQL thread id 621279, query id 905889605 10.0.0.6 spaces ---TRANSACTION 9 1144348445, not started, process no 10361, OS thread id 1146100032 MySQL thread id 621124, query id 905781546 10.0.0.6 spaces ---TRANSACTION 9 1144447646, not started, process no 10361, OS thread id 1197881664 MySQL thread id 621261, query id 905851661 10.0.0.6 spaces ---TRANSACTION 9 1144466074, not started, process no 10361, OS thread id 1190054208 MySQL thread id 621259, query id 905885775 10.0.0.6 spaces ---TRANSACTION 9 1144329028, not started, process no 10361, OS thread id 1169582400 MySQL thread id 621139, query id 905892674 10.0.0.6 spaces ---TRANSACTION 9 1144466945, not started, process no 10361, OS thread id 1178212672 MySQL thread id 621078, query id 905895291 10.0.0.6 spaces ---TRANSACTION 9 1144436790, not started, process no 10361, OS thread id 1215142208 MySQL thread id 621099, query id 905894339 10.0.0.6 spaces ---TRANSACTION 9 1144469747, not started, process no 10361, OS thread id 1234008384 MySQL thread id 621244, query id 905892947 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144399187, not started, process no 10361, OS thread id 1206913344 MySQL thread id 621240, query id 905764887 10.0.0.6 spaces ---TRANSACTION 9 1144466817, not started, process no 10361, OS thread id 1198082368 MySQL thread id 621232, query id 905887423 10.0.0.6 spaces ---TRANSACTION 9 1144263344, not started, process no 10361, OS thread id 1181423936 MySQL thread id 621106, query id 905888000 10.0.0.6 spaces ---TRANSACTION 9 1144449788, not started, process no 10361, OS thread id 1228790080 MySQL thread id 621220, query id 905855453 10.0.0.6 spaces ---TRANSACTION 9 1144470173, not started, process no 10361, OS thread id 1229793600 MySQL thread id 621221, query id 905893702 10.0.0.6 spaces ---TRANSACTION 9 1144470611, not started, process no 10361, OS thread id 1226381632 MySQL thread id 621218, query id 905894402 10.0.0.6 spaces ---TRANSACTION 9 1144441274, not started, process no 10361, OS thread id 1220561216 MySQL thread id 621213, query id 905840670 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144460141, not started, process no 10361, OS thread id 1223973184 MySQL thread id 621211, query id 905874508 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144461605, not started, process no 10361, OS thread id 1222969664 MySQL thread id 621210, query id 905877300 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144465133, not started, process no 10361, OS thread id 1220761920 MySQL thread id 621208, query id 905883906 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144444883, not started, process no 10361, OS thread id 1196878144 MySQL thread id 621020, query id 905892773 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144437288, not started, process no 10361, OS thread id 1214540096 MySQL thread id 621204, query id 905833389 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144447026, not started, process no 10361, OS thread id 1208920384 MySQL thread id 621201, query id 905850454 10.0.0.6 spaces ---TRANSACTION 9 1144438985, not started, process no 10361, OS thread id 1192462656 MySQL thread id 621197, query id 905836462 10.0.0.6 spaces ---TRANSACTION 9 1144435020, not started, process no 10361, OS thread id 1167976768 MySQL thread id 621192, query id 905829256 10.0.0.6 spaces ---TRANSACTION 9 1144437592, not started, process no 10361, OS thread id 1148107072 MySQL thread id 621189, query id 905833972 10.0.0.6 spaces ---TRANSACTION 9 1144470741, not started, process no 10361, OS thread id 1247856960 MySQL thread id 621168, query id 905894744 10.0.0.6 spaces freeing items SELECT * FROM spaces_forums_comments WHERE comment_id = '8517721' ---TRANSACTION 9 1144470616, not started, process no 10361, OS thread id 1157941568 MySQL thread id 621160, query id 905894438 10.0.0.6 spaces freeing items SELECT * FROM spaces_forums WHERE category_id = '4657' ---TRANSACTION 9 1144397305, not started, process no 10361, OS thread id 1278564672 MySQL thread id 621152, query id 905761529 10.0.0.6 spaces ---TRANSACTION 9 1144470082, not started, process no 10361, OS thread id 1260300608 MySQL thread id 621149, query id 905893486 10.0.0.6 spaces ---TRANSACTION 9 1144330504, not started, process no 10361, OS thread id 1141283136 MySQL thread id 621135, query id 905892639 10.0.0.6 spaces ---TRANSACTION 9 1144470506, not started, process no 10361, OS thread id 1162959168 MySQL thread id 621137, query id 905894283 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_chat WHERE room_id='7767' AND ((private = 0 or private = '208150') OR user_id = '208150') ---TRANSACTION 9 1144466834, not started, process no 10361, OS thread id 1202698560 MySQL thread id 621140, query id 905887451 10.0.0.6 spaces ---TRANSACTION 9 1144450907, not started, process no 10361, OS thread id 1262508352 MySQL thread id 621122, query id 905895804 10.0.0.6 spaces ---TRANSACTION 9 1144465390, not started, process no 10361, OS thread id 1164564800 MySQL thread id 621107, query id 905884389 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470722, not started, process no 10361, OS thread id 1145899328 MySQL thread id 621105, query id 905894662 10.0.0.6 spaces freeing items SELECT page,comments_cnt,last_comment_id FROM spaces_music_tracking WHERE user_id='392410' AND object_id='1328892' ---TRANSACTION 9 1144433009, not started, process no 10361, OS thread id 1201895744 MySQL thread id 621062, query id 905825581 10.0.0.6 spaces ---TRANSACTION 9 1144470610, not started, process no 10361, OS thread id 1199085888 MySQL thread id 621056, query id 905894396 spaces 10.0.0.3 spaces freeing items SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '51' ORDER BY rate DESC LIMIT 0,5 ---TRANSACTION 9 1144228099, not started, process no 10361, OS thread id 1200089408 MySQL thread id 621031, query id 905892878 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144457588, not started, process no 10361, OS thread id 1221966144 MySQL thread id 620832, query id 905892301 10.0.0.6 spaces ---TRANSACTION 9 1144469459, not started, process no 10361, OS thread id 1244645696 MySQL thread id 620998, query id 905892339 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144466242, not started, process no 10361, OS thread id 1231599936 MySQL thread id 620997, query id 905886447 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470612, not started, process no 10361, OS thread id 1142688064 MySQL thread id 620995, query id 905894458 spaces 10.0.0.3 spaces freeing items SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1735' ORDER BY rate DESC LIMIT 1530,5 ---TRANSACTION 9 1144214383, not started, process no 10361, OS thread id 1156938048 MySQL thread id 620988, query id 905895142 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470674, not started, process no 10361, OS thread id 1268730176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620984, query id 905895169 10.0.0.6 spaces Sorting result SELECT * FROM spaces_forums_comments WHERE topic_id = '458363' AND user_id = '433333' ORDER BY ctime DESC LIMIT 1 ---TRANSACTION 9 1144460306, not started, process no 10361, OS thread id 1248459072 MySQL thread id 620979, query id 905874783 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144459671, not started, process no 10361, OS thread id 1203099968 MySQL thread id 620978, query id 905873736 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144222662, not started, process no 10361, OS thread id 1219156288 MySQL thread id 620969, query id 905893227 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144465914, not started, process no 10361, OS thread id 1154931008 MySQL thread id 620976, query id 905885440 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144469524, not started, process no 10361, OS thread id 1232001344 MySQL thread id 620973, query id 905892496 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144328708, not started, process no 10361, OS thread id 1176607040 MySQL thread id 620911, query id 905848051 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470689, not started, process no 10361, OS thread id 1168378176 MySQL thread id 620968, query id 905894572 spaces 10.0.0.3 spaces freeing items SELECT comment_id FROM spaces_myfiles_comments WHERE file_id='174182' ORDER BY comment_id DESC LIMIT 1 ---TRANSACTION 9 1144470742, not started, process no 10361, OS thread id 1233004864 MySQL thread id 620961, query id 905894747 spaces 10.0.0.3 spaces freeing items SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '262961' ---TRANSACTION 9 1144375763, not started, process no 10361, OS thread id 1228187968 MySQL thread id 620794, query id 905892321 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144445823, not started, process no 10361, OS thread id 1268930880 MySQL thread id 620926, query id 905848275 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144463881, not started, process no 10361, OS thread id 1238624576 MySQL thread id 620925, query id 905881546 10.0.0.7 spaces ---TRANSACTION 9 1144445878, not started, process no 10361, OS thread id 1147906368 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 620910, query id 905895801 spaces 10.0.0.3 spaces update INSERT INTO spaces_mail SET user_id='386523', msg_user_id='321846',flags='0',direction='0',ctime=NOW(),text='Блондинки.впринцепи со всеми,кроме ласкавай,надо её удалить,я не беру всех подряд в друзья практически вообще не беру.',new='0' ---TRANSACTION 9 1144437414, not started, process no 10361, OS thread id 1264314688 MySQL thread id 620823, query id 905883168 10.0.0.6 spaces ---TRANSACTION 9 1144361651, not started, process no 10361, OS thread id 1206712640 MySQL thread id 620855, query id 905891663 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144418148, not started, process no 10361, OS thread id 1273547072 MySQL thread id 620893, query id 905800242 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144458032, not started, process no 10361, OS thread id 1203902784 MySQL thread id 620892, query id 905870748 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144453032, not started, process no 10361, OS thread id 1165166912 MySQL thread id 620886, query id 905861335 10.0.0.6 spaces ---TRANSACTION 9 1144406298, not started, process no 10361, OS thread id 1210526016 MySQL thread id 620878, query id 905778465 10.0.0.6 spaces ---TRANSACTION 9 1144421071, not started, process no 10361, OS thread id 1278966080 MySQL thread id 620660, query id 905891286 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144453374, not started, process no 10361, OS thread id 1205909824 MySQL thread id 620865, query id 905861944 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144456523, not started, process no 10361, OS thread id 1160751424 MySQL thread id 620861, query id 905867738 10.0.0.6 spaces ---TRANSACTION 9 1144396395, not started, process no 10361, OS thread id 1235011904 MySQL thread id 620820, query id 905892153 10.0.0.6 spaces ---TRANSACTION 9 1144420111, not started, process no 10361, OS thread id 1259698496 MySQL thread id 620796, query id 905886752 10.0.0.7 spaces ---TRANSACTION 9 1144464832, not started, process no 10361, OS thread id 1269131584 MySQL thread id 620797, query id 905883382 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470556, not started, process no 10361, OS thread id 1209522496 MySQL thread id 620795, query id 905894390 10.0.0.7 spaces freeing items SELECT page,comments_cnt,last_comment_id FROM spaces_pictures_tracking WHERE user_id='426619' AND object_id='523658' ---TRANSACTION 9 1144458042, not started, process no 10361, OS thread id 1225378112 MySQL thread id 620786, query id 905870768 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144425881, not started, process no 10361, OS thread id 1241033024 MySQL thread id 620771, query id 905814491 10.0.0.6 spaces ---TRANSACTION 9 1144422462, not started, process no 10361, OS thread id 1233807680 MySQL thread id 620644, query id 905893508 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144465896, not started, process no 10361, OS thread id 1227385152 MySQL thread id 620764, query id 905885487 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144446056, not started, process no 10361, OS thread id 1164765504 MySQL thread id 620497, query id 905895157 10.0.0.6 spaces ---TRANSACTION 9 1144376592, not started, process no 10361, OS thread id 1263511872 MySQL thread id 620696, query id 905893624 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144457015, not started, process no 10361, OS thread id 1208318272 MySQL thread id 620742, query id 905868760 spaces 10.0.0.3 spaces ---TRANSACTION 9 1143973777, not started, process no 10361, OS thread id 1162557760 MySQL thread id 614725, query id 905037561 10.0.0.7 spaces ---TRANSACTION 9 1144453108, not started, process no 10361, OS thread id 1253677376 MySQL thread id 620720, query id 905892486 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144434318, not started, process no 10361, OS thread id 1171188032 MySQL thread id 620683, query id 905892993 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470703, not started, process no 10361, OS thread id 1180019008 MySQL thread id 620692, query id 905894536 spaces 10.0.0.3 spaces freeing items SELECT COUNT(*) FROM spaces_diary_topics WHERE user_id = '660477' ---TRANSACTION 9 1144433689, not started, process no 10361, OS thread id 1199286592 MySQL thread id 620700, query id 905826842 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470600, not started, process no 10361, OS thread id 1150314816 MySQL thread id 620659, query id 905894475 spaces 10.0.0.3 spaces freeing items SELECT * FROM spaces_diary_comments WHERE user = '38247' AND topic_id='1235228762' ORDER BY ctime DESC LIMIT 1 ---TRANSACTION 9 1144442110, not started, process no 10361, OS thread id 1275353408 MySQL thread id 620575, query id 905891822 10.0.0.6 spaces ---TRANSACTION 9 1144422554, not started, process no 10361, OS thread id 1188448576 MySQL thread id 620592, query id 905808449 10.0.0.6 spaces ---TRANSACTION 9 1144469227, not started, process no 10361, OS thread id 1267325248 MySQL thread id 620444, query id 905891851 spaces 10.0.0.3 spaces ---TRANSACTION 9 1143815761, not started, process no 10361, OS thread id 1207716160 MySQL thread id 620428, query id 904751160 10.0.0.7 spaces ---TRANSACTION 9 1144396694, not started, process no 10361, OS thread id 1267124544 MySQL thread id 620411, query id 905760358 10.0.0.6 spaces ---TRANSACTION 9 1144432876, not started, process no 10361, OS thread id 1208719680 MySQL thread id 620223, query id 905892223 10.0.0.6 spaces ---TRANSACTION 9 1144467614, not started, process no 10361, OS thread id 1172793664 MySQL thread id 620372, query id 905888879 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144470203, not started, process no 10361, OS thread id 1262106944 MySQL thread id 620342, query id 905893763 spaces 10.0.0.3 spaces ---TRANSACTION 9 1144453919, not started, process no 10361, OS thread id 1191459136 MySQL thread id 620340, query id 905862889 10.0.0.6 spaces ---TRANSACTION 9 1144458607, not started, process no 10361, OS thread id 1235814720 MySQL thread id 620240, query id 905893908 10.0.0.6 spaces ---TRANSACTION 9 1144370921, not started, process no 10361, OS thread id 1170585920 MySQL thread id 620247, query id 905891825 10.0.0.6 spaces ---TRANSACTION 9 1144470489, not started, process no 10361, OS thread id 1184033088 MySQL thread id 620241, query id 905894265 10.0.0.6 spaces ---TRANSACTION 9 1144366483, not started, process no 10361, OS thread id 1265518912 MySQL thread id 619901, query id 905893475 10.0.0.7 spaces ---TRANSACTION 9 1144465330, not started, process no 10361, OS thread id 1194871104 MySQL thread id 620007, query id 905893828 10.0.0.6 spaces ---TRANSACTION 9 1143500547, not started, process no 10361, OS thread id 1183430976 MySQL thread id 618750, query id 904217054 10.0.0.7 spaces ---TRANSACTION 9 1144458674, not started, process no 10361, OS thread id 1239025984 MySQL thread id 620026, query id 905871998 10.0.0.6 spaces ---TRANSACTION 9 1143491052, not started, process no 10361, OS thread id 1204906304 MySQL thread id 620024, query id 904199361 10.0.0.7 spaces ---TRANSACTION 9 1144368837, not started, process no 10361, OS thread id 1244043584 MySQL thread id 619617, query id 905892538 10.0.0.6 spaces ---TRANSACTION 9 1144204528, not started, process no 10361, OS thread id 1183230272 MySQL thread id 619654, query id 905894670 10.0.0.6 spaces ---TRANSACTION 9 1144259561, not started, process no 10361, OS thread id 1271740736 MySQL thread id 619922, query id 905548917 10.0.0.6 spaces ---TRANSACTION 9 1144455425, not started, process no 10361, OS thread id 1230395712 MySQL thread id 619897, query id 905893905 10.0.0.6 spaces ---TRANSACTION 9 1144419183, not started, process no 10361, OS thread id 1256888640 MySQL thread id 619693, query id 905895322 10.0.0.6 spaces ---TRANSACTION 9 1144463576, not started, process no 10361, OS thread id 1166772544 MySQL thread id 619912, query id 905880927 10.0.0.7 spaces ---TRANSACTION 9 1144466416, not started, process no 10361, OS thread id 1213335872 MySQL thread id 619908, query id 905886687 10.0.0.7 spaces ---TRANSACTION 9 1144470721, not started, process no 10361, OS thread id 1242839360 MySQL thread id 619900, query id 905894690 10.0.0.7 spaces freeing items SELECT * FROM spaces_users_anketa WHERE user_id='653935' ---TRANSACTION 9 1144415060, not started, process no 10361, OS thread id 1163561280 MySQL thread id 619895, query id 905893888 10.0.0.7 spaces ---TRANSACTION 9 1144352475, not started, process no 10361, OS thread id 1162156352 MySQL thread id 619857, query id 905891953 10.0.0.7 spaces ---TRANSACTION 9 1144463307, not started, process no 10361, OS thread id 1280371008 MySQL thread id 619690, query id 905895211 10.0.0.6 spaces ---TRANSACTION 9 1144423845, not started, process no 10361, OS thread id 1150515520 MySQL thread id 619870, query id 905810861 10.0.0.7 spaces ---TRANSACTION 9 1144454885, not started, process no 10361, OS thread id 1278765376 MySQL thread id 619502, query id 905894209 10.0.0.7 spaces ---TRANSACTION 9 1144452847, not started, process no 10361, OS thread id 1157540160 MySQL thread id 619806, query id 905893629 10.0.0.7 spaces ---TRANSACTION 9 1144452966, not started, process no 10361, OS thread id 1154529600 MySQL thread id 619686, query id 905895062 10.0.0.6 spaces ---TRANSACTION 9 1144469955, not started, process no 10361, OS thread id 1212733760 MySQL thread id 619811, query id 905893304 10.0.0.7 spaces ---TRANSACTION 9 1144408689, not started, process no 10361, OS thread id 1210124608 MySQL thread id 619803, query id 905782662 10.0.0.6 spaces ---TRANSACTION 9 1144406464, not started, process no 10361, OS thread id 1205107008 MySQL thread id 619797, query id 905778749 10.0.0.6 spaces ---TRANSACTION 9 1144416554, not started, process no 10361, OS thread id 1149913408 MySQL thread id 619793, query id 905797173 10.0.0.6 spaces ---TRANSACTION 9 1144470039, not started, process no 10361, OS thread id 1279568192 MySQL thread id 619771, query id 905893478 10.0.0.6 spaces ---TRANSACTION 9 1144455381, not started, process no 10361, OS thread id 1245448512 MySQL thread id 619763, query id 905865616 10.0.0.7 spaces ---TRANSACTION 9 1144467707, not started, process no 10361, OS thread id 1170184512 MySQL thread id 619753, query id 905889101 10.0.0.6 spaces ---TRANSACTION 9 1144465767, not started, process no 10361, OS thread id 1226783040 MySQL thread id 619752, query id 905885245 10.0.0.6 spaces ---TRANSACTION 9 1144165645, not started, process no 10361, OS thread id 1156536640 MySQL thread id 619698, query id 905893925 10.0.0.6 spaces ---TRANSACTION 9 1144462249, not started, process no 10361, OS thread id 1266723136 MySQL thread id 619742, query id 905878432 10.0.0.6 spaces ---TRANSACTION 9 1144369636, not started, process no 10361, OS thread id 1182026048 MySQL thread id 619643, query id 905894560 10.0.0.6 spaces ---TRANSACTION 9 1144434393, not started, process no 10361, OS thread id 1172191552 MySQL thread id 619606, query id 905894500 10.0.0.6 spaces ---TRANSACTION 9 1144470728, not started, process no 10361, OS thread id 1151117632 MySQL thread id 619697, query id 905894679 10.0.0.6 spaces freeing items SELECT * FROM spaces_myfiles WHERE user_id = '333128' AND dir = '0' ORDER BY file_id DESC LIMIT 10,5 ---TRANSACTION 9 1144470726, not started, process no 10361, OS thread id 1220159808 MySQL thread id 619653, query id 905894692 10.0.0.6 spaces freeing items SELECT * FROM spaces_sessions WHERE sid='6966200503581452' ---TRANSACTION 9 1144470774, not started, process no 10361, OS thread id 1215945024 MySQL thread id 619641, query id 905894812 10.0.0.6 spaces freeing items SELECT * FROM spaces_guests WHERE ip_address='217.74.250.55' AND user_agent='Nokia6131/2.0 (06.10) Profile/MIDP-2.0 Configuration/CLDC-1.1' ---TRANSACTION 9 1144434563, not started, process no 10361, OS thread id 1263712576 MySQL thread id 619604, query id 905893574 10.0.0.7 spaces ---TRANSACTION 9 1144470717, not started, process no 10361, OS thread id 1279166784 MySQL thread id 619605, query id 905894585 10.0.0.6 spaces ---TRANSACTION 9 1144399564, not started, process no 10361, OS thread id 1276156224 MySQL thread id 619565, query id 905891117 10.0.0.7 spaces ---TRANSACTION 9 1144468290, not started, process no 10361, OS thread id 1240230208 MySQL thread id 619568, query id 905890179 10.0.0.7 spaces ---TRANSACTION 9 1144465933, not started, process no 10361, OS thread id 1166571840 MySQL thread id 619503, query id 905885549 10.0.0.7 spaces ---TRANSACTION 9 1144470982, not started, process no 10361, OS thread id 1253476672 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619501, query id 905895167 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_shared_zone_files WHERE com_id='778' ---TRANSACTION 9 1144218401, not started, process no 10361, OS thread id 1154730304 MySQL thread id 619300, query id 905895270 10.0.0.6 spaces ---TRANSACTION 9 1142812732, not started, process no 10361, OS thread id 1156135232 MySQL thread id 619351, query id 903023505 10.0.0.7 spaces ---TRANSACTION 9 1144421864, not started, process no 10361, OS thread id 1146300736 MySQL thread id 619314, query id 905864451 10.0.0.6 spaces ---TRANSACTION 9 1144417178, not started, process no 10361, OS thread id 1276758336 MySQL thread id 618748, query id 905891432 10.0.0.7 spaces ---TRANSACTION 9 1144460745, not started, process no 10361, OS thread id 1191659840 MySQL thread id 618928, query id 905875572 10.0.0.7 spaces ---TRANSACTION 9 1144451059, not started, process no 10361, OS thread id 1182427456 MySQL thread id 618838, query id 905894594 10.0.0.7 spaces ---TRANSACTION 9 1144454246, not started, process no 10361, OS thread id 1153927488 MySQL thread id 618770, query id 905863521 10.0.0.7 spaces ---TRANSACTION 9 1144466618, not started, process no 10361, OS thread id 1247656256 MySQL thread id 618763, query id 905887035 10.0.0.7 spaces ---TRANSACTION 9 1144440972, not started, process no 10361, OS thread id 1166170432 MySQL thread id 618641, query id 905892318 10.0.0.7 spaces ---TRANSACTION 9 1144179062, not started, process no 10361, OS thread id 1206511936 MySQL thread id 618583, query id 905892800 10.0.0.7 spaces ---TRANSACTION 9 1144446164, not started, process no 10361, OS thread id 1221163328 MySQL thread id 618670, query id 905848951 10.0.0.6 spaces ---TRANSACTION 9 1144424278, not started, process no 10361, OS thread id 1227987264 MySQL thread id 618609, query id 905891661 10.0.0.7 spaces ---TRANSACTION 9 1144466395, not started, process no 10361, OS thread id 1194068288 MySQL thread id 618624, query id 905886568 10.0.0.7 spaces ---TRANSACTION 9 1144459072, not started, process no 10361, OS thread id 1206311232 MySQL thread id 618605, query id 905894755 10.0.0.6 spaces ---TRANSACTION 9 1144459710, not started, process no 10361, OS thread id 1163159872 MySQL thread id 618595, query id 905873810 10.0.0.7 spaces ---TRANSACTION 9 1144163028, not started, process no 10361, OS thread id 1251469632 MySQL thread id 618077, query id 905379430 10.0.0.6 spaces ---TRANSACTION 9 1144241344, not started, process no 10361, OS thread id 1195673920 MySQL thread id 618380, query id 905894712 10.0.0.7 spaces ---TRANSACTION 9 1144454430, not started, process no 10361, OS thread id 1228990784 MySQL thread id 618400, query id 905863920 10.0.0.7 spaces ---TRANSACTION 9 1144459449, not started, process no 10361, OS thread id 1277159744 MySQL thread id 618369, query id 905893724 10.0.0.7 spaces ---TRANSACTION 9 1144463680, not started, process no 10361, OS thread id 1246050624 MySQL thread id 618381, query id 905881140 10.0.0.7 spaces ---TRANSACTION 9 1144470719, not started, process no 10361, OS thread id 1239828800 MySQL thread id 618368, query id 905894661 10.0.0.7 spaces freeing items SELECT * FROM spaces_myfiles WHERE file_id = '642901' ---TRANSACTION 9 1141909393, not started, process no 10361, OS thread id 1244846400 MySQL thread id 617944, query id 901455451 10.0.0.7 spaces ---TRANSACTION 9 1144161709, not started, process no 10361, OS thread id 1150916928 MySQL thread id 618109, query id 905881808 10.0.0.7 spaces ---TRANSACTION 9 1144450645, not started, process no 10361, OS thread id 1163761984 MySQL thread id 618133, query id 905856953 10.0.0.7 spaces ---TRANSACTION 9 1141572186, not started, process no 10361, OS thread id 1262307648 MySQL thread id 617852, query id 900889642 10.0.0.6 spaces ---TRANSACTION 9 1144470747, not started, process no 10361, OS thread id 1250466112 MySQL thread id 617599, query id 905894689 10.0.0.7 spaces ---TRANSACTION 9 1141497637, not started, process no 10361, OS thread id 1152923968 MySQL thread id 618073, query id 900758585 10.0.0.7 spaces ---TRANSACTION 9 1144456159, not started, process no 10361, OS thread id 1189452096 MySQL thread id 617727, query id 905895069 10.0.0.6 spaces ---TRANSACTION 9 1144438836, not started, process no 10361, OS thread id 1158342976 MySQL thread id 617738, query id 905895267 10.0.0.6 spaces ---TRANSACTION 9 1144447654, not started, process no 10361, OS thread id 1158142272 MySQL thread id 617844, query id 905851674 10.0.0.6 spaces ---TRANSACTION 9 1144420354, not started, process no 10361, OS thread id 1203702080 MySQL thread id 617729, query id 905894596 10.0.0.7 spaces ---TRANSACTION 9 1144450387, not started, process no 10361, OS thread id 1272944960 MySQL thread id 617838, query id 905856561 10.0.0.7 spaces ---TRANSACTION 9 1144468497, not started, process no 10361, OS thread id 1176406336 MySQL thread id 617778, query id 905890522 10.0.0.6 spaces ---TRANSACTION 9 1144355690, not started, process no 10361, OS thread id 1260702016 MySQL thread id 617666, query id 905895232 10.0.0.7 spaces ---TRANSACTION 9 1144439517, not started, process no 10361, OS thread id 1149512000 MySQL thread id 617748, query id 905837373 10.0.0.7 spaces ---TRANSACTION 9 1144461425, not started, process no 10361, OS thread id 1242638656 MySQL thread id 617664, query id 905876973 10.0.0.7 spaces ---TRANSACTION 9 1143989165, not started, process no 10361, OS thread id 1184635200 MySQL thread id 617634, query id 905066357 10.0.0.7 spaces ---TRANSACTION 9 1144150494, not started, process no 10361, OS thread id 1187043648 MySQL thread id 617256, query id 905895074 10.0.0.6 spaces ---TRANSACTION 9 1144454162, not started, process no 10361, OS thread id 1169180992 MySQL thread id 617394, query id 905863327 10.0.0.6 spaces ---TRANSACTION 9 1144164678, not started, process no 10361, OS thread id 1216948544 MySQL thread id 617045, query id 905895301 10.0.0.6 spaces ---TRANSACTION 9 1144447980, not started, process no 10361, OS thread id 1232402752 MySQL thread id 616996, query id 905893855 10.0.0.7 spaces ---TRANSACTION 9 1144465803, not started, process no 10361, OS thread id 1185638720 MySQL thread id 617163, query id 905885317 10.0.0.6 spaces ---TRANSACTION 9 1144471037, not started, process no 10361, OS thread id 1243240768 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 617042, query id 905895302 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='0' WHERE user_id='681964' ---TRANSACTION 9 1144463189, not started, process no 10361, OS thread id 1194469696 MySQL thread id 616998, query id 905880371 10.0.0.7 spaces ---TRANSACTION 9 1140281135, not started, process no 10361, OS thread id 1205307712 MySQL thread id 614957, query id 898651998 10.0.0.7 spaces ---TRANSACTION 9 1144417725, not started, process no 10361, OS thread id 1229994304 MySQL thread id 616030, query id 905894746 10.0.0.7 spaces ---TRANSACTION 9 1144453512, not started, process no 10361, OS thread id 1171589440 MySQL thread id 616066, query id 905862171 10.0.0.7 spaces ---TRANSACTION 9 1140116231, not started, process no 10361, OS thread id 1147705664 MySQL thread id 614949, query id 898356507 10.0.0.7 spaces ---TRANSACTION 9 1144130717, not started, process no 10361, OS thread id 1275152704 MySQL thread id 615623, query id 905894895 10.0.0.7 spaces ---TRANSACTION 9 1144454851, not started, process no 10361, OS thread id 1155733824 MySQL thread id 615706, query id 905864630 10.0.0.7 spaces ---TRANSACTION 9 1144379976, not started, process no 10361, OS thread id 1201092928 MySQL thread id 615258, query id 905892145 10.0.0.7 spaces ---TRANSACTION 9 1144459142, not started, process no 10361, OS thread id 1189251392 MySQL thread id 615278, query id 905872803 10.0.0.7 spaces ---TRANSACTION 9 1144393790, not started, process no 10361, OS thread id 1257290048 MySQL thread id 614670, query id 905894765 10.0.0.7 spaces ---TRANSACTION 9 1144033237, not started, process no 10361, OS thread id 1147103552 MySQL thread id 614786, query id 905894909 10.0.0.6 spaces ---TRANSACTION 9 1144329362, not started, process no 10361, OS thread id 1261906240 MySQL thread id 614765, query id 905893029 10.0.0.6 spaces ---TRANSACTION 9 1144285639, not started, process no 10361, OS thread id 1144494400 MySQL thread id 614969, query id 905891843 10.0.0.7 spaces ---TRANSACTION 9 1144456837, not started, process no 10361, OS thread id 1260099904 MySQL thread id 614986, query id 905868356 10.0.0.7 spaces ---TRANSACTION 9 1144379973, not started, process no 10361, OS thread id 1153124672 MySQL thread id 614961, query id 905728985 10.0.0.6 spaces ---TRANSACTION 9 1144368010, not started, process no 10361, OS thread id 1239427392 MySQL thread id 614661, query id 905892626 10.0.0.7 spaces ---TRANSACTION 9 1143999957, not started, process no 10361, OS thread id 1183029568 MySQL thread id 614864, query id 905895329 10.0.0.6 spaces ---TRANSACTION 9 1144445776, not started, process no 10361, OS thread id 1188649280 MySQL thread id 614918, query id 905848198 10.0.0.6 spaces ---TRANSACTION 9 1144454466, not started, process no 10361, OS thread id 1159747904 MySQL thread id 614789, query id 905863959 10.0.0.6 spaces ---TRANSACTION 9 1144470688, not started, process no 10361, OS thread id 1277761856 MySQL thread id 614764, query id 905894577 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_journal WHERE topic_id='459863' AND user_id='228094' AND event_id='2' ---TRANSACTION 9 1144468111, not started, process no 10361, OS thread id 1211730240 MySQL thread id 614699, query id 905889877 10.0.0.7 spaces ---TRANSACTION 9 1144422158, not started, process no 10361, OS thread id 1215342912 MySQL thread id 614665, query id 905807768 10.0.0.7 spaces ---TRANSACTION 9 1144373574, not started, process no 10361, OS thread id 1270536512 MySQL thread id 614599, query id 905893457 10.0.0.7 spaces ---TRANSACTION 9 1144409518, not started, process no 10361, OS thread id 1149712704 MySQL thread id 614600, query id 905784261 10.0.0.7 spaces ---TRANSACTION 9 1144415225, not started, process no 10361, OS thread id 1259899200 MySQL thread id 614098, query id 905892941 10.0.0.7 spaces ---TRANSACTION 9 1144458106, not started, process no 10361, OS thread id 1249462592 MySQL thread id 614086, query id 905893101 10.0.0.7 spaces ---TRANSACTION 9 1144469555, not started, process no 10361, OS thread id 1210325312 MySQL thread id 614284, query id 905892577 10.0.0.7 spaces ---TRANSACTION 9 1144469755, not started, process no 10361, OS thread id 1273145664 MySQL thread id 614087, query id 905892961 10.0.0.7 spaces ---TRANSACTION 9 1144312792, not started, process no 10361, OS thread id 1190455616 MySQL thread id 613629, query id 905894844 10.0.0.7 spaces ---TRANSACTION 9 1144469949, not started, process no 10361, OS thread id 1196476736 MySQL thread id 613642, query id 905893288 10.0.0.7 spaces ---TRANSACTION 9 1144451049, not started, process no 10361, OS thread id 1217149248 MySQL thread id 613506, query id 905894919 10.0.0.7 spaces ---TRANSACTION 9 1144470945, not started, process no 10361, OS thread id 1207916864 MySQL thread id 613509, query id 905894965 10.0.0.7 spaces ---TRANSACTION 9 1144463367, not started, process no 10361, OS thread id 1236216128 MySQL thread id 613260, query id 905891247 10.0.0.7 spaces ---TRANSACTION 9 1144448861, not started, process no 10361, OS thread id 1269532992 MySQL thread id 613355, query id 905853733 10.0.0.7 spaces ---TRANSACTION 9 1144469406, not started, process no 10361, OS thread id 1241233728 MySQL thread id 613349, query id 905895227 10.0.0.7 spaces ---TRANSACTION 9 1144471010, not started, process no 10361, OS thread id 1255283008 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 613348, query id 905895238 10.0.0.7 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='16' WHERE user_id='572802' ---TRANSACTION 9 1144465152, not started, process no 10361, OS thread id 1233606976 MySQL thread id 613337, query id 905883957 10.0.0.7 spaces ---TRANSACTION 9 1144384622, not started, process no 10361, OS thread id 1195071808 MySQL thread id 613191, query id 905893541 10.0.0.7 spaces ---TRANSACTION 9 1144428619, not started, process no 10361, OS thread id 1247455552 MySQL thread id 613322, query id 905818653 10.0.0.7 spaces ---TRANSACTION 9 1144409107, not started, process no 10361, OS thread id 1214941504 MySQL thread id 613311, query id 905895114 10.0.0.7 spaces ---TRANSACTION 9 1144319135, not started, process no 10361, OS thread id 1174600000 MySQL thread id 613296, query id 905892678 10.0.0.7 spaces ---TRANSACTION 9 1144458791, not started, process no 10361, OS thread id 1145698624 MySQL thread id 613285, query id 905872190 10.0.0.7 spaces ---TRANSACTION 9 1144416596, not started, process no 10361, OS thread id 1230596416 MySQL thread id 613254, query id 905894240 10.0.0.7 spaces ---TRANSACTION 9 1144456008, not started, process no 10361, OS thread id 1173997888 MySQL thread id 613274, query id 905866834 10.0.0.7 spaces ---TRANSACTION 9 1144470739, not started, process no 10361, OS thread id 1227184448 MySQL thread id 613259, query id 905895833 10.0.0.7 spaces Waiting for table SELECT * from spaces_pictures WHERE pic_id='117007' ---TRANSACTION 9 1144186016, not started, process no 10361, OS thread id 1240430912 MySQL thread id 613204, query id 905891766 10.0.0.7 spaces ---TRANSACTION 9 1144465918, not started, process no 10361, OS thread id 1171388736 MySQL thread id 613212, query id 905885520 10.0.0.7 spaces ---TRANSACTION 9 1144376984, not started, process no 10361, OS thread id 1200892224 MySQL thread id 613156, query id 905894365 10.0.0.7 spaces ---TRANSACTION 9 1144470002, not started, process no 10361, OS thread id 1204304192 MySQL thread id 613205, query id 905893375 10.0.0.7 spaces ---TRANSACTION 9 1144456666, not started, process no 10361, OS thread id 1168779584 MySQL thread id 613177, query id 905893764 10.0.0.7 spaces ---TRANSACTION 9 1144468088, not started, process no 10361, OS thread id 1232804160 MySQL thread id 613184, query id 905889845 10.0.0.7 spaces ---TRANSACTION 9 1144448241, not started, process no 10361, OS thread id 1182828864 MySQL thread id 613157, query id 905852662 10.0.0.7 spaces ---TRANSACTION 9 1144470789, not started, process no 10361, OS thread id 1179416896 MySQL thread id 613155, query id 905894825 10.0.0.7 spaces freeing items SELECT * FROM spaces_shared_zone_files WHERE file_id = '929357' AND source = '0' AND com_id = 0 ---TRANSACTION 9 1144471223, ACTIVE 35 sec, process no 10361, OS thread id 1145096512 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621687, query id 905895852 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 1144471224, sees < 9 1144462277 ---TRANSACTION 9 1144471222, ACTIVE 241 sec, process no 10361, OS thread id 1210927424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621406, query id 905895807 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail_contact_list_6 WHERE user_id='682349' AND user2_id='4839' Trx read view will not see trx with id >= 9 1144471223, sees < 9 1144462277 ---TRANSACTION 9 1144471221, ACTIVE 241 sec, process no 10361, OS thread id 1162357056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621463, query id 905895802 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_3 WHERE nid='91942' AND user_id='395521' ---TRANSACTION 9 1144471220, ACTIVE 243 sec, process no 10361, OS thread id 1167575360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621669, query id 905895800 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='eter87' ---TRANSACTION 9 1144471219, ACTIVE 243 sec, process no 10361, OS thread id 1180821824 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621667, query id 905895797 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='leshkin' ---TRANSACTION 9 1144471218, ACTIVE 243 sec, process no 10361, OS thread id 1161955648 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621665, query id 905895794 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4187104994108576' ---TRANSACTION 9 1144471217, ACTIVE 243 sec, process no 10361, OS thread id 1273948480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621662, query id 905895789 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4357789089791890' ---TRANSACTION 9 1144471216, ACTIVE 243 sec, process no 10361, OS thread id 1207114048 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621660, query id 905895788 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8272691851054985' ---TRANSACTION 9 1144471215, ACTIVE 243 sec, process no 10361, OS thread id 1239226688 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621659, query id 905895787 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5788654011583646' ---TRANSACTION 9 1144471214, ACTIVE 243 sec, process no 10361, OS thread id 1143089472 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621657, query id 905895773 10.0.0.6 spaces statistics SELECT * FROM spaces_guests WHERE ip_address='67.228.166.105' AND user_agent='NOKIA6120c' ---TRANSACTION 9 1144471213, ACTIVE 243 sec, process no 10361, OS thread id 1265117504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621649, query id 905895763 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9904140508375178' ---TRANSACTION 9 1144471212, ACTIVE 243 sec, process no 10361, OS thread id 1200691520 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621648, query id 905895762 10.0.0.6 spaces statistics SELECT * FROM spaces_guests WHERE ip_address='85.115.224.9' AND user_agent='MAUI WAP Browser' ---TRANSACTION 9 1144471211, ACTIVE 243 sec, process no 10361, OS thread id 1212934464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621644, query id 905895755 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '60' ORDER BY rate DESC LIMIT 0,5 Trx read view will not see trx with id >= 9 1144471212, sees < 9 1144462277 ---TRANSACTION 9 1144471210, ACTIVE 243 sec, process no 10361, OS thread id 1167776064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621643, query id 905895754 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Husbandyou' ---TRANSACTION 9 1144471209, ACTIVE 243 sec, process no 10361, OS thread id 1203300672 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621641, query id 905895753 10.0.0.6 spaces Sending data SELECT page,comments_cnt,last_comment_id FROM spaces_diary_tracking WHERE user_id='493245' AND topic_id='1235229272' Trx read view will not see trx with id >= 9 1144471210, sees < 9 1144462277 ---TRANSACTION 9 1144471208, ACTIVE 244 sec, process no 10361, OS thread id 1243040064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621314, query id 905895725 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1533' ORDER BY rate DESC LIMIT 15,5 Trx read view will not see trx with id >= 9 1144471209, sees < 9 1144462277 ---TRANSACTION 9 1144471207, ACTIVE 244 sec, process no 10361, OS thread id 1264515392 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621639, query id 905895720 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8844378142751033' ---TRANSACTION 9 1144471206, ACTIVE 244 sec, process no 10361, OS thread id 1148307776 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621637, query id 905895719 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_friend_list WHERE user_id = '128182' Trx read view will not see trx with id >= 9 1144471207, sees < 9 1144462277 ---TRANSACTION 9 1144471205, ACTIVE 244 sec, process no 10361, OS thread id 1258293568 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621634, query id 905895718 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='528496' Trx read view will not see trx with id >= 9 1144471206, sees < 9 1144462277 ---TRANSACTION 9 1144471204, ACTIVE 244 sec, process no 10361, OS thread id 1181624640 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621631, query id 905895717 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4203078470633966' ---TRANSACTION 9 1144471203, ACTIVE 244 sec, process no 10361, OS thread id 1217751360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621630, query id 905895712 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '1' Trx read view will not see trx with id >= 9 1144471204, sees < 9 1144462277 ---TRANSACTION 9 1144471202, ACTIVE 244 sec, process no 10361, OS thread id 1224776000 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621629, query id 905895709 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '1' Trx read view will not see trx with id >= 9 1144471203, sees < 9 1144462277 ---TRANSACTION 9 1144471201, ACTIVE 244 sec, process no 10361, OS thread id 1193064768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621627, query id 905895702 10.0.0.6 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235229159' Trx read view will not see trx with id >= 9 1144471202, sees < 9 1144462277 ---TRANSACTION 9 1144471200, ACTIVE 244 sec, process no 10361, OS thread id 1234610496 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621625, query id 905895689 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='535118' Trx read view will not see trx with id >= 9 1144471201, sees < 9 1144462277 ---TRANSACTION 9 1144471199, ACTIVE 244 sec, process no 10361, OS thread id 1187645760 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621620, query id 905895675 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_3 WHERE nid='129313' AND user_id='365091' ---TRANSACTION 9 1144471198, ACTIVE 244 sec, process no 10361, OS thread id 1275955520 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621621, query id 905895674 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4786265213646108' ---TRANSACTION 9 1144471197, ACTIVE 244 sec, process no 10361, OS thread id 1160550720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621616, query id 905895669 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='5' AND user_id='647305' Trx read view will not see trx with id >= 9 1144471198, sees < 9 1144462277 ---TRANSACTION 9 1144471196, ACTIVE 244 sec, process no 10361, OS thread id 1142487360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621611, query id 905895665 10.0.0.6 spaces Sorting result SELECT * FROM spaces_mail_contacts WHERE user_id='483509' AND (!spam_cnt OR in_cnt) ORDER BY (new_cnt != 0) DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 1144471197, sees < 9 1144462277 ---TRANSACTION 9 1144471195, ACTIVE 244 sec, process no 10361, OS thread id 1263110464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621609, query id 905895660 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4104621220402738' ---TRANSACTION 9 1144471194, ACTIVE 244 sec, process no 10361, OS thread id 1193867584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621608, query id 905895658 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7998524271348448' ---TRANSACTION 9 1144471193, ACTIVE 245 sec, process no 10361, OS thread id 1245247808 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621605, query id 905895636 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Tunning' ---TRANSACTION 9 1144471192, ACTIVE 246 sec, process no 10361, OS thread id 1272142144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621603, query id 905895629 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9901721909582202' ---TRANSACTION 9 1144471191, ACTIVE 246 sec, process no 10361, OS thread id 1186240832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621600, query id 905895628 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4425345124783564' ---TRANSACTION 9 1144471190, ACTIVE 246 sec, process no 10361, OS thread id 1190254912 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621599, query id 905895627 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='felexxx' ---TRANSACTION 9 1144471189, ACTIVE 246 sec, process no 10361, OS thread id 1241635136 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621597, query id 905895626 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='9' AND user_id='39568' Trx read view will not see trx with id >= 9 1144471190, sees < 9 1144462277 ---TRANSACTION 9 1144471188, ACTIVE 246 sec, process no 10361, OS thread id 1229592896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621595, query id 905895620 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contacts WHERE user_id='125032' AND contact_id='1' Trx read view will not see trx with id >= 9 1144471189, sees < 9 1144462277 ---TRANSACTION 9 1144471187, ACTIVE 246 sec, process no 10361, OS thread id 1148909888 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621591, query id 905895619 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1229915' ---TRANSACTION 9 1144471186, ACTIVE 246 sec, process no 10361, OS thread id 1226983744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621593, query id 905895617 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1735' ORDER BY rate DESC LIMIT 5,5 Trx read view will not see trx with id >= 9 1144471187, sees < 9 1144462277 ---TRANSACTION 9 1144471185, ACTIVE 246 sec, process no 10361, OS thread id 1236416832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621009, query id 905895592 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='0095812287302466' ---TRANSACTION 9 1144471184, ACTIVE 246 sec, process no 10361, OS thread id 1197078848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621589, query id 905895587 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='sergei9099' ---TRANSACTION 9 1144471183, ACTIVE 246 sec, process no 10361, OS thread id 1199888704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621587, query id 905895580 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)' ---TRANSACTION 9 1144471182, ACTIVE 246 sec, process no 10361, OS thread id 1259497792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621585, query id 905895579 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9389379786017738' ---TRANSACTION 9 1144471181, ACTIVE 246 sec, process no 10361, OS thread id 1252673856 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621569, query id 905895576 spaces 10.0.0.3 spaces Sending data SELECT * from spaces_pictures_albums WHERE album_id='134054' Trx read view will not see trx with id >= 9 1144471182, sees < 9 1144462277 ---TRANSACTION 9 1144471180, ACTIVE 246 sec, process no 10361, OS thread id 1253075264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621577, query id 905895550 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='_n_i_k_o_l_a_' ---TRANSACTION 9 1144471179, ACTIVE 246 sec, process no 10361, OS thread id 1262909760 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621575, query id 905895549 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)' ---TRANSACTION 9 1144471178, ACTIVE 246 sec, process no 10361, OS thread id 1148709184 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621571, query id 905895544 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_mail WHERE nid = '78833159' AND user_id = '460102' LIMIT 1 ---TRANSACTION 9 1144471177, ACTIVE 246 sec, process no 10361, OS thread id 1155934528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621572, query id 905895521 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Rus84' ---TRANSACTION 9 1144471176, ACTIVE 247 sec, process no 10361, OS thread id 1200490816 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621567, query id 905895504 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='3569127712560689' ---TRANSACTION 9 1144471175, ACTIVE 247 sec, process no 10361, OS thread id 1188247872 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621565, query id 905895503 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE user_id = '457867' Trx read view will not see trx with id >= 9 1144471176, sees < 9 1144462277 ---TRANSACTION 9 1144471174, ACTIVE 247 sec, process no 10361, OS thread id 1209923904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621564, query id 905895502 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_2 WHERE nid='164653' AND user_id='214172' Trx read view will not see trx with id >= 9 1144471175, sees < 9 1144462277 ---TRANSACTION 9 1144471173, ACTIVE 247 sec, process no 10361, OS thread id 1170987328 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621560, query id 905895497 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '689518' Trx read view will not see trx with id >= 9 1144471174, sees < 9 1144462277 ---TRANSACTION 9 1144471172, ACTIVE 247 sec, process no 10361, OS thread id 1151318336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621558, query id 905895482 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='GANGSTALIFE' ---TRANSACTION 9 1144471171, ACTIVE 247 sec, process no 10361, OS thread id 1202497856 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621556, query id 905895481 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1234960777' Trx read view will not see trx with id >= 9 1144471172, sees < 9 1144462277 ---TRANSACTION 9 1144471170, ACTIVE 247 sec, process no 10361, OS thread id 1150716224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621554, query id 905895480 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5955420237611749' ---TRANSACTION 9 1144471169, ACTIVE 247 sec, process no 10361, OS thread id 1189652800 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621552, query id 905895479 spaces 10.0.0.3 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1621336' ---TRANSACTION 9 1144471168, ACTIVE 247 sec, process no 10361, OS thread id 1221364032 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621550, query id 905895470 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='9' AND user_id='53057' Trx read view will not see trx with id >= 9 1144471169, sees < 9 1144462277 ---TRANSACTION 9 1144471167, ACTIVE 248 sec, process no 10361, OS thread id 1232603456 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621548, query id 905895464 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8586500830816672' ---TRANSACTION 9 1144471166, ACTIVE 248 sec, process no 10361, OS thread id 1211328832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621546, query id 905895453 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE user_id = '675564' Trx read view will not see trx with id >= 9 1144471167, sees < 9 1144462277 ---TRANSACTION 9 1144471165, ACTIVE 248 sec, process no 10361, OS thread id 1208117568 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621540, query id 905895452 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='5' AND user_id='499553' Trx read view will not see trx with id >= 9 1144471166, sees < 9 1144462277 ---TRANSACTION 9 1144471164, ACTIVE 248 sec, process no 10361, OS thread id 1166371136 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621544, query id 905895448 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='657005' Trx read view will not see trx with id >= 9 1144471165, sees < 9 1144462277 ---TRANSACTION 9 1144471163, ACTIVE 248 sec, process no 10361, OS thread id 1269934400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621542, query id 905895443 10.0.0.6 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '1449' AND user_id = '373887' Trx read view will not see trx with id >= 9 1144471164, sees < 9 1144462277 ---TRANSACTION 9 1144471162, ACTIVE 248 sec, process no 10361, OS thread id 1251670336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621532, query id 905895440 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='1838167594320130' ---TRANSACTION 9 1144471161, ACTIVE 248 sec, process no 10361, OS thread id 1190857024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621536, query id 905895423 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2745012848279704' ---TRANSACTION 9 1144471160, ACTIVE 248 sec, process no 10361, OS thread id 1208518976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621531, query id 905895409 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '1' Trx read view will not see trx with id >= 9 1144471161, sees < 9 1144462277 ---TRANSACTION 9 1144471159, ACTIVE 248 sec, process no 10361, OS thread id 1205508416 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621527, query id 905895406 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7057654680438393' ---TRANSACTION 9 1144471158, ACTIVE 248 sec, process no 10361, OS thread id 1188047168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621526, query id 905895402 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='158' AND user_id='681762' Trx read view will not see trx with id >= 9 1144471159, sees < 9 1144462277 ---TRANSACTION 9 1144471157, ACTIVE 248 sec, process no 10361, OS thread id 1250666816 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621529, query id 905895400 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='kuzj1' ---TRANSACTION 9 1144471156, ACTIVE 248 sec, process no 10361, OS thread id 1186040128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621524, query id 905895388 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='romath' ---TRANSACTION 9 1144471155, ACTIVE 249 sec, process no 10361, OS thread id 1221765440 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621522, query id 905895375 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '830' ORDER BY rate DESC LIMIT 35,5 Trx read view will not see trx with id >= 9 1144471156, sees < 9 1144462277 ---TRANSACTION 9 1144471154, ACTIVE 249 sec, process no 10361, OS thread id 1275554112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621520, query id 905895370 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='KAROPUZ' ---TRANSACTION 9 1144471153, ACTIVE 249 sec, process no 10361, OS thread id 1224374592 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621518, query id 905895369 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='535497' Trx read view will not see trx with id >= 9 1144471154, sees < 9 1144462277 ---TRANSACTION 9 1144471152, ACTIVE 249 sec, process no 10361, OS thread id 1152121152 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621516, query id 905895360 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_mail WHERE nid = '78833446' AND user_id = '508800' LIMIT 1 ---TRANSACTION 9 1144471151, ACTIVE 249 sec, process no 10361, OS thread id 1160350016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621514, query id 905895359 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1103' ORDER BY rate DESC LIMIT 0,5 Trx read view will not see trx with id >= 9 1144471152, sees < 9 1144462277 ---TRANSACTION 9 1144471150, ACTIVE 249 sec, process no 10361, OS thread id 1250064704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621506, query id 905895358 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='453069' ---TRANSACTION 9 1144471149, ACTIVE 249 sec, process no 10361, OS thread id 1165969728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621511, query id 905895357 spaces 10.0.0.3 spaces Sending data SELECT text FROM spaces_mail USE INDEX (user_id_2) WHERE user_id = '215342' AND msg_user_id='565908' AND direction='0' ORDER BY CTIME DESC LIMIT 1 ---TRANSACTION 9 1144471148, ACTIVE 249 sec, process no 10361, OS thread id 1190656320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621510, query id 905895356 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='SaHaRa13' ---TRANSACTION 9 1144471147, ACTIVE 249 sec, process no 10361, OS thread id 1152321856 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621507, query id 905895348 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9515687680440522' ---TRANSACTION 9 1144471146, ACTIVE 249 sec, process no 10361, OS thread id 1179818304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614862, query id 905895330 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2339444272086700' ---TRANSACTION 9 1144471145, ACTIVE 249 sec, process no 10361, OS thread id 1198483776 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619685, query id 905895325 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='6755265663186763' ---TRANSACTION 9 1144471144, ACTIVE 249 sec, process no 10361, OS thread id 1216547136 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621295, query id 905895324 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='6' AND user_id='628202' Trx read view will not see trx with id >= 9 1144471145, sees < 9 1144462277 ---TRANSACTION 9 1144471143, ACTIVE 249 sec, process no 10361, OS thread id 1266121024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621447, query id 905895297 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='KIRILL37' ---TRANSACTION 9 1144471142, ACTIVE 249 sec, process no 10361, OS thread id 1271138624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621077, query id 905895292 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2094143726066701' ---TRANSACTION 9 1144471141, ACTIVE 249 sec, process no 10361, OS thread id 1161554240 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621145, query id 905895287 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7444619846640752' ---TRANSACTION 9 1144471140, ACTIVE 249 sec, process no 10361, OS thread id 1173596480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 613253, query id 905895282 10.0.0.7 spaces Sending data SELECT page,comments_cnt,last_comment_id FROM spaces_files_tracking WHERE user_id='658369' AND object_id='271240' Trx read view will not see trx with id >= 9 1144471141, sees < 9 1144462277 ---TRANSACTION 9 1144471139, ACTIVE 249 sec, process no 10361, OS thread id 1246652736 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621097, query id 905895281 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_journal WHERE user_id='213605' AND flags & 1 Trx read view will not see trx with id >= 9 1144471140, sees < 9 1144462277 ---TRANSACTION 9 1144471138, ACTIVE 250 sec, process no 10361, OS thread id 1185839424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621304, query id 905895278 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='681918' Trx read view will not see trx with id >= 9 1144471139, sees < 9 1144462277 ---TRANSACTION 9 1144471137, ACTIVE 250 sec, process no 10361, OS thread id 1231198528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619298, query id 905895277 10.0.0.6 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235227331' Trx read view will not see trx with id >= 9 1144471138, sees < 9 1144462277 ---TRANSACTION 9 1144471136, ACTIVE 250 sec, process no 10361, OS thread id 1204504896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621312, query id 905895274 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '1267' Trx read view will not see trx with id >= 9 1144471137, sees < 9 1144462277 ---TRANSACTION 9 1144471135, ACTIVE 250 sec, process no 10361, OS thread id 1211529536 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 617737, query id 905895271 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Atomic' ---TRANSACTION 9 1144471134, ACTIVE 250 sec, process no 10361, OS thread id 1155533120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 618604, query id 905895261 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='307451' Trx read view will not see trx with id >= 9 1144471135, sees < 9 1144462277 ---TRANSACTION 9 1144471133, ACTIVE 250 sec, process no 10361, OS thread id 1182628160 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620987, query id 905895256 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '985052' Trx read view will not see trx with id >= 9 1144471134, sees < 9 1144462277 ---TRANSACTION 9 1144471132, ACTIVE 250 sec, process no 10361, OS thread id 1266522432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 615257, query id 905895255 10.0.0.7 spaces statistics SELECT * FROM spaces_music WHERE file_id = '938757' Trx read view will not see trx with id >= 9 1144471133, sees < 9 1144462277 ---TRANSACTION 9 1144471131, ACTIVE 250 sec, process no 10361, OS thread id 1152522560 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621344, query id 905895252 10.0.0.6 spaces Sending data SELECT dir_id FROM spaces_file_directories WHERE parent_dir='69097' Trx read view will not see trx with id >= 9 1144471132, sees < 9 1144462277 ---TRANSACTION 9 1144471130, ACTIVE 250 sec, process no 10361, OS thread id 1173395776 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 161, query id 905895180 data.spaces.ru 10.0.0.5 nagios update INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='1', status_update_time=FROM_UNIXTIME(1242201087), output='PING OK - Packet loss = 0%, RTA = 0\.13 ms', perfdata='rta=0\.130000ms;3000\.000000;5000\.000000;0\.000000 pl=0%;80;100;0', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='10', last_check=FROM_UNIXTIME(1242201077), next_check=FROM_UNIXTIME(1242201147), check_type='0', last_state_change=FROM_UNIXTIME(1241329332), last_hard_state_change=FROM_UNIXTIME(1235953385), last_hard_state='0', last_time_up=FROM_UNIXTIM ---TRANSACTION 9 1144471129, ACTIVE 250 sec, process no 10361, OS thread id 1233205568 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619684, query id 905895251 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums_comments WHERE comment_id = '8517376' Trx read view will not see trx with id >= 9 1144471130, sees < 9 1144462277 ---TRANSACTION 9 1144471128, ACTIVE 250 sec, process no 10361, OS thread id 1255684416 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 613505, query id 905895250 10.0.0.7 spaces statistics SELECT nid FROM spaces_blacklist WHERE user_id = '387244' AND enemy_id = '312731' Trx read view will not see trx with id >= 9 1144471129, sees < 9 1144462277 ---TRANSACTION 9 1144471127, ACTIVE 250 sec, process no 10361, OS thread id 1268328768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 617726, query id 905895248 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '4' Trx read view will not see trx with id >= 9 1144471128, sees < 9 1144462277 ---TRANSACTION 9 1144471126, ACTIVE 250 sec, process no 10361, OS thread id 1265318208 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614660, query id 905895245 10.0.0.7 spaces statistics SELECT COUNT(*) FROM spaces_users WHERE name='Den4ik22' ---TRANSACTION 9 1144471125, ACTIVE 250 sec, process no 10361, OS thread id 1278363968 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621369, query id 905895168 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_forums_comments WHERE topic_id = '410844' AND deleted_by = 0 ORDER BY ctime LIMIT 0,4 Trx read view will not see trx with id >= 9 1144471126, sees < 9 1144462277 ---TRANSACTION 9 1144471123, ACTIVE 250 sec, process no 10361, OS thread id 1212131648 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621488, query id 905895166 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_shared_zone_directories WHERE dir_id='13792' Trx read view will not see trx with id >= 9 1144471124, sees < 9 1144462277 ---TRANSACTION 9 1144471122, ACTIVE 250 sec, process no 10361, OS thread id 1202096448 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620643, query id 905895242 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '571963' Trx read view will not see trx with id >= 9 1144471123, sees < 9 1144462277 ---TRANSACTION 9 1144471121, ACTIVE 250 sec, process no 10361, OS thread id 1194268992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619896, query id 905895241 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_favorites WHERE user_id = '665922' Trx read view will not see trx with id >= 9 1144471122, sees < 9 1144462277 ---TRANSACTION 9 1144471120, ACTIVE 250 sec, process no 10361, OS thread id 1234209088 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620006, query id 905895237 10.0.0.6 spaces Sending data SELECT * FROM spaces_users WHERE nid='497669' ---TRANSACTION 9 1144471119, ACTIVE 250 sec, process no 10361, OS thread id 1218554176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620246, query id 905895236 10.0.0.6 spaces Sending data SELECT new_count FROM spaces_diary_topics WHERE user_id='388960' AND new_count != 0 Trx read view will not see trx with id >= 9 1144471120, sees < 9 1144462277 ---TRANSACTION 9 1144471118, ACTIVE 250 sec, process no 10361, OS thread id 1225177408 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 617665, query id 905895233 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='1514329396114919' ---TRANSACTION 9 1144471117, ACTIVE 250 sec, process no 10361, OS thread id 1264113984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 615622, query id 905895230 10.0.0.7 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235228489' Trx read view will not see trx with id >= 9 1144471118, sees < 9 1144462277 ---TRANSACTION 9 1144471116, ACTIVE 250 sec, process no 10361, OS thread id 1193666880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620822, query id 905895229 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='645656' Trx read view will not see trx with id >= 9 1144471117, sees < 9 1144462277 ---TRANSACTION 9 1144471115, ACTIVE 250 sec, process no 10361, OS thread id 1217550656 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621354, query id 905895228 spaces 10.0.0.3 spaces Sending data SELECT new_count FROM spaces_diary_topics WHERE user_id='297227' AND new_count != 0 Trx read view will not see trx with id >= 9 1144471116, sees < 9 1144462277 ---TRANSACTION 9 1144471114, ACTIVE 250 sec, process no 10361, OS thread id 1267525952 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621343, query id 905895223 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '104272' Trx read view will not see trx with id >= 9 1144471115, sees < 9 1144462277 ---TRANSACTION 9 1144471113, ACTIVE 250 sec, process no 10361, OS thread id 1204103488 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 613310, query id 905895222 10.0.0.7 spaces Sending data SELECT * FROM spaces_users WHERE nid='605458' ---TRANSACTION 9 1144471112, ACTIVE 250 sec, process no 10361, OS thread id 1144092992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620341, query id 905895221 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235229016' Trx read view will not see trx with id >= 9 1144471113, sees < 9 1144462277 ---TRANSACTION 9 1144471111, ACTIVE 250 sec, process no 10361, OS thread id 1187846464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619689, query id 905895218 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8760408354775558' ---TRANSACTION 9 1144471110, ACTIVE 250 sec, process no 10361, OS thread id 1234811200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621132, query id 905895217 10.0.0.6 spaces Sending data SELECT * FROM spaces_users WHERE nid='543886' ---TRANSACTION 9 1144471109, ACTIVE 250 sec, process no 10361, OS thread id 1216346432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620852, query id 905895216 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_forums_comments WHERE user_id='407997' AND com_id='4101' Trx read view will not see trx with id >= 9 1144471110, sees < 9 1144462277 ---TRANSACTION 9 1144471108, ACTIVE 250 sec, process no 10361, OS thread id 1174198592 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614781, query id 905895215 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_directories WHERE parent_dir='25497' AND com_id='4278'ORDER BY level Trx read view will not see trx with id >= 9 1144471109, sees < 9 1144462277 ---TRANSACTION 9 1144471107, ACTIVE 250 sec, process no 10361, OS thread id 1224976704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621328, query id 905895214 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_journal WHERE user_id='83958' AND flags & 1 Trx read view will not see trx with id >= 9 1144471108, sees < 9 1144462277 ---TRANSACTION 9 1144471106, ACTIVE 250 sec, process no 10361, OS thread id 1213135168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 613176, query id 905895213 10.0.0.7 spaces statistics SELECT page,comments_cnt,last_comment_id FROM spaces_forums_tracking WHERE user_id='257866' AND topic_id='437566' ---TRANSACTION 9 1144471104, ACTIVE 250 sec, process no 10361, OS thread id 1179216192 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620574, query id 905895209 10.0.0.6 spaces Sending data SELECT * FROM spaces_chat WHERE room_id='5' AND ((private = 0 or private = '681582') OR user_id = '681582') ORDER BY msg_id DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 1144471105, sees < 9 1144462277 ---TRANSACTION 9 1144471103, ACTIVE 250 sec, process no 10361, OS thread id 1247054144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621048, query id 905895208 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '810282' Trx read view will not see trx with id >= 9 1144471104, sees < 9 1144462277 ---TRANSACTION 9 1144471102, ACTIVE 250 sec, process no 10361, OS thread id 1205709120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619856, query id 905895207 10.0.0.7 spaces Sending data SELECT new_count FROM spaces_music WHERE user_id='157415' AND new_count != 0 Trx read view will not see trx with id >= 9 1144471103, sees < 9 1144462277 ---TRANSACTION 9 1144471101, ACTIVE 250 sec, process no 10361, OS thread id 1248860480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 613203, query id 905895206 10.0.0.7 spaces Sending data SELECT new_count FROM spaces_pictures WHERE user_id='682162' AND new_count != 0 ---TRANSACTION 9 1144471100, ACTIVE 250 sec, process no 10361, OS thread id 1192261952 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620681, query id 905895203 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_music WHERE file_id = '1341148' Trx read view will not see trx with id >= 9 1144471101, sees < 9 1144462277 ---TRANSACTION 9 1144471099, ACTIVE 250 sec, process no 10361, OS thread id 1181825344 waiting in InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 621323, query id 905895199 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_journal WHERE topic_id='458489' AND user_id='552745' AND event_id='2' Trx read view will not see trx with id >= 9 1144471100, sees < 9 1144462277 ---TRANSACTION 9 1144471097, ACTIVE 250 sec, process no 10361, OS thread id 1248057664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621373, query id 905895194 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_chat WHERE room_id='158' AND ((private = 0 or private = '410067') OR user_id = '410067') Trx read view will not see trx with id >= 9 1144471098, sees < 9 1144462277 ---TRANSACTION 9 1144471096, ACTIVE 250 sec, process no 10361, OS thread id 1236015424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619616, query id 905895193 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='114053' Trx read view will not see trx with id >= 9 1144471097, sees < 9 1144462277 ---TRANSACTION 9 1144471095, ACTIVE 250 sec, process no 10361, OS thread id 1195272512 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621029, query id 905895192 spaces 10.0.0.3 spaces Sending data SELECT dir_id FROM spaces_file_directories WHERE parent_dir='113887' Trx read view will not see trx with id >= 9 1144471096, sees < 9 1144462277 ---TRANSACTION 9 1144471094, ACTIVE 250 sec, process no 10361, OS thread id 1258895680 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620817, query id 905895191 10.0.0.6 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '18105' AND forum = 1 Trx read view will not see trx with id >= 9 1144471095, sees < 9 1144462277 ---TRANSACTION 9 1144471093, ACTIVE 250 sec, process no 10361, OS thread id 1215744320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 616029, query id 905895190 10.0.0.7 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='2' AND user_id='382236' Trx read view will not see trx with id >= 9 1144471094, sees < 9 1144462277 ---TRANSACTION 9 1144471092, ACTIVE 250 sec, process no 10361, OS thread id 1219959104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614669, query id 905895189 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '38946' Trx read view will not see trx with id >= 9 1144471093, sees < 9 1144462277 ---TRANSACTION 9 1144471091, ACTIVE 250 sec, process no 10361, OS thread id 1263311168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621019, query id 905895188 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_guestbook WHERE user_id = '321446' Trx read view will not see trx with id >= 9 1144471092, sees < 9 1144462277 ---TRANSACTION 9 1144471088, ACTIVE 250 sec, process no 10361, OS thread id 1267927360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621293, query id 905895186 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '1' Trx read view will not see trx with id >= 9 1144471089, sees < 9 1144462277 ---TRANSACTION 9 1144471087, ACTIVE 250 sec, process no 10361, OS thread id 1234409792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620719, query id 905895185 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='305062' Trx read view will not see trx with id >= 9 1144471088, sees < 9 1144462277 ---TRANSACTION 9 1144471086, ACTIVE 250 sec, process no 10361, OS thread id 1152723264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 616995, query id 905895184 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles_comments WHERE comment_id = '760390' Trx read view will not see trx with id >= 9 1144471087, sees < 9 1144462277 ---TRANSACTION 9 1144471085, ACTIVE 250 sec, process no 10361, OS thread id 1242237248 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614598, query id 905895183 10.0.0.7 spaces statistics SELECT * FROM spaces_mylenta_userlist WHERE user_id = '595810' and lenta_user_id = '160124' Trx read view will not see trx with id >= 9 1144471086, sees < 9 1144462277 ---TRANSACTION 9 1144471083, ACTIVE 250 sec, process no 10361, OS thread id 1172392256, 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 617255, query id 905895086 10.0.0.6 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='20562' ---TRANSACTION 9 1144471078, ACTIVE 250 sec, process no 10361, OS thread id 1222568256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621136, query id 905895177 10.0.0.6 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1199' ORDER BY rate DESC LIMIT 25,5 Trx read view will not see trx with id >= 9 1144471079, sees < 9 1144462277 ---TRANSACTION 9 1144471075, ACTIVE 250 sec, process no 10361, OS thread id 1175202112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620496, query id 905895176 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE pic_id='1219349' ---TRANSACTION 9 1144471074, ACTIVE 250 sec, process no 10361, OS thread id 1195473216 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621498, query id 905895175 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_guests WHERE sid='4189019765954604' ---TRANSACTION 9 1144471073, ACTIVE 250 sec, process no 10361, OS thread id 1201695040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 613295, query id 905895174 10.0.0.7 spaces Sending data SELECT * FROM spaces_forums WHERE forum_id = '12636' Trx read view will not see trx with id >= 9 1144471074, sees < 9 1144462277 ---TRANSACTION 9 1144471071, ACTIVE 250 sec, process no 10361, OS thread id 1177811264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621376, query id 905895172 spaces 10.0.0.3 spaces statistics SELECT nid FROM spaces_blacklist WHERE user_id = '501135' AND enemy_id = '596884' Trx read view will not see trx with id >= 9 1144471072, sees < 9 1144462277 ---TRANSACTION 9 1144471051, ACTIVE 250 sec, process no 10361, OS thread id 1175804224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621193, query id 905895143 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '937850' Trx read view will not see trx with id >= 9 1144471052, sees < 9 1144462277 ---TRANSACTION 9 1144471040, ACTIVE 250 sec, process no 10361, OS thread id 1229191488 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621148, query id 905895126 10.0.0.6 spaces Sending data SELECT * FROM spaces_users WHERE nid='4104' Trx read view will not see trx with id >= 9 1144471101, sees < 9 1144462277 ---TRANSACTION 9 1144471035, ACTIVE 250 sec, process no 10361, OS thread id 1209723200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619805, query id 905895123 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1258011' Trx read view will not see trx with id >= 9 1144471036, sees < 9 1144462277 ---TRANSACTION 9 1144471034, ACTIVE 250 sec, process no 10361, OS thread id 1168578880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614085, query id 905895121 10.0.0.7 spaces Sending data SELECT * FROM spaces_users WHERE nid='134347' Trx read view will not see trx with id >= 9 1144471105, sees < 9 1144462277 ---TRANSACTION 9 1144471029, ACTIVE 250 sec, process no 10361, OS thread id 1219758400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620222, query id 905895117 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '87604' Trx read view will not see trx with id >= 9 1144471030, sees < 9 1144462277 ---TRANSACTION 9 1144471019, ACTIVE 250 sec, process no 10361, OS thread id 1274550592 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 618582, query id 905895026 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles_comments WHERE file_id = '361864' ORDER BY ctime LIMIT 0,4 Trx read view will not see trx with id >= 9 1144471020, sees < 9 1144462277 ---TRANSACTION 9 1144471018, ACTIVE 250 sec, process no 10361, OS thread id 1265920320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620854, query id 905895109 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '4136' Trx read view will not see trx with id >= 9 1144471019, sees < 9 1144462277 ---TRANSACTION 9 1144471016, ACTIVE 250 sec, process no 10361, OS thread id 1171990848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620831, query id 905895105 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '4910' Trx read view will not see trx with id >= 9 1144471017, sees < 9 1144462277 ---TRANSACTION 9 1144471013, ACTIVE 250 sec, process no 10361, OS thread id 1180219712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619603, query id 905895031 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1144471014, sees < 9 1144462277 ---TRANSACTION 9 1144471011, ACTIVE 250 sec, process no 10361, OS thread id 1259096384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621095, query id 905895101 10.0.0.6 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '250904' Trx read view will not see trx with id >= 9 1144471012, sees < 9 1144462277 ---TRANSACTION 9 1144470991, ACTIVE 250 sec, process no 10361, OS thread id 1141483840 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621184, query id 905895081 10.0.0.6 spaces Sending data SELECT * FROM spaces_users WHERE nid='107555' Trx read view will not see trx with id >= 9 1144471083, sees < 9 1144462277 ---TRANSACTION 9 1144470989, ACTIVE 250 sec, process no 10361, OS thread id 1230195008, 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 618837, query id 905895012 10.0.0.7 spaces update INSERT INTO spaces_guests SET sid='5564853824746313', mtime=NOW(), ip_address='217.118.78.106', user_agent='Nokia5700', mobile_device='Nokia 5700', reklama_cursor='3', flags='0' ---TRANSACTION 9 1144470986, ACTIVE 250 sec, process no 10361, OS thread id 1236617536, 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 618379, query id 905895015 10.0.0.7 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='5' WHERE user_id='663205' ---TRANSACTION 9 1144470983, ACTIVE 250 sec, process no 10361, OS thread id 1155332416, 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 617728, query id 905895010 10.0.0.7 spaces update INSERT INTO spaces_guests SET sid='6648046509576417', mtime=NOW(), ip_address='91.192.245.3', user_agent='SonyEricssonP990i/R100 Mozilla/4.0 (compatible; MSIE 6.0; Symbian OS; 306) Opera 8.60 [ru]', mobile_device='SonyEricsson P990i', reklama_cursor='7', flags='0' ---TRANSACTION 9 1144470970, ACTIVE 250 sec, process no 10361, OS thread id 1199688000 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621380, query id 905894990 spaces 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1144470971, sees < 9 1144462277 ---TRANSACTION 9 1144470953, ACTIVE 250 sec, process no 10361, OS thread id 1170786624, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 619894, query id 905894984 10.0.0.7 spaces end UPDATE spaces_forums_tracking SET page='1',comments_cnt='3',last_comment_id='8512647' WHERE user_id='28652' AND topic_id='452449' ---TRANSACTION 9 1144470948, ACTIVE 250 sec, process no 10361, OS thread id 1176004928 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 619564, query id 905894966 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1144470949, sees < 9 1144462277 ---TRANSACTION 9 1144470941, ACTIVE 250 sec, process no 10361, OS thread id 1254078784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620971, query id 905894959 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_directories WHERE parent_dir='0' AND com_id='0'ORDER BY level Trx read view will not see trx with id >= 9 1144470942, sees < 9 1144462277 ---TRANSACTION 9 1144470936, ACTIVE 250 sec, process no 10361, OS thread id 1257892160, 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 613190, query id 905894962 10.0.0.7 spaces end UPDATE spaces_users SET logins = (logins + 1) WHERE nid = '473253' ---TRANSACTION 9 1144470934, ACTIVE 250 sec, process no 10361, OS thread id 1271540032, 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 621494, query id 905894964 spaces 10.0.0.3 spaces end UPDATE spaces_users_events SET mail_new = (mail_new + 1) WHERE user_id='4506' ---TRANSACTION 9 1144470932, ACTIVE 250 sec, process no 10361, OS thread id 1189853504, 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 621500, query id 905894953 spaces 10.0.0.3 spaces end UPDATE spaces_users_events SET mail_new = (mail_new + 1) WHERE user_id='604571' ---TRANSACTION 9 1144470892, ACTIVE 250 sec, process no 10361, OS thread id 1265719616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621141, query id 905894885 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 1144470893, sees < 9 1144462277 ---TRANSACTION 9 1144470890, ACTIVE 250 sec, process no 10361, OS thread id 1241434432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620793, query id 905894840 spaces 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1144470891, sees < 9 1144462277 ---TRANSACTION 9 1144470884, ACTIVE 250 sec, process no 10361, OS thread id 1143892288 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 613628, query id 905894877 10.0.0.7 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '52' ORDER BY rate DESC LIMIT 795,5 Trx read view will not see trx with id >= 9 1144470885, sees < 9 1144462277 ---TRANSACTION 9 1144470879, ACTIVE 250 sec, process no 10361, OS thread id 1146902848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620239, query id 905894876 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 1144470880, sees < 9 1144462277 ---TRANSACTION 9 1144470877, ACTIVE 250 sec, process no 10361, OS thread id 1266321728 waiting in InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 618608, query id 905894905 10.0.0.7 spaces Sorting result SELECT * FROM spaces_forums_comments WHERE topic_id = '147215' AND user_id = '201859' ORDER BY ctime DESC LIMIT 1 Trx read view will not see trx with id >= 9 1144470878, sees < 9 1144462277 ---TRANSACTION 9 1144470870, ACTIVE 250 sec, process no 10361, OS thread id 1252473152 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 618747, query id 905894933 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 9 1144470871, sees < 9 1144462277 ---TRANSACTION 9 1144470860, ACTIVE 250 sec, process no 10361, OS thread id 1164163392 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 618640, query id 905894841 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1144470861, sees < 9 1144462277 ---TRANSACTION 9 1144470839, ACTIVE 250 sec, process no 10361, OS thread id 1251068224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614097, query id 905894827 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 9 1144470840, sees < 9 1144462277 ---TRANSACTION 9 1144470828, ACTIVE 250 sec, process no 10361, OS thread id 1219356992, 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 621330, query id 905894872 spaces 10.0.0.3 spaces end DELETE FROM spaces_guests WHERE sid='1212633738932566' ---TRANSACTION 9 1144470824, ACTIVE 250 sec, process no 10361, OS thread id 1176807744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621334, query id 905894867 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_shared_zone_directories WHERE parent_dir='0' AND com_id='0'ORDER BY level Trx read view will not see trx with id >= 9 1144470825, sees < 9 1144462277 ---TRANSACTION 9 1144470809, ACTIVE 250 sec, process no 10361, OS thread id 1153526080, 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 617598, query id 905894807 10.0.0.7 spaces end UPDATE spaces_users_events SET mylenta_notifies = (mylenta_notifies + 1) WHERE user_id = '321774' ---TRANSACTION 9 1144470792, ACTIVE 250 sec, process no 10361, OS thread id 1165367616, 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 621482, query id 905894767 spaces 10.0.0.3 spaces end UPDATE spaces_pictures SET mtime=NOW(), new_count = (new_count + 1) WHERE pic_id='1628324' ---TRANSACTION 9 1144470772, ACTIVE 250 sec, process no 10361, OS thread id 1226180928 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621307, query id 905894759 spaces 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1144470773, sees < 9 1144462277 ---TRANSACTION 9 1144470760, ACTIVE 250 sec, process no 10361, OS thread id 1209321792 updating or deleting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 619796, query id 905894736 10.0.0.6 spaces updating DELETE FROM spaces_mail_contact_list_3 WHERE nid='140073' AND user_id='309498' ---TRANSACTION 9 1144470648, ACTIVE 250 sec, process no 10361, OS thread id 1161754944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 618108, query id 905894432 10.0.0.7 spaces Sending data SELECT * FROM spaces_forums_comments WHERE topic_id = '390958' AND comment_id > '7473402' AND deleted_by = 0 Trx read view will not see trx with id >= 9 1144470649, sees < 9 1144462277 ---TRANSACTION 9 1144470636, ACTIVE 250 sec, process no 10361, OS thread id 1157339456 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620930, query id 905894510 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_chat WHERE room_id='9' AND ((private = 0 or private = '178783') OR user_id = '178783') ORDER BY msg_id DESC LIMIT 0, 20 Trx read view will not see trx with id >= 9 1144470637, sees < 9 1144462277 ---TRANSACTION 9 1144470437, ACTIVE 250 sec, process no 10361, OS thread id 1266923840 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621134, query id 905894172 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_complaints WHERE (type_id='1' OR type_id='2') AND state = 0 Trx read view will not see trx with id >= 9 1144470438, sees < 9 1144462277 ---TRANSACTION 9 1144470434, ACTIVE 250 sec, process no 10361, OS thread id 1159145792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621484, query id 905894167 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='367021' AND msg_user_id='195407' ORDER BY ctime DESC LIMIT 0,15 Trx read view will not see trx with id >= 9 1144470502, sees < 9 1144462277 ---TRANSACTION 9 1144470365, ACTIVE 250 sec, process no 10361, OS thread id 1143490880, 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 621101, query id 905894072 10.0.0.6 spaces update INSERT INTO spaces_mail SET user_id='341457', msg_user_id='134554',flags='0',direction='0',ctime=NOW(),text='Тебя тоже,кис! Зай у мя 10 р на счету. Кину,зайду.',new='0' ---TRANSACTION 9 1144470310, ACTIVE 250 sec, process no 10361, OS thread id 1230997824, 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 621180, query id 905893946 10.0.0.6 spaces end UPDATE spaces_pictures SET mtime=NOW(), new_count = (new_count + 1) WHERE pic_id='1488287' ---TRANSACTION 9 1144470132, ACTIVE 250 sec, process no 10361, OS thread id 1209121088, 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 621058, query id 905893582 spaces 10.0.0.3 spaces end DELETE FROM spaces_mail WHERE nid='78694482' ---TRANSACTION 9 1144469332, ACTIVE 250 sec, process no 10361, OS thread id 1255483712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 614968, query id 905892080 10.0.0.7 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '18' ORDER BY rate DESC LIMIT 130,5 Trx read view will not see trx with id >= 9 1144469375, sees < 9 1144462277 ---TRANSACTION 9 1144469243, ACTIVE 250 sec, process no 10361, OS thread id 1191057728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 620442, query id 905891877 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail WHERE user_id='211669' AND msg_user_id='200482' Trx read view will not see trx with id >= 9 1144470991, sees < 9 1144462277 ---TRANSACTION 9 1144467900, ACTIVE 251 sec, process no 10361, OS thread id 1200290112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621053, query id 905889473 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='11671' AND msg_user_id='4839' ORDER BY ctime DESC LIMIT 0,15 Trx read view will not see trx with id >= 9 1144468562, sees < 9 1144462277 ---TRANSACTION 9 1144462277, ACTIVE 255 sec, process no 10361, OS thread id 1257089344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 621308, query id 905878471 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE last_place = '24' AND (UNIX_TIMESTAMP() - last_time) < 300 ORDER BY name LIMIT 20,10 Trx read view will not see trx with id >= 9 1144462278, sees < 9 1144462039 -------- 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 23096708 OS file reads, 6121406 OS file writes, 795511 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 1138, free list len 3330, seg size 4469, 3900770 inserts, 3900420 merged recs, 844220 merges Hash table size 25499819, node heap has 71746 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 538 1174113084 Log flushed up to 538 1174113084 Last checkpoint at 538 33658810 0 pending log writes, 0 pending chkp writes 309704 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 14139452608; in additional pool allocated 12600064 Dictionary memory allocated 1210360 Buffer pool size 786432 Free buffers 0 Database pages 714686 Modified db pages 98154 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 26410963, created 563762, written 8071413 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, 190 queries in queue 109 read views open inside InnoDB Main thread process no. 10361, id 1140881728, state: purging Number of rows inserted 18874230, updated 48720062, deleted 7181387, read 87214494713 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================