mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
161014 23:45:18 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 26251 1_second, 26249 sleeps, 2397 10_second, 2338 background, 2338 flush
srv_master_thread log flush and writes: 26368
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 21468, signal count 69108
Mutex spin waits 142870, rounds 868562, OS waits 10634
RW-shared spins 24682, rounds 383671, OS waits 6298
RW-excl spins 6314, rounds 259378, OS waits 4091
Spin rounds per wait: 6.08 mutex, 15.54 RW-shared, 41.08 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 1E3E2D1
Purge done for trx's n:o < 1E3E284 undo n:o < 0
History list length 665
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 68964, OS thread handle 0x7fead6d06700, query id 21512398 localhost root
SHOW ENGINE INNODB STATUS
---TRANSACTION 1E3E280, ACTIVE 100 sec
34 lock struct(s), heap size 6960, 407 row lock(s), undo log entries 95399
MySQL thread id 69268, OS thread handle 0x7fead923b700, query id 21512397 localhost broncos_xen2
Trx read view will not see trx with id >= 1E3E281, sees < 1E3E281
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
263284 OS file reads, 424241 OS file writes, 57707 OS fsyncs
46.39 reads/s, 16384 avg bytes/read, 10.07 writes/s, 3.89 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 6150, seg size 6152, 7395 merges
merged operations:
insert 62242, delete mark 2082833, delete 87967
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 63 buffer(s)
300444.38 hash searches/s, 5653.19 non-hash searches/s
---
LOG
---
Log sequence number 12365288622
Log flushed up to 12365133424
Last checkpoint at 12362220502
0 pending log writes, 0 pending chkp writes
26504 log i/o's done, 1.50 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 6393817
Buffer pool size 8192
Free buffers 1
Database pages 8128
Old database pages 2980
Modified db pages 149
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 524687, not young 0
206.46 youngs/s, 0.00 non-youngs/s
Pages read 262539, created 66264, written 383340
46.39 reads/s, 4.14 creates/s, 7.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8128, unzip_LRU len: 0
I/O sum[2040]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread process no. 22442, id 140646637958912, state: sleeping
Number of rows inserted 2402858, updated 2417191, deleted 619600, read 1089595243
21.50 inserts/s, 699.08 updates/s, 0.00 deletes/s, 303949.97 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
