mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
Status:
=====================================
070419 20:38:00 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 31 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 100, signal count 100
Mutex spin waits 13, rounds 184, OS waits 1
RW-shared spins 198, OS waits 99; RW-excl spins 0, OS waits 0
------------
TRANSACTIONS
------------
Trx id counter 0 1598085474
Purge done for trx's n:o < 0 1598085453 undo n:o < 0 0
History list length 22
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 32367, OS thread id 1159256384
MySQL thread id 786, query id 18591 localhost root
SHOW ENGINE INNODB STATUS
---TRANSACTION 0 1598085465, not started, process no 32367, OS thread id 1160587584
MySQL thread id 785, query id 18553 web1 10.100.1.102 civicspacelabs_o
---TRANSACTION 0 1598085464, not started, process no 32367, OS thread id 1162451264
MySQL thread id 784, query id 18544 web1 10.100.1.102 civicspacelabs_o
---TRANSACTION 0 0, not started, process no 32367, OS thread id 1159788864
MySQL thread id 781, query id 18523 web1 10.100.1.102 civicspacelabs_o
---TRANSACTION 0 0, not started, process no 32367, OS thread id 1161652544
MySQL thread id 780, query id 18514 web1 10.100.1.102 civicspacelabs_o
---TRANSACTION 0 1598085462, not started, process no 32367, OS thread id 1162983744
MySQL thread id 777, query id 18502 web1 10.100.1.102 civicspacelabs_o
--------
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
2972 OS file reads, 2241 OS file writes, 662 OS fsyncs
0.03 reads/s, 16384 avg bytes/read, 0.10 writes/s, 0.03 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf for space 0: size 1, free list len 5, seg size 7, is empty
Ibuf for space 0: size 1, free list len 5, seg size 7,
53 inserts, 53 merged recs, 53 merges
Hash table size 1593833, used cells 4897, node heap has 8 buffer(s)
0.19 hash searches/s, 0.97 non-hash searches/s
---
LOG
---
Log sequence number 114 1134701118
Log flushed up to 114 1134701118
Last checkpoint at 114 1134700648
0 pending log writes, 0 pending chkp writes
1367 log i/o's done, 0.10 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 927440000; in additional pool allocated 11928064
Buffer pool size 49152
Free buffers 46173
Database pages 2971
Modified db pages 4
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 2961, created 10, written 862
0.03 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 996 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 32367, id 1157658944, state: sleeping
Number of rows inserted 418, updated 66, deleted 335, read 37726
0.00 inserts/s, 0.03 updates/s, 0.00 deletes/s, 0.19 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================