===================================== 090628 23:57:47 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 48 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 49885180, signal count 32676310 --Thread 1168980288 has waited at row/row0mysql.c line 1720 for 247.00 seconds the semaphore: X-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1168980288) 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 1266723136 has waited at row/row0mysql.c line 1685 for 247.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1168980288) 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 1256888640 has waited at row/row0mysql.c line 1685 for 247.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1168980288) 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 243.00 seconds the semaphore: S-lock on RW-latch at 0xc73b20 created in file dict/dict0dict.c line 728 a writer (thread id 1168980288) 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 14794594966, OS waits 33483182 RW-shared spins 23527165, OS waits 5462400; RW-excl spins 80257165, OS waits 5663764 ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 090627 22:29:34 Transaction: TRANSACTION 11 2466536607, ACTIVE 1 sec, process no 8320, OS thread id 1254480192 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 70606, query id 308746536 10.0.0.3 spaces update INSERT INTO spaces_mail_data_1 SET contact_id='451752', flags='1', ctime=NOW() Foreign key constraint fails for table `spaces_mail`.`spaces_mail_data_1`: , CONSTRAINT `spaces_mail_data_1` FOREIGN KEY (`contact_id`) REFERENCES `spaces_mail_contact_list_1` (`nid`) ON DELETE CASCADE Trying to add in child table, in index `contact_id` tuple: DATA TUPLE: 2 fields; 0: len 4; hex 8006e4a8; asc ;; 1: len 4; hex 80b3d7f2; asc ;; But in parent table `spaces_mail`.`spaces_mail_contact_list_1`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 14; compact format; info bits 0 0: len 4; hex 8006e4a9; asc ;; 1: len 6; hex 000b0843d287; asc C ;; 2: len 7; hex 000024400d165a; asc $@ Z;; 3: len 4; hex 8001c10e; asc ;; 4: len 4; hex 80000000; asc ;; 5: len 4; hex 80000001; asc ;; 6: len 4; hex 80000000; asc ;; 7: len 4; hex 80000000; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 1; hex 80; asc ;; 10: len 1; hex 80; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex ca3baf14; asc ; ;; 13: len 30; hex 72757374726166304063703133342e61676176612e6e6574202020202020; asc rustraf0@cp134.agava.net ;...(truncated); ------------ TRANSACTIONS ------------ Trx id counter 11 2785647174 Purge done for trx's n:o < 11 2785609111 undo n:o < 0 0 History list length 1953 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 8320, OS thread id 1291811136 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 214062, query id 792904186 10.0.0.5 spaces Updating UPDATE spaces_users_remarks SET active=0 WHERE ctime < (FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()) - ban_time)) ---TRANSACTION 0 0, not started, process no 8320, OS thread id 1291409728 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 214060, query id 792904181 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 8320, OS thread id 1146501440 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 214055, query id 792904169 10.0.0.5 spaces update INSERT INTO spaces_chat SET room_id='9', ctime=NOW(), user_id='11889', msg='Первая подсказка: в***', flags='0', private='0', dst='0' ---TRANSACTION 0 0, not started, process no 8320, OS thread id 1280170304 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 214040, query id 792904117 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='25' WHERE user_id='543687' ---TRANSACTION 0 0, not started, process no 8320, OS thread id 1231198528 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 214017, query id 792904058 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='25' WHERE user_id='838993' ---TRANSACTION 0 0, not started, process no 8320, OS thread id 1220159808 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 214018, query id 792904051 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='912523' ---TRANSACTION 0 0, not started, process no 8320, OS thread id 1263511872 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213997, query id 792903983 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='24' WHERE user_id='240516' ---TRANSACTION 11 2785644552, not started, process no 8320, OS thread id 1212131648 MySQL thread id 213921, query id 792899740 10.0.0.6 spaces ---TRANSACTION 11 2785641152, not started, process no 8320, OS thread id 1280371008 MySQL thread id 213989, query id 792902111 10.0.0.6 spaces ---TRANSACTION 11 2785640882, not started, process no 8320, OS thread id 1243040064 MySQL thread id 213992, query id 792894013 10.0.0.3 spaces ---TRANSACTION 11 2785646203, not started, process no 8320, OS thread id 1219557696 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213988, query id 792903557 10.0.0.6 spaces update INSERT INTO spaces_guests SET sid='3551466029716983', mtime=NOW(), ip_address='77.52.117.69', user_agent='Nokia6670/2.0 (6.0522.0) SymbianOS/7.0s Series60/2.1 Profile/MIDP-2.0 Configuration/CLDC-1.0', mobile_device='Nokia 6670', reklama_cursor='0', flags='0' ---TRANSACTION 11 2785637297, not started, process no 8320, OS thread id 1200089408 MySQL thread id 213987, query id 792888654 10.0.0.6 spaces ---TRANSACTION 11 2785637239, not started, process no 8320, OS thread id 1287596352 MySQL thread id 213986, query id 792889977 10.0.0.6 spaces ---TRANSACTION 11 2785634889, not started, process no 8320, OS thread id 1232804160 MySQL thread id 213707, query id 792899955 10.0.0.8 spaces ---TRANSACTION 11 2785634482, not started, process no 8320, OS thread id 1153927488 MySQL thread id 213985, query id 792884514 10.0.0.6 spaces ---TRANSACTION 11 2785630340, not started, process no 8320, OS thread id 1185438016 MySQL thread id 213858, query id 792896654 10.0.0.6 spaces ---TRANSACTION 11 2785646554, not started, process no 8320, OS thread id 1249261888 MySQL thread id 213983, query id 792902649 10.0.0.6 spaces freeing items SELECT * from spaces_diary_comments WHERE user_id = '732289' AND topic_id = '1235478412' ORDER BY ctime DESC LIMIT 1 ---TRANSACTION 11 2785646741, not started, process no 8320, OS thread id 1263712576 MySQL thread id 213981, query id 792902923 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='726266' AND forum_id='5645' ---TRANSACTION 11 2785625183, not started, process no 8320, OS thread id 1177209152 MySQL thread id 213842, query id 792887129 10.0.0.6 spaces ---TRANSACTION 11 2785646664, not started, process no 8320, OS thread id 1274550592 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213976, query id 792903402 10.0.0.6 spaces Updating UPDATE advertise_stat SET show_cnt = show_cnt + '1000' WHERE campaign_id='200' AND ctime = date(NOW()) ---TRANSACTION 11 2785619086, not started, process no 8320, OS thread id 1146300736 MySQL thread id 213973, query id 792860943 10.0.0.6 spaces ---TRANSACTION 11 2785631086, not started, process no 8320, OS thread id 1170184512 MySQL thread id 213972, query id 792878997 10.0.0.6 spaces ---TRANSACTION 11 2785646658, not started, process no 8320, OS thread id 1261906240 MySQL thread id 213945, query id 792903922 10.0.0.3 spaces ---TRANSACTION 11 2785614796, not started, process no 8320, OS thread id 1149913408 MySQL thread id 213971, query id 792854142 10.0.0.6 spaces ---TRANSACTION 11 2785612787, not started, process no 8320, OS thread id 1267927360 MySQL thread id 213616, query id 792850985 10.0.0.7 spaces ---TRANSACTION 11 2785639630, not started, process no 8320, OS thread id 1149110592 MySQL thread id 213966, query id 792891914 10.0.0.3 spaces ---TRANSACTION 11 2785643824, not started, process no 8320, OS thread id 1164364096 MySQL thread id 213959, query id 792903949 10.0.0.3 spaces ---TRANSACTION 11 2785645721, not started, process no 8320, OS thread id 1194469696 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213953, query id 792903832 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='40' WHERE user_id='486958' ---TRANSACTION 11 2785646429, not started, process no 8320, OS thread id 1189652800 MySQL thread id 213956, query id 792903899 10.0.0.3 spaces ---TRANSACTION 11 2785644039, not started, process no 8320, OS thread id 1269532992 MySQL thread id 213955, query id 792903831 10.0.0.3 spaces ---TRANSACTION 11 2785606887, not started, process no 8320, OS thread id 1171589440 MySQL thread id 213948, query id 792842335 10.0.0.6 spaces ---TRANSACTION 11 2785606055, not started, process no 8320, OS thread id 1141684544 MySQL thread id 213764, query id 792903800 10.0.0.8 spaces ---TRANSACTION 11 2785616426, not started, process no 8320, OS thread id 1262307648 MySQL thread id 213649, query id 792901731 10.0.0.7 spaces ---TRANSACTION 11 2785644265, not started, process no 8320, OS thread id 1213737280 MySQL thread id 213944, query id 792903957 10.0.0.3 spaces ---TRANSACTION 11 2785644865, not started, process no 8320, OS thread id 1245047104 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213942, query id 792903960 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='40' WHERE user_id='905715' ---TRANSACTION 11 2785646688, not started, process no 8320, OS thread id 1257892160 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213940, query id 792903893 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='24' WHERE user_id='595206' ---TRANSACTION 11 2785618114, not started, process no 8320, OS thread id 1151920448 MySQL thread id 213652, query id 792903970 10.0.0.7 spaces ---TRANSACTION 11 2785646075, not started, process no 8320, OS thread id 1258293568 MySQL thread id 213931, query id 792903868 10.0.0.3 spaces ---TRANSACTION 11 2785646174, not started, process no 8320, OS thread id 1274751296 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213929, query id 792903870 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='40' WHERE user_id='271346' ---TRANSACTION 11 2785646555, not started, process no 8320, OS thread id 1232202048 MySQL thread id 213910, query id 792902690 10.0.0.6 spaces freeing items SELECT * FROM spaces_lenta_0 USE INDEX(user_id) WHERE user_id='74800' AND hidden = 0 ORDER BY nid DESC LIMIT 0, 29 ---TRANSACTION 11 2785645215, not started, process no 8320, OS thread id 1159948608 MySQL thread id 213916, query id 792900751 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='662344' AND forum_id='4151' ---TRANSACTION 11 2785598365, not started, process no 8320, OS thread id 1269733696 MySQL thread id 213912, query id 792829534 10.0.0.6 spaces ---TRANSACTION 11 2785619166, not started, process no 8320, OS thread id 1201494336 MySQL thread id 213911, query id 792861387 10.0.0.6 spaces ---TRANSACTION 11 2785594998, not started, process no 8320, OS thread id 1255283008 MySQL thread id 213175, query id 792841847 10.0.0.3 spaces ---TRANSACTION 11 2785644440, not started, process no 8320, OS thread id 1144293696 MySQL thread id 213909, query id 792900131 10.0.0.6 spaces ---TRANSACTION 11 2785624800, not started, process no 8320, OS thread id 1264515392 MySQL thread id 213709, query id 792903794 10.0.0.3 spaces ---TRANSACTION 11 2785645991, not started, process no 8320, OS thread id 1171990848 MySQL thread id 213907, query id 792901849 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='848696' AND forum_id='19897' ---TRANSACTION 11 2785594428, not started, process no 8320, OS thread id 1284786496 MySQL thread id 213482, query id 792893267 10.0.0.3 spaces ---TRANSACTION 11 2785644873, not started, process no 8320, OS thread id 1189050688 MySQL thread id 213901, query id 792900162 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_mylenta_userlist WHERE lenta_user_id = '14847' ---TRANSACTION 11 2785589194, not started, process no 8320, OS thread id 1165166912 MySQL thread id 213811, query id 792903920 10.0.0.8 spaces ---TRANSACTION 11 2785585072, not started, process no 8320, OS thread id 1192462656 MySQL thread id 213578, query id 792903915 10.0.0.8 spaces ---TRANSACTION 11 2785646347, not started, process no 8320, OS thread id 1154931008 MySQL thread id 213894, query id 792902422 10.0.0.3 spaces freeing items SELECT new_count FROM spaces_pictures WHERE user_id='95353' AND new_count != 0 ---TRANSACTION 11 2785645920, not started, process no 8320, OS thread id 1191659840 MySQL thread id 213896, query id 792901604 10.0.0.3 spaces ---TRANSACTION 11 2785571671, not started, process no 8320, OS thread id 1284585792 MySQL thread id 213626, query id 792903862 10.0.0.8 spaces ---TRANSACTION 11 2785569939, not started, process no 8320, OS thread id 1285388608 MySQL thread id 213629, query id 792903555 10.0.0.8 spaces ---TRANSACTION 11 2785561918, not started, process no 8320, OS thread id 1161152832 MySQL thread id 213891, query id 792772896 10.0.0.6 spaces ---TRANSACTION 11 2785603420, not started, process no 8320, OS thread id 1249061184 MySQL thread id 213850, query id 792898164 10.0.0.6 spaces ---TRANSACTION 11 2785641277, not started, process no 8320, OS thread id 1159747904 MySQL thread id 213890, query id 792894628 10.0.0.6 spaces ---TRANSACTION 11 2785550718, not started, process no 8320, OS thread id 1211529536 MySQL thread id 213889, query id 792756071 10.0.0.6 spaces ---TRANSACTION 11 2785544377, not started, process no 8320, OS thread id 1254480192 MySQL thread id 213855, query id 792903836 10.0.0.8 spaces ---TRANSACTION 11 2785544242, not started, process no 8320, OS thread id 1260300608 MySQL thread id 213844, query id 792894881 10.0.0.6 spaces ---TRANSACTION 11 2785623269, not started, process no 8320, OS thread id 1250466112 MySQL thread id 213888, query id 792868663 10.0.0.6 spaces ---TRANSACTION 11 2785525074, not started, process no 8320, OS thread id 1233406272 MySQL thread id 213883, query id 792722008 10.0.0.6 spaces ---TRANSACTION 11 2785588329, not started, process no 8320, OS thread id 1273346368 MySQL thread id 213827, query id 792901331 10.0.0.8 spaces ---TRANSACTION 11 2785517760, not started, process no 8320, OS thread id 1217349952 MySQL thread id 213817, query id 792897830 10.0.0.6 spaces ---TRANSACTION 11 2785644932, not started, process no 8320, OS thread id 1149311296 MySQL thread id 213874, query id 792903859 10.0.0.3 spaces ---TRANSACTION 11 2785499400, not started, process no 8320, OS thread id 1227786560 MySQL thread id 213705, query id 792896649 10.0.0.6 spaces ---TRANSACTION 11 2785500897, not started, process no 8320, OS thread id 1198684480 MySQL thread id 213879, query id 792689309 10.0.0.6 spaces ---TRANSACTION 11 2785645848, not started, process no 8320, OS thread id 1199085888 MySQL thread id 213875, query id 792903807 10.0.0.3 spaces ---TRANSACTION 11 2785645869, not started, process no 8320, OS thread id 1240029504 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213872, query id 792903869 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='40' WHERE user_id='737945' ---TRANSACTION 11 2785497446, not started, process no 8320, OS thread id 1263913280 MySQL thread id 213671, query id 792903945 10.0.0.8 spaces ---TRANSACTION 11 2785497136, not started, process no 8320, OS thread id 1144895808 MySQL thread id 213680, query id 792896364 10.0.0.6 spaces ---TRANSACTION 11 2785602911, not started, process no 8320, OS thread id 1200691520 MySQL thread id 213863, query id 792877275 10.0.0.6 spaces ---TRANSACTION 11 2785595838, not started, process no 8320, OS thread id 1214941504 MySQL thread id 213871, query id 792825626 10.0.0.6 spaces ---TRANSACTION 11 2785514168, not started, process no 8320, OS thread id 1240230208 MySQL thread id 213870, query id 792708684 10.0.0.6 spaces ---TRANSACTION 11 2785492496, not started, process no 8320, OS thread id 1170585920 MySQL thread id 213869, query id 792677105 10.0.0.6 spaces ---TRANSACTION 11 2785643834, not started, process no 8320, OS thread id 1204504896 MySQL thread id 213866, query id 792903973 10.0.0.3 spaces ---TRANSACTION 11 2785645239, not started, process no 8320, OS thread id 1278966080 MySQL thread id 213862, query id 792900474 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='599781' AND forum_id='40629' ---TRANSACTION 11 2785487383, not started, process no 8320, OS thread id 1288800576 MySQL thread id 213861, query id 792669502 10.0.0.6 spaces ---TRANSACTION 11 2785486849, not started, process no 8320, OS thread id 1161353536 MySQL thread id 213823, query id 792900343 10.0.0.6 spaces ---TRANSACTION 11 2785646366, not started, process no 8320, OS thread id 1224575296 MySQL thread id 213843, query id 792902281 10.0.0.6 spaces freeing items SELECT page,comments_cnt,last_comment_id FROM spaces_guestbook_tracking WHERE user_id='769234' AND book_user_id='769234' ---TRANSACTION 11 2785486223, not started, process no 8320, OS thread id 1197480256 MySQL thread id 213719, query id 792895811 10.0.0.6 spaces ---TRANSACTION 11 2785646334, not started, process no 8320, OS thread id 1153726784 MySQL thread id 213853, query id 792902116 10.0.0.8 spaces freeing items SELECT COUNT(DISTINCT user_id) FROM spaces_favorites WHERE type_id='3' AND object_id='632110' AND closed != 1 ---TRANSACTION 11 2785645625, not started, process no 8320, OS thread id 1180019008 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213851, query id 792903692 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='147856' ---TRANSACTION 11 2785646250, not started, process no 8320, OS thread id 1270737216 MySQL thread id 213847, query id 792902282 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='513798' AND forum_id='8488' ---TRANSACTION 11 2785645083, not started, process no 8320, OS thread id 1162156352 MySQL thread id 213841, query id 792900596 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='93792' AND forum_id='4638' ---TRANSACTION 11 2785484021, not started, process no 8320, OS thread id 1206110528 MySQL thread id 213840, query id 792664739 10.0.0.6 spaces ---TRANSACTION 11 2785482878, not started, process no 8320, OS thread id 1142286656 MySQL thread id 213835, query id 792663154 10.0.0.6 spaces ---TRANSACTION 11 2785646526, not started, process no 8320, OS thread id 1237420352 MySQL thread id 213825, query id 792902628 10.0.0.8 spaces freeing items SELECT * FROM spaces_forums_comments WHERE topic_id = '602661' AND user_id = '264756' ORDER BY ctime DESC LIMIT 1 ---TRANSACTION 11 2785475397, not started, process no 8320, OS thread id 1198082368 MySQL thread id 213734, query id 792903736 10.0.0.8 spaces ---TRANSACTION 11 2785567185, not started, process no 8320, OS thread id 1217550656 MySQL thread id 213746, query id 792903650 10.0.0.8 spaces ---TRANSACTION 11 2785486431, not started, process no 8320, OS thread id 1207114048 MySQL thread id 213806, query id 792668280 10.0.0.6 spaces ---TRANSACTION 11 2785625483, not started, process no 8320, OS thread id 1215543616 MySQL thread id 213675, query id 792891715 10.0.0.6 spaces ---TRANSACTION 11 2785453321, not started, process no 8320, OS thread id 1277159744 MySQL thread id 213697, query id 792898795 10.0.0.6 spaces ---TRANSACTION 11 2785612983, not started, process no 8320, OS thread id 1200892224 MySQL thread id 213803, query id 792851287 10.0.0.6 spaces ---TRANSACTION 11 2785449699, not started, process no 8320, OS thread id 1276156224 MySQL thread id 213646, query id 792903422 10.0.0.7 spaces ---TRANSACTION 11 2785543874, not started, process no 8320, OS thread id 1182828864 MySQL thread id 213696, query id 792819848 10.0.0.6 spaces ---TRANSACTION 11 2785443816, not started, process no 8320, OS thread id 1286994240 MySQL thread id 213748, query id 792897809 10.0.0.8 spaces ---TRANSACTION 11 2785614593, not started, process no 8320, OS thread id 1176807744 MySQL thread id 213717, query id 792897942 10.0.0.6 spaces ---TRANSACTION 11 2785443104, not started, process no 8320, OS thread id 1232603456 MySQL thread id 213802, query id 792605623 10.0.0.6 spaces ---TRANSACTION 11 2785440871, not started, process no 8320, OS thread id 1195673920 MySQL thread id 213550, query id 792903785 10.0.0.8 spaces ---TRANSACTION 11 2785638945, not started, process no 8320, OS thread id 1183430976 MySQL thread id 213715, query id 792900459 10.0.0.6 spaces ---TRANSACTION 11 2785430434, not started, process no 8320, OS thread id 1228990784 MySQL thread id 213799, query id 792586148 10.0.0.6 spaces ---TRANSACTION 11 2785644402, not started, process no 8320, OS thread id 1253677376 MySQL thread id 213693, query id 792902563 10.0.0.6 spaces ---TRANSACTION 11 2785644912, not started, process no 8320, OS thread id 1180621120 MySQL thread id 213607, query id 792900233 10.0.0.6 spaces ---TRANSACTION 11 2785609423, not started, process no 8320, OS thread id 1262709056 MySQL thread id 213622, query id 792903518 10.0.0.6 spaces ---TRANSACTION 11 2785572348, not started, process no 8320, OS thread id 1234008384 MySQL thread id 213691, query id 792840965 10.0.0.6 spaces ---TRANSACTION 11 2785466262, not started, process no 8320, OS thread id 1287997760 MySQL thread id 213796, query id 792637071 10.0.0.6 spaces ---TRANSACTION 11 2785409999, not started, process no 8320, OS thread id 1252071744 MySQL thread id 213754, query id 792903846 10.0.0.8 spaces ---TRANSACTION 11 2785617911, not started, process no 8320, OS thread id 1158142272 MySQL thread id 213640, query id 792904161 10.0.0.6 spaces ---TRANSACTION 11 2785580485, not started, process no 8320, OS thread id 1196276032 MySQL thread id 213702, query id 792897117 10.0.0.6 spaces ---TRANSACTION 11 2785603452, not started, process no 8320, OS thread id 1260902720 MySQL thread id 213650, query id 792902578 10.0.0.7 spaces ---TRANSACTION 11 2785394783, not started, process no 8320, OS thread id 1202899264 MySQL thread id 213262, query id 792903478 10.0.0.7 spaces ---TRANSACTION 11 2785578246, not started, process no 8320, OS thread id 1144695104 MySQL thread id 213666, query id 792900584 10.0.0.6 spaces ---TRANSACTION 11 2785643894, not started, process no 8320, OS thread id 1158945088 MySQL thread id 213679, query id 792898703 10.0.0.6 spaces ---TRANSACTION 11 2785454696, not started, process no 8320, OS thread id 1259297088 MySQL thread id 213792, query id 792621461 10.0.0.6 spaces ---TRANSACTION 11 2785596597, not started, process no 8320, OS thread id 1186040128 MySQL thread id 213699, query id 792864333 10.0.0.6 spaces ---TRANSACTION 11 2785588606, not started, process no 8320, OS thread id 1277761856 MySQL thread id 213618, query id 792849655 10.0.0.6 spaces ---TRANSACTION 11 2785545427, not started, process no 8320, OS thread id 1257490752 MySQL thread id 213668, query id 792902133 10.0.0.6 spaces ---TRANSACTION 11 2785646271, not started, process no 8320, OS thread id 1255082304 MySQL thread id 213787, query id 792902390 10.0.0.6 spaces ---TRANSACTION 11 2785606543, not started, process no 8320, OS thread id 1191459136 MySQL thread id 213681, query id 792901842 10.0.0.6 spaces ---TRANSACTION 11 2785369285, not started, process no 8320, OS thread id 1141885248 MySQL thread id 213352, query id 792896229 10.0.0.8 spaces ---TRANSACTION 11 2785405504, not started, process no 8320, OS thread id 1167173952 MySQL thread id 213336, query id 792902903 10.0.0.7 spaces ---TRANSACTION 11 2785641844, not started, process no 8320, OS thread id 1182628160 MySQL thread id 213772, query id 792898828 10.0.0.3 spaces ---TRANSACTION 11 2785636046, not started, process no 8320, OS thread id 1153124672 MySQL thread id 213769, query id 792887092 10.0.0.3 spaces ---TRANSACTION 11 2785645149, not started, process no 8320, OS thread id 1228388672 MySQL thread id 213768, query id 792900623 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='314929' AND forum_id='5264' ---TRANSACTION 11 2785642910, not started, process no 8320, OS thread id 1278564672 MySQL thread id 213771, query id 792897259 10.0.0.3 spaces ---TRANSACTION 11 2785644262, not started, process no 8320, OS thread id 1197078848 MySQL thread id 213757, query id 792903581 10.0.0.3 spaces ---TRANSACTION 11 2785599602, not started, process no 8320, OS thread id 1201293632 MySQL thread id 213660, query id 792896501 10.0.0.6 spaces ---TRANSACTION 11 2785451799, not started, process no 8320, OS thread id 1194068288 MySQL thread id 213659, query id 792899130 10.0.0.6 spaces ---TRANSACTION 11 2785526564, not started, process no 8320, OS thread id 1149512000 MySQL thread id 213721, query id 792879802 10.0.0.6 spaces ---TRANSACTION 11 2785596948, not started, process no 8320, OS thread id 1195071808 MySQL thread id 213737, query id 792899625 10.0.0.6 spaces ---TRANSACTION 11 2785420961, not started, process no 8320, OS thread id 1172392256 MySQL thread id 213642, query id 792902988 10.0.0.6 spaces ---TRANSACTION 11 2785645147, not started, process no 8320, OS thread id 1260099904 MySQL thread id 213751, query id 792900541 10.0.0.8 spaces freeing items SELECT page,comments_cnt,last_comment_id FROM spaces_forums_tracking WHERE user_id='593839' AND topic_id='632181' ---TRANSACTION 11 2785646320, not started, process no 8320, OS thread id 1183631680 MySQL thread id 213740, query id 792902314 10.0.0.8 spaces freeing items SELECT * FROM spaces_users WHERE name='Piknik9' ---TRANSACTION 11 2785582471, not started, process no 8320, OS thread id 1253878080 MySQL thread id 213703, query id 792902542 10.0.0.6 spaces ---TRANSACTION 11 2785584300, not started, process no 8320, OS thread id 1277962560 MySQL thread id 213738, query id 792807561 10.0.0.6 spaces ---TRANSACTION 11 2785645793, not started, process no 8320, OS thread id 1199688000 MySQL thread id 213718, query id 792901435 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='180938' AND forum_id='6010' ---TRANSACTION 11 2785643875, not started, process no 8320, OS thread id 1181825344 MySQL thread id 213720, query id 792898664 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='809648' AND forum_id='30601' ---TRANSACTION 11 2785645166, not started, process no 8320, OS thread id 1269131584 MySQL thread id 213714, query id 792900576 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_myfiles WHERE user_id = '141851' ---TRANSACTION 11 2785646173, not started, process no 8320, OS thread id 1259096384 MySQL thread id 213716, query id 792902176 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='821120' AND forum_id='18313' ---TRANSACTION 11 2785421234, not started, process no 8320, OS thread id 1173395776 MySQL thread id 213713, query id 792572760 10.0.0.6 spaces ---TRANSACTION 11 2785563426, not started, process no 8320, OS thread id 1209121088 MySQL thread id 213683, query id 792901119 10.0.0.6 spaces ---TRANSACTION 11 2785645695, not started, process no 8320, OS thread id 1197680960 MySQL thread id 213708, query id 792903792 10.0.0.3 spaces ---TRANSACTION 11 2785368871, not started, process no 8320, OS thread id 1226582336 MySQL thread id 213614, query id 792901791 10.0.0.7 spaces ---TRANSACTION 11 2785646573, not started, process no 8320, OS thread id 1205107008 MySQL thread id 213706, query id 792902354 10.0.0.8 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='499092' AND forum_id='240' ---TRANSACTION 11 2785646581, not started, process no 8320, OS thread id 1153526080 MySQL thread id 213698, query id 792902718 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='56802' AND forum_id='65223' ---TRANSACTION 11 2785646351, not started, process no 8320, OS thread id 1185638720 MySQL thread id 213694, query id 792902374 10.0.0.6 spaces freeing items SELECT * from spaces_pictures WHERE user_id = '628694' AND album_id='0' ORDER BY level,ctime DESC LIMIT 3,1 ---TRANSACTION 11 2785646951, not started, process no 8320, OS thread id 1159346496 MySQL thread id 213692, query id 792903253 10.0.0.6 spaces freeing items SELECT COUNT(*) from spaces_pictures WHERE user_id = '892138' ---TRANSACTION 11 2785645020, not started, process no 8320, OS thread id 1220761920 MySQL thread id 213690, query id 792900484 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='161652' AND forum_id='27557' ---TRANSACTION 11 2785647042, not started, process no 8320, OS thread id 1221765440 waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 213678, query id 792903425 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_friend_list LEFT JOIN spaces_users_anketa ON (spaces_friend_list.friend_id = spaces_users_anketa.user_id) WHERE spaces_friend_list.user_id = '731714' AND MONTH(spaces_users_anketa.age) = MONTH(NOW()) AND DAY(spaces_users_anketa.age) = DAY(NOW()) ---TRANSACTION 11 2785646325, not started, process no 8320, OS thread id 1195272512 MySQL thread id 213682, query id 792902382 10.0.0.6 spaces freeing items SELECT * from spaces_pictures WHERE user_id = '493686' AND album_id='0' ORDER BY pic_id DESC LIMIT 0,5 ---TRANSACTION 11 2785646572, not started, process no 8320, OS thread id 1152723264 MySQL thread id 213677, query id 792902685 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='879721' AND forum_id='25413' ---TRANSACTION 11 2785386707, not started, process no 8320, OS thread id 1272342848 MySQL thread id 213669, query id 792523889 10.0.0.6 spaces ---TRANSACTION 11 2785646588, not started, process no 8320, OS thread id 1171388736 MySQL thread id 213665, query id 792902705 10.0.0.6 spaces freeing items SELECT page,comments_cnt,last_comment_id FROM spaces_diary_tracking WHERE user_id='463644' AND topic_id='1235478369' ---TRANSACTION 11 2785646293, not started, process no 8320, OS thread id 1228790080 MySQL thread id 213657, query id 792902332 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='653263' AND forum_id='11421' ---TRANSACTION 11 2785645141, not started, process no 8320, OS thread id 1247254848 MySQL thread id 213641, query id 792900499 10.0.0.6 spaces freeing items SELECT page,comments_cnt,last_comment_id FROM spaces_guestbook_tracking WHERE user_id='779904' AND book_user_id='798534' ---TRANSACTION 11 2785646746, not started, process no 8320, OS thread id 1169783104 MySQL thread id 213647, query id 792902966 10.0.0.7 spaces freeing items SELECT comment_id FROM spaces_myfiles_comments WHERE file_id='209616' ORDER BY comment_id DESC LIMIT 1 ---TRANSACTION 11 2785646261, not started, process no 8320, OS thread id 1245649216 MySQL thread id 213648, query id 792902233 10.0.0.7 spaces freeing items SELECT * FROM spaces_myfiles_comments WHERE file_id = '343961' ORDER BY ctime LIMIT 0,5 ---TRANSACTION 11 2785646981, not started, process no 8320, OS thread id 1240832320 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213637, query id 792904162 10.0.0.6 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='5' WHERE user_id='909626' ---TRANSACTION 11 2785424039, not started, process no 8320, OS thread id 1185839424 MySQL thread id 213636, query id 792576819 10.0.0.6 spaces ---TRANSACTION 11 2785640568, not started, process no 8320, OS thread id 1251469632 MySQL thread id 213630, query id 792903874 10.0.0.3 spaces ---TRANSACTION 11 2785638869, not started, process no 8320, OS thread id 1168779584 MySQL thread id 213635, query id 792890815 10.0.0.3 spaces ---TRANSACTION 11 2785646344, not started, process no 8320, OS thread id 1270536512 MySQL thread id 213617, query id 792902420 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='774234' AND forum_id='38029' ---TRANSACTION 11 2785645140, not started, process no 8320, OS thread id 1267124544 MySQL thread id 213615, query id 792900660 10.0.0.7 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='169279' AND forum_id='9960' ---TRANSACTION 11 2785646322, not started, process no 8320, OS thread id 1242036544 MySQL thread id 213613, query id 792902005 10.0.0.7 spaces freeing items SELECT * FROM spaces_file_directories WHERE dir_id='20966' ---TRANSACTION 11 2785602802, not started, process no 8320, OS thread id 1272944960 MySQL thread id 213610, query id 792836125 10.0.0.3 spaces ---TRANSACTION 11 2785609469, not started, process no 8320, OS thread id 1202297152 MySQL thread id 213580, query id 792903640 10.0.0.7 spaces ---TRANSACTION 11 2785645145, not started, process no 8320, OS thread id 1169983808 MySQL thread id 213606, query id 792900665 10.0.0.6 spaces freeing items SELECT * FROM spaces_pictures_comments WHERE picture_id = '2142018' ORDER BY ctime LIMIT 0,4 ---TRANSACTION 11 2785615122, not started, process no 8320, OS thread id 1174198592 MySQL thread id 213586, query id 792897772 10.0.0.7 spaces ---TRANSACTION 11 2785602890, not started, process no 8320, OS thread id 1174600000 MySQL thread id 213584, query id 792861945 10.0.0.6 spaces ---TRANSACTION 11 2785452235, not started, process no 8320, OS thread id 1247054144 MySQL thread id 213334, query id 792880852 10.0.0.7 spaces ---TRANSACTION 11 2785284085, not started, process no 8320, OS thread id 1152522560 MySQL thread id 213598, query id 792367967 10.0.0.6 spaces ---TRANSACTION 11 2785409317, not started, process no 8320, OS thread id 1152321856 MySQL thread id 213450, query id 792902031 10.0.0.7 spaces ---TRANSACTION 11 2785519518, not started, process no 8320, OS thread id 1241835840 MySQL thread id 213582, query id 792901651 10.0.0.6 spaces ---TRANSACTION 11 2785509822, not started, process no 8320, OS thread id 1240430912 MySQL thread id 210932, query id 792893168 10.0.0.8 spaces ---TRANSACTION 11 2785585351, not started, process no 8320, OS thread id 1239025984 MySQL thread id 213597, query id 792809221 10.0.0.6 spaces ---TRANSACTION 11 2785256602, not started, process no 8320, OS thread id 1188047168 MySQL thread id 213596, query id 792325216 10.0.0.6 spaces ---TRANSACTION 11 2785335796, not started, process no 8320, OS thread id 1142688064 MySQL thread id 213066, query id 792903573 10.0.0.8 spaces ---TRANSACTION 11 2785322636, not started, process no 8320, OS thread id 1227184448 MySQL thread id 212976, query id 792903506 10.0.0.8 spaces ---TRANSACTION 11 2785632900, not started, process no 8320, OS thread id 1156135232 MySQL thread id 213591, query id 792883729 10.0.0.6 spaces ---TRANSACTION 11 2785463140, not started, process no 8320, OS thread id 1286592832 MySQL thread id 213590, query id 792632508 10.0.0.6 spaces ---TRANSACTION 11 2785645073, not started, process no 8320, OS thread id 1232402752 MySQL thread id 213541, query id 792900569 10.0.0.6 spaces ---TRANSACTION 11 2785646826, not started, process no 8320, OS thread id 1273547072 MySQL thread id 213583, query id 792903029 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='294001' AND forum_id='19154' ---TRANSACTION 11 2785216770, not started, process no 8320, OS thread id 1285990720 MySQL thread id 213567, query id 792265337 10.0.0.6 spaces ---TRANSACTION 11 2785559785, not started, process no 8320, OS thread id 1181223232 MySQL thread id 213556, query id 792901625 10.0.0.6 spaces ---TRANSACTION 11 2785452341, not started, process no 8320, OS thread id 1264716096 MySQL thread id 213553, query id 792902758 10.0.0.6 spaces ---TRANSACTION 11 2785646268, not started, process no 8320, OS thread id 1250064704 MySQL thread id 213554, query id 792902304 10.0.0.6 spaces freeing items SELECT * from spaces_pictures WHERE user_id = '385229' AND album_id='0' ORDER BY level,ctime DESC LIMIT 8,1 ---TRANSACTION 11 2785356028, not started, process no 8320, OS thread id 1224173888 MySQL thread id 213534, query id 792479052 10.0.0.6 spaces ---TRANSACTION 11 2785646369, not started, process no 8320, OS thread id 1219959104 MySQL thread id 213531, query id 792902343 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='320395' AND forum_id='23989' ---TRANSACTION 11 2785632234, not started, process no 8320, OS thread id 1209321792 MySQL thread id 213533, query id 792880757 10.0.0.3 spaces ---TRANSACTION 11 2785641982, not started, process no 8320, OS thread id 1243842880 MySQL thread id 213530, query id 792903544 10.0.0.3 spaces ---TRANSACTION 11 2785564738, not started, process no 8320, OS thread id 1200290112 MySQL thread id 213527, query id 792776972 10.0.0.6 spaces ---TRANSACTION 11 2785373697, not started, process no 8320, OS thread id 1275353408 MySQL thread id 213520, query id 792503926 10.0.0.6 spaces ---TRANSACTION 11 2785537215, not started, process no 8320, OS thread id 1180219712 MySQL thread id 212893, query id 792903685 10.0.0.8 spaces ---TRANSACTION 11 2785639560, not started, process no 8320, OS thread id 1245448512 MySQL thread id 213517, query id 792891812 10.0.0.6 spaces ---TRANSACTION 11 2785143882, not started, process no 8320, OS thread id 1175402816 MySQL thread id 213498, query id 792154131 10.0.0.6 spaces ---TRANSACTION 11 2785645183, not started, process no 8320, OS thread id 1155131712 MySQL thread id 213491, query id 792900739 10.0.0.3 spaces ---TRANSACTION 11 2785577508, not started, process no 8320, OS thread id 1194268992 MySQL thread id 213356, query id 792901513 10.0.0.6 spaces ---TRANSACTION 11 2785644995, not started, process no 8320, OS thread id 1205508416 MySQL thread id 213483, query id 792900431 10.0.0.3 spaces ---TRANSACTION 11 2785646564, not started, process no 8320, OS thread id 1184434496 MySQL thread id 213481, query id 792902700 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='724607' AND forum_id='44945' ---TRANSACTION 11 2785591551, not started, process no 8320, OS thread id 1187645760 MySQL thread id 213415, query id 792902907 10.0.0.6 spaces ---TRANSACTION 11 2785604715, not started, process no 8320, OS thread id 1163159872 MySQL thread id 212762, query id 792903988 10.0.0.7 spaces ---TRANSACTION 11 2785643078, not started, process no 8320, OS thread id 1236216128 MySQL thread id 213474, query id 792903611 10.0.0.3 spaces ---TRANSACTION 11 2785646967, not started, process no 8320, OS thread id 1216145728 MySQL thread id 213468, query id 792903262 10.0.0.3 spaces ---TRANSACTION 11 2785579290, not started, process no 8320, OS thread id 1195874624 MySQL thread id 213457, query id 792799527 10.0.0.6 spaces ---TRANSACTION 11 2785645333, not started, process no 8320, OS thread id 1257691456 MySQL thread id 213454, query id 792903773 10.0.0.3 spaces ---TRANSACTION 11 2785079974, not started, process no 8320, OS thread id 1190656320 MySQL thread id 213242, query id 792900160 10.0.0.7 spaces ---TRANSACTION 11 2785540431, not started, process no 8320, OS thread id 1235413312 MySQL thread id 213395, query id 792841440 10.0.0.6 spaces ---TRANSACTION 11 2785317101, not started, process no 8320, OS thread id 1143089472 MySQL thread id 212985, query id 792903491 10.0.0.8 spaces ---TRANSACTION 11 2785646270, not started, process no 8320, OS thread id 1183029568 MySQL thread id 213453, query id 792902407 10.0.0.3 spaces ---TRANSACTION 11 2785646751, not started, process no 8320, OS thread id 1274952000 MySQL thread id 213449, query id 792902955 10.0.0.7 spaces freeing items SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '0' AND user_id='414388' ---TRANSACTION 11 2785586838, not started, process no 8320, OS thread id 1150515520 MySQL thread id 213392, query id 792884179 10.0.0.6 spaces ---TRANSACTION 11 2785562080, not started, process no 8320, OS thread id 1162557760 MySQL thread id 213412, query id 792838223 10.0.0.6 spaces ---TRANSACTION 11 2785640877, not started, process no 8320, OS thread id 1246452032 MySQL thread id 213379, query id 792900595 10.0.0.6 spaces ---TRANSACTION 11 2785473954, not started, process no 8320, OS thread id 1176406336 MySQL thread id 213286, query id 792902101 10.0.0.7 spaces ---TRANSACTION 11 2785551320, not started, process no 8320, OS thread id 1157740864 MySQL thread id 213383, query id 792886097 10.0.0.6 spaces ---TRANSACTION 11 2785226242, not started, process no 8320, OS thread id 1192061248 MySQL thread id 213287, query id 792896153 10.0.0.7 spaces ---TRANSACTION 11 2785619001, not started, process no 8320, OS thread id 1236818240 MySQL thread id 213263, query id 792902944 10.0.0.7 spaces ---TRANSACTION 11 2785433208, not started, process no 8320, OS thread id 1283782976 MySQL thread id 213400, query id 792855957 10.0.0.6 spaces ---TRANSACTION 11 2785599056, not started, process no 8320, OS thread id 1287194944 MySQL thread id 213428, query id 792830512 10.0.0.6 spaces ---TRANSACTION 11 2785647064, not started, process no 8320, OS thread id 1273747776 MySQL thread id 213425, query id 792903457 10.0.0.3 spaces ---TRANSACTION 11 2785569381, not started, process no 8320, OS thread id 1217149248 MySQL thread id 213423, query id 792784289 10.0.0.6 spaces ---TRANSACTION 11 2785598505, not started, process no 8320, OS thread id 1248860480 MySQL thread id 213406, query id 792872240 10.0.0.6 spaces ---TRANSACTION 11 2785413644, not started, process no 8320, OS thread id 1244645696 MySQL thread id 212802, query id 792904144 10.0.0.7 spaces ---TRANSACTION 11 2785646947, not started, process no 8320, OS thread id 1273145664 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213413, query id 792903545 10.0.0.6 spaces update INSERT INTO spaces_guests SET sid='4730419260743727', mtime=NOW(), ip_address='85.26.178.205', user_agent='SonyEricssonW810i/R4EA Browser/NetFront/3.3 Profile/MIDP-2.0 Configuration/CLDC-1.1', mobile_device='SonyEricsson W810i', reklama_cursor='2', flags='0' ---TRANSACTION 11 2785646233, not started, process no 8320, OS thread id 1177008448 MySQL thread id 213411, query id 792902088 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='226339' AND forum_id='43961' ---TRANSACTION 11 2785645767, not started, process no 8320, OS thread id 1155332416 MySQL thread id 213403, query id 792901406 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='630619' AND forum_id='56188' ---TRANSACTION 11 2785312307, not started, process no 8320, OS thread id 1278363968 MySQL thread id 213410, query id 792410310 10.0.0.6 spaces ---TRANSACTION 11 2785621283, not started, process no 8320, OS thread id 1278765376 MySQL thread id 213375, query id 792893031 10.0.0.6 spaces ---TRANSACTION 11 2785645151, not started, process no 8320, OS thread id 1274349888 MySQL thread id 213391, query id 792900683 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='565135' AND forum_id='24029' ---TRANSACTION 11 2785646702, not started, process no 8320, OS thread id 1196677440 MySQL thread id 213393, query id 792902890 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='486655' AND forum_id='13103' ---TRANSACTION 11 2785603056, not started, process no 8320, OS thread id 1180821824 MySQL thread id 213382, query id 792890051 10.0.0.6 spaces ---TRANSACTION 11 2785646162, not started, process no 8320, OS thread id 1148508480 MySQL thread id 213378, query id 792902167 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='772974' AND forum_id='380' ---TRANSACTION 11 2785644496, not started, process no 8320, OS thread id 1202096448 MySQL thread id 213380, query id 792899482 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='901294' AND forum_id='44771' ---TRANSACTION 11 2785646324, not started, process no 8320, OS thread id 1148709184 MySQL thread id 213376, query id 792902269 10.0.0.6 spaces freeing items SELECT * FROM spaces_users WHERE nid='612562' ---TRANSACTION 11 2785646819, not started, process no 8320, OS thread id 1167776064 MySQL thread id 213370, query id 792903074 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='162733' AND forum_id='578' ---TRANSACTION 11 2785635687, not started, process no 8320, OS thread id 1165769024 MySQL thread id 213350, query id 792899136 10.0.0.6 spaces ---TRANSACTION 11 2785159821, not started, process no 8320, OS thread id 1265920320 MySQL thread id 213235, query id 792903645 10.0.0.8 spaces ---TRANSACTION 11 2785646354, not started, process no 8320, OS thread id 1180420416 MySQL thread id 213351, query id 792902287 10.0.0.8 spaces freeing items SELECT new_count FROM spaces_music WHERE user_id='822109' AND new_count != 0 ---TRANSACTION 11 2785646578, not started, process no 8320, OS thread id 1202497856 MySQL thread id 213349, query id 792902665 10.0.0.6 spaces freeing items SELECT page,comments_cnt,last_comment_id FROM spaces_diary_tracking WHERE user_id='821980' AND topic_id='1235455944' ---TRANSACTION 11 2785312975, not started, process no 8320, OS thread id 1186842944 MySQL thread id 212978, query id 792903739 10.0.0.8 spaces ---TRANSACTION 11 2785488419, not started, process no 8320, OS thread id 1286793536 MySQL thread id 213283, query id 792902014 10.0.0.7 spaces ---TRANSACTION 11 2784938746, not started, process no 8320, OS thread id 1257290048 MySQL thread id 213281, query id 792899881 10.0.0.7 spaces ---TRANSACTION 11 2785132406, not started, process no 8320, OS thread id 1155934528 MySQL thread id 212986, query id 792903740 10.0.0.8 spaces ---TRANSACTION 11 2785647049, not started, process no 8320, OS thread id 1193265472 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213335, query id 792903437 10.0.0.7 spaces update INSERT INTO spaces_files_tracking SET user_id='914637', object_id='1196701', page=1, comments_cnt='86', last_comment_id='1065309' ---TRANSACTION 11 2785646745, not started, process no 8320, OS thread id 1225578816 MySQL thread id 213333, query id 792902954 10.0.0.7 spaces freeing items SELECT dir_id FROM spaces_music_directories WHERE parent_dir='32268' ---TRANSACTION 11 2784930749, not started, process no 8320, OS thread id 1264916800 MySQL thread id 212323, query id 792881901 10.0.0.8 spaces ---TRANSACTION 11 2785366775, not started, process no 8320, OS thread id 1191860544 MySQL thread id 213271, query id 792903892 10.0.0.8 spaces ---TRANSACTION 11 2785492785, not started, process no 8320, OS thread id 1212934464 MySQL thread id 212318, query id 792871719 10.0.0.8 spaces ---TRANSACTION 11 2785645087, not started, process no 8320, OS thread id 1204705600 MySQL thread id 213324, query id 792900565 10.0.0.3 spaces ---TRANSACTION 11 2785645157, not started, process no 8320, OS thread id 1171188032 MySQL thread id 213321, query id 792900612 10.0.0.3 spaces freeing items SELECT nid FROM spaces_blacklist WHERE user_id = '830956' AND enemy_id = '867122' ---TRANSACTION 11 2785644205, not started, process no 8320, OS thread id 1146702144 MySQL thread id 213315, query id 792899065 10.0.0.3 spaces ---TRANSACTION 11 2785644250, not started, process no 8320, OS thread id 1170987328 MySQL thread id 213316, query id 792903596 10.0.0.3 spaces ---TRANSACTION 11 2785645204, not started, process no 8320, OS thread id 1233606976 MySQL thread id 213312, query id 792903712 10.0.0.3 spaces ---TRANSACTION 11 2785646355, not started, process no 8320, OS thread id 1164966208 MySQL thread id 213301, query id 792902324 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='407248' AND forum_id='55423' ---TRANSACTION 11 2785646910, not started, process no 8320, OS thread id 1177610560 MySQL thread id 213311, query id 792903210 10.0.0.3 spaces ---TRANSACTION 11 2785590992, not started, process no 8320, OS thread id 1162357056 MySQL thread id 213306, query id 792818015 10.0.0.3 spaces ---TRANSACTION 11 2785645022, not started, process no 8320, OS thread id 1194670400 MySQL thread id 213305, query id 792900230 10.0.0.3 spaces ---TRANSACTION 11 2785645150, not started, process no 8320, OS thread id 1187445056 MySQL thread id 213300, query id 792900535 10.0.0.3 spaces freeing items SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '62416' AND shzone = 1 ---TRANSACTION 11 2785646596, not started, process no 8320, OS thread id 1249462592 MySQL thread id 213294, query id 792902739 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='774999' AND forum_id='261' ---TRANSACTION 11 2785643051, not started, process no 8320, OS thread id 1241233728 MySQL thread id 213296, query id 792897557 10.0.0.3 spaces ---TRANSACTION 11 2785638514, not started, process no 8320, OS thread id 1226783040 MySQL thread id 213228, query id 792898096 10.0.0.6 spaces ---TRANSACTION 11 2785646274, not started, process no 8320, OS thread id 1243642176 MySQL thread id 213282, query id 792902229 10.0.0.7 spaces freeing items SELECT * FROM spaces_myfiles WHERE file_id = '1231210' ---TRANSACTION 11 2785645144, not started, process no 8320, OS thread id 1160149312 MySQL thread id 213280, query id 792900519 10.0.0.7 spaces freeing items SELECT * FROM spaces_file_directories WHERE user_id='440353' AND parent_dir='0' ORDER BY level ---TRANSACTION 11 2785611638, not started, process no 8320, OS thread id 1165568320 MySQL thread id 213163, query id 792900409 10.0.0.7 spaces ---TRANSACTION 11 2785587031, not started, process no 8320, OS thread id 1230596416 MySQL thread id 213267, query id 792812020 10.0.0.6 spaces ---TRANSACTION 11 2785579730, not started, process no 8320, OS thread id 1204103488 MySQL thread id 213252, query id 792879529 10.0.0.6 spaces ---TRANSACTION 11 2785489363, not started, process no 8320, OS thread id 1244444992 MySQL thread id 213240, query id 792903124 10.0.0.7 spaces ---TRANSACTION 11 2785646824, not started, process no 8320, OS thread id 1201895744 MySQL thread id 213250, query id 792903058 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='432481' AND forum_id='72422' ---TRANSACTION 11 2785644720, not started, process no 8320, OS thread id 1249864000 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213248, query id 792903519 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='25' WHERE user_id='870430' ---TRANSACTION 11 2785646828, not started, process no 8320, OS thread id 1181423936 MySQL thread id 213241, query id 792903069 10.0.0.7 spaces freeing items SELECT * FROM spaces_myfiles_comments WHERE file_id = '285916' ORDER BY ctime LIMIT 0,5 ---TRANSACTION 11 2785577651, not started, process no 8320, OS thread id 1147504960 MySQL thread id 213236, query id 792796813 10.0.0.6 spaces ---TRANSACTION 11 2785619667, not started, process no 8320, OS thread id 1144494400 MySQL thread id 213217, query id 792862008 10.0.0.6 spaces ---TRANSACTION 11 2785586505, not started, process no 8320, OS thread id 1201092928 MySQL thread id 213064, query id 792902798 10.0.0.6 spaces ---TRANSACTION 11 2785280890, not started, process no 8320, OS thread id 1269332288 MySQL thread id 212981, query id 792903535 10.0.0.8 spaces ---TRANSACTION 11 2785506947, not started, process no 8320, OS thread id 1205709120 MySQL thread id 213095, query id 792898374 10.0.0.6 spaces ---TRANSACTION 11 2785506207, not started, process no 8320, OS thread id 1163962688 MySQL thread id 213203, query id 792697162 10.0.0.6 spaces ---TRANSACTION 11 2785349565, not started, process no 8320, OS thread id 1229994304 MySQL thread id 212958, query id 792903524 10.0.0.8 spaces ---TRANSACTION 11 2785420433, not started, process no 8320, OS thread id 1253275968 MySQL thread id 213056, query id 792900555 10.0.0.7 spaces ---TRANSACTION 11 2785645255, not started, process no 8320, OS thread id 1173195072 MySQL thread id 213177, query id 792903756 10.0.0.3 spaces ---TRANSACTION 11 2785609429, not started, process no 8320, OS thread id 1239628096 MySQL thread id 213174, query id 792845954 10.0.0.3 spaces ---TRANSACTION 11 2785638749, not started, process no 8320, OS thread id 1169381696 MySQL thread id 213170, query id 792890845 10.0.0.6 spaces ---TRANSACTION 11 2785644779, not started, process no 8320, OS thread id 1235011904 MySQL thread id 213167, query id 792903610 10.0.0.3 spaces ---TRANSACTION 11 2785644820, not started, process no 8320, OS thread id 1203501376 MySQL thread id 213164, query id 792903670 10.0.0.3 spaces ---TRANSACTION 11 2785640083, not started, process no 8320, OS thread id 1251268928 MySQL thread id 213161, query id 792892649 10.0.0.3 spaces ---TRANSACTION 11 2785646161, not started, process no 8320, OS thread id 1196476736 MySQL thread id 213159, query id 792902087 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='245008' AND forum_id='24851' ---TRANSACTION 11 2785645788, not started, process no 8320, OS thread id 1241033024 MySQL thread id 213105, query id 792903295 10.0.0.6 spaces ---TRANSACTION 11 2785569844, not started, process no 8320, OS thread id 1171790144 MySQL thread id 213150, query id 792784925 10.0.0.6 spaces ---TRANSACTION 11 2785170247, not started, process no 8320, OS thread id 1280973120 MySQL thread id 213148, query id 792196053 10.0.0.6 spaces ---TRANSACTION 11 2785329207, not started, process no 8320, OS thread id 1178413376 MySQL thread id 212947, query id 792903578 10.0.0.6 spaces ---TRANSACTION 11 2785646363, not started, process no 8320, OS thread id 1259899200 MySQL thread id 213094, query id 792902334 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '868125' AND shzone = 1 ---TRANSACTION 11 2785525351, not started, process no 8320, OS thread id 1262106944 MySQL thread id 212954, query id 792903661 10.0.0.8 spaces ---TRANSACTION 11 2785552852, not started, process no 8320, OS thread id 1282980160 MySQL thread id 212942, query id 792892736 10.0.0.6 spaces ---TRANSACTION 11 2785405328, not started, process no 8320, OS thread id 1250666816 MySQL thread id 213067, query id 792550065 10.0.0.6 spaces ---TRANSACTION 11 2785611478, not started, process no 8320, OS thread id 1218152768 MySQL thread id 212730, query id 792903486 10.0.0.7 spaces ---TRANSACTION 11 2785644964, not started, process no 8320, OS thread id 1192663360 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 213065, query id 792903574 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='24' WHERE user_id='556877' ---TRANSACTION 11 2785109696, not started, process no 8320, OS thread id 1265518912 MySQL thread id 213062, query id 792102155 10.0.0.6 spaces ---TRANSACTION 11 2785645242, not started, process no 8320, OS thread id 1178212672 MySQL thread id 213055, query id 792900684 10.0.0.7 spaces freeing items SELECT * FROM spaces_users_anketa WHERE user_id='906621' ---TRANSACTION 11 2785128504, not started, process no 8320, OS thread id 1184033088 MySQL thread id 212296, query id 792903769 10.0.0.8 spaces ---TRANSACTION 11 2784950186, not started, process no 8320, OS thread id 1208117568 MySQL thread id 212927, query id 792898592 10.0.0.8 spaces ---TRANSACTION 11 2785012904, not started, process no 8320, OS thread id 1161554240 MySQL thread id 213040, query id 791956666 10.0.0.6 spaces ---TRANSACTION 11 2784778890, not started, process no 8320, OS thread id 1279568192 MySQL thread id 212219, query id 792902477 10.0.0.8 spaces ---TRANSACTION 11 2785619216, not started, process no 8320, OS thread id 1210927424 MySQL thread id 212922, query id 792903170 10.0.0.6 spaces ---TRANSACTION 11 2785582024, not started, process no 8320, OS thread id 1288599872 MySQL thread id 212960, query id 792859303 10.0.0.6 spaces ---TRANSACTION 11 2785588123, not started, process no 8320, OS thread id 1284987200 MySQL thread id 212964, query id 792895251 10.0.0.6 spaces ---TRANSACTION 11 2785642240, not started, process no 8320, OS thread id 1141283136 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 212833, query id 792903629 10.0.0.3 spaces Updating UPDATE spaces_users_events SET mail_new = 0 WHERE user_id='855623' ---TRANSACTION 11 2785457007, not started, process no 8320, OS thread id 1175603520 MySQL thread id 212993, query id 792624401 10.0.0.6 spaces ---TRANSACTION 11 2785607948, not started, process no 8320, OS thread id 1273948480 MySQL thread id 212939, query id 792882848 10.0.0.6 spaces ---TRANSACTION 11 2785523568, not started, process no 8320, OS thread id 1282779456 MySQL thread id 212941, query id 792901650 10.0.0.6 spaces ---TRANSACTION 11 2785644903, not started, process no 8320, OS thread id 1145297216 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 212956, query id 792903536 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='22' WHERE user_id='910666' ---TRANSACTION 11 2785645223, not started, process no 8320, OS thread id 1147705664 MySQL thread id 212959, query id 792900801 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='15985' AND forum_id='2017' ---TRANSACTION 11 2785646359, not started, process no 8320, OS thread id 1151318336 MySQL thread id 212940, query id 792902378 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='697638' AND forum_id='47764' ---TRANSACTION 11 2785645065, not started, process no 8320, OS thread id 1186642240 MySQL thread id 212937, query id 792900481 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='186820' AND forum_id='1059' ---TRANSACTION 11 2785474856, not started, process no 8320, OS thread id 1230195008 MySQL thread id 212787, query id 792902054 10.0.0.6 spaces ---TRANSACTION 11 2784553374, not started, process no 8320, OS thread id 1177409856 MySQL thread id 212208, query id 792894220 10.0.0.7 spaces ---TRANSACTION 11 2785646577, not started, process no 8320, OS thread id 1192261952 MySQL thread id 212925, query id 792902706 10.0.0.8 spaces freeing items SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '244236' AND shzone = 1 ---TRANSACTION 11 2785644189, not started, process no 8320, OS thread id 1195473216 MySQL thread id 212875, query id 792903657 10.0.0.3 spaces ---TRANSACTION 11 2785644785, not started, process no 8320, OS thread id 1219156288 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 212873, query id 792903664 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='40' WHERE user_id='125481' ---TRANSACTION 11 2785643143, not started, process no 8320, OS thread id 1282578752 MySQL thread id 212868, query id 792897572 10.0.0.3 spaces ---TRANSACTION 11 2785646600, not started, process no 8320, OS thread id 1206913344 MySQL thread id 212866, query id 792902709 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='699624' AND forum_id='47113' ---TRANSACTION 11 2785645205, not started, process no 8320, OS thread id 1199286592 MySQL thread id 212843, query id 792900750 10.0.0.3 spaces ---TRANSACTION 11 2785644786, not started, process no 8320, OS thread id 1241635136 MySQL thread id 212837, query id 792903624 10.0.0.3 spaces ---TRANSACTION 11 2785646718, not started, process no 8320, OS thread id 1261705536 MySQL thread id 212825, query id 792903936 10.0.0.3 spaces ---TRANSACTION 11 2785635531, not started, process no 8320, OS thread id 1173797184 MySQL thread id 212778, query id 792885436 10.0.0.6 spaces ---TRANSACTION 11 2784965176, not started, process no 8320, OS thread id 1209923904 MySQL thread id 212795, query id 791887421 10.0.0.6 spaces ---TRANSACTION 11 2785584280, not started, process no 8320, OS thread id 1242638656 MySQL thread id 212390, query id 792903594 10.0.0.8 spaces ---TRANSACTION 11 2785618914, not started, process no 8320, OS thread id 1243441472 MySQL thread id 212760, query id 792903498 10.0.0.8 spaces ---TRANSACTION 11 2785361392, not started, process no 8320, OS thread id 1151519040 MySQL thread id 212370, query id 792885019 10.0.0.8 spaces ---TRANSACTION 11 2785314592, not started, process no 8320, OS thread id 1214740800 MySQL thread id 212647, query id 792900554 10.0.0.7 spaces ---TRANSACTION 11 2785644632, not started, process no 8320, OS thread id 1229592896 MySQL thread id 212686, query id 792899686 10.0.0.3 spaces ---TRANSACTION 11 2785645057, not started, process no 8320, OS thread id 1225779520 MySQL thread id 212684, query id 792900373 10.0.0.3 spaces freeing items SELECT new_count FROM spaces_music WHERE user_id='566925' AND new_count != 0 ---TRANSACTION 11 2785041226, not started, process no 8320, OS thread id 1190054208 MySQL thread id 212299, query id 792903746 10.0.0.8 spaces ---TRANSACTION 11 2785637492, not started, process no 8320, OS thread id 1239828800 MySQL thread id 212645, query id 792888855 10.0.0.6 spaces ---TRANSACTION 11 2785034901, not started, process no 8320, OS thread id 1276758336 MySQL thread id 212314, query id 792899642 10.0.0.8 spaces ---TRANSACTION 11 2784141138, not started, process no 8320, OS thread id 1222367552 MySQL thread id 209572, query id 792900534 10.0.0.3 spaces ---TRANSACTION 11 2784024807, not started, process no 8320, OS thread id 1169180992 MySQL thread id 209452, query id 792902397 10.0.0.3 spaces ---TRANSACTION 11 2785128799, not started, process no 8320, OS thread id 1162959168 MySQL thread id 212357, query id 792903550 10.0.0.8 spaces ---TRANSACTION 11 2785085436, not started, process no 8320, OS thread id 1283180864 MySQL thread id 212410, query id 792064809 10.0.0.6 spaces ---TRANSACTION 11 2785318872, not started, process no 8320, OS thread id 1258895680 MySQL thread id 210592, query id 792881543 10.0.0.3 spaces ---TRANSACTION 11 2785556570, not started, process no 8320, OS thread id 1217751360 MySQL thread id 212310, query id 792822919 10.0.0.6 spaces ---TRANSACTION 11 2785646557, not started, process no 8320, OS thread id 1215342912 MySQL thread id 212369, query id 792902669 10.0.0.8 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='89266' AND forum_id='63656' ---TRANSACTION 11 2785644862, not started, process no 8320, OS thread id 1256487232 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 212354, query id 792903551 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='25' WHERE user_id='914540' ---TRANSACTION 11 2785645110, not started, process no 8320, OS thread id 1143691584 MySQL thread id 212320, query id 792900277 10.0.0.8 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='390805' AND forum_id='41980' ---TRANSACTION 11 2785646299, not started, process no 8320, OS thread id 1164564800 MySQL thread id 212316, query id 792902344 10.0.0.8 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='71268' AND forum_id='7124' ---TRANSACTION 11 2785644611, not started, process no 8320, OS thread id 1145899328 MySQL thread id 212313, query id 792899671 10.0.0.8 spaces freeing items SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '1691' ORDER BY rate DESC LIMIT 50,5 ---TRANSACTION 11 2785646338, not started, process no 8320, OS thread id 1187244352 MySQL thread id 212308, query id 792902349 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='123152' AND forum_id='17505' ---TRANSACTION 11 2785645816, not started, process no 8320, OS thread id 1202698560 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 212298, query id 792903749 10.0.0.8 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='24' WHERE user_id='893266' ---TRANSACTION 11 2785645947, not started, process no 8320, OS thread id 1253075264 MySQL thread id 212206, query id 792901750 10.0.0.7 spaces freeing items SELECT COUNT(DISTINCT user_id) FROM spaces_favorites WHERE type_id='1' AND object_id='349494' AND closed != 1 ---TRANSACTION 11 2785032705, not started, process no 8320, OS thread id 1157941568 MySQL thread id 211942, query id 792897355 10.0.0.7 spaces ---TRANSACTION 11 2784905074, not started, process no 8320, OS thread id 1281775936 MySQL thread id 212147, query id 791798873 10.0.0.6 spaces ---TRANSACTION 11 2785445321, not started, process no 8320, OS thread id 1239427392 MySQL thread id 212052, query id 792901672 10.0.0.6 spaces ---TRANSACTION 11 2785646309, not started, process no 8320, OS thread id 1275152704 MySQL thread id 212051, query id 792902366 10.0.0.6 spaces freeing items SELECT COUNT(*) from spaces_pictures WHERE user_id = '730017' AND album_id='0' ---TRANSACTION 11 2784678987, not started, process no 8320, OS thread id 1176607040 MySQL thread id 211927, query id 792901506 10.0.0.7 spaces ---TRANSACTION 11 2785629965, not started, process no 8320, OS thread id 1172994368 MySQL thread id 212010, query id 792897096 10.0.0.6 spaces ---TRANSACTION 11 2785290290, not started, process no 8320, OS thread id 1205909824 MySQL thread id 211680, query id 792903298 10.0.0.8 spaces ---TRANSACTION 11 2785646839, not started, process no 8320, OS thread id 1145497920 MySQL thread id 212009, query id 792903106 10.0.0.6 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='403995' AND forum_id='7135' ---TRANSACTION 11 2785130086, not started, process no 8320, OS thread id 1206511936 MySQL thread id 211935, query id 792898154 10.0.0.8 spaces ---TRANSACTION 11 2785641470, not started, process no 8320, OS thread id 1231800640 MySQL thread id 211542, query id 792903764 10.0.0.8 spaces ---TRANSACTION 11 2785612996, not started, process no 8320, OS thread id 1208518976 MySQL thread id 211671, query id 792903590 10.0.0.8 spaces ---TRANSACTION 11 2785263959, not started, process no 8320, OS thread id 1203300672 MySQL thread id 211892, query id 792903415 10.0.0.7 spaces ---TRANSACTION 11 2785645913, not started, process no 8320, OS thread id 1222166848 MySQL thread id 211941, query id 792901704 10.0.0.7 spaces freeing items SELECT COUNT(*) FROM spaces_music_comments WHERE file_id = '557116' ---TRANSACTION 11 2785646818, not started, process no 8320, OS thread id 1208318272 MySQL thread id 211934, query id 792903073 10.0.0.8 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='89266' AND forum_id='12932' ---TRANSACTION 11 2785180220, not started, process no 8320, OS thread id 1213135168 MySQL thread id 211837, query id 792903492 10.0.0.7 spaces ---TRANSACTION 11 2785646275, not started, process no 8320, OS thread id 1183230272 MySQL thread id 211926, query id 792902083 10.0.0.7 spaces freeing items SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '673749' AND shzone = 1 ---TRANSACTION 11 2785469228, not started, process no 8320, OS thread id 1156335936 MySQL thread id 211882, query id 792641528 10.0.0.6 spaces ---TRANSACTION 11 2785320095, not started, process no 8320, OS thread id 1261504832 MySQL thread id 211879, query id 792423720 10.0.0.6 spaces ---TRANSACTION 11 2785196554, not started, process no 8320, OS thread id 1172592960 MySQL thread id 211627, query id 792899821 10.0.0.7 spaces ---TRANSACTION 11 2785210324, not started, process no 8320, OS thread id 1241434432 MySQL thread id 211798, query id 792256088 10.0.0.6 spaces ---TRANSACTION 11 2785619768, not started, process no 8320, OS thread id 1199487296 MySQL thread id 211682, query id 792900669 10.0.0.6 spaces ---TRANSACTION 11 2785402286, not started, process no 8320, OS thread id 1207716160 MySQL thread id 211479, query id 792898540 10.0.0.8 spaces ---TRANSACTION 11 2785628281, not started, process no 8320, OS thread id 1162758464 MySQL thread id 211660, query id 792898160 10.0.0.6 spaces ---TRANSACTION 11 2785619917, not started, process no 8320, OS thread id 1166772544 MySQL thread id 211668, query id 792864918 10.0.0.6 spaces ---TRANSACTION 11 2785646335, not started, process no 8320, OS thread id 1275754816 MySQL thread id 211659, query id 792902398 10.0.0.6 spaces freeing items SELECT COUNT(*) FROM spaces_pictures WHERE user_id = '443092' AND album_id = '90844' ---TRANSACTION 11 2785552134, not started, process no 8320, OS thread id 1226381632 MySQL thread id 211546, query id 792899419 10.0.0.6 spaces ---TRANSACTION 11 2785360719, not started, process no 8320, OS thread id 1251068224 MySQL thread id 210927, query id 792903805 10.0.0.8 spaces ---TRANSACTION 11 2785570242, not started, process no 8320, OS thread id 1285589312 MySQL thread id 211548, query id 792895738 10.0.0.6 spaces ---TRANSACTION 11 2785645154, not started, process no 8320, OS thread id 1266923840 MySQL thread id 211543, query id 792900687 10.0.0.6 spaces freeing items SELECT * FROM spaces_users_anketa WHERE user_id='586023' ---TRANSACTION 11 2785646807, not started, process no 8320, OS thread id 1170385216 MySQL thread id 211476, query id 792903057 10.0.0.8 spaces freeing items SELECT new_count FROM spaces_diary_topics WHERE user_id='786266' AND new_count != 0 ---TRANSACTION 11 2784977672, not started, process no 8320, OS thread id 1221564736 MySQL thread id 210887, query id 792897479 10.0.0.7 spaces ---TRANSACTION 11 2784861491, not started, process no 8320, OS thread id 1279768896 MySQL thread id 210702, query id 792903705 10.0.0.8 spaces ---TRANSACTION 11 2784880400, not started, process no 8320, OS thread id 1247656256 MySQL thread id 210385, query id 792901947 10.0.0.8 spaces ---TRANSACTION 11 2785645091, not started, process no 8320, OS thread id 1254680896 MySQL thread id 210931, query id 792900615 10.0.0.8 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='416647' AND forum_id='2053' ---TRANSACTION 11 2785645115, not started, process no 8320, OS thread id 1194871104 MySQL thread id 210886, query id 792900547 10.0.0.7 spaces freeing items SELECT COUNT(DISTINCT user_id) FROM spaces_favorites WHERE type_id='1' AND object_id='196496' AND closed != 1 ---TRANSACTION 11 2782227052, not started, process no 8320, OS thread id 1156938048 MySQL thread id 210440, query id 792903687 10.0.0.3 spaces ---TRANSACTION 11 2785569159, not started, process no 8320, OS thread id 1186441536 MySQL thread id 210817, query id 792783924 10.0.0.3 spaces ---TRANSACTION 11 2785642847, not started, process no 8320, OS thread id 1144092992 MySQL thread id 210607, query id 792896708 10.0.0.3 spaces ---TRANSACTION 11 2785642636, not started, process no 8320, OS thread id 1167374656 MySQL thread id 210593, query id 792896793 10.0.0.3 spaces ---TRANSACTION 11 2781739706, not started, process no 8320, OS thread id 1223170368 MySQL thread id 210447, query id 787148856 10.0.0.7 spaces ---TRANSACTION 11 2785643666, not started, process no 8320, OS thread id 1227987264 MySQL thread id 210439, query id 792903683 10.0.0.3 spaces ---TRANSACTION 11 2785433949, not started, process no 8320, OS thread id 1246251328 MySQL thread id 210239, query id 792897458 10.0.0.7 spaces ---TRANSACTION 11 2785643620, not started, process no 8320, OS thread id 1193666880 MySQL thread id 210238, query id 792898076 10.0.0.7 spaces freeing items SELECT * FROM spaces_file_directories WHERE dir_id='886' ---TRANSACTION 11 2785646306, not started, process no 8320, OS thread id 1166973248 MySQL thread id 210190, query id 792902360 10.0.0.3 spaces freeing items SELECT COUNT(*) FROM spaces_mail_contact_list_0 WHERE user_id='5137' AND contact_type=0 ---TRANSACTION 11 2785637948, not started, process no 8320, OS thread id 1250265408 MySQL thread id 210175, query id 792889428 10.0.0.3 spaces ---TRANSACTION 11 2785646747, not started, process no 8320, OS thread id 1221163328 MySQL thread id 210173, query id 792902969 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='325572' AND forum_id='15392' ---TRANSACTION 11 2785559919, not started, process no 8320, OS thread id 1218754880 MySQL thread id 209958, query id 792895020 10.0.0.8 spaces ---TRANSACTION 11 2785646774, not started, process no 8320, OS thread id 1153325376 MySQL thread id 209956, query id 792902994 10.0.0.8 spaces freeing items SELECT COUNT(*) FROM spaces_guestbook WHERE user_id = '751657' ---TRANSACTION 11 2785645199, not started, process no 8320, OS thread id 1151117632 MySQL thread id 209924, query id 792903698 10.0.0.3 spaces ---TRANSACTION 11 2785634440, not started, process no 8320, OS thread id 1265318208 MySQL thread id 209912, query id 792884231 10.0.0.3 spaces ---TRANSACTION 11 2785646353, not started, process no 8320, OS thread id 1234409792 MySQL thread id 209908, query id 792902376 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='625517' AND forum_id='70420' ---TRANSACTION 11 2785646512, not started, process no 8320, OS thread id 1286191424 MySQL thread id 209855, query id 792902622 10.0.0.3 spaces ---TRANSACTION 11 2785646576, not started, process no 8320, OS thread id 1231599936 MySQL thread id 209857, query id 792902648 10.0.0.3 spaces freeing items SELECT * FROM spaces_mail_contact_list_6 WHERE nid='453909' AND user_id='637326' ---TRANSACTION 11 2785643954, not started, process no 8320, OS thread id 1165367616 MySQL thread id 209822, query id 792903225 10.0.0.3 spaces ---TRANSACTION 11 2785600906, not started, process no 8320, OS thread id 1244043584 MySQL thread id 209830, query id 792833174 10.0.0.3 spaces ---TRANSACTION 11 2785646841, not started, process no 8320, OS thread id 1193867584 MySQL thread id 209828, query id 792903109 10.0.0.3 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='475681' AND forum_id='53340' ---TRANSACTION 11 2785646963, not started, process no 8320, OS thread id 1268529472 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 209824, query id 792903440 10.0.0.3 spaces Updating UPDATE spaces_mail_contact_list_6 SET new=0,new_cnt=0 WHERE nid='76046' ---TRANSACTION 11 2785645495, not started, process no 8320, OS thread id 1166571840 MySQL thread id 209806, query id 792903780 10.0.0.3 spaces ---TRANSACTION 11 2784723696, not started, process no 8320, OS thread id 1268328768 MySQL thread id 209690, query id 792903473 10.0.0.7 spaces ---TRANSACTION 11 2785644108, not started, process no 8320, OS thread id 1276356928 MySQL thread id 209587, query id 792903559 10.0.0.3 spaces ---TRANSACTION 11 2785642604, not started, process no 8320, OS thread id 1271540032 MySQL thread id 209570, query id 792900521 10.0.0.3 spaces ---TRANSACTION 11 2785644774, not started, process no 8320, OS thread id 1216747840 MySQL thread id 209535, query id 792899974 10.0.0.3 spaces ---TRANSACTION 11 2785645008, not started, process no 8320, OS thread id 1255483712 MySQL thread id 209531, query id 792900458 10.0.0.3 spaces freeing items SELECT * FROM spaces_forums WHERE category_id = '268' ---TRANSACTION 11 2785593006, not started, process no 8320, OS thread id 1219758400 MySQL thread id 209530, query id 792821200 10.0.0.3 spaces ---TRANSACTION 11 2784164649, not started, process no 8320, OS thread id 1270937920 MySQL thread id 209338, query id 792859524 10.0.0.8 spaces ---TRANSACTION 11 2785646583, not started, process no 8320, OS thread id 1168177472 MySQL thread id 209423, query id 792902683 10.0.0.3 spaces freeing items SELECT new_count FROM spaces_music WHERE user_id='754745' AND new_count != 0 ---TRANSACTION 11 2785643634, not started, process no 8320, OS thread id 1224976704 MySQL thread id 209449, query id 792902377 10.0.0.3 spaces ---TRANSACTION 11 2785644237, not started, process no 8320, OS thread id 1283582272 MySQL thread id 209441, query id 792899167 10.0.0.3 spaces ---TRANSACTION 11 2785646973, not started, process no 8320, OS thread id 1264314688 MySQL thread id 209280, query id 792903322 10.0.0.3 spaces ---TRANSACTION 11 2785641157, not started, process no 8320, OS thread id 1263110464 MySQL thread id 209277, query id 792894451 10.0.0.3 spaces ---TRANSACTION 11 2785639513, not started, process no 8320, OS thread id 1152121152 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 209274, query id 792903726 10.0.0.3 spaces Updating UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='40' WHERE user_id='848051' ---TRANSACTION 11 2785644561, not started, process no 8320, OS thread id 1197279552 MySQL thread id 209276, query id 792903724 10.0.0.3 spaces ---TRANSACTION 11 2785645640, not started, process no 8320, OS thread id 1250867520 MySQL thread id 209184, query id 792901097 10.0.0.3 spaces ---TRANSACTION 11 2785645926, not started, process no 8320, OS thread id 1210124608 MySQL thread id 209182, query id 792901681 10.0.0.3 spaces freeing items SELECT new_count FROM spaces_pictures WHERE user_id='431027' AND new_count != 0 ---TRANSACTION 11 2785024557, not started, process no 8320, OS thread id 1234209088 MySQL thread id 208673, query id 792903818 10.0.0.8 spaces ---TRANSACTION 11 2785644229, not started, process no 8320, OS thread id 1160550720 MySQL thread id 208293, query id 792899145 10.0.0.3 spaces ---TRANSACTION 11 2785201727, not started, process no 8320, OS thread id 1260501312 MySQL thread id 207451, query id 792903626 10.0.0.7 spaces ---TRANSACTION 11 2785493325, not started, process no 8320, OS thread id 1207515456 MySQL thread id 207499, query id 792885302 10.0.0.7 spaces ---TRANSACTION 11 2785644555, not started, process no 8320, OS thread id 1147103552 MySQL thread id 207498, query id 792899545 10.0.0.7 spaces freeing items SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='595412' AND forum_id='7265' ---TRANSACTION 11 2763126517, not started, process no 8320, OS thread id 1188649280 MySQL thread id 189339, query id 759333206 localhost spaces ---TRANSACTION 11 2785647173, ACTIVE 165 sec, process no 8320, OS thread id 1291008320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214058, query id 792904176 10.0.0.5 spaces Sending data SELECT * FROM spaces_chat_rooms Trx read view will not see trx with id >= 11 2785647174, sees < 11 2785642279 ---TRANSACTION 11 2785647172, ACTIVE 229 sec, process no 8320, OS thread id 1145698624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209279, query id 792904154 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_3 WHERE nid='183806' AND user_id='370519' Trx read view will not see trx with id >= 11 2785647173, sees < 11 2785642279 ---TRANSACTION 11 2785647171, ACTIVE 235 sec, process no 8320, OS thread id 1245849920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214053, query id 792904153 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='MasteRock' ---TRANSACTION 11 2785647170, ACTIVE 236 sec, process no 8320, OS thread id 1143290176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213176, query id 792904146 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_0 WHERE nid='669458' AND user_id='2180' Trx read view will not see trx with id >= 11 2785647171, sees < 11 2785642279 ---TRANSACTION 11 2785647169, ACTIVE 237 sec, process no 8320, OS thread id 1193466176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212801, query id 792904145 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '647410' Trx read view will not see trx with id >= 11 2785647170, sees < 11 2785642279 ---TRANSACTION 11 2785647168, ACTIVE 238 sec, process no 8320, OS thread id 1276557632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213612, query id 792904140 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_8 WHERE nid='235597' AND user_id='867359' ---TRANSACTION 11 2785647167, ACTIVE 239 sec, process no 8320, OS thread id 1290606912 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214051, query id 792904139 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='avsinitsa' ---TRANSACTION 11 2785647166, ACTIVE 240 sec, process no 8320, OS thread id 1260702016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209533, query id 792904132 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_4 WHERE nid='392279' AND user_id='437785' ---TRANSACTION 11 2785647165, ACTIVE 242 sec, process no 8320, OS thread id 1290205504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214049, query id 792904131 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4298680873984834' ---TRANSACTION 11 2785647164, ACTIVE 242 sec, process no 8320, OS thread id 1289804096 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214047, query id 792904126 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='2' AND user_id='756826' ---TRANSACTION 11 2785647163, ACTIVE 242 sec, process no 8320, OS thread id 1289402688 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214045, query id 792904120 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='11' AND user_id='525124' ---TRANSACTION 11 2785647162, ACTIVE 242 sec, process no 8320, OS thread id 1272543552 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214039, query id 792904118 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '52' ORDER BY rate DESC LIMIT 295,5 ---TRANSACTION 11 2785647161, ACTIVE 242 sec, process no 8320, OS thread id 1289001280 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214043, query id 792904116 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='687208' ---TRANSACTION 11 2785647160, ACTIVE 242 sec, process no 8320, OS thread id 1264113984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214035, query id 792904110 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '51' ORDER BY rate DESC LIMIT 480,5 ---TRANSACTION 11 2785647159, ACTIVE 242 sec, process no 8320, OS thread id 1266321728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214036, query id 792904098 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5916135333639982' ---TRANSACTION 11 2785647158, ACTIVE 242 sec, process no 8320, OS thread id 1259698496 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214033, query id 792904093 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5013714635864193' ---TRANSACTION 11 2785647157, ACTIVE 242 sec, process no 8320, OS thread id 1256286528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214031, query id 792904092 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='12' AND user_id='790352' ---TRANSACTION 11 2785647156, ACTIVE 242 sec, process no 8320, OS thread id 1242237248 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214027, query id 792904087 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '13790' ORDER BY rate DESC LIMIT 45,5 ---TRANSACTION 11 2785647155, ACTIVE 242 sec, process no 8320, OS thread id 1246050624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214028, query id 792904081 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5485173564300896' ---TRANSACTION 11 2785647154, ACTIVE 243 sec, process no 8320, OS thread id 1238423872 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214025, query id 792904068 10.0.0.8 spaces Sending data SELECT * FROM spaces_forums_comments WHERE comment_id = '11453614' Trx read view will not see trx with id >= 11 2785647155, sees < 11 2785642279 ---TRANSACTION 11 2785647153, ACTIVE 243 sec, process no 8320, OS thread id 1229793600 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214023, query id 792904061 10.0.0.8 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '648483' AND chat = 1 Trx read view will not see trx with id >= 11 2785647154, sees < 11 2785642279 ---TRANSACTION 11 2785647152, ACTIVE 243 sec, process no 8320, OS thread id 1224374592 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214020, query id 792904057 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='9' AND user_id='53057' ---TRANSACTION 11 2785647151, ACTIVE 243 sec, process no 8320, OS thread id 1189452096 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214013, query id 792904038 10.0.0.8 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '6184' AND user_id = '525810' Trx read view will not see trx with id >= 11 2785647152, sees < 11 2785642279 ---TRANSACTION 11 2785647150, ACTIVE 243 sec, process no 8320, OS thread id 1255684416 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214014, query id 792904037 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='9' AND user_id='316026' ---TRANSACTION 11 2785647149, ACTIVE 243 sec, process no 8320, OS thread id 1258494272 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214011, query id 792904034 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='1804623034540257' ---TRANSACTION 11 2785647148, ACTIVE 244 sec, process no 8320, OS thread id 1191258432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214009, query id 792904021 10.0.0.8 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '215245' AND counselor = 1 Trx read view will not see trx with id >= 11 2785647149, sees < 11 2785642279 ---TRANSACTION 11 2785647147, ACTIVE 244 sec, process no 8320, OS thread id 1235614016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214007, query id 792904015 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='837165' ---TRANSACTION 11 2785647146, ACTIVE 244 sec, process no 8320, OS thread id 1213536576 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214004, query id 792904014 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='3272630670799683' ---TRANSACTION 11 2785647145, ACTIVE 244 sec, process no 8320, OS thread id 1219356992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214003, query id 792904013 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8910828149525507' ---TRANSACTION 11 2785647144, ACTIVE 245 sec, process no 8320, OS thread id 1152923968 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 214000, query id 792904000 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2759089215382074' ---TRANSACTION 11 2785647143, ACTIVE 245 sec, process no 8320, OS thread id 1216948544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213999, query id 792903999 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE com_id=3482 AND shared_dir=0 ORDER BY ctime DESC LIMIT 0,5 ---TRANSACTION 11 2785647142, ACTIVE 246 sec, process no 8320, OS thread id 1178614080 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212761, query id 792903989 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='3615656884339646' ---TRANSACTION 11 2785647141, ACTIVE 246 sec, process no 8320, OS thread id 1156737344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 210819, query id 792903984 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_6 WHERE nid='403791' AND user_id='649169' Trx read view will not see trx with id >= 11 2785647142, sees < 11 2785642279 ---TRANSACTION 11 2785647140, ACTIVE 247 sec, process no 8320, OS thread id 1157339456 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213868, query id 792903978 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_8 WHERE user_id='836094' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 ---TRANSACTION 11 2785647139, ACTIVE 247 sec, process no 8320, OS thread id 1218353472 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213651, query id 792903971 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='4953271774661718' ---TRANSACTION 11 2785647138, ACTIVE 247 sec, process no 8320, OS thread id 1157540160 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213741, query id 792903966 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='548824' ---TRANSACTION 11 2785647137, ACTIVE 247 sec, process no 8320, OS thread id 1225378112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213961, query id 792903963 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_1 WHERE user_id='193711' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 ---TRANSACTION 11 2785647136, ACTIVE 247 sec, process no 8320, OS thread id 1175202112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213670, query id 792903954 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='7767' AND user_id='458167' ---TRANSACTION 11 2785647135, ACTIVE 247 sec, process no 8320, OS thread id 1229191488 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212827, query id 792903941 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_3 WHERE nid='67404' AND user_id='396683' Trx read view will not see trx with id >= 11 2785647136, sees < 11 2785642279 ---TRANSACTION 11 2785647134, ACTIVE 247 sec, process no 8320, OS thread id 1247856960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213824, query id 792903934 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='1346492824389881' ---TRANSACTION 11 2785647133, ACTIVE 247 sec, process no 8320, OS thread id 1240631616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213947, query id 792903933 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_6 WHERE nid='378735' AND user_id='626201' Trx read view will not see trx with id >= 11 2785647134, sees < 11 2785642279 ---TRANSACTION 11 2785647132, ACTIVE 247 sec, process no 8320, OS thread id 1196878144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213810, query id 792903925 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='5' AND user_id='628259' ---TRANSACTION 11 2785647131, ACTIVE 247 sec, process no 8320, OS thread id 1287797056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213577, query id 792903916 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='6870929443407389' ---TRANSACTION 11 2785647130, ACTIVE 247 sec, process no 8320, OS thread id 1238223168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213828, query id 792903911 10.0.0.8 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '563389' Trx read view will not see trx with id >= 11 2785647131, sees < 11 2785642279 ---TRANSACTION 11 2785647129, ACTIVE 247 sec, process no 8320, OS thread id 1242839360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213958, query id 792903904 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_1 WHERE nid='423637' AND user_id='181699' ---TRANSACTION 11 2785647128, ACTIVE 247 sec, process no 8320, OS thread id 1281374528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213270, query id 792903897 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='11' AND user_id='161522' ---TRANSACTION 11 2785647127, ACTIVE 247 sec, process no 8320, OS thread id 1163761984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213778, query id 792903895 10.0.0.8 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '1287' AND user_id = '720496' Trx read view will not see trx with id >= 11 2785647128, sees < 11 2785642279 ---TRANSACTION 11 2785647126, ACTIVE 247 sec, process no 8320, OS thread id 1173596480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213632, query id 792903882 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_8 WHERE nid='168376' AND user_id='810255' ---TRANSACTION 11 2785647125, ACTIVE 247 sec, process no 8320, OS thread id 1268930880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213625, query id 792903875 10.0.0.8 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '631956' Trx read view will not see trx with id >= 11 2785647126, sees < 11 2785642279 ---TRANSACTION 11 2785647124, ACTIVE 247 sec, process no 8320, OS thread id 1208920384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213555, query id 792903852 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9912242399523560' ---TRANSACTION 11 2785647123, ACTIVE 247 sec, process no 8320, OS thread id 1281575232 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213753, query id 792903847 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='3909973972999089' ---TRANSACTION 11 2785647122, ACTIVE 247 sec, process no 8320, OS thread id 1244846400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213548, query id 792903842 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2270313877175840' ---TRANSACTION 11 2785647121, ACTIVE 247 sec, process no 8320, OS thread id 1277360448 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213854, query id 792903837 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '1738' ORDER BY rate DESC LIMIT 160,5 ---TRANSACTION 11 2785647120, ACTIVE 247 sec, process no 8320, OS thread id 1193064768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213777, query id 792903829 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8930050490726448' ---TRANSACTION 11 2785647119, ACTIVE 247 sec, process no 8320, OS thread id 1223571776 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 208672, query id 792903820 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '26317' ORDER BY rate DESC LIMIT 5,5 ---TRANSACTION 11 2785647118, ACTIVE 247 sec, process no 8320, OS thread id 1181624640 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213877, query id 792903819 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_5 WHERE nid='153360' AND user_id='568209' Trx read view will not see trx with id >= 11 2785647119, sees < 11 2785642279 ---TRANSACTION 11 2785647117, ACTIVE 247 sec, process no 8320, OS thread id 1151719744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 210926, query id 792903814 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='9' AND user_id='803545' ---TRANSACTION 11 2785647116, ACTIVE 247 sec, process no 8320, OS thread id 1182026048 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213762, query id 792903808 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_directories WHERE dir_id='13' Trx read view will not see trx with id >= 11 2785647117, sees < 11 2785642279 ---TRANSACTION 11 2785647115, ACTIVE 247 sec, process no 8320, OS thread id 1176205632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213710, query id 792903801 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_8 WHERE nid='124523' AND user_id='817123' ---TRANSACTION 11 2785647114, ACTIVE 247 sec, process no 8320, OS thread id 1168378176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213549, query id 792903790 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='348995' ---TRANSACTION 11 2785647113, ACTIVE 247 sec, process no 8320, OS thread id 1261103424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209809, query id 792903789 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_5 WHERE nid='356666' AND user_id='571620' Trx read view will not see trx with id >= 11 2785647114, sees < 11 2785642279 ---TRANSACTION 11 2785647112, ACTIVE 247 sec, process no 8320, OS thread id 1233205568 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213456, query id 792903778 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_7 WHERE nid='345307' AND user_id='770594' ---TRANSACTION 11 2785647111, ACTIVE 247 sec, process no 8320, OS thread id 1272142144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212293, query id 792903771 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='0219328117225738' ---TRANSACTION 11 2785647110, ACTIVE 247 sec, process no 8320, OS thread id 1157138752 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 211539, query id 792903770 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '13788' ORDER BY rate DESC LIMIT 20,5 ---TRANSACTION 11 2785647109, ACTIVE 247 sec, process no 8320, OS thread id 1203902784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213179, query id 792903767 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_8 WHERE nid='284675' AND user_id='813007' ---TRANSACTION 11 2785647108, ACTIVE 247 sec, process no 8320, OS thread id 1187043648 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213951, query id 792903754 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='903108' ---TRANSACTION 11 2785647107, ACTIVE 247 sec, process no 8320, OS thread id 1142888768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212984, query id 792903748 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='5' AND user_id='842732' ---TRANSACTION 11 2785647106, ACTIVE 247 sec, process no 8320, OS thread id 1188849984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212969, query id 792903744 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='0619162932452153' ---TRANSACTION 11 2785647105, ACTIVE 247 sec, process no 8320, OS thread id 1155533120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213732, query id 792903743 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5764933519614392' ---TRANSACTION 11 2785647104, ACTIVE 247 sec, process no 8320, OS thread id 1185036608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213833, query id 792903731 10.0.0.8 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='6' AND user_id='647689' ---TRANSACTION 11 2785647103, ACTIVE 247 sec, process no 8320, OS thread id 1183832384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213314, query id 792903725 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_9 WHERE user_id='903240' AND user2_id='637326' Trx read view will not see trx with id >= 11 2785647104, sees < 11 2785642279 ---TRANSACTION 11 2785647102, ACTIVE 247 sec, process no 8320, OS thread id 1218554176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 210701, query id 792903708 10.0.0.8 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '630916' Trx read view will not see trx with id >= 11 2785647103, sees < 11 2785642279 ---TRANSACTION 11 2785647101, ACTIVE 247 sec, process no 8320, OS thread id 1210726720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209926, query id 792903703 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_7 WHERE nid='134728' AND user_id='705360' ---TRANSACTION 11 2785647100, ACTIVE 247 sec, process no 8320, OS thread id 1270135104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 210441, query id 792903696 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_3 WHERE user_id='341999' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 20, 20 Trx read view will not see trx with id >= 11 2785647101, sees < 11 2785642279 ---TRANSACTION 11 2785647099, ACTIVE 247 sec, process no 8320, OS thread id 1145096512 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212891, query id 792903695 10.0.0.8 spaces Sending data SELECT * FROM spaces_forums_comments WHERE comment_id = '11452820' Trx read view will not see trx with id >= 11 2785647100, sees < 11 2785642279 ---TRANSACTION 11 2785647098, ACTIVE 247 sec, process no 8320, OS thread id 1251670336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213166, query id 792903675 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_4 WHERE nid='47217' AND user_id='460421' ---TRANSACTION 11 2785647097, ACTIVE 247 sec, process no 8320, OS thread id 1154328896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213730, query id 792903668 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='199914' ---TRANSACTION 11 2785647096, ACTIVE 247 sec, process no 8320, OS thread id 1154128192 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212952, query id 792903665 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='1329109583606551' ---TRANSACTION 11 2785647095, ACTIVE 247 sec, process no 8320, OS thread id 1198483776 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213742, query id 792903651 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='2821656196194281' ---TRANSACTION 11 2785647094, ACTIVE 247 sec, process no 8320, OS thread id 1285790016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213234, query id 792903646 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='574992' ---TRANSACTION 11 2785647093, ACTIVE 247 sec, process no 8320, OS thread id 1150916928 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213579, query id 792903641 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='1157475013555261' ---TRANSACTION 11 2785647092, ACTIVE 247 sec, process no 8320, OS thread id 1286392128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213169, query id 792903628 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_9 WHERE user_id='900579' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 11 2785647093, sees < 11 2785642279 ---TRANSACTION 11 2785647091, ACTIVE 247 sec, process no 8320, OS thread id 1222568256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 207450, query id 792903627 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '358234' Trx read view will not see trx with id >= 11 2785647092, sees < 11 2785642279 ---TRANSACTION 11 2785647090, ACTIVE 247 sec, process no 8320, OS thread id 1207314752 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213472, query id 792903616 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='damirddd' ---TRANSACTION 11 2785647089, ACTIVE 247 sec, process no 8320, OS thread id 1184835904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213320, query id 792903604 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_2 WHERE nid='479929' AND user_id='209348' ---TRANSACTION 11 2785647088, ACTIVE 247 sec, process no 8320, OS thread id 1272744256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212389, query id 792903602 10.0.0.8 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '84552' AND forum = 1 Trx read view will not see trx with id >= 11 2785647089, sees < 11 2785642279 ---TRANSACTION 11 2785647087, ACTIVE 247 sec, process no 8320, OS thread id 1284184384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 211669, query id 792903597 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '26317' ORDER BY rate DESC LIMIT 15,5 ---TRANSACTION 11 2785647086, ACTIVE 247 sec, process no 8320, OS thread id 1170786624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213759, query id 792903586 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_2 WHERE nid='142403' AND user_id='214196' ---TRANSACTION 11 2785647085, ACTIVE 247 sec, process no 8320, OS thread id 1258092864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212944, query id 792903579 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='khorinis' ---TRANSACTION 11 2785647084, ACTIVE 247 sec, process no 8320, OS thread id 1148909888 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213820, query id 792903569 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='alex22223' ---TRANSACTION 11 2785647083, ACTIVE 247 sec, process no 8320, OS thread id 1266121024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209589, query id 792903564 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_4 WHERE nid='338883' AND user_id='400395' ---TRANSACTION 11 2785647082, ACTIVE 247 sec, process no 8320, OS thread id 1169582400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213627, query id 792903556 10.0.0.8 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '339708' AND forum = 1 Trx read view will not see trx with id >= 11 2785647083, sees < 11 2785642279 ---TRANSACTION 11 2785647081, ACTIVE 247 sec, process no 8320, OS thread id 1201695040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213528, query id 792903548 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Kan_Kiro' ---TRANSACTION 11 2785647080, ACTIVE 247 sec, process no 8320, OS thread id 1262508352 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213993, query id 792903538 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='255077' ---TRANSACTION 11 2785647079, ACTIVE 247 sec, process no 8320, OS thread id 1186240832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212971, query id 792903537 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='7327152587441852' ---TRANSACTION 11 2785647078, ACTIVE 247 sec, process no 8320, OS thread id 1216547136 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213608, query id 792903531 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '83778' Trx read view will not see trx with id >= 11 2785647079, sees < 11 2785642279 ---TRANSACTION 11 2785647077, ACTIVE 247 sec, process no 8320, OS thread id 1211730240 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213621, query id 792903520 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5645354458987454' ---TRANSACTION 11 2785647076, ACTIVE 247 sec, process no 8320, OS thread id 1196075328 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212968, query id 792903516 10.0.0.8 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='596952' ---TRANSACTION 11 2785647075, ACTIVE 247 sec, process no 8320, OS thread id 1271339328 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212759, query id 792903509 10.0.0.8 spaces statistics SELECT COUNT(*) FROM spaces_moderators WHERE user_id = '760007' AND chat = 1 Trx read view will not see trx with id >= 11 2785647076, sees < 11 2785642279 ---TRANSACTION 11 2785647074, ACTIVE 247 sec, process no 8320, OS thread id 1163360576 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 211836, query id 792903501 10.0.0.7 spaces statistics SELECT * FROM spaces_users WHERE name='FILES_FOTOVIDEO' ---TRANSACTION 11 2785647073, ACTIVE 247 sec, process no 8320, OS thread id 1143490880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212982, query id 792903499 10.0.0.8 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9768629471518412' ---TRANSACTION 11 2785647072, ACTIVE 247 sec, process no 8320, OS thread id 1210526016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212729, query id 792903488 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '588294' Trx read view will not see trx with id >= 11 2785647073, sees < 11 2785642279 ---TRANSACTION 11 2785647071, ACTIVE 247 sec, process no 8320, OS thread id 1233004864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213260, query id 792903479 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9001966994989704' ---TRANSACTION 11 2785647070, ACTIVE 247 sec, process no 8320, OS thread id 1257089344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209688, query id 792903476 10.0.0.7 spaces statistics SELECT * FROM spaces_users WHERE name='SPA444' ---TRANSACTION 11 2785647069, ACTIVE 247 sec, process no 8320, OS thread id 1216346432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212777, query id 792903471 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums_comments WHERE comment_id = '11349506' Trx read view will not see trx with id >= 11 2785647070, sees < 11 2785642279 ---TRANSACTION 11 2785647068, ACTIVE 247 sec, process no 8320, OS thread id 1236617536 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213922, query id 792903470 10.0.0.6 spaces Sending data SELECT * FROM spaces_diary_comments WHERE topic_id = '1235477892' AND comment_id > '8753091' Trx read view will not see trx with id >= 11 2785647069, sees < 11 2785642279 ---TRANSACTION 11 2785647067, ACTIVE 247 sec, process no 8320, OS thread id 1181022528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213676, query id 792903463 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums_comments WHERE comment_id = '9887407' Trx read view will not see trx with id >= 11 2785647068, sees < 11 2785642279 ---TRANSACTION 11 2785647066, ACTIVE 247 sec, process no 8320, OS thread id 1214138688 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 211547, query id 792903460 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_pictures WHERE user_id = '459745' AND album_id = '104314' Trx read view will not see trx with id >= 11 2785647067, sees < 11 2785642279 ---TRANSACTION 11 2785647065, ACTIVE 247 sec, process no 8320, OS thread id 1256888640 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 213427, query id 792903458 10.0.0.3 spaces update INSERT INTO spaces_mail_data_0 SET contact_id='727691', flags='0', ctime=NOW() ---TRANSACTION 11 2785647062, ACTIVE 247 sec, process no 8320, OS thread id 1261304128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209282, query id 792903453 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_mail_contact_list_1 WHERE user_id='189170' AND contact_type=2 ---TRANSACTION 11 2785647061, ACTIVE 247 sec, process no 8320, OS thread id 1213335872 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213285, query id 792903451 10.0.0.7 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='282817' ---TRANSACTION 11 2785647060, ACTIVE 247 sec, process no 8320, OS thread id 1269934400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213104, query id 792903449 10.0.0.6 spaces statistics SELECT * FROM spaces_sessions WHERE sid='8579695105712465' ---TRANSACTION 11 2785647059, ACTIVE 247 sec, process no 8320, OS thread id 1232001344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213645, query id 792903448 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='5671298810808269' ---TRANSACTION 11 2785647058, ACTIVE 247 sec, process no 8320, OS thread id 1248258368 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213394, query id 792903447 10.0.0.6 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='678432' AND forum_id='57694' ---TRANSACTION 11 2785647056, ACTIVE 247 sec, process no 8320, OS thread id 1278163264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213552, query id 792903445 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='51132' ---TRANSACTION 11 2785647052, ACTIVE 247 sec, process no 8320, OS thread id 1237018944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213995, query id 792903441 10.0.0.6 spaces Sending data SELECT page,comments_cnt,last_comment_id FROM spaces_pictures_tracking WHERE user_id='908310' AND object_id='2046725' ---TRANSACTION 11 2785647048, ACTIVE 247 sec, process no 8320, OS thread id 1212733760 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 211891, query id 792903431 10.0.0.7 spaces statistics SELECT * FROM spaces_users WHERE name='Hron' ---TRANSACTION 11 2785647047, ACTIVE 247 sec, process no 8320, OS thread id 1207916864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213736, query id 792903430 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='682566' ---TRANSACTION 11 2785647046, ACTIVE 247 sec, process no 8320, OS thread id 1215945024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213638, query id 792903429 10.0.0.6 spaces statistics SELECT * FROM advertise_campaign WHERE nid='43' Trx read view will not see trx with id >= 11 2785647047, sees < 11 2785642279 ---TRANSACTION 11 2785647045, ACTIVE 247 sec, process no 8320, OS thread id 1147304256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213856, query id 792903428 10.0.0.6 spaces Sending data SELECT new_count FROM spaces_music WHERE user_id='856720' AND new_count != 0 Trx read view will not see trx with id >= 11 2785647046, sees < 11 2785642279 ---TRANSACTION 11 2785647044, ACTIVE 247 sec, process no 8320, OS thread id 1234811200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213760, query id 792903427 10.0.0.8 spaces Sending data SELECT new_count FROM spaces_myfiles WHERE user_id='240609' AND new_count != 0 Trx read view will not see trx with id >= 11 2785647045, sees < 11 2785642279 ---TRANSACTION 11 2785647043, ACTIVE 247 sec, process no 8320, OS thread id 1288399168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213471, query id 792903423 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_data_9 WHERE contact_id='24807' ORDER BY nid DESC LIMIT 0,4 Trx read view will not see trx with id >= 11 2785647044, sees < 11 2785642279 ---TRANSACTION 11 2785647041, ACTIVE 247 sec, process no 8320, OS thread id 1205307712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 209337, query id 792903418 10.0.0.8 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='538870' AND forum_id='66800' ---TRANSACTION 11 2785647040, ACTIVE 247 sec, process no 8320, OS thread id 1276959040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213308, query id 792903411 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='844872' ---TRANSACTION 11 2785647039, ACTIVE 247 sec, process no 8320, OS thread id 1254881600 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213755, query id 792903406 10.0.0.8 spaces Sending data SELECT user_id FROM spaces_chat_users WHERE user_id='907382' AND flags & '1' LIMIT 1 ---TRANSACTION 11 2785647038, ACTIVE 247 sec, process no 8320, OS thread id 1164163392 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212919, query id 792903405 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_friend_list WHERE user_id = '752567' Trx read view will not see trx with id >= 11 2785647039, sees < 11 2785642279 ---TRANSACTION 11 2785647037, ACTIVE 247 sec, process no 8320, OS thread id 1160952128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 210185, query id 792903403 10.0.0.3 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='29299' ---TRANSACTION 11 2785647036, ACTIVE 247 sec, process no 8320, OS thread id 1191057728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213484, query id 792903400 10.0.0.7 spaces Sending data SELECT page,comments_cnt,last_comment_id FROM spaces_files_tracking WHERE user_id='544790' AND object_id='1209892' ---TRANSACTION 11 2785647035, ACTIVE 247 sec, process no 8320, OS thread id 1192864064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 212963, query id 792903399 10.0.0.6 spaces statistics SELECT * FROM spaces_reklama_off WHERE user_id='700627' Trx read view will not see trx with id >= 11 2785647036, sees < 11 2785642279 ---TRANSACTION 11 2785647034, ACTIVE 247 sec, process no 8320, OS thread id 1237621056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213355, query id 792903397 10.0.0.6 spaces statistics SELECT * FROM advertise_campaign WHERE nid='4' Trx read view will not see trx with id >= 11 2785647035, sees < 11 2785642279 ---TRANSACTION 11 2785647033, ACTIVE 247 sec, process no 8320, OS thread id 1158342976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 211679, query id 792903396 10.0.0.8 spaces Sorting result SELECT * FROM spaces_shared_zone_directories WHERE parent_dir='60' AND com_id='0'ORDER BY level Trx read view will not see trx with id >= 11 2785647034, sees < 11 2785642279 ---TRANSACTION 11 2785647032, ACTIVE 247 sec, process no 8320, OS thread id 1172793664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213633, query id 792903394 10.0.0.3 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='546276' AND forum_id='4114' ---TRANSACTION 11 2785647031, ACTIVE 247 sec, process no 8320, OS thread id 1266723136 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 213495, query id 792903319 10.0.0.3 spaces update INSERT INTO spaces_mail_data_1 SET contact_id='497947', flags='0', ctime=NOW() ---TRANSACTION 11 2785647030, ACTIVE 247 sec, process no 8320, OS thread id 1203702080 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213674, query id 792903392 10.0.0.6 spaces Sending data SELECT new_count FROM spaces_pictures WHERE user_id='824653' AND new_count != 0 Trx read view will not see trx with id >= 11 2785647031, sees < 11 2785642279 ---TRANSACTION 11 2785647029, ACTIVE 247 sec, process no 8320, OS thread id 1279166784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213964, query id 792903390 10.0.0.3 spaces Sending data SELECT last_topics_cnt,last_comments_cnt FROM spaces_forums_users_counters WHERE user_id='66391' AND forum_id='353' ---TRANSACTION 11 2785646975, ACTIVE 247 sec, process no 8320, OS thread id 1168578880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213239, query id 792903327 10.0.0.7 spaces Sending data SELECT * FROM spaces_file_directories WHERE dir_id='78095' Trx read view will not see trx with id >= 11 2785646976, sees < 11 2785642279 ---TRANSACTION 11 2785646970, ACTIVE 247 sec, process no 8320, OS thread id 1210325312 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213585, query id 792903315 10.0.0.7 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE file_id = '1727816' AND source = '0' AND com_id = 0 Trx read view will not see trx with id >= 11 2785647042, sees < 11 2785642279 ---TRANSACTION 11 2785646969, ACTIVE 247 sec, process no 8320, OS thread id 1251871040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213667, query id 792903313 10.0.0.6 spaces Sending data SELECT * FROM spaces_users WHERE nid='846034' Trx read view will not see trx with id >= 11 2785647044, sees < 11 2785642279 ---TRANSACTION 11 2785646933, ACTIVE 247 sec, process no 8320, OS thread id 1175804224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213704, query id 792903183 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 11 2785646934, sees < 11 2785642279 ---TRANSACTION 11 2785646932, ACTIVE 247 sec, process no 8320, OS thread id 1215744320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213261, query id 792903184 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 11 2785646933, sees < 11 2785642279 ---TRANSACTION 11 2785646931, ACTIVE 247 sec, process no 8320, OS thread id 1166170432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213920, query id 792903187 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 11 2785646932, sees < 11 2785642279 ---TRANSACTION 11 2785646930, ACTIVE 247 sec, process no 8320, OS thread id 1222969664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213836, query id 792903236 10.0.0.8 spaces Sending data SELECT * FROM spaces_shared_zone_files2 WHERE shared_dir = '1740' ORDER BY rate DESC LIMIT 0,5 Trx read view will not see trx with id >= 11 2785646971, sees < 11 2785642279 ---TRANSACTION 11 2785646919, ACTIVE 247 sec, process no 8320, OS thread id 1163561280 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213733, query id 792903181 10.0.0.6 spaces Sending data SELECT * from spaces_pictures WHERE user_id = '388729' AND album_id='105326' ORDER BY pic_id DESC LIMIT 0,5 Trx read view will not see trx with id >= 11 2785646920, sees < 11 2785642279 ---TRANSACTION 11 2785646909, ACTIVE 247 sec, process no 8320, OS thread id 1168980288 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 212786, query id 792903208 10.0.0.6 spaces update INSERT INTO spaces_blacklist SET user_id='384522',enemy_id='899930' ---TRANSACTION 11 2785646896, ACTIVE 247 sec, process no 8320, OS thread id 1238825280 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213695, query id 792903067 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '2207' Trx read view will not see trx with id >= 11 2785646897, sees < 11 2785642279 ---TRANSACTION 11 2785646883, ACTIVE 247 sec, process no 8320, OS thread id 1282378048 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213766, query id 792903139 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '2826' Trx read view will not see trx with id >= 11 2785646884, sees < 11 2785642279 ---TRANSACTION 11 2785646881, ACTIVE 247 sec, process no 8320, OS thread id 1275554112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213726, query id 792903092 10.0.0.8 spaces Sending data SELECT COUNT(*) FROM spaces_chat WHERE room_id='2' AND ((private = 0 or private = '637728') OR user_id = '637728') Trx read view will not see trx with id >= 11 2785646882, sees < 11 2785642279 ---TRANSACTION 11 2785646875, ACTIVE 247 sec, process no 8320, OS thread id 1211128128, 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 213701, query id 792903063 10.0.0.6 spaces end UPDATE spaces_users_events SET mail_new = (mail_new + 1) WHERE user_id='227258' ---TRANSACTION 11 2785646874, ACTIVE 248 sec, process no 8320, OS thread id 1225980224, 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 212216, query id 792903146 10.0.0.8 spaces update INSERT INTO spaces_forums_users_counters SET user_id='703490', last_topics_cnt='9', last_comments_cnt='0', forum_id='48415' ---TRANSACTION 11 2785646856, ACTIVE 248 sec, process no 8320, OS thread id 1203099968, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 213845, query id 792903130 10.0.0.8 spaces end UPDATE spaces_chat_users SET last_time='1246218819' WHERE room_id='7767' AND user_id='634564' ---TRANSACTION 11 2785646843, ACTIVE 248 sec, process no 8320, OS thread id 1150314816, 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 213063, query id 792903112 10.0.0.6 spaces end DELETE FROM spaces_sessions WHERE user_id='828490' ---TRANSACTION 11 2785646820, ACTIVE 248 sec, process no 8320, OS thread id 1265117504, 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 213581, query id 792903078 10.0.0.6 spaces end UPDATE spaces_users SET logins = (logins + 1) WHERE nid = '913459' ---TRANSACTION 11 2785646799, ACTIVE 248 sec, process no 8320, OS thread id 1218955584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213949, query id 792903030 10.0.0.8 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 11 2785646800, sees < 11 2785642279 ---TRANSACTION 11 2785646757, ACTIVE 248 sec, process no 8320, OS thread id 1214339392 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213816, query id 792902858 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 11 2785646759, sees < 11 2785642279 ---TRANSACTION 11 2785646750, ACTIVE 248 sec, process no 8320, OS thread id 1235212608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 210384, query id 792902812 10.0.0.8 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 11 2785646751, sees < 11 2785642279 ---TRANSACTION 11 2785646744, ACTIVE 248 sec, process no 8320, OS thread id 1235814720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 210591, query id 792902855 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '4292' Trx read view will not see trx with id >= 11 2785646745, sees < 11 2785642279 ---TRANSACTION 11 2785646676, ACTIVE 248 sec, process no 8320, OS thread id 1164765504, 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 213284, query id 792902853 10.0.0.7 spaces update INSERT INTO spaces_files_tracking SET user_id='909771', object_id='1393970', page=1, comments_cnt='2', last_comment_id='822031' ---TRANSACTION 11 2785646663, ACTIVE 248 sec, process no 8320, OS thread id 1220561216, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 1 MySQL thread id 213814, query id 792902844 10.0.0.8 spaces end UPDATE spaces_chat_users SET last_time='1246218819' WHERE room_id='6' AND user_id='619411' ---TRANSACTION 11 2785646654, ACTIVE 248 sec, process no 8320, OS thread id 1213937984, 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 213466, query id 792902834 10.0.0.7 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='20' WHERE user_id='270271' ---TRANSACTION 11 2785646622, ACTIVE 248 sec, process no 8320, OS thread id 1245247808, thread declared inside InnoDB 127 mysql tables in use 1, locked 1 357 lock struct(s), heap size 47088, 739 row lock(s), undo log entries 4 MySQL thread id 213700, query id 792902696 10.0.0.6 spaces end UPDATE spaces_journal SET flags = (flags & ~(1)) WHERE user_id='640094' ---TRANSACTION 11 2785646601, ACTIVE 248 sec, process no 8320, OS thread id 1146902848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 213838, query id 792902428 10.0.0.8 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 >= 11 2785646602, sees < 11 2785642279 ---TRANSACTION 11 2785646449, ACTIVE 248 sec, process no 8320, OS thread id 1284385088, 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 213377, query id 792902547 10.0.0.6 spaces end UPDATE spaces_users SET logins = (logins + 1) WHERE nid = '129901' ---TRANSACTION 11 2785646428, ACTIVE 248 sec, process no 8320, OS thread id 1214540096, 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 213451, query id 792902505 10.0.0.3 spaces end UPDATE spaces_users_events SET mail_new = (mail_new + 1) WHERE user_id='242622' ---TRANSACTION 11 2785646416, ACTIVE 248 sec, process no 8320, OS thread id 1280772416, 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 209453, query id 792902494 10.0.0.3 spaces end UPDATE spaces_mail_contact_list_4 SET new=0,new_cnt=0 WHERE nid='405764' ---TRANSACTION 11 2785646413, ACTIVE 248 sec, process no 8320, OS thread id 1246652736, 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 213381, query id 792902493 10.0.0.6 spaces update INSERT INTO spaces_lenta_6 SET user_id='612562', author_id='268067', event_id='128', source_id='1235478424' ---TRANSACTION 11 2785646375, ACTIVE 248 sec, process no 8320, OS thread id 1230797120, 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 212938, query id 792902453 10.0.0.6 spaces end UPDATE spaces_users_anketa SET books='Я своё уже отчитал' WHERE user_id='827303' ---TRANSACTION 11 2785646339, ACTIVE 248 sec, process no 8320, OS thread id 1280571712, 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 208297, query id 792902408 10.0.0.3 spaces end UPDATE spaces_mail_contact_list_1 SET in_cnt=in_cnt+1, new_cnt=new_cnt+1, new=1, mtime='1246218819', contact_type=0 WHERE nid='481915' ---TRANSACTION 11 2785646333, ACTIVE 248 sec, process no 8320, OS thread id 1252272448 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 213774, query id 792902392 10.0.0.3 spaces updating DELETE FROM spaces_mail_contact_list_4 WHERE nid='410907' AND user_id='453953' ---TRANSACTION 11 2785646332, ACTIVE 248 sec, process no 8320, OS thread id 1148107072, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 213319, query id 792902389 10.0.0.3 spaces update INSERT INTO spaces_mail_data_8 SET contact_id='289009', flags='1', ctime=NOW() ---TRANSACTION 11 2785646001, ACTIVE 248 sec, process no 8320, OS thread id 1200490816, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 210609, query id 792901856 10.0.0.3 spaces update INSERT INTO spaces_mail_data_8 SET contact_id='290215', flags='1', ctime=NOW() ---TRANSACTION 11 2785645623, ACTIVE 248 sec, process no 8320, OS thread id 1142085952, 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 213162, query id 792901214 10.0.0.7 spaces update INSERT INTO spaces_files_tracking SET user_id='904694', object_id='74256', page=1, comments_cnt='9', last_comment_id='1073726' ---TRANSACTION 11 2785645437, ACTIVE 248 sec, process no 8320, OS thread id 1267325248, 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 213227, query id 792901000 10.0.0.6 spaces update INSERT INTO spaces_users_anketa_views SET user_id='913821', viewer_id='913821', ctime=NOW() ---TRANSACTION 11 2785645407, ACTIVE 248 sec, process no 8320, OS thread id 1176004928, 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 211681, query id 792900968 10.0.0.6 spaces end UPDATE spaces_users_anketa SET last_view = NOW() WHERE user_id = '679013' ---TRANSACTION 11 2785645251, ACTIVE 248 sec, process no 8320, OS thread id 1179617600, 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 213540, query id 792900833 10.0.0.6 spaces end UPDATE spaces_users_events SET mylenta_notifies = (mylenta_notifies + 1) WHERE user_id = '390721' ---TRANSACTION 11 2785645246, ACTIVE 248 sec, process no 8320, OS thread id 1252473152, 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 213821, query id 792900830 10.0.0.6 spaces update INSERT INTO spaces_pictures_tracking SET user_id='802306', object_id='2142396', page=1, comments_cnt='0', last_comment_id='0' ---TRANSACTION 11 2785645214, ACTIVE 248 sec, process no 8320, OS thread id 1265719616, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 212850, query id 792900778 10.0.0.3 spaces update INSERT INTO spaces_mail_data_2 SET contact_id='43332', flags='0', ctime=NOW() ---TRANSACTION 11 2785645208, ACTIVE 248 sec, process no 8320, OS thread id 1198283072, 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 211626, query id 792900765 10.0.0.7 spaces end UPDATE spaces_shared_zone_files2 SET rate='7.2' WHERE file_id='358047' AND source='1' ---TRANSACTION 11 2785645207, ACTIVE 248 sec, process no 8320, OS thread id 1156536640, 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 209573, query id 792900760 10.0.0.3 spaces end UPDATE spaces_mail_contact_list_7 SET new=0,new_cnt=0 WHERE nid='266680' ---TRANSACTION 11 2785645120, ACTIVE 248 sec, process no 8320, OS thread id 1167976768, 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 212646, query id 792900648 10.0.0.7 spaces update INSERT INTO spaces_pics_downloads SET user_id='910604', file_id='1632667', ctime=NOW(), owner_id='684316', adult='0' ---TRANSACTION 11 2785645074, ACTIVE 248 sec, process no 8320, OS thread id 1279969600, 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 213711, query id 792900582 10.0.0.8 spaces end UPDATE spaces_sessions SET atime=NOW(),reklama_cursor=(reklama_cursor + 1), last_place='25' WHERE user_id='872673' ---TRANSACTION 11 2785645013, ACTIVE 248 sec, process no 8320, OS thread id 1223371072, 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 213745, query id 792900466 10.0.0.8 spaces update INSERT INTO spaces_chat_users SET room_id='10', last_time='1246218819', user_id='593139', flags='0' ---TRANSACTION 11 2785643568, ACTIVE 248 sec, process no 8320, OS thread id 1277561152 mysql tables in use 1, locked 0 MySQL thread id 213918, query id 792898339 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums_comments WHERE topic_id = '182413' AND comment_id > '10291634' AND deleted_by = 0 Trx read view will not see trx with id >= 11 2785643569, sees < 11 2785642279 ---TRANSACTION 11 2785642576, ACTIVE 249 sec, process no 8320, OS thread id 1248659776 waiting in InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 213658, query id 792896557 10.0.0.6 spaces Sorting result SELECT * from spaces_users_anketa WHERE dating = 1 AND gender = 1 AND photo_id AND (age >= "1953-06-28" AND age <= "1999-06-28") AND getting_target & 16 ORDER BY anketa_level DESC LIMIT 12,7 Trx read view will not see trx with id >= 11 2785642577, sees < 11 2785641726 ---TRANSACTION 11 2785642279, ACTIVE 249 sec, process no 8320, OS thread id 1236015424 waiting in InnoDB queue mysql tables in use 5, locked 0 MySQL thread id 213864, query id 792896031 10.0.0.6 spaces Sorting result SELECT * from spaces_users_anketa WHERE dating = 1 AND gender = 0 AND sex_orient = 0 AND photo_id AND (age >= "1973-06-28" AND age <= "1989-06-28") AND country = 2 AND city = 9268 AND getting_target & 8 ORDER BY anketa_level DESC LIMIT 120,7 Trx read view will not see trx with id >= 11 2785642280, sees < 11 2785617401 -------- 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 5328275 OS file reads, 6319776 OS file writes, 297629 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 2657, free list len 1355, seg size 4013, 1746592 inserts, 1417724 merged recs, 241031 merges Hash table size 48874589, node heap has 169622 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 623 3093399355 Log flushed up to 623 3093396515 Last checkpoint at 623 2905034099 0 pending log writes, 0 pending chkp writes 131650 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 27054928674; in additional pool allocated 16777216 Dictionary memory allocated 1054480 Buffer pool size 1507328 Free buffers 0 Database pages 1337704 Modified db pages 86493 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 6043411, created 165688, written 9063949 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 32 queries inside InnoDB, 179 queries in queue 61 read views open inside InnoDB Main thread process no. 8320, id 1140881728, state: purging Number of rows inserted 10400374, updated 35101069, deleted 2945032, read 66166712441 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================