===================================== 090911 8:41:12 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 4 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4299, signal count 4238 Mutex spin waits 0, rounds 75060, OS waits 1810 RW-shared spins 4722, OS waits 2335; RW-excl spins 303, OS waits 82 ------------ TRANSACTIONS ------------ Trx id counter 0 19596631 Purge done for trx's n:o < 0 19596567 undo n:o < 0 0 History list length 41 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 1036, OS thread id 1148070208 MySQL thread id 29859, query id 26306366 localhost root show innodb status ---TRANSACTION 0 0, not started, process no 1036, OS thread id 1155524928 MySQL thread id 29851, query id 26306124 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0015') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 245,35 ---TRANSACTION 0 19596630, not started, process no 1036, OS thread id 1154726208 MySQL thread id 29848, query id 26305560 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0017') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 ---TRANSACTION 0 0, not started, process no 1036, OS thread id 1153661248 MySQL thread id 29844, query id 26304151 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0012') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 35,35 ---TRANSACTION 0 0, not started, process no 1036, OS thread id 1145141568 MySQL thread id 29836, query id 26302544 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 245,35 ---TRANSACTION 0 19596629, not started, process no 1036, OS thread id 1143810368 MySQL thread id 29822, query id 26300570 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0016') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 245,35 ---TRANSACTION 0 0, not started, process no 1036, OS thread id 1151265088 MySQL thread id 29819, query id 26300409 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 210,35 ---TRANSACTION 0 0, not started, process no 1036, OS thread id 1147271488 MySQL thread id 29810, query id 26298979 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0013','G0005','G0006','G0008') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 ---TRANSACTION 0 19596535, not started, process no 1036, OS thread id 1143011648 MySQL thread id 27373, query id 26297908 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0033') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 ---TRANSACTION 0 19596628, not started, process no 1036, OS thread id 1143544128 MySQL thread id 24619, query id 26298057 localhost 127.0.0.1 windin Table lock select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0001') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 ---TRANSACTION 0 19596626, ACTIVE 1309 sec, process no 1036, OS thread id 1150732608, 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 29769, query id 26297893 localhost 127.0.0.1 windin update insert into tb_livenews_section_disk (section,newsid,sourceid,channel,publishdate,lan) values(new.section,new.newsid,new.sourceid,new.channel,new.publishdate,new.lan) -------- 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 49909 OS file reads, 90419 OS file writes, 11208 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 1, free list len 33, seg size 35, 2372 inserts, 2372 merged recs, 760 merges Hash table size 1106407, node heap has 246 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 1 2401787418 Log flushed up to 1 2401787418 Last checkpoint at 1 2401787418 0 pending log writes, 0 pending chkp writes 59249 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 621628994; in additional pool allocated 4537600 Dictionary memory allocated 252840 Buffer pool size 32768 Free buffers 7332 Database pages 25190 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 77767, created 41203, written 65552 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 1036, id 1140881728, state: waiting for server activity Number of rows inserted 2456004, updated 5, deleted 60778, read 9269551 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================