存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
变量
|
缓冲池
|
InnoDB 状态
]
=====================================
2026-06-16 18:16:37 0x7f3cb44cc700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 36799 srv_idle
srv_master_thread log flush and writes: 36799
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 950611
OS WAIT ARRAY INFO: signal count 624426
RW-shared spins 182467, rounds 3583413, OS waits 94634
RW-excl spins 1215, rounds 19928, OS waits 594
RW-sx spins 7, rounds 158, OS waits 3
Spin rounds per wait: 19.64 RW-shared, 16.40 RW-excl, 22.57 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 1355032814
Purge done for trx's n:o < 1355032814 undo n:o < 0 state: running but idle
History list length 6
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421382637666808, 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 421382637709368, 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 421382637700856, 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 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, 591674 OS file writes, 405599 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 33.96 writes/s, 18.61 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 39 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)
591.87 hash searches/s, 103.50 non-hash searches/s
---
LOG
---
Log sequence number 90293814980
Log flushed up to 90293814960
Pages flushed up to 90293809959
Last checkpoint at 90293807130
0 pending log flushes, 0 pending chkp writes
174207 log i/o's done, 8.79 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 513264
Old database pages 189303
Modified db pages 11
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 1790797, not young 52738676
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4160695, created 680, written 312138
0.00 reads/s, 0.00 creates/s, 20.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: 513264, unzip_LRU len: 0
I/O sum[8944]: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 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 206417, not young 6643103
0.00 youngs/s, 0.00 non-youngs/s
Pages read 526182, created 240, written 127476
0.00 reads/s, 0.00 creates/s, 4.82 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[1118]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 64184
Free buffers 1
Database pages 64161
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.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: 64161, unzip_LRU len: 0
I/O sum[1118]: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[1118]: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 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 251546, not young 6670082
0.00 youngs/s, 0.00 non-youngs/s
Pages read 524937, created 12, written 66994
0.00 reads/s, 0.00 creates/s, 0.82 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[1118]: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 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 220228, not young 6621172
0.00 youngs/s, 0.00 non-youngs/s
Pages read 520306, created 32, written 48798
0.00 reads/s, 0.00 creates/s, 6.94 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[1118]: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 26541
0.00 reads/s, 0.00 creates/s, 2.65 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[1118]: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 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 223828, not young 6351983
0.00 youngs/s, 0.00 non-youngs/s
Pages read 501323, created 181, written 25280
0.00 reads/s, 0.00 creates/s, 4.76 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[1118]: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 515
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: 64162, unzip_LRU len: 0
I/O sum[1118]: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=3309, Main thread ID=139898840102656, state: sleeping
Number of rows inserted 4733, updated 74717, deleted 167, read 2565260679
0.00 inserts/s, 6.07 updates/s, 0.00 deletes/s, 291068.43 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 82773
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 34.68 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
