| ===================================== 131122 21:13:31 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 25 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 27604, signal count 26023 Mutex spin waits 0, rounds 513658, OS waits 3494 RW-shared spins 19370, OS waits 6625; RW-excl spins 20516, OS waits 17477 ------------ TRANSACTIONS ------------ Trx id counter 0 258502042 Purge done for trx's n:o < 0 258501983 undo n:o < 0 0 History list length 11 Total number of lock structs in row lock hash table 6 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 5744 MySQL thread id 1445, query id 296601 localhost 127.0.0.1 root show engine innodb status ---TRANSACTION 0 258502040, not started, OS thread id 5584 MySQL thread id 1570, query id 296595 localhost 127.0.0.1 ukm_server freeing ite ms select h.id from trm_out_receipt_header h force index(primary) inner join trm_ou t_receipt_footer f on h.cash_id = f.cash_id and h.id = f.id where h.cash_id = 99 9001005 and h.id > 125599 order by h.id ---TRANSACTION 0 258501975, not started, OS thread id 1060 MySQL thread id 1564, query id 296571 localhost 127.0.0.1 ukm_server ---TRANSACTION 0 258376678, not started, OS thread id 4036 MySQL thread id 560, query id 126788 localhost 127.0.0.1 ukm_server ---TRANSACTION 0 258502030, not started, OS thread id 4728 MySQL thread id 70, query id 296503 localhost 127.0.0.1 ukm_server ---TRANSACTION 0 258502014, not started, OS thread id 4688 MySQL thread id 62, query id 296417 localhost 127.0.0.1 ukm_server ---TRANSACTION 0 258502041, ACTIVE 1 sec, OS thread id 4864, thread declared ins ide InnoDB 385 mysql tables in use 2, locked 0 MySQL thread id 1, query id 296597 localhost 127.0.0.1 root Copying to tmp table select COUNT ( 1 ) from ( select article , max ( concat ( fTime , fVal , deleted ) ) xxx from xxx_update_itms2_v u group by article ) u where ( SUBSTRING ( u.xx x , 3 , 1 ) ='0' and SUBSTRING ( u.xxx , 1 , 2 ) ='11' ) or ( SUBSTRING ( u.xxx , 3 , 1 ) ='1' and SUBSTRING ( u.xxx , 1 , 2 ) <> '11' ) Trx read view will not see trx with id >= 0 258502042, sees < 0 258501997 ---TRANSACTION 0 258502028, ACTIVE 6 sec, OS thread id 984 6 lock struct(s), heap size 1024, undo log entries 3 MySQL thread id 1569, query id 296594 localhost 127.0.0.1 ukm_server freeing ite ms SAVEPOINT T1 Trx read view will not see trx with id >= 0 258502029, sees < 0 258501975 ---TRANSACTION 0 258501997, ACTIVE 16 sec, OS thread id 456 19 lock struct(s), heap size 1024, undo log entries 204 MySQL thread id 1566, query id 296600 localhost 127.0.0.1 ukm_server Trx read view will not see trx with id >= 0 258501998, sees < 0 258501972 -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (read thread) I/O thread 4 state: wait Windows aio (read thread) I/O thread 5 state: wait Windows aio (write thread) I/O thread 6 state: wait Windows aio (write thread) I/O thread 7 state: wait Windows aio (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 305468 OS file reads, 760441 OS file writes, 49580 OS fsyncs 1.84 reads/s, 16384 avg bytes/read, 10.40 writes/s, 1.80 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 36, seg size 38, 932579 inserts, 932579 merged recs, 20049 merges Hash table size 3320377, used cells 924986, node heap has 1063 buffer(s) 3896.00 hash searches/s, 89.44 non-hash searches/s --- LOG --- Log sequence number 10 3808648089 Log flushed up to 10 3808648089 Last checkpoint at 10 3808543948 0 pending log writes, 0 pending chkp writes 32060 log i/o's done, 1.32 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 934612814; in additional pool allocated 10485760 Buffer pool size 51200 Free buffers 0 Database pages 50137 Modified db pages 249 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 305458, created 533688, written 713924 1.84 reads/s, 0.88 creates/s, 8.80 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 4 read views open inside InnoDB Main thread id 3360, state: sleeping Number of rows inserted 29353582, updated 19445, deleted 7550, read 199307679 15.24 inserts/s, 3.88 updates/s, 1.68 deletes/s, 588519.50 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================