存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
变量
|
缓冲池
|
InnoDB 状态
]
=====================================
2026-06-16 18:05:22 0x7f3cb4481700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 63 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 36128 srv_idle
srv_master_thread log flush and writes: 36128
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 905294
OS WAIT ARRAY INFO: signal count 588325
RW-shared spins 181769, rounds 3563565, OS waits 93982
RW-excl spins 1146, rounds 18470, OS waits 551
RW-sx spins 7, rounds 158, OS waits 3
Spin rounds per wait: 19.60 RW-shared, 16.12 RW-excl, 22.57 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 1354801626
Purge done for trx's n:o < 1354801491 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421382637756184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637679576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 1354801618, ACTIVE 0 sec committing
0 lock struct(s), heap size 1128, 0 row lock(s)
Trx read view will not see trx with id >= 1354801619, sees < 1354801618
---TRANSACTION 421382637739160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637700856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637751928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637743416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637734904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637705112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637730648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637726392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637722136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637717880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637713624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637683832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637709368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637696600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637675320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637688088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637692344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637671064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637662552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637658296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
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] , 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
4160943 OS file reads, 568921 OS file writes, 393583 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 26.86 writes/s, 16.79 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 11, seg size 13, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 2212699, node heap has 38 buffer(s)
Hash table size 2212699, node heap has 1 buffer(s)
Hash table size 2212699, node heap has 71 buffer(s)
Hash table size 2212699, node heap has 31 buffer(s)
Hash table size 2212699, node heap has 34 buffer(s)
Hash table size 2212699, node heap has 19 buffer(s)
Hash table size 2212699, node heap has 2 buffer(s)
Hash table size 2212699, node heap has 2 buffer(s)
826.02 hash searches/s, 114.11 non-hash searches/s
---
LOG
---
Log sequence number 90288154308
Log flushed up to 90288154288
Pages flushed up to 90288146970
Last checkpoint at 90288134000
0 pending log flushes, 0 pending chkp writes
167936 log i/o's done, 7.67 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8606711808
Dictionary memory allocated 623856
Buffer pool size 513472
Free buffers 9
Database pages 513265
Old database pages 189303
Modified db pages 13
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1790794, not young 52738676
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4160695, created 680, written 298188
0.00 reads/s, 0.00 creates/s, 17.28 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: 513265, unzip_LRU len: 0
I/O sum[7248]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 64184
Free buffers 1
Database pages 64161
Old database pages 23664
Modified db pages 5
Percent of dirty pages(LRU & free pages): 0.008
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 206414, not young 6643103
0.00 youngs/s, 0.00 non-youngs/s
Pages read 526182, created 240, written 121027
0.00 reads/s, 0.00 creates/s, 4.86 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: 64161, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 64184
Free buffers 1
Database pages 64162
Old database pages 23664
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 227406, not young 6600894
0.00 youngs/s, 0.00 non-youngs/s
Pages read 521261, created 0, written 127
0.00 reads/s, 0.00 creates/s, 0.05 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: 64162, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 64184
Free buffers 1
Database pages 64158
Old database pages 23663
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 217443, not young 6634758
0.00 youngs/s, 0.00 non-youngs/s
Pages read 523025, created 0, written 16407
0.00 reads/s, 0.00 creates/s, 0.00 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: 64158, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 64184
Free buffers 1
Database pages 64152
Old database pages 23661
Modified db pages 3
Percent of dirty pages(LRU & free pages): 0.005
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 251546, not young 6670082
0.00 youngs/s, 0.00 non-youngs/s
Pages read 524937, created 12, written 63802
0.00 reads/s, 0.00 creates/s, 4.00 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: 64152, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 64184
Free buffers 2
Database pages 64156
Old database pages 23662
Modified db pages 2
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 220228, not young 6621172
0.00 youngs/s, 0.00 non-youngs/s
Pages read 520306, created 32, written 46539
0.00 reads/s, 0.00 creates/s, 3.57 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: 64156, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 64184
Free buffers 1
Database pages 64159
Old database pages 23663
Modified db pages 3
Percent of dirty pages(LRU & free pages): 0.005
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 216199, not young 6583288
0.00 youngs/s, 0.00 non-youngs/s
Pages read 520631, created 146, written 25502
0.00 reads/s, 0.00 creates/s, 2.52 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: 64159, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 64184
Free buffers 1
Database pages 64155
Old database pages 23662
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 223828, not young 6351983
0.00 youngs/s, 0.00 non-youngs/s
Pages read 501323, created 181, written 24270
0.00 reads/s, 0.00 creates/s, 2.24 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: 64155, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 64184
Free buffers 1
Database pages 64162
Old database pages 23664
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 227730, not young 6633396
0.00 youngs/s, 0.00 non-youngs/s
Pages read 523030, created 69, written 514
0.00 reads/s, 0.00 creates/s, 0.05 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: 64162, unzip_LRU len: 0
I/O sum[906]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=3309, Main thread ID=139898840102656, state: sleeping
Number of rows inserted 4730, updated 70446, deleted 167, read 2526905002
0.06 inserts/s, 4.68 updates/s, 0.00 deletes/s, 29522.71 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 75318
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
