mysql> show innodb status \G select sleep(10); show innodb status \G *************************** 1. row *************************** Status: ===================================== 080624 23:09:09 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 35 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 34732, signal count 34728 Mutex spin waits 0, rounds 7509646, OS waits 4566 RW-shared spins 1929, OS waits 15; RW-excl spins 2482, OS waits 57 ------------ TRANSACTIONS ------------ Trx id counter 0 3981 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 75925504 MySQL thread id 1338, query id 1405 localhost root show innodb status ---TRANSACTION 0 3980, ACTIVE 0 sec, OS thread id 76086272 mysql tables in use 1, locked 0 MySQL thread id 1340, query id 1404 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 3981, sees < 0 3981 -------- 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, 74 OS file writes, 40 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 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 5038, node heap has 7 buffer(s) 15009.83 hash searches/s, 470.87 non-hash searches/s --- LOG --- Log sequence number 0 13211949 Log flushed up to 0 13211949 Last checkpoint at 0 13211949 0 pending log writes, 0 pending chkp writes 34 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19753616; in additional pool allocated 922496 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 167 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread id 75659776, state: sleeping Number of rows inserted 6000, updated 0, deleted 0, read 6271019 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 15471.47 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.08 sec) +-----------+ | sleep(10) | +-----------+ | 0 | +-----------+ 1 row in set (10.00 sec) *************************** 1. row *************************** Status: ===================================== 080624 23:09:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 10 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 34732, signal count 34728 Mutex spin waits 0, rounds 7509646, OS waits 4566 RW-shared spins 1929, OS waits 15; RW-excl spins 2482, OS waits 57 ------------ TRANSACTIONS ------------ Trx id counter 0 4043 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 75925504 MySQL thread id 1338, query id 1469 localhost root show innodb status ---TRANSACTION 0 4042, ACTIVE 0 sec, OS thread id 76086272 fetching rows, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1340, query id 1468 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 4043, sees < 0 4043 -------- 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, 74 OS file writes, 40 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 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 5038, node heap has 7 buffer(s) 33019.60 hash searches/s, 762.42 non-hash searches/s --- LOG --- Log sequence number 0 13211949 Log flushed up to 0 13211949 Last checkpoint at 0 13211949 0 pending log writes, 0 pending chkp writes 34 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19753616; in additional pool allocated 922496 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 167 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread id 75659776, state: sleeping Number of rows inserted 6000, updated 0, deleted 0, read 6608686 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 33763.32 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.00 sec) $vm_stat 5 Mach Virtual Memory Statistics: (page size of 4096 bytes, cache hits 94%) free active inac wire faults copy zerofill reactive pageins pageout 35858 274367 129145 84910 781662269 122161524 260708201 5482457 764082 431785 35498 275661 129510 83618 20565 1 20197 0 0 0 34982 274169 129619 85517 22916 39 22125 0 0 0 35676 274970 129346 84295 20597 10 20255 0 0 0 35983 274440 129063 84801 19843 35 19027 0 0 0 35815 275616 129227 83629 21986 352 20322 0 0 0 35701 275314 129337 83935 20678 20 20541 0 0 0 35314 275636 129683 83654 22890 293 20881 0 0 0 35574 274651 129421 84641 23223 239 20574 0 0 0 35669 275613 129339 83666 22469 35 21730 0 0 0 35809 274352 129231 84895 21462 34 20754 0 0 0