- MySQL> show engine innodb status\G;
- *************************** 1. row ***************************
- Type: InnoDB
- Name:
- Status:
- =====================================
- 2018-08-15 22:55:43 0x7f5b69b4e700 INNODB MONITOR OUTPUT
- =====================================
- Per second averages calculated from the last 39 seconds
- -----------------
- BACKGROUND THREAD
- -----------------
- srv_master_thread loops: 4 srv_active, 0 srv_shutdown, 18800 srv_idle
- srv_master_thread log flush and writes: 18804
- ----------
- SEMAPHORES
- ----------
- OS WAIT ARRAY INFO: reservation count 2
- OS WAIT ARRAY INFO: signal count 2
- RW-shared spins 0, rounds 4, OS waits 2
- RW-excl spins 0, rounds 0, OS waits 0
- RW-sx spins 0, rounds 0, OS waits 0
- Spin rounds per wait: 4.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
- ------------
- TRANSACTIONS
- ------------
- Trx id counter 35363587
- Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
- History list length 0
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 421507019233104, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- --------
- 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] , aio writes: [0, 0, 0, 0] ,
- ibuf aio reads:, log i/o's:, sync i/o's:
- Pending flushes (fsync) log: 0; buffer pool: 0
- 480 OS file reads, 131 OS file writes, 7 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 merges
- merged operations:
- insert 0, delete mark 0, delete 0
- discarded operations:
- insert 0, delete mark 0, delete 0
- Hash table size 332099, node heap has 2 buffer(s)
- Hash table size 332099, node heap has 0 buffer(s)
- Hash table size 332099, node heap has 0 buffer(s)
- Hash table size 332099, node heap has 0 buffer(s)
- Hash table size 332099, node heap has 0 buffer(s)
- Hash table size 332099, node heap has 0 buffer(s)
- Hash table size 332099, node heap has 0 buffer(s)
- Hash table size 332099, node heap has 2 buffer(s)
- 0.00 hash searches/s, 0.00 non-hash searches/s
- ---
- LOG
- ---
- Log sequence number 3964869295
- Log flushed up to 3964869295
- Pages flushed up to 3964869295
- Last checkpoint at 3964869286
- 0 pending log flushes, 0 pending chkp writes
- 10 log i/o's done, 0.00 log i/o's/second
- ----------------------
- BUFFER POOL AND MEMORY
- ----------------------
- Total large memory allocated 1374289920
- Dictionary memory allocated 102398
- Buffer pool size 81910
- Free buffers 81395
- Database pages 511
- Old database pages 0
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 0, not young 0
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 453, created 58, written 114
- 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, Random read ahead 0.00/s
- LRU len: 511, 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 16382
- Free buffers 16226
- Database pages 155
- Old database pages 0
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 0, not young 0
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 155, created 0, written 2
- 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, Random read ahead 0.00/s
- LRU len: 155, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- .....
来源: http://www.linuxidc.com/Linux/2019-01/156387.htm