Type Name Status InnoDB ===================================== 090518 20:50:55 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 8 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 298064405, signal count 188103048 Mutex spin waits 0, rounds 111455276837, OS waits 165666140 RW-shared spins 149080048, OS waits 48227159; RW-excl spins 253271446, OS waits 28963075 ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 090516 22:52:21 Transaction: TRANSACTION 9 1673867885, ACTIVE 0 sec, process no 32573, OS thread id 1142286656 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 870607, query id 894973501 spaces 10.0.0.3 spaces update INSERT INTO spaces_mail_data_6 SET contact_id='110895', flags='1', ctime=NOW() Foreign key constraint fails for table `spaces_mail`.`spaces_mail_data_6`: , CONSTRAINT `spaces_mail_data_6` FOREIGN KEY (`contact_id`) REFERENCES `spaces_mail_contact_list_6` (`nid`) ON DELETE CASCADE Trying to add in child table, in index `contact_id` tuple: DATA TUPLE: 2 fields; 0: len 4; hex 8001b12f; asc /;; 1: len 4; hex 801bd10a; asc ;; But in parent table `spaces_mail`.`spaces_mail_contact_list_6`, 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 8001b130; asc 0;; 1: len 6; hex 0009039e5526; asc U&;; 2: len 7; hex 00001940040b08; asc @ ;; 3: len 4; hex 8009b99c; asc ;; 4: len 4; hex 80024459; asc DY;; 5: len 4; hex 80000005; asc ;; 6: len 4; hex 80000005; 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 ca00c484; asc ;; 13: len 30; hex 497a6272616e6e6969383920202020202020202020202020202020202020; asc Izbrannii89 ;...(truncated); ------------------------ LATEST DETECTED DEADLOCK ------------------------ 090518 20:30:05 *** (1) TRANSACTION: TRANSACTION 9 1939780772, ACTIVE 0 sec, process no 32573, OS thread id 1261906240 inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 368, 2 row lock(s), undo log entries 1 MySQL thread id 1250338, query id 1337922787 10.0.0.6 spaces update INSERT INTO spaces_guests SET sid='6649210649027392', mtime=NOW(), ip_address='212.151.224.216,212.151.224.216', user_agent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Google Wireless Transcoder;)', mobile_device='вашей мобилы', reklama_cursor='0', flags='0' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 312593 n bits 128 index `ip_address` of table `spaces`.`spaces_guests` trx id 9 1939780772 lock mode S waiting Record lock, heap no 7 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 0: len 16; hex 3231322e3135312e3232342e3231362c; asc 212.151.224.216,;; 1: len 30; hex 4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520; asc Mozilla/4.0 (compatible; MSIE ;...(truncated); 2: len 6; hex 0000176deb51; asc m Q;; *** (2) TRANSACTION: TRANSACTION 9 1939771218, ACTIVE 3 sec, process no 32573, OS thread id 1252071744 fetching rows, thread declared inside InnoDB 381 mysql tables in use 1, locked 1 474 lock struct(s), heap size 47088, 12785 row lock(s), undo log entries 2341 MySQL thread id 1251600, query id 1337913043 data.spaces.ru 10.0.0.5 spaces updating DELETE FROM spaces_guests WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(mtime)) > '3600' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 312593 n bits 128 index `ip_address` of table `spaces`.`spaces_guests` trx id 9 1939771218 lock_mode X locks rec but not gap Record lock, heap no 7 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 0: len 16; hex 3231322e3135312e3232342e3231362c; asc 212.151.224.216,;; 1: len 30; hex 4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520; asc Mozilla/4.0 (compatible; MSIE ;...(truncated); 2: len 6; hex 0000176deb51; asc m Q;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 25490 n bits 104 index `GEN_CLUST_INDEX` of table `spaces`.`spaces_guests` trx id 9 1939771218 lock_mode X waiting Record lock, heap no 35 PHYSICAL RECORD: n_fields 13; compact format; info bits 0 0: len 6; hex 0000176e7b05; asc n{ ;; 1: len 6; hex 0009739eb4a4; asc s ;; 2: len 7; hex 800025bb7e0110; asc % ~ ;; 3: len 4; hex 819d2061; asc a;; 4: len 20; hex 3636343932313036343930323733393220202020; asc 6649210649027392 ;; 5: len 8; hex 80001245b0336a7d; asc E 3j};; 6: len 16; hex 3231322e3135312e3232342e3231362c; asc 212.151.224.216,;; 7: len 30; hex 4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520; asc Mozilla/4.0 (compatible; MSIE ;...(truncated); 8: len 30; hex d0b2d0b0d188d0b5d0b920d0bcd0bed0b1d0b8d0bbd18b20202020202020; asc ;...(truncated); 9: SQL NULL; 10: len 4; hex 80000000; asc ;; 11: len 4; hex 80000000; asc ;; 12: len 4; hex 80000000; asc ;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 9 1942006543 Purge done for trx's n:o < 9 1942005013 undo n:o < 0 0 History list length 183 ... truncated... ces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '113787' ---TRANSACTION 9 1942005744, not started, process no 32573, OS thread id 1207916864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1254122, query id 1341615399 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '34726' ---TRANSACTION 9 1942006085, not started, process no 32573, OS thread id 1210726720 MySQL thread id 1254120, query id 1341614909 10.0.0.7 spaces freeing items SELECT * FROM spaces_myfiles WHERE file_id = '1351744' ---TRANSACTION 9 1942006396, not started, process no 32573, OS thread id 1263913280 MySQL thread id 1254114, query id 1341615265 10.0.0.7 spaces freeing items SELECT new_count FROM spaces_music WHERE user_id='88975' AND new_count != 0 ---TRANSACTION 9 1941962394, not started, process no 32573, OS thread id 1194469696 MySQL thread id 1253286, query id 1341614234 10.0.0.7 spaces ---TRANSACTION 9 1941997394, not started, process no 32573, OS thread id 1212131648 MySQL thread id 1253627, query id 1341612641 10.0.0.7 spaces ---TRANSACTION 9 1941432722, not started, process no 32573, OS thread id 1210325312 MySQL thread id 1253864, query id 1341613806 10.0.0.7 spaces ---TRANSACTION 9 1941967787, not started, process no 32573, OS thread id 1283983680 MySQL thread id 1253882, query id 1341615607 10.0.0.7 spaces ---TRANSACTION 9 1941664236, not started, process no 32573, OS thread id 1190054208 MySQL thread id 1253791, query id 1341613551 10.0.0.7 spaces ---TRANSACTION 9 1941805088, not started, process no 32573, OS thread id 1146902848 MySQL thread id 1253896, query id 1341614040 10.0.0.6 spaces ---TRANSACTION 9 1941993219, not started, process no 32573, OS thread id 1249663296 MySQL thread id 1253906, query id 1341592666 10.0.0.6 spaces ---TRANSACTION 9 1941932172, not started, process no 32573, OS thread id 1222367552 MySQL thread id 1253307, query id 1341612403 10.0.0.7 spaces ---TRANSACTION 9 1942006196, not started, process no 32573, OS thread id 1148307776 MySQL thread id 1253895, query id 1341615011 10.0.0.6 spaces freeing items SELECT * FROM spaces_guestbook WHERE comment_id = '1901105' ---TRANSACTION 9 1942006334, not started, process no 32573, OS thread id 1280772416 MySQL thread id 1253789, query id 1341614996 10.0.0.7 spaces freeing items SELECT COUNT(*) FROM spaces_files_downloads WHERE file_id='194425' ---TRANSACTION 9 1942006399, not started, process no 32573, OS thread id 1141684544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253620, query id 1341615418 10.0.0.7 spaces Sending data SELECT * FROM spaces_users WHERE nid='108980' ---TRANSACTION 9 1941565290, not started, process no 32573, OS thread id 1202497856 MySQL thread id 1253470, query id 1341613097 10.0.0.7 spaces ---TRANSACTION 9 1941944832, not started, process no 32573, OS thread id 1154529600 MySQL thread id 1252660, query id 1341613664 10.0.0.7 spaces ---TRANSACTION 9 1941887341, not started, process no 32573, OS thread id 1290406208 MySQL thread id 1253379, query id 1341613320 10.0.0.7 spaces ---TRANSACTION 9 1942006332, not started, process no 32573, OS thread id 1258293568 MySQL thread id 1253306, query id 1341615132 10.0.0.7 spaces freeing items SELECT album_id FROM spaces_pictures_albums WHERE parent_album='47932' ---TRANSACTION 9 1942005830, not started, process no 32573, OS thread id 1256487232 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253285, query id 1341615116 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_pictures_comments WHERE picture_id = '1403089' ---TRANSACTION 9 1942006279, not started, process no 32573, OS thread id 1272543552 MySQL thread id 1253244, query id 1341615048 10.0.0.7 spaces freeing items SELECT * FROM spaces_shared_zone_directories WHERE dir_id='3371' ---TRANSACTION 9 1942006473, not started, process no 32573, OS thread id 1205307712 MySQL thread id 1253132, query id 1341615150 spaces 10.0.0.3 spaces ---TRANSACTION 9 1941915178, not started, process no 32573, OS thread id 1209121088 MySQL thread id 1253111, query id 1341614420 spaces 10.0.0.3 spaces ---TRANSACTION 9 1942006248, not started, process no 32573, OS thread id 1167374656 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253109, query id 1341615401 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='6130' ---TRANSACTION 9 1941904241, not started, process no 32573, OS thread id 1299237184 MySQL thread id 1252686, query id 1341615309 spaces 10.0.0.3 spaces ---TRANSACTION 9 1941982345, not started, process no 32573, OS thread id 1201092928 MySQL thread id 1252871, query id 1341613523 spaces 10.0.0.3 spaces ---TRANSACTION 9 1941936716, not started, process no 32573, OS thread id 1212533056 MySQL thread id 1252986, query id 1341587887 10.0.0.6 spaces ---TRANSACTION 9 1941926540, not started, process no 32573, OS thread id 1151519040 MySQL thread id 1252995, query id 1341480400 spaces 10.0.0.3 spaces ---TRANSACTION 9 1941998540, not started, process no 32573, OS thread id 1190857024 MySQL thread id 1252939, query id 1341614434 10.0.0.6 spaces ---TRANSACTION 9 1942006402, not started, process no 32573, OS thread id 1171589440 MySQL thread id 1252870, query id 1341615199 spaces 10.0.0.3 spaces freeing items SELECT COUNT(*) FROM spaces_forums_comments WHERE topic_id = '430680' AND deleted_by = 0 ---TRANSACTION 9 1941998712, not started, process no 32573, OS thread id 1237219648 MySQL thread id 1252733, query id 1341615321 spaces 10.0.0.3 spaces ---TRANSACTION 9 1941709714, not started, process no 32573, OS thread id 1196476736 MySQL thread id 1252352, query id 1341614455 10.0.0.6 spaces ---TRANSACTION 9 1942006179, not started, process no 32573, OS thread id 1179617600 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1252685, query id 1341615349 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='tanya0991' ---TRANSACTION 9 1942006097, not started, process no 32573, OS thread id 1266923840 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1252659, query id 1341615308 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '695114' ---TRANSACTION 9 1941979845, not started, process no 32573, OS thread id 1264314688 MySQL thread id 1252551, query id 1341614855 10.0.0.7 spaces ---TRANSACTION 9 1942006082, not started, process no 32573, OS thread id 1191057728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1252550, query id 1341615160 10.0.0.7 spaces Sending data SELECT * FROM spaces_shared_zone_directories WHERE dir_id='61' ---TRANSACTION 9 1941956218, not started, process no 32573, OS thread id 1181825344 MySQL thread id 1252353, query id 1341531352 10.0.0.6 spaces ---TRANSACTION 9 1941991171, not started, process no 32573, OS thread id 1231198528 MySQL thread id 1250249, query id 1341613055 10.0.0.7 spaces ---TRANSACTION 9 1941981767, not started, process no 32573, OS thread id 1172191552 MySQL thread id 1250321, query id 1341613377 10.0.0.7 spaces ---TRANSACTION 9 1941873731, not started, process no 32573, OS thread id 1243842880 MySQL thread id 1250294, query id 1341614225 10.0.0.7 spaces ---TRANSACTION 9 1941962037, not started, process no 32573, OS thread id 1302047040 MySQL thread id 1250312, query id 1341612079 10.0.0.7 spaces ---TRANSACTION 9 1941912339, not started, process no 32573, OS thread id 1147304256 MySQL thread id 1250769, query id 1341612094 10.0.0.7 spaces ---TRANSACTION 9 1942006199, not started, process no 32573, OS thread id 1199888704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250768, query id 1341615422 10.0.0.7 spaces Sending data SELECT * FROM spaces_users WHERE nid='632824' ---TRANSACTION 9 1941515457, not started, process no 32573, OS thread id 1252272448 MySQL thread id 1250284, query id 1341615125 10.0.0.7 spaces ---TRANSACTION 9 1941657297, not started, process no 32573, OS thread id 1197078848 MySQL thread id 1249621, query id 1341612880 10.0.0.7 spaces ---TRANSACTION 9 1941829585, not started, process no 32573, OS thread id 1181624640 MySQL thread id 1250322, query id 1341615699 10.0.0.7 spaces ---TRANSACTION 9 1941966956, not started, process no 32573, OS thread id 1286994240 MySQL thread id 1250277, query id 1341612329 10.0.0.7 spaces ---TRANSACTION 9 1941918829, not started, process no 32573, OS thread id 1269733696 MySQL thread id 1250310, query id 1341615458 10.0.0.7 spaces ---TRANSACTION 9 1941941827, not started, process no 32573, OS thread id 1189251392 MySQL thread id 1250304, query id 1341611782 10.0.0.7 spaces ---TRANSACTION 9 1942006264, not started, process no 32573, OS thread id 1285990720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250311, query id 1341615432 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '526299' ---TRANSACTION 9 1942006228, not started, process no 32573, OS thread id 1204103488 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250293, query id 1341615415 10.0.0.7 spaces statistics SELECT * FROM spaces_music_directories WHERE dir_id='0' ---TRANSACTION 9 1942006001, not started, process no 32573, OS thread id 1214740800 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250283, query id 1341615178 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles WHERE dir = '1' ---TRANSACTION 9 1942006411, not started, process no 32573, OS thread id 1207114048 MySQL thread id 1250276, query id 1341615288 10.0.0.7 spaces freeing items SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '344156' ---TRANSACTION 9 1942006022, not started, process no 32573, OS thread id 1233406272 MySQL thread id 1250248, query id 1341614813 10.0.0.7 spaces freeing items SELECT * FROM spaces_music WHERE user_id = '370882' AND dir = '0' ORDER BY level,ctime DESC LIMIT 0,10 ---TRANSACTION 9 1941925410, not started, process no 32573, OS thread id 1208318272 MySQL thread id 1249359, query id 1341612262 spaces 10.0.0.3 spaces ---TRANSACTION 9 1942005734, not started, process no 32573, OS thread id 1271740736 MySQL thread id 1249466, query id 1341613609 spaces 10.0.0.3 spaces ---TRANSACTION 9 1941973611, not started, process no 32573, OS thread id 1227385152 MySQL thread id 1247675, query id 1341613739 10.0.0.7 spaces ---TRANSACTION 9 1941605150, not started, process no 32573, OS thread id 1177409856 MySQL thread id 1248051, query id 1341613805 10.0.0.7 spaces ---TRANSACTION 9 1941775527, not started, process no 32573, OS thread id 1179216192 MySQL thread id 1247166, query id 1341613838 10.0.0.7 spaces ---TRANSACTION 9 1941984736, not started, process no 32573, OS thread id 1147906368 MySQL thread id 1247089, query id 1341612345 10.0.0.7 spaces ---TRANSACTION 9 1941924706, not started, process no 32573, OS thread id 1141283136 MySQL thread id 1246931, query id 1341612589 10.0.0.7 spaces ---TRANSACTION 9 1942006084, not started, process no 32573, OS thread id 1206511936 MySQL thread id 1247088, query id 1341614908 10.0.0.7 spaces freeing items SELECT * FROM spaces_myfiles WHERE file_id = '17642' ---TRANSACTION 9 1941706772, not started, process no 32573, OS thread id 1145698624 MySQL thread id 1246876, query id 1341612665 10.0.0.7 spaces ---TRANSACTION 9 1942006307, not started, process no 32573, OS thread id 1152723264 MySQL thread id 1246875, query id 1341615063 10.0.0.7 spaces freeing items SELECT COUNT(DISTINCT user_id) FROM spaces_favorites WHERE type_id='1' AND object_id='731367' AND closed != 1 ---TRANSACTION 9 1942006542, ACTIVE 53 sec, process no 32573, OS thread id 1305860416 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256890, query id 1341616075 data.spaces.ru 10.0.0.5 spaces Sending data SELECT * FROM spaces_chat_rooms Trx read view will not see trx with id >= 9 1942006543, sees < 9 1942005005 ---TRANSACTION 9 1942006541, ACTIVE 216 sec, process no 32573, OS thread id 1276356928 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250320, query id 1341615700 10.0.0.7 spaces statistics SELECT * FROM spaces_users WHERE name='Resistor' ---TRANSACTION 9 1942006540, ACTIVE 224 sec, process no 32573, OS thread id 1165367616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255443, query id 1341615671 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_1 WHERE nid='92636' AND user_id='153823' Trx read view will not see trx with id >= 9 1942006541, sees < 9 1942005005 ---TRANSACTION 9 1942006539, ACTIVE 227 sec, process no 32573, OS thread id 1204906304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256754, query id 1341615664 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='samarkand' ---TRANSACTION 9 1942006538, ACTIVE 229 sec, process no 32573, OS thread id 1194871104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256748, query id 1341615648 10.0.0.6 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '468328' Trx read view will not see trx with id >= 9 1942006539, sees < 9 1942005005 ---TRANSACTION 9 1942006537, ACTIVE 229 sec, process no 32573, OS thread id 1174600000 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256747, query id 1341615645 10.0.0.6 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '205785' Trx read view will not see trx with id >= 9 1942006538, sees < 9 1942005005 ---TRANSACTION 9 1942006536, ACTIVE 229 sec, process no 32573, OS thread id 1255483712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256742, query id 1341615634 10.0.0.6 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '5259' AND user_id = '423562' ---TRANSACTION 9 1942006535, ACTIVE 229 sec, process no 32573, OS thread id 1171790144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256741, query id 1341615632 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='6' AND user_id='394775' ---TRANSACTION 9 1942006534, ACTIVE 229 sec, process no 32573, OS thread id 1289001280 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256744, query id 1341615630 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_2 WHERE nid='122264' AND user_id='227876' Trx read view will not see trx with id >= 9 1942006535, sees < 9 1942005005 ---TRANSACTION 9 1942006533, ACTIVE 230 sec, process no 32573, OS thread id 1244244288 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253881, query id 1341615608 10.0.0.7 spaces statistics SELECT * FROM spaces_sessions WHERE sid='9698849213485598' Trx read view will not see trx with id >= 9 1942006534, sees < 9 1942005005 ---TRANSACTION 9 1942006532, ACTIVE 230 sec, process no 32573, OS thread id 1200691520 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256734, query id 1341615600 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums_comments WHERE comment_id = '8741803' Trx read view will not see trx with id >= 9 1942006533, sees < 9 1942005005 ---TRANSACTION 9 1942006531, ACTIVE 230 sec, process no 32573, OS thread id 1182628160 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256727, query id 1341615588 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_diary_topics WHERE topic_id = '1235253052' Trx read view will not see trx with id >= 9 1942006532, sees < 9 1942005005 ---TRANSACTION 9 1942006530, ACTIVE 230 sec, process no 32573, OS thread id 1144092992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256730, query id 1341615587 10.0.0.6 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '3839' AND user_id = '514926' ---TRANSACTION 9 1942006529, ACTIVE 230 sec, process no 32573, OS thread id 1193666880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256726, query id 1341615585 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '5406' AND user_id = '604913' ---TRANSACTION 9 1942006528, ACTIVE 230 sec, process no 32573, OS thread id 1232603456 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256723, query id 1341615583 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Nezhdana' ---TRANSACTION 9 1942006527, ACTIVE 230 sec, process no 32573, OS thread id 1162959168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256722, query id 1341615581 10.0.0.6 spaces statistics SELECT * FROM spaces_mail_contact_list_0 WHERE nid='79541' AND user_id='39067' Trx read view will not see trx with id >= 9 1942006528, sees < 9 1942005005 ---TRANSACTION 9 1942006526, ACTIVE 230 sec, process no 32573, OS thread id 1279367488 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256719, query id 1341615580 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Anjutka1' ---TRANSACTION 9 1942006525, ACTIVE 230 sec, process no 32573, OS thread id 1222166848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256715, query id 1341615575 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_mail_contact_list_6 WHERE nid='181500' AND user_id='603137' Trx read view will not see trx with id >= 9 1942006526, sees < 9 1942005005 ---TRANSACTION 9 1942006524, ACTIVE 230 sec, process no 32573, OS thread id 1186842944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256712, query id 1341615574 spaces 10.0.0.3 spaces Sending data SELECT COUNT(*) FROM spaces_lenta_5 WHERE user_id='504634' ---TRANSACTION 9 1942006523, ACTIVE 231 sec, process no 32573, OS thread id 1167976768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256708, query id 1341615533 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='695082' ---TRANSACTION 9 1942006522, ACTIVE 231 sec, process no 32573, OS thread id 1248860480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256704, query id 1341615520 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '289461' Trx read view will not see trx with id >= 9 1942006523, sees < 9 1942005005 ---TRANSACTION 9 1942006521, ACTIVE 231 sec, process no 32573, OS thread id 1236216128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253856, query id 1341615517 10.0.0.7 spaces statistics SELECT * FROM spaces_users WHERE name='AnnaKarenina' ---TRANSACTION 9 1942006520, ACTIVE 231 sec, process no 32573, OS thread id 1222768960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256311, query id 1341615508 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_comm_users WHERE user_id = '691595' ---TRANSACTION 9 1942006519, ACTIVE 231 sec, process no 32573, OS thread id 1210124608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256702, query id 1341615501 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_users WHERE name='Braiana' ---TRANSACTION 9 1942006518, ACTIVE 231 sec, process no 32573, OS thread id 1232804160 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256700, query id 1341615500 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '2005' AND user_id = '11309' ---TRANSACTION 9 1942006517, ACTIVE 231 sec, process no 32573, OS thread id 1165568320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256698, query id 1341615498 10.0.0.6 spaces statistics SELECT * FROM spaces_guests WHERE ip_address='90.139.200.219' AND user_agent='Nokia6233/2.0 (03.70) Profile/MIDP-2.0 Configuration/CLDC-1.1' ---TRANSACTION 9 1942006516, ACTIVE 231 sec, process no 32573, OS thread id 1151318336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256672, query id 1341615485 spaces 10.0.0.3 spaces Sending data SELECT nid FROM spaces_forums_filters WHERE user_id='407707' LIMIT 1 Trx read view will not see trx with id >= 9 1942006517, sees < 9 1942005005 ---TRANSACTION 9 1942006515, ACTIVE 232 sec, process no 32573, OS thread id 1151117632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255862, query id 1341615477 10.0.0.6 spaces Sending data SELECT new_count FROM spaces_diary_topics WHERE user_id='556404' AND new_count != 0 Trx read view will not see trx with id >= 9 1942006516, sees < 9 1942005005 ---TRANSACTION 9 1942006514, ACTIVE 232 sec, process no 32573, OS thread id 1205709120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256220, query id 1341615469 10.0.0.6 spaces Sending data SELECT COUNT(*) from spaces_pictures WHERE user_id = '426889' Trx read view will not see trx with id >= 9 1942006515, sees < 9 1942005005 ---TRANSACTION 9 1942006513, ACTIVE 232 sec, process no 32573, OS thread id 1211730240 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1249620, query id 1341615380 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 9 1942006514, sees < 9 1942005005 ---TRANSACTION 9 1942006512, ACTIVE 232 sec, process no 32573, OS thread id 1177811264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250309, query id 1341615465 10.0.0.7 spaces Sorting result SELECT * from spaces_pictures_albums WHERE user_id='599299' AND parent_album = '133358' ORDER BY level Trx read view will not see trx with id >= 9 1942006513, sees < 9 1942005005 ---TRANSACTION 9 1942006511, ACTIVE 232 sec, process no 32573, OS thread id 1248459072 waiting in InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 1254529, query id 1341615459 10.0.0.6 spaces Sorting result SELECT user_id,topic_id,comment_id,user,ctime,mtime,text,reply, UNIX_TIMESTAMP(ctime) AS unix_ctime from spaces_diary_comments WHERE user_id = '564438' AND topic_id = '1235249735' ORDER BY ctime LIMIT 32,4 Trx read view will not see trx with id >= 9 1942006512, sees < 9 1942005005 ---TRANSACTION 9 1942006510, ACTIVE 232 sec, process no 32573, OS thread id 1192663360 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256460, query id 1341615426 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='11' AND user_id='150186' ---TRANSACTION 9 1942006509, ACTIVE 232 sec, process no 32573, OS thread id 1301645632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256193, query id 1341615283 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='4' Trx read view will not see trx with id >= 9 1942006510, sees < 9 1942005005 ---TRANSACTION 9 1942006508, ACTIVE 232 sec, process no 32573, OS thread id 1201494336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256430, query id 1341615367 spaces 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 9 1942006509, sees < 9 1942005005 ---TRANSACTION 9 1942006507, ACTIVE 232 sec, process no 32573, OS thread id 1282378048 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1246930, query id 1341615382 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1942006508, sees < 9 1942005005 ---TRANSACTION 9 1942006506, ACTIVE 232 sec, process no 32573, OS thread id 1155934528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256387, query id 1341615425 10.0.0.6 spaces statistics SELECT nid FROM spaces_blacklist WHERE user_id = '686224' AND enemy_id = '671695' Trx read view will not see trx with id >= 9 1942006507, sees < 9 1942005005 ---TRANSACTION 9 1942006504, ACTIVE 232 sec, process no 32573, OS thread id 1171388736 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250319, query id 1341615424 10.0.0.7 spaces Sending data SELECT COUNT(*) FROM spaces_myfiles_comments WHERE file_id = '725854' Trx read view will not see trx with id >= 9 1942006505, sees < 9 1942005005 ---TRANSACTION 9 1942006503, ACTIVE 232 sec, process no 32573, OS thread id 1232001344, 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 1256269, query id 1341615329 spaces 10.0.0.3 spaces end UPDATE spaces_users SET last_time = '1242665223', online_time = online_time + '108' WHERE nid = '626996' ---TRANSACTION 9 1942006502, ACTIVE 232 sec, process no 32573, OS thread id 1199286592, 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 1255285, query id 1341615318 spaces 10.0.0.3 spaces end UPDATE spaces_chat_users SET last_time='1242665223' WHERE room_id='11' AND user_id='273897' ---TRANSACTION 9 1942006501, ACTIVE 232 sec, process no 32573, OS thread id 1251268928, 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 1255434, query id 1341615345 spaces 10.0.0.3 spaces end UPDATE spaces_mail_contact_list_5 SET new=0,new_cnt=0 WHERE nid='73056' ---TRANSACTION 9 1942006500, ACTIVE 232 sec, process no 32573, OS thread id 1160149312, 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 1256097, query id 1341615296 spaces 10.0.0.3 spaces end UPDATE spaces_mail_contact_list_4 SET new=0,new_cnt=0 WHERE nid='125247' ---TRANSACTION 9 1942006499, ACTIVE 232 sec, process no 32573, OS thread id 1297631552, 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 1256560, query id 1341615289 spaces 10.0.0.3 spaces update INSERT INTO spaces_lenta_5 SET user_id='589857', author_id='210712', event_id='256', source_id='476466' ---TRANSACTION 9 1942006496, ACTIVE 232 sec, process no 32573, OS thread id 1240230208, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 1256498, query id 1341615285 spaces 10.0.0.3 spaces end UPDATE spaces_comm_users SET atime = NOW() WHERE com_id = '3839' AND user_id = '278162' ---TRANSACTION 9 1942006495, ACTIVE 232 sec, process no 32573, OS thread id 1194068288, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 1256150, query id 1341615257 10.0.0.6 spaces end UPDATE spaces_comm_users SET atime = NOW() WHERE com_id = '651' AND user_id = '125032' ---TRANSACTION 9 1942006494, ACTIVE 232 sec, process no 32573, OS thread id 1150314816, 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 1252938, query id 1341615255 10.0.0.6 spaces end UPDATE spaces_chat_users SET last_time='1242665223' WHERE room_id='11' AND user_id='389758' ---TRANSACTION 9 1942006492, ACTIVE 232 sec, process no 32573, OS thread id 1285790016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256538, query id 1341615262 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_chat WHERE room_id='6' AND ((private = 0 or private = '572277') OR user_id = '572277') Trx read view will not see trx with id >= 9 1942006493, sees < 9 1942005005 ---TRANSACTION 9 1942006490, ACTIVE 232 sec, process no 32573, OS thread id 1254680896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256224, query id 1341615068 10.0.0.6 spaces statistics SELECT * FROM spaces_forums_topics WHERE topic_id = '476421' Trx read view will not see trx with id >= 9 1942006491, sees < 9 1942005005 ---TRANSACTION 9 1942006489, ACTIVE 232 sec, process no 32573, OS thread id 1268930880 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256525, query id 1341615411 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_favorites WHERE user_id = '353129' and flags != 1 Trx read view will not see trx with id >= 9 1942006490, sees < 9 1942005005 ---TRANSACTION 9 1942006488, ACTIVE 232 sec, process no 32573, OS thread id 1292814656 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1248050, query id 1341615406 10.0.0.7 spaces Sorting result SELECT * FROM spaces_music_comments WHERE file_id = '1663123' ORDER BY ctime LIMIT 0,4 Trx read view will not see trx with id >= 9 1942006489, sees < 9 1942005005 ---TRANSACTION 9 1942006487, ACTIVE 232 sec, process no 32573, OS thread id 1285589312, 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 1255754, query id 1341615242 10.0.0.6 spaces end UPDATE spaces_users_anketa SET anketa_level='1242645715' WHERE user_id='233456' ---TRANSACTION 9 1942006484, ACTIVE 232 sec, process no 32573, OS thread id 1263311168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256522, query id 1341615405 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_comm_users WHERE com_id = '5528' Trx read view will not see trx with id >= 9 1942006485, sees < 9 1942005005 ---TRANSACTION 9 1942006483, ACTIVE 232 sec, process no 32573, OS thread id 1169783104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1254301, query id 1341615310 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name = 'Wanek14' ---TRANSACTION 9 1942006477, ACTIVE 232 sec, process no 32573, OS thread id 1215342912 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256476, query id 1341615219 10.0.0.6 spaces Sending data SELECT name FROM spaces_cities WHERE nid = '8785' Trx read view will not see trx with id >= 9 1942006478, sees < 9 1942005005 ---TRANSACTION 9 1942006475, ACTIVE 232 sec, process no 32573, OS thread id 1236416832, 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 1255577, query id 1341615205 spaces 10.0.0.3 spaces end UPDATE spaces_guests SET flags = (flags | '1') WHERE sid='6626229302380020' ---TRANSACTION 9 1942006472, ACTIVE 232 sec, process no 32573, OS thread id 1258694976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253913, query id 1341615384 10.0.0.7 spaces Sorting result SELECT * from spaces_pictures_albums WHERE user_id='184846' AND parent_album = '127704' ORDER BY level Trx read view will not see trx with id >= 9 1942006473, sees < 9 1941996375 ---TRANSACTION 9 1942006471, ACTIVE 232 sec, process no 32573, OS thread id 1259899200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255858, query id 1341615379 spaces 10.0.0.3 spaces Sending data SELECT name FROM spaces_cities WHERE nid = '13043' Trx read view will not see trx with id >= 9 1942006472, sees < 9 1941996375 ---TRANSACTION 9 1942006470, ACTIVE 232 sec, process no 32573, OS thread id 1234409792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256002, query id 1341615371 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_lenta_3 WHERE user_id='301873' AND hidden = 0 ORDER BY nid DESC LIMIT 0, 30 Trx read view will not see trx with id >= 9 1942006471, sees < 9 1941996375 ---TRANSACTION 9 1942006468, ACTIVE 232 sec, process no 32573, OS thread id 1230195008 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1252351, query id 1341615094 10.0.0.6 spaces Sending data SELECT name FROM spaces_cities WHERE nid = '12863' Trx read view will not see trx with id >= 9 1942006469, sees < 9 1941996375 ---TRANSACTION 9 1942006466, ACTIVE 232 sec, process no 32573, OS thread id 1166170432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255774, query id 1341615277 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 9 1942006467, sees < 9 1941996375 ---TRANSACTION 9 1942006465, ACTIVE 232 sec, process no 32573, OS thread id 1287395648 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256166, query id 1341615370 10.0.0.6 spaces Sending data SELECT COUNT(*) from spaces_pictures WHERE user_id = '704007' Trx read view will not see trx with id >= 9 1942006466, sees < 9 1941996375 ---TRANSACTION 9 1942006464, ACTIVE 232 sec, process no 32573, OS thread id 1184233792 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256455, query id 1341615372 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_users_anketa_views WHERE user_id = '203614' AND ctime > '2009-05-18 20:44:57' ---TRANSACTION 9 1942006463, ACTIVE 232 sec, process no 32573, OS thread id 1183832384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256662, query id 1341615207 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_comm_users WHERE com_id = '5153' AND user_id = '428791' Trx read view will not see trx with id >= 9 1942006464, sees < 9 1941996375 ---TRANSACTION 9 1942006462, ACTIVE 232 sec, process no 32573, OS thread id 1195673920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255212, query id 1341615363 10.0.0.6 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='6' AND user_id='548600' ---TRANSACTION 9 1942006461, ACTIVE 232 sec, process no 32573, OS thread id 1239427392 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256694, query id 1341615145 spaces 10.0.0.3 spaces statistics SELECT * FROM spaces_chat_users WHERE room_id='5' AND user_id='47448' ---TRANSACTION 9 1942006460, ACTIVE 232 sec, process no 32573, OS thread id 1143691584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256363, query id 1341615273 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums WHERE forum_id = '1196' Trx read view will not see trx with id >= 9 1942006461, sees < 9 1941996375 ---TRANSACTION 9 1942006459, ACTIVE 232 sec, process no 32573, OS thread id 1284385088 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256079, query id 1341615260 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail_contact_list_6 WHERE user_id='608301' AND user2_id='692276' Trx read view will not see trx with id >= 9 1942006460, sees < 9 1941996375 ---TRANSACTION 9 1942006458, ACTIVE 232 sec, process no 32573, OS thread id 1226582336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256486, query id 1341615188 10.0.0.6 spaces statistics SELECT * FROM spaces_users WHERE name='Onela' ---TRANSACTION 9 1942006456, ACTIVE 232 sec, process no 32573, OS thread id 1261504832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256518, query id 1341615258 10.0.0.6 spaces Sending data SELECT SUM(downloads) FROM spaces_pictures WHERE user_id='706419' AND adult != 1 Trx read view will not see trx with id >= 9 1942006457, sees < 9 1941996375 ---TRANSACTION 9 1942006454, ACTIVE 232 sec, process no 32573, OS thread id 1183631680 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256454, query id 1341615350 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='248248' AND msg_user_id='353190' ORDER BY ctime DESC LIMIT 0,4 Trx read view will not see trx with id >= 9 1942006455, sees < 9 1941996375 ---TRANSACTION 9 1942006452, ACTIVE 232 sec, process no 32573, OS thread id 1278966080 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255968, query id 1341615346 10.0.0.6 spaces statistics SELECT * FROM spaces_users_anketa WHERE user_id='572870' ---TRANSACTION 9 1942006449, ACTIVE 232 sec, process no 32573, OS thread id 1234008384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256546, query id 1341615339 10.0.0.6 spaces Sorting result SELECT * FROM spaces_mail_contacts WHERE user_id='83799' AND (!spam_cnt OR in_cnt) ORDER BY (new_cnt != 0) DESC, mtime DESC LIMIT 0, 10 ---TRANSACTION 9 1942006448, ACTIVE 232 sec, process no 32573, OS thread id 1286592832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253863, query id 1341615338 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles WHERE file_id = '1164158' Trx read view will not see trx with id >= 9 1942006449, sees < 9 1941996375 ---TRANSACTION 9 1942006446, ACTIVE 232 sec, process no 32573, OS thread id 1297832256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256561, query id 1341615335 spaces 10.0.0.3 spaces Sending data SELECT new_count FROM spaces_pictures WHERE user_id='571957' AND new_count != 0 Trx read view will not see trx with id >= 9 1942006447, sees < 9 1941996375 ---TRANSACTION 9 1942006445, ACTIVE 232 sec, process no 32573, OS thread id 1237821760 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255925, query id 1341615334 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_journal WHERE user_id = '337811' ORDER BY mtime DESC LIMIT 0,28 Trx read view will not see trx with id >= 9 1942006503, sees < 9 1942005005 ---TRANSACTION 9 1942006444, ACTIVE 232 sec, process no 32573, OS thread id 1284184384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256534, query id 1341615330 spaces 10.0.0.3 spaces Sorting result SELECT * FROM spaces_journal WHERE user_id = '468019' ORDER BY mtime DESC LIMIT 0,8 ---TRANSACTION 9 1942006434, ACTIVE 232 sec, process no 32573, OS thread id 1260300608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256516, query id 1341615317 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_friend_list WHERE user_id = '571014' Trx read view will not see trx with id >= 9 1942006435, sees < 9 1941996375 ---TRANSACTION 9 1942006428, ACTIVE 232 sec, process no 32573, OS thread id 1298233664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255843, query id 1341615120 10.0.0.6 spaces Sending data SELECT * FROM spaces_users WHERE nid='149194' Trx read view will not see trx with id >= 9 1942006504, sees < 9 1942005005 ---TRANSACTION 9 1942006421, ACTIVE 232 sec, process no 32573, OS thread id 1180621120, thread declared inside InnoDB 443 mysql tables in use 1, locked 1 49 lock struct(s), heap size 6752, 113 row lock(s), undo log entries 1 MySQL thread id 1256178, query id 1341615147 spaces 10.0.0.3 spaces end UPDATE spaces_journal SET flags = (flags & ~(1)) WHERE user_id='253051' ---TRANSACTION 9 1942006412, ACTIVE 232 sec, process no 32573, OS thread id 1229191488, 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 1255042, query id 1341615113 spaces 10.0.0.3 spaces end UPDATE spaces_users SET last_time = '1242665223', online_time = online_time + '113' WHERE nid = '248552' ---TRANSACTION 9 1942006390, ACTIVE 232 sec, process no 32573, OS thread id 1225578816 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256157, query id 1341615246 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums WHERE forum_id = '37468' Trx read view will not see trx with id >= 9 1942006391, sees < 9 1941996375 ---TRANSACTION 9 1942006389, ACTIVE 232 sec, process no 32573, OS thread id 1148909888, 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 1256367, query id 1341615054 spaces 10.0.0.3 spaces end UPDATE advertise_stat SET clicks_cnt = clicks_cnt + 1, spent_money = spent_money + '0.001' WHERE campaign_id='189' AND ctime = date(NOW()) ---TRANSACTION 9 1942006387, ACTIVE 232 sec, process no 32573, OS thread id 1235212608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256493, query id 1341615121 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='587536' Trx read view will not see trx with id >= 9 1942006480, sees < 9 1942005005 ---TRANSACTION 9 1942006378, ACTIVE 232 sec, process no 32573, OS thread id 1219356992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256480, query id 1341615238 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='94372' AND msg_user_id='318056' ORDER BY ctime DESC LIMIT 0,10 Trx read view will not see trx with id >= 9 1942006379, sees < 9 1941996375 ---TRANSACTION 9 1942006367, ACTIVE 232 sec, process no 32573, OS thread id 1245247808, 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 1256502, query id 1341615040 10.0.0.6 spaces end UPDATE spaces_users_anketa SET last_view = NOW() WHERE user_id = '706382' ---TRANSACTION 9 1942006357, ACTIVE 232 sec, process no 32573, OS thread id 1188047168, 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 1256303, query id 1341615006 spaces 10.0.0.3 spaces end UPDATE spaces_chat_users SET last_time='1242665223' WHERE room_id='5' AND user_id='642090' ---TRANSACTION 9 1942006353, ACTIVE 232 sec, process no 32573, OS thread id 1265318208 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253624, query id 1341615139 10.0.0.7 spaces Sending data SELECT * FROM spaces_myfiles_comments WHERE file_id = '686704' ORDER BY ctime LIMIT 0,4 Trx read view will not see trx with id >= 9 1942006354, sees < 9 1941996375 ---TRANSACTION 9 1942006346, ACTIVE 232 sec, process no 32573, OS thread id 1260702016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256175, query id 1341614976 10.0.0.6 spaces Sending data SELECT * FROM spaces_lenta_4 WHERE user_id='401731' ORDER BY nid DESC LIMIT 0, 8 Trx read view will not see trx with id >= 9 1942006347, sees < 9 1941996375 ---TRANSACTION 9 1942006341, ACTIVE 232 sec, process no 32573, OS thread id 1167173952 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256240, query id 1341615184 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_users WHERE nid='130441' Trx read view will not see trx with id >= 9 1942006445, sees < 9 1941996375 ---TRANSACTION 9 1942006335, ACTIVE 232 sec, process no 32573, OS thread id 1248258368 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255637, query id 1341615179 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail_data_4 WHERE contact_id='136327' ORDER BY nid DESC LIMIT 0,4 Trx read view will not see trx with id >= 9 1942006336, sees < 9 1941996375 ---TRANSACTION 9 1942006296, ACTIVE 232 sec, process no 32573, OS thread id 1155733824 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256185, query id 1341615013 10.0.0.6 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1942006297, sees < 9 1941996375 ---TRANSACTION 9 1942006255, ACTIVE 232 sec, process no 32573, OS thread id 1229793600 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256059, query id 1341614859 spaces 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1942006256, sees < 9 1941996375 ---TRANSACTION 9 1942006244, ACTIVE 232 sec, process no 32573, OS thread id 1273145664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256526, query id 1341615070 10.0.0.6 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '110' ORDER BY level Trx read view will not see trx with id >= 9 1942006245, sees < 9 1941996375 ---TRANSACTION 9 1942006200, ACTIVE 232 sec, process no 32573, OS thread id 1230596416 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1247165, query id 1341615016 10.0.0.7 spaces Sending data SELECT * FROM spaces_shared_zone_files WHERE L2 = '1700' ORDER BY ctime DESC LIMIT 0,5 Trx read view will not see trx with id >= 9 1942006201, sees < 9 1941996375 ---TRANSACTION 9 1942006166, ACTIVE 232 sec, process no 32573, OS thread id 1265518912 waiting in InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 1256164, query id 1341614699 10.0.0.6 spaces Sorting result SELECT * FROM spaces_forums_comments WHERE topic_id = '4120' AND user_id = '169492' ORDER BY ctime DESC LIMIT 1 Trx read view will not see trx with id >= 9 1942006167, sees < 9 1941996375 ---TRANSACTION 9 1942006141, ACTIVE 232 sec, process no 32573, OS thread id 1196677440 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1250303, query id 1341614703 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='8' Trx read view will not see trx with id >= 9 1942006142, sees < 9 1941996375 ---TRANSACTION 9 1942006126, ACTIVE 232 sec, process no 32573, OS thread id 1271941440 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1254742, query id 1341614718 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1942006127, sees < 9 1941996375 ---TRANSACTION 9 1942006120, ACTIVE 232 sec, process no 32573, OS thread id 1223772480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256215, query id 1341614677 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_chat WHERE room_id='12' AND ((private = 0 or private = '456362') OR user_id = '456362') Trx read view will not see trx with id >= 9 1942006121, sees < 9 1941996375 ---TRANSACTION 9 1942006110, ACTIVE 232 sec, process no 32573, OS thread id 1231599936 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256489, query id 1341614950 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_chat WHERE room_id='11' AND ((private = 0 or private = '245674') OR user_id = '245674') Trx read view will not see trx with id >= 9 1942006111, sees < 9 1941996375 ---TRANSACTION 9 1942006091, ACTIVE 232 sec, process no 32573, OS thread id 1204304192 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256356, query id 1341614902 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_lenta_4 WHERE user_id='466753' AND hidden = 0 ORDER BY nid DESC LIMIT 0, 30 Trx read view will not see trx with id >= 9 1942006092, sees < 9 1941996375 ---TRANSACTION 9 1942006075, ACTIVE 232 sec, process no 32573, OS thread id 1239628096 waiting in InnoDB queue mysql tables in use 3, locked 1 MySQL thread id 1256497, query id 1341614595 spaces 10.0.0.3 spaces Updating UPDATE spaces_diary_tracking SET page='1',comments_cnt='11', last_comment_id='6599518' WHERE user_id='65657' AND topic_id='1235245196' Trx read view will not see trx with id >= 9 1942006076, sees < 9 1941996375 ---TRANSACTION 9 1942006024, ACTIVE 232 sec, process no 32573, OS thread id 1144695104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255249, query id 1341614792 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='54450' AND msg_user_id='386588' ORDER BY ctime DESC LIMIT 0,4 Trx read view will not see trx with id >= 9 1942006025, sees < 9 1941996375 ---TRANSACTION 9 1942005974, ACTIVE 232 sec, process no 32573, OS thread id 1304856896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256664, query id 1341614743 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_6 WHERE user_id='610323' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 1942005975, sees < 9 1941996375 ---TRANSACTION 9 1942005957, ACTIVE 232 sec, process no 32573, OS thread id 1143290176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256127, query id 1341614714 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_data_3 WHERE contact_id='25953' ORDER BY nid DESC LIMIT 0,10 Trx read view will not see trx with id >= 9 1942005958, sees < 9 1941996375 ---TRANSACTION 9 1942005955, ACTIVE 232 sec, process no 32573, OS thread id 1207716160 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1249358, query id 1341614708 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='152873' AND msg_user_id='171282' ORDER BY ctime DESC LIMIT 0,4 Trx read view will not see trx with id >= 9 1942005956, sees < 9 1941996375 ---TRANSACTION 9 1942005943, ACTIVE 232 sec, process no 32573, OS thread id 1161554240 waiting in InnoDB queue mysql tables in use 1, locked 1 2011 lock struct(s), heap size 260080, 5013 row lock(s) MySQL thread id 1255734, query id 1341613912 10.0.0.6 spaces Updating UPDATE spaces_journal SET flags = (flags & ~(1)) WHERE user_id='203998' ---TRANSACTION 9 1942005929, ACTIVE 232 sec, process no 32573, OS thread id 1189853504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256438, query id 1341614671 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '355' ORDER BY level Trx read view will not see trx with id >= 9 1942005930, sees < 9 1941996375 ---TRANSACTION 9 1942005920, ACTIVE 232 sec, process no 32573, OS thread id 1174198592 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1247674, query id 1341614674 10.0.0.7 spaces Sending data SELECT * FROM spaces_shared_zone_files WHERE L1 = '1690' AND adult=0 ORDER BY ctime DESC LIMIT 10,5 Trx read view will not see trx with id >= 9 1942005921, sees < 9 1941996375 ---TRANSACTION 9 1942005914, ACTIVE 232 sec, process no 32573, OS thread id 1282980160, thread declared inside InnoDB 130 mysql tables in use 1, locked 1 2219 lock struct(s), heap size 276464, 5752 row lock(s), undo log entries 1 MySQL thread id 1256533, query id 1341613705 spaces 10.0.0.3 spaces end UPDATE spaces_journal SET flags = (flags & ~(1)) WHERE user_id='133297' ---TRANSACTION 9 1942005912, ACTIVE 232 sec, process no 32573, OS thread id 1292011840 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256288, query id 1341614669 10.0.0.6 spaces Sending data SELECT COUNT(*) FROM spaces_chat WHERE room_id='12' AND ((private = 0 or private = '443965') OR user_id = '443965') Trx read view will not see trx with id >= 9 1942006086, sees < 9 1941996375 ---TRANSACTION 9 1942005908, ACTIVE 232 sec, process no 32573, OS thread id 1211128128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255198, query id 1341614665 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums_comments WHERE topic_id = '476296' AND deleted_by = 0 ORDER BY ctime LIMIT 0,30 Trx read view will not see trx with id >= 9 1942005909, sees < 9 1941996375 ---TRANSACTION 9 1942005901, ACTIVE 232 sec, process no 32573, OS thread id 1251469632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256691, query id 1341614653 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_mail_contact_list_6 WHERE user_id='623763' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 1942005902, sees < 9 1941996375 ---TRANSACTION 9 1942005834, ACTIVE 233 sec, process no 32573, OS thread id 1262508352 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256084, query id 1341614279 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail_contact_list_6 WHERE user_id='631076' AND contact_type=0 ORDER BY new DESC, mtime DESC LIMIT 0, 30 Trx read view will not see trx with id >= 9 1942005835, sees < 9 1941996375 ---TRANSACTION 9 1942005813, ACTIVE 233 sec, process no 32573, OS thread id 1196075328 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253378, query id 1341613540 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1942005814, sees < 9 1941996375 ---TRANSACTION 9 1942005731, ACTIVE 234 sec, process no 32573, OS thread id 1150114112 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255713, query id 1341613565 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_forums WHERE category_id = '3668' Trx read view will not see trx with id >= 9 1942005732, sees < 9 1941996375 ---TRANSACTION 9 1942005721, ACTIVE 234 sec, process no 32573, OS thread id 1195473216 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1254162, query id 1341613563 10.0.0.7 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1942005722, sees < 9 1941996375 ---TRANSACTION 9 1942005698, ACTIVE 234 sec, process no 32573, OS thread id 1169582400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256445, query id 1341613610 10.0.0.6 spaces Sending data SELECT * FROM spaces_lenta_2 WHERE user_id='242133' ORDER BY nid DESC LIMIT 0, 15 Trx read view will not see trx with id >= 9 1942005699, sees < 9 1941996375 ---TRANSACTION 9 1942005695, ACTIVE 234 sec, process no 32573, OS thread id 1256888640 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256267, query id 1341613606 10.0.0.6 spaces Sending data SELECT * FROM spaces_chat WHERE room_id='6' AND ((private = 0 or private = '702499') OR user_id = '702499') ORDER BY msg_id DESC LIMIT 0, 10 Trx read view will not see trx with id >= 9 1942005809, sees < 9 1941996375 ---TRANSACTION 9 1942005693, ACTIVE 234 sec, process no 32573, OS thread id 1170786624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1254043, query id 1341613581 10.0.0.7 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '1735' ORDER BY rate DESC LIMIT 15,5 Trx read view will not see trx with id >= 9 1942005694, sees < 9 1941996375 ---TRANSACTION 9 1942005620, ACTIVE 234 sec, process no 32573, OS thread id 1287194944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1256470, query id 1341613455 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_chat WHERE room_id='158' AND ((private = 0 or private = '289571') OR user_id = '289571') ORDER BY msg_id DESC LIMIT 0, 25 Trx read view will not see trx with id >= 9 1942005658, sees < 9 1941996375 ---TRANSACTION 9 1942005607, ACTIVE 234 sec, process no 32573, OS thread id 1146100032 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1254782, query id 1341613419 10.0.0.7 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '52' ORDER BY rate DESC LIMIT 75,5 Trx read view will not see trx with id >= 9 1942005608, sees < 9 1941996375 ---TRANSACTION 9 1942005471, ACTIVE 234 sec, process no 32573, OS thread id 1193867584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1253469, query id 1341613200 10.0.0.7 spaces Sorting result SELECT * FROM spaces_shared_zone_files WHERE shared_dir = '806' ORDER BY rate DESC LIMIT 540,5 Trx read view will not see trx with id >= 9 1942005472, sees < 9 1941996375 ---TRANSACTION 9 1942005359, ACTIVE 234 sec, process no 32573, OS thread id 1249061184 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255746, query id 1341612967 spaces 10.0.0.3 spaces Sending data SELECT * FROM advertise_places WHERE place_id='7' Trx read view will not see trx with id >= 9 1942005360, sees < 9 1941996375 ---TRANSACTION 9 1942005174, ACTIVE 235 sec, process no 32573, OS thread id 1276557632 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255883, query id 1341612747 10.0.0.6 spaces Sending data SELECT * FROM spaces_mail USE INDEX (user_id_2) WHERE user_id='44969' AND msg_user_id='235092' ORDER BY ctime DESC LIMIT 0,8 Trx read view will not see trx with id >= 9 1942005175, sees < 9 1941996375 ---TRANSACTION 9 1942005005, ACTIVE 235 sec, process no 32573, OS thread id 1220360512 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1255923, query id 1341612453 spaces 10.0.0.3 spaces Sending data SELECT * FROM spaces_favorites WHERE user_id='661807' AND token='В' ORDER BY nid DESC LIMIT 0,15 Trx read view will not see trx with id >= 9 1942005006, sees < 9 1941996375 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 1 36862067 OS file reads, 9508753 OS file writes, 1266244 OS fsyncs 10.50 reads/s, 20089 avg bytes/read, 42.62 writes/s, 5.87 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1159, free list len 2753, seg size 3913, 6055177 inserts, 6052913 merged recs, 1374235 merges Hash table size 25499819, node heap has 76606 buffer(s) 0.00 hash searches/s, 85.24 non-hash searches/s --- LOG --- Log sequence number 551 64571792 Log flushed up to 551 64555963 Last checkpoint at 550 3404387296 0 pending log writes, 0 pending chkp writes 469605 log i/o's done, 1.25 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 14161840128; in additional pool allocated 16777216 Dictionary memory allocated 1334144 Buffer pool size 786432 Free buffers 0 Database pages 709795 Modified db pages 89789 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 42056179, created 831575, written 12276856 12.87 reads/s, 0.00 creates/s, 69.24 writes/s Buffer pool hit rate 973 / 1000 -------------- ROW OPERATIONS -------------- 16 queries inside InnoDB, 230 queries in queue 85 read views open inside InnoDB Main thread process no. 32573, id 1140881728, state: flushing buffer pool pages Number of rows inserted 25788906, updated 73973557, deleted 9368283, read 128266491522 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================