mysql---show engine innodb status

show engine innodb status

=====================================
2017-02-17 18:26:07 7f14a2411700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2041789 srv_active, 0 srv_shutdown, 1482075 srv_idle
srv_master_thread log flush and writes: 3523864
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2911377
OS WAIT ARRAY INFO: signal count 3438443
Mutex spin waits 2506762, rounds 49757768, OS waits 1623200
RW-shared spins 1952414, rounds 36771492, OS waits 1143636
RW-excl spins 433191, rounds 5164657, OS waits 117538
Spin rounds per wait: 19.85 mutex, 18.83 RW-shared, 11.92 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 523219377
Purge done for trx''s n:o < 523219377 undo n:o < 0 state: running but idle
History list length 1605
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 16339967, OS thread handle 0x7f14a2411700, query id 116330869 192.168.1.194 dev init
show engine innodb status
---TRANSACTION 523219374, not started
MySQL thread id 16340017, OS thread handle 0x7f14a379e700, query id 116330870 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219365, not started
MySQL thread id 16340015, OS thread handle 0x7f14a3aaa700, query id 116330837 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219375, not started
MySQL thread id 16340013, OS thread handle 0x7f14c84f5700, query id 116330873 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219344, not started
MySQL thread id 16340011, OS thread handle 0x7f14a1c32700, query id 116330820 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16339966, OS thread handle 0x7f14a3104700, query id 116330872 192.168.1.194 dev cleaning up
---TRANSACTION 523219217, not started
MySQL thread id 16339981, OS thread handle 0x7f14c85b8700, query id 116330457 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219213, not started
MySQL thread id 16339978, OS thread handle 0x7f14a2fbf700, query id 116330449 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219210, not started
MySQL thread id 16339975, OS thread handle 0x7f14a33cf700, query id 116330443 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219289, not started
MySQL thread id 16339974, OS thread handle 0x7f14a27e0700, query id 116330698 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219228, not started
MySQL thread id 16339433, OS thread handle 0x7f14a3000700, query id 116330602 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523218361, not started
MySQL thread id 16339431, OS thread handle 0x7f14c822c700, query id 116328924 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219236, not started
MySQL thread id 16338308, OS thread handle 0x7f14a224a700, query id 116330563 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219239, not started
MySQL thread id 16338306, OS thread handle 0x7f14c8842700, query id 116330593 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219235, not started
MySQL thread id 16338300, OS thread handle 0x7f14a3618700, query id 116330554 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523219241, not started
MySQL thread id 16338304, OS thread handle 0x7f14a271d700, query id 116330612 node21.pp100.net 192.168.6.21 dev cleaning up
---TRANSACTION 523219373, not started
MySQL thread id 16331847, OS thread handle 0x7f14c8169700, query id 116330855 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16331846, OS thread handle 0x7f14caea4700, query id 116326190 node12.pp100.net 192.168.6.12 root cleaning up
---TRANSACTION 523219242, not started
MySQL thread id 16331742, OS thread handle 0x7f14c85f9700, query id 116330635 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523218362, not started
MySQL thread id 16329108, OS thread handle 0x7f14c8577700, query id 116328920 node18.pp100.net 192.168.6.18 dev cleaning up
---TRANSACTION 523218854, not started
MySQL thread id 16324979, OS thread handle 0x7f14a30c3700, query id 116330411 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523218255, not started
MySQL thread id 16324981, OS thread handle 0x7f14c8883700, query id 116330413 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523217678, not started
MySQL thread id 16324980, OS thread handle 0x7f14c8801700, query id 116330412 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523154476, not started
MySQL thread id 16321728, OS thread handle 0x7f14a2e7a700, query id 116124445 192.168.1.199 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16321710, OS thread handle 0x7f14a2d76700, query id 116124093 192.168.1.199 dev cleaning up
---TRANSACTION 523206836, not started
MySQL thread id 16321461, OS thread handle 0x7f14a1fc0700, query id 116330415 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 523049437, not started
MySQL thread id 16292497, OS thread handle 0x7f14a3410700, query id 115808491 192.168.1.189 dev cleaning up
---TRANSACTION 523023325, not started
MySQL thread id 16284388, OS thread handle 0x7f14c8c93700, query id 115753515 192.168.1.191 root cleaning up
---TRANSACTION 0, not started
MySQL thread id 16190017, OS thread handle 0x7f14c80e7700, query id 116141937 192.168.1.141 dev cleaning up
---TRANSACTION 522986314, not started
MySQL thread id 16267723, OS thread handle 0x7f14a3c30700, query id 115654969 192.168.1.144 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16267306, OS thread handle 0x7f14a1d36700, query id 115564249 192.168.1.144 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16267289, OS thread handle 0x7f14a2c31700, query id 115563962 192.168.1.144 dev cleaning up
---TRANSACTION 523164504, not started
MySQL thread id 16221325, OS thread handle 0x7f14c8a8b700, query id 116330414 node16.pp100.net 192.168.6.16 dev cleaning up
---TRANSACTION 522807317, not started
MySQL thread id 16221955, OS thread handle 0x7f14c81aa700, query id 115181936 192.168.1.182 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16193854, OS thread handle 0x7f14a3249700, query id 115753850 192.168.1.191 root cleaning up
---TRANSACTION 522984987, not started
MySQL thread id 16192830, OS thread handle 0x7f14c8905700, query id 115651993 192.168.1.145 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16192765, OS thread handle 0x7f14a2b6e700, query id 115651778 192.168.1.145 dev cleaning up
---TRANSACTION 523166197, not started
MySQL thread id 16190073, OS thread handle 0x7f14a35d7700, query id 116149192 192.168.1.141 dev cleaning up
---TRANSACTION 0, not started
MySQL thread id 16186327, OS thread handle 0x7f14a3eba700, query id 115181921 192.168.1.182 dev cleaning up
--------
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 (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (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
126223 OS file reads, 29898157 OS file writes, 11754541 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 12.25 writes/s, 4.87 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 3278 merges
merged operations:
insert 6939, delete mark 2553, delete 1262
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 10624727, node heap has 3414 buffer(s)
194.73 hash searches/s, 105.74 non-hash searches/s
---
LOG
---
Log sequence number 170031549686
Log flushed up to   170031549189
Pages flushed up to 170031532814
Last checkpoint at  170031532814
0 pending log writes, 0 pending chkp writes
9743470 log i/o''s done, 4.38 log i/o''s/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 5494538240; in additional pool allocated 0
Dictionary memory allocated 9316456
Buffer pool size   327672
Free buffers       101527
Database pages     222731
Old database pages 82247
Modified db pages  23
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1043, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 181720, created 41011, written 21952933
0.00 reads/s, 0.00 creates/s, 8.12 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: 222731, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   40959
Free buffers       12094
Database pages     28442
Old database pages 10481
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 150, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 23071, created 5371, written 3883250
0.00 reads/s, 0.00 creates/s, 0.75 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: 28442, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   40959
Free buffers       12546
Database pages     27990
Old database pages 10351
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 68, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22818, created 5172, written 1235821
0.00 reads/s, 0.00 creates/s, 0.12 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: 27990, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   40959
Free buffers       12452
Database pages     28080
Old database pages 10379
Modified db pages  3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 160, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22652, created 5428, written 1489375
0.00 reads/s, 0.00 creates/s, 1.12 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: 28080, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   40959
Free buffers       12759
Database pages     27767
Old database pages 10267
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 118, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22900, created 4867, written 4474465
0.00 reads/s, 0.00 creates/s, 0.25 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: 27767, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   40959
Free buffers       12540
Database pages     28006
Old database pages 10356
Modified db pages  10
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 128, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22768, created 5238, written 4299446
0.00 reads/s, 0.00 creates/s, 2.62 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: 28006, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   40959
Free buffers       13349
Database pages     27176
Old database pages 10023
Modified db pages  1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 112, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21966, created 5210, written 1314134
0.00 reads/s, 0.00 creates/s, 1.12 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: 27176, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   40959
Free buffers       12334
Database pages     28194
Old database pages 10400
Modified db pages  6
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 221, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 23495, created 4699, written 3811952
0.00 reads/s, 0.00 creates/s, 1.75 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: 28194, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   40959
Free buffers       13453
Database pages     27076
Old database pages 9990
Modified db pages  3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 86, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22050, created 5026, written 1444490
0.00 reads/s, 0.00 creates/s, 0.37 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: 27076, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Main thread process no. 1493, id 139727345493760, state: sleeping
Number of rows inserted 576345, updated 7080840, deleted 226779, read 7819671243
0.00 inserts/s, 3.12 updates/s, 0.00 deletes/s, 1519.06 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================