mysql> show innodb status \G *************************** 1. row *************************** Status: ===================================== 080624 23:07:10 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 17 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 13084, signal count 13083 Mutex spin waits 0, rounds 2807986, OS waits 1477 RW-shared spins 722, OS waits 10; RW-excl spins 1098, OS waits 31 ------------ TRANSACTIONS ------------ Trx id counter 0 3298 Purge done for trx's n:o < 0 1800 undo n:o < 0 0 History list length 2 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 76086272 MySQL thread id 1331, query id 713 localhost root show innodb status ---TRANSACTION 0 3297, ACTIVE 0 sec, OS thread id 75925504 fetching rows, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1329, query id 711 localhost 127.0.0.1 root Sending data select * from vault_safes_log where i64safeid = 48 Trx read view will not see trx with id >= 0 3298, sees < 0 3296 ---TRANSACTION 0 3296, ACTIVE 0 sec, OS thread id 75970048 fetching rows, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1328, query id 710 localhost 127.0.0.1 root Sending data select * from vault_safes_log where i64safeid = 48 Trx read view will not see trx with id >= 0 3297, sees < 0 3295 -------- 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 29 OS file reads, 62 OS file writes, 28 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.18 writes/s, 0.18 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 5038, node heap has 7 buffer(s) 45100.52 hash searches/s, 1571.08 non-hash searches/s --- LOG --- Log sequence number 0 13211919 Log flushed up to 0 13211919 Last checkpoint at 0 13211919 0 pending log writes, 0 pending chkp writes 28 log i/o's done, 0.06 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19753792; in additional pool allocated 926080 Buffer pool size 512 Free buffers 331 Database pages 174 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 23, created 151, written 164 0.00 reads/s, 0.00 creates/s, 0.06 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 2 queries inside InnoDB, 0 queries in queue 3 read views open inside InnoDB Main thread id 75659776, state: sleeping Number of rows inserted 6000, updated 0, deleted 0, read 2570020 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 46655.14 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.00 sec) mysql> select sleep(10); show innodb status \G +-----------+ | sleep(10) | +-----------+ | 0 | +-----------+ 1 row in set (10.04 sec) *************************** 1. row *************************** Status: ===================================== 080624 23:07:33 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 23 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 19114, signal count 19112 Mutex spin waits 0, rounds 4135584, OS waits 2253 RW-shared spins 1070, OS waits 13; RW-excl spins 1534, OS waits 37 ------------ TRANSACTIONS ------------ Trx id counter 0 3484 Purge done for trx's n:o < 0 1800 undo n:o < 0 0 History list length 2 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 76086272 MySQL thread id 1331, query id 901 localhost root show innodb status ---TRANSACTION 0 3483, ACTIVE 0 sec, OS thread id 75925504 fetching rows, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1329, query id 900 localhost 127.0.0.1 root Sending data select * from vault_safes_log where i64safeid = 48 Trx read view will not see trx with id >= 0 3484, sees < 0 3482 ---TRANSACTION 0 3482, ACTIVE 0 sec, OS thread id 75970048 fetching rows, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1328, query id 899 localhost 127.0.0.1 root Sending data select * from vault_safes_log where i64safeid = 48 Trx read view will not see trx with id >= 0 3483, sees < 0 3481 -------- 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 29 OS file reads, 66 OS file writes, 32 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.17 writes/s, 0.17 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 5038, node heap has 7 buffer(s) 42287.25 hash searches/s, 1458.07 non-hash searches/s --- LOG --- Log sequence number 0 13211929 Log flushed up to 0 13211929 Last checkpoint at 0 13211929 0 pending log writes, 0 pending chkp writes 30 log i/o's done, 0.09 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19753792; in additional pool allocated 926080 Buffer pool size 512 Free buffers 331 Database pages 174 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 23, created 151, written 165 0.00 reads/s, 0.00 creates/s, 0.04 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 2 queries inside InnoDB, 0 queries in queue 3 read views open inside InnoDB Main thread id 75659776, state: sleeping Number of rows inserted 6000, updated 0, deleted 0, read 3575708 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 43723.66 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.00 sec) Mach Virtual Memory Statistics: (page size of 4096 bytes, cache hits 94%) free active inac wire faults copy zerofill reactive pageins pageout 34452 275237 130213 84385 782111231 122166673 261117409 5482457 764242 431785 33982 275617 130683 84005 27842 0 27687 0 0 0 34373 275917 130413 83584 27591 2 27467 0 0 0 34913 275585 129767 84022 29070 11 28435 0 0 0 34317 275885 130361 83724 29276 352 27415 0 0 0 34545 274577 130131 85034 27380 9 27122 0 0 0 34230 275911 130422 83724 28540 22 28037 0 0 0 34727 275609 130053 83898 26770 16 26136 0 0 0 34869 274881 129808 84729 28473 13 27531 0 0 0 34354 274923 130313 84697 22323 34 21716 0 1 0 33626 275252 131015 84394 17482 369 13687 0 88 0 33728 275619 130910 84030 14030 31 13626 0 0 0 30408 275927 134223 83729 20108 25 19483 0 2 0 29929 275003 134699 84656 14776 17 14045 0 0 0 29918 275933 134707 83729 15360 3 15256 0 0 0 30045 275652 134563 84027 17069 34 16327 0 0 0 30672 275271 133936 84408 22328 347 20444 0 0 0