Type	Name	Status
InnoDB		\n=====================================\n130423 13:32:09 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 23 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 408852 1_second, 407802 sleeps, 40883 10_second, 15 background, 15 flush\nsrv_master_thread log flush and writes: 415971\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 2207527, signal count 138524975\nMutex spin waits 194116908, rounds 123564793, OS waits 227717\nRW-shared spins 42441126, rounds 77112761, OS waits 306802\nRW-excl spins 13367092, rounds 227320767, OS waits 1571333\nSpin rounds per wait: 0.64 mutex, 1.82 RW-shared, 17.01 RW-excl\n--------\nFILE I/O\n--------\nI/O thread 0 state: waiting for completed aio requests (insert buffer thread)\nI/O thread 1 state: waiting for completed aio requests (log thread)\nI/O thread 2 state: waiting for completed aio requests (read thread)\nI/O thread 3 state: waiting for completed aio requests (read thread)\nI/O thread 4 state: waiting for completed aio requests (read thread)\nI/O thread 5 state: waiting for completed aio requests (read thread)\nI/O thread 6 state: waiting for completed aio requests (write thread)\nI/O thread 7 state: waiting for completed aio requests (write thread)\nI/O thread 8 state: waiting for completed aio requests (write thread)\nI/O thread 9 state: waiting for completed aio requests (write thread)\nPending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,\n ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0\nPending flushes (fsync) log: 0; buffer pool: 0\n1199010 OS file reads, 19821102 OS file writes, 11528471 OS fsyncs\n0.04 reads/s, 16384 avg bytes/read, 61.61 writes/s, 42.56 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 5, seg size 7, 9519 merges\nmerged operations:\n insert 17833, delete mark 766, delete 605\ndiscarded operations:\n insert 0, delete mark 0, delete 0\nHash table size 76499243, node heap has 35513 buffer(s)\n149274.99 hash searches/s, 7372.24 non-hash searches/s\n---\nLOG\n---\nLog sequence number 171430700854\nLog flushed up to   171430700854\nLast checkpoint at  171429941187\nMax checkpoint age    7782360\nCheckpoint age target 7539162\nModified age          759667\nCheckpoint age        759667\n0 pending log writes, 0 pending chkp writes\n11225123 log i/o's done, 42.04 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal memory allocated 39692795904; in additional pool allocated 0\nInternal hash tables (constant factor + variable factor)\n    Adaptive hash index 1193843152 \t(611993944 + 581849208)\n    Page hash           38250584 (buffer pool 0 only)\n    Dictionary cache    154726912 \t(152999984 + 1726928)\n    File system         88720 \t(82672 + 6048)\n    Lock system         95629336 \t(95624824 + 4512)\n    Recovery system     0 \t(0 + 0)\nDictionary memory allocated 1726928\nBuffer pool size        2359295\nBuffer pool size, bytes 38654689280\nFree buffers            1098357\nDatabase pages          1225425\nOld database pages      452373\nModified db pages       975\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1087, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 1198987, created 26438, written 8384051\n0.04 reads/s, 0.13 creates/s, 19.13 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 1225425, unzip_LRU len: 0\nI/O sum[0]:cur[0], unzip sum[0]:cur[0]\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n1 read views open inside InnoDB\n---OLDEST VIEW---\nNormal read view\nRead view low limit trx n:o 7AF1E6FA\nRead view up limit trx id 7AF1E6FA\nRead view low limit trx id 7AF1E6FA\nRead view individually stored trx ids:\n-----------------\nMain thread process no. 4519, id 139986436200192, state: flushing log\nNumber of rows inserted 3967361, updated 1559892, deleted 3449055, read 141330698222\n12.35 inserts/s, 8.61 updates/s, 0.30 deletes/s, 314056.39 reads/s\n------------\nTRANSACTIONS\n------------\nTrx id counter 7AF1E787\nPurge done for trx's n:o < 7AF1E6F7 undo n:o < 0\nHistory list length 3169\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 0, not started\nMySQL thread id 5310989, OS thread handle 0x7f50ffc71700, query id 355861904 localhost root\nshow engine innodb status\n---TRANSACTION 0, not started\nMySQL thread id 5310988, OS thread handle 0x7f510b30c700, query id 355861901 web5.dvidshub.net 192.168.1.176 www\n---TRANSACTION 0, not started\nMySQL thread id 5310987, OS thread handle 0x7f4fbfb6d700, query id 355861900 web5.dvidshub.net 192.168.1.176 www\n---TRANSACTION 0, not started\nMySQL thread id 5310986, OS thread handle 0x7f510bf7d700, query id 355861894 web4.dvidshub.net 192.168.1.175 www\n---TRANSACTION 0, not started\nMySQL thread id 5310985, OS thread handle 0x7f510bd34700, query id 355861893 web4.dvidshub.net 192.168.1.175 www\n---TRANSACTION 0, not started\nMySQL thread id 5310984, OS thread handle 0x7f510b659700, query id 355861891 web5.dvidshub.net 192.168.1.176 www\n---TRANSACTION 7AF1E786, not started\nMySQL thread id 5310983, OS thread handle 0x7f50f408e700, query id 355861902 web2.dvidshub.net 192.168.1.202 www\n---TRANSACTION 7AF1E784, not started\nMySQL thread id 5310976, OS thread handle 0x7f51204b7700, query id 355861898 web2.dvidshub.net 192.168.1.202 www\n---TRANSACTION 7AF14D3E, not started\nMySQL thread id 5308388, OS thread handle 0x7f50f53da700, query id 355769867 app6.dvidshub.net 192.168.1.129 www\n---TRANSACTION 7AF1E339, not started\nMySQL thread id 5278085, OS thread handle 0x7f510baaa700, query id 355858391 app1.dvidshub.net 192.168.1.111 www\n---TRANSACTION 7AF1DE35, not started\nMySQL thread id 5267263, OS thread handle 0x7f510b2cb700, query id 355855350 app5.dvidshub.net 192.168.1.231 www\n---TRANSACTION 7AACABEA, not started\nMySQL thread id 5202855, OS thread handle 0x7f51200e8700, query id 349538843 192.168.1.20 bmorton\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n