存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
变量
|
缓冲池
|
InnoDB 状态
]
=====================================
2026-03-17 20:18:39 0x7f216404b700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 30 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 28547 srv_idle
srv_master_thread log flush and writes: 28546
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 35781
OS WAIT ARRAY INFO: signal count 33681
RW-shared spins 39230, rounds 974790, OS waits 28719
RW-excl spins 564, rounds 3387, OS waits 71
RW-sx spins 2, rounds 8, OS waits 0
Spin rounds per wait: 24.85 RW-shared, 6.01 RW-excl, 4.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 2099666
Purge done for trx's n:o < 2099666 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421256374151544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374147288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374143032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374138776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374134520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374130264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374104728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374113240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374108984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374100472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374126008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374121752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374117496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374096216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421256374091960, 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
4419596 OS file reads, 232091 OS file writes, 168795 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 36.10 writes/s, 19.73 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 3 buffer(s)
Hash table size 2212699, node heap has 1 buffer(s)
Hash table size 2212699, node heap has 53 buffer(s)
Hash table size 2212699, node heap has 11 buffer(s)
Hash table size 2212699, node heap has 25 buffer(s)
Hash table size 2212699, node heap has 5 buffer(s)
Hash table size 2212699, node heap has 2 buffer(s)
Hash table size 2212699, node heap has 2 buffer(s)
34.60 hash searches/s, 56.60 non-hash searches/s
---
LOG
---
Log sequence number 76956323998
Log flushed up to 76956323978
Pages flushed up to 76956318160
Last checkpoint at 76956313804
0 pending log flushes, 0 pending chkp writes
71975 log i/o's done, 8.30 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8606711808
Dictionary memory allocated 499592
Buffer pool size 513472
Free buffers 9
Database pages 513361
Old database pages 189338
Modified db pages 27
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 1664665, not young 50801532
0.40 youngs/s, 0.00 non-youngs/s
Pages read 4419408, created 694, written 115927
0.00 reads/s, 0.00 creates/s, 22.50 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: 513361, unzip_LRU len: 0
I/O sum[9280]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 64184
Free buffers 1
Database pages 64173
Old database pages 23668
Modified db pages 4
Percent of dirty pages(LRU & free pages): 0.006
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 181773, not young 6490288
0.00 youngs/s, 0.00 non-youngs/s
Pages read 562764, created 270, written 49373
0.00 reads/s, 0.00 creates/s, 5.67 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: 64173, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 64184
Free buffers 1
Database pages 64168
Old database pages 23667
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 180086, not young 6391990
0.00 youngs/s, 0.00 non-youngs/s
Pages read 557203, created 0, written 339
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: 64168, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 64184
Free buffers 1
Database pages 64169
Old database pages 23667
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 165062, not young 6453449
0.00 youngs/s, 0.00 non-youngs/s
Pages read 559769, created 0, written 8009
0.00 reads/s, 0.00 creates/s, 0.87 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: 64169, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 64184
Free buffers 1
Database pages 64176
Old database pages 23669
Modified db pages 12
Percent of dirty pages(LRU & free pages): 0.019
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 164823, not young 6498323
0.00 youngs/s, 0.00 non-youngs/s
Pages read 563987, created 0, written 23216
0.00 reads/s, 0.00 creates/s, 4.83 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: 64176, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 64184
Free buffers 2
Database pages 64173
Old database pages 23668
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 180228, not young 6482786
0.00 youngs/s, 0.00 non-youngs/s
Pages read 560535, created 39, written 18021
0.00 reads/s, 0.00 creates/s, 4.60 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: 64173, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 64184
Free buffers 1
Database pages 64164
Old database pages 23665
Modified db pages 7
Percent of dirty pages(LRU & free pages): 0.011
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 181365, not young 6439703
0.00 youngs/s, 0.00 non-youngs/s
Pages read 559005, created 150, written 7922
0.00 reads/s, 0.00 creates/s, 4.33 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: 64164, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 64184
Free buffers 1
Database pages 64168
Old database pages 23667
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 429993, not young 5598249
0.00 youngs/s, 0.00 non-youngs/s
Pages read 497620, created 171, written 8982
0.00 reads/s, 0.00 creates/s, 2.20 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: 64168, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 64184
Free buffers 1
Database pages 64170
Old database pages 23667
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 181335, not young 6446744
0.40 youngs/s, 0.00 non-youngs/s
Pages read 558525, created 64, written 65
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: 64170, unzip_LRU len: 0
I/O sum[1160]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=13619, Main thread ID=139772379985664, state: sleeping
Number of rows inserted 279, updated 23610, deleted 180, read 1183999797
0.00 inserts/s, 5.27 updates/s, 0.00 deletes/s, 22467.42 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 36646
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 33.73 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
