Show Engine InnoDB Status\g

Mysql> Show engine InnoDB status\g

1. Row ***************************
Type:innodb
Name:
Status:
=====================================
131226 17:12:38 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last seconds----the state of the database in the past 55 seconds
-----------------
BACKGROUND THREAD
-----------------
Srv_master_thread loops:372007 1_second, 372007 sleeps, 36255 10_second, 10646 background, 10646 flush----can reflect the pressure of the database Condition
Srv_master_thread Log Flush and writes:373344
----------
Semaphores
----------
OS WAIT ARRAY info:reservation count 9135562, signal count 21215755
Mutex spin waits 520177934, Rounds 2648194228, OS waits 5360746
Rw-shared spins 33278462, rounds 135599856, OS waits 1460221
Rw-excl spins 1200397, rounds 36578622, OS waits 370830
Spin rounds per wait:5.09 mutex, 4.07 rw-shared, 30.47 rw-excl
------------
Transactions
------------
Trx ID Counter 2193c7f93
Purge done for Trx ' s N:o < 2193c7f82 undo N:o < 0
History list Length 1640
LIST of transactions for each SESSION:
---TRANSACTION 0, not started
MySQL thread ID 998695, query ID 2141628314 127.0.0.1 root
Show Engine InnoDB Status
--------
FILE I/O
--------
I/O thread 0 state:waiting for I/O request (insert buffer thread)----can see 10 IO threads, namely insert buffer thread,
I/O thread 1 state:waiting for I/O request (log thread) log thread, read thread, write 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
47691 os file reads, 29911059 OS file writes, 23777623 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 4782, seg size 4784, 14474 merges----SEG size 4784 indicates that the current insert buffer is of a 4784*16K=75MB The free list Len indicates the length of the idle lists
Merged operations:size indicates the number of records pages that have been merged
Insert 11381, delete mark 784750, delete 14238 Insert indicates the number of records inserted
Discarded operations:
Insert 0, delete mark 0, delete 0
Hash table Size 42499631, node heap has 20599 buffer (s)
0.00 Hash SEARCHES/S, 0.00 Non-hash SEARCHES/S
---
LOG
---
Log Sequence Number 19152346341--Indicates the current LSN
Log flushed up to 19152346341--Indicates the LSN that was flushed to the redo log file
Last checkpoint at 19152346341--Indicates the LSN flushed to disk
0 Pending Log writes, 0 pending CHKP writes
23272508 log I/O ' s done, 0.00 log I/O ' S/second
----------------------
Buffer pool and memory----The following information can be seen in the usage of InnoDB storage engine buffer pools
----------------------
Total memory Allocated 21978152960; In additional pool allocated 0
Dictionary Memory Allocated 532520
Buffer pool Size 1310719----Indicates a total of 1,310,719 buffer frames, each with a buffer frame of 16K, that is: 1310719*16k/1024=20g
Free buffers 1070650----buffer frames that represent the remaining space
Database pages 219470----represents a buffer frame already in use
Old database Pages 80995
Modified db pages 0----indicates the number of dirty pages
Pending reads 0
Pending WRITES:LRU 0, flush list 0, single page 0
Pages made young 40256, isn't young 0
0.00 YOUNGS/S, 0.00 NON-YOUNGS/S
Pages read 48595, created 170875, written 10931522
0.00 READS/S, 0.00 CREATES/S, 0.00 WRITES/S
No Buffer Pool page gets since the last printout
Pages Read ahead 0.00/s, evicted without access 0.00/s
LRU len:219470, 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
1 read views open inside InnoDB
Main thread Process No. 9823, id 140584323032832, state:waiting for server activity
Number of rows inserted 7012357, updated 9253488, deleted 2913883, read 214512661409
0.00 INSERTS/S, 0.00 UPDATES/S, 0.00 DELETES/S, 0.00 READS/S
----------------------------
END of INNODB MONITOR OUTPUT
============================

Show Engine InnoDB Status\g