存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
变量
|
缓冲池
|
InnoDB 状态
]
=====================================
2026-06-16 17:14:33 0x7f3ed816f700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 59 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 33094 srv_idle
srv_master_thread log flush and writes: 33094
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 808388
OS WAIT ARRAY INFO: signal count 518033
RW-shared spins 179530, rounds 3497056, OS waits 91776
RW-excl spins 1026, rounds 16534, OS waits 494
RW-sx spins 7, rounds 158, OS waits 3
Spin rounds per wait: 19.48 RW-shared, 16.12 RW-excl, 22.57 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 1353890169
Purge done for trx's n:o < 1353890168 undo n:o < 0 state: running but idle
History list length 4
LIST OF TRANSACTIONS FOR EACH SESSION:
---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 421382637683832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421382637666808, 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
4160940 OS file reads, 526789 OS file writes, 366004 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 8.44 writes/s, 5.76 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)
145.69 hash searches/s, 44.76 non-hash searches/s
---
LOG
---
Log sequence number 90279503764
Log flushed up to 90279503764
Pages flushed up to 90279503764
Last checkpoint at 90279499651
0 pending log flushes, 0 pending chkp writes
154882 log i/o's done, 2.76 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 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 1790794, not young 52738262
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4160692, created 676, written 275627
0.00 reads/s, 0.00 creates/s, 4.36 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[1472]:cur[56], 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 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 206414, not young 6642689
0.00 youngs/s, 0.00 non-youngs/s
Pages read 526179, created 240, written 111605
0.00 reads/s, 0.00 creates/s, 2.15 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[184]:cur[7], 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 123
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[184]:cur[7], 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[184]:cur[7], 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 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 251546, not young 6670082
0.00 youngs/s, 0.00 non-youngs/s
Pages read 524937, created 12, written 59349
0.00 reads/s, 0.00 creates/s, 1.10 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[184]:cur[7], 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 42505
0.00 reads/s, 0.00 creates/s, 0.22 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[184]:cur[7], 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 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 216199, not young 6583288
0.00 youngs/s, 0.00 non-youngs/s
Pages read 520631, created 146, written 23116
0.00 reads/s, 0.00 creates/s, 0.15 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[184]:cur[7], 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 178, written 22063
0.00 reads/s, 0.00 creates/s, 0.73 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[184]:cur[7], 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 68, written 459
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[184]:cur[7], 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 4567, updated 63964, deleted 167, read 2473073069
0.00 inserts/s, 1.12 updates/s, 0.00 deletes/s, 2359.57 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 70679
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
