Storage engines

InnoDB

Supports transactions, row-level locking, foreign keys and encryption for tables

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-09-29 15:27:04 0x7f98 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 31 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 11669 srv_active, 0 srv_shutdown, 136663 srv_idle
srv_master_thread log flush and writes: 148332
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 41911
OS WAIT ARRAY INFO: signal count 26428
RW-shared spins 20203, rounds 430931, OS waits 13970
RW-excl spins 35530, rounds 152747, OS waits 1564
RW-sx spins 299, rounds 4541, OS waits 131
Spin rounds per wait: 21.33 RW-shared, 4.30 RW-excl, 15.19 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 1315320
Purge done for trx's n:o < 1315320 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283987523887536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523883368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523879200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523875032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523870864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: native aio handle (insert buffer thread)
I/O thread 1 state: native aio handle (log thread)
I/O thread 2 state: native aio handle (read thread)
I/O thread 3 state: native aio handle (read thread)
I/O thread 4 state: native aio handle (read thread)
I/O thread 5 state: native aio handle (read thread)
I/O thread 6 state: native aio handle (write thread)
I/O thread 7 state: native aio handle (write thread)
I/O thread 8 state: native aio handle (write thread)
I/O thread 9 state: native aio handle (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
26819 OS file reads, 238606 OS file writes, 144003 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 9.45 writes/s, 6.90 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 1053, seg size 1055, 199 merges
merged operations:
 insert 224, delete mark 6, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 553253, node heap has 101 buffer(s)
Hash table size 553253, node heap has 127 buffer(s)
Hash table size 553253, node heap has 15 buffer(s)
Hash table size 553253, node heap has 194 buffer(s)
Hash table size 553253, node heap has 45 buffer(s)
Hash table size 553253, node heap has 38 buffer(s)
Hash table size 553253, node heap has 18 buffer(s)
Hash table size 553253, node heap has 33 buffer(s)
14.71 hash searches/s, 70.80 non-hash searches/s
---
LOG
---
Log sequence number 4266141461
Log flushed up to   4266141461
Pages flushed up to 4266086762
Last checkpoint at  4266086762
0 pending log flushes, 0 pending chkp writes
52997 log i/o's done, 3.81 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2684354560
Dictionary memory allocated 6272520
Buffer pool size   128432
Free buffers       103357
Database pages     24504
Old database pages 9202
Modified db pages  103
Percent of dirty pages(LRU & free pages): 0.081
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 15, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24307, created 197, written 146011
0.00 reads/s, 0.00 creates/s, 4.19 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: 24504, 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   16054
Free buffers       13240
Database pages     2704
Old database pages 1018
Modified db pages  21
Percent of dirty pages(LRU & free pages): 0.132
Max dirty pages percent: 75.000
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 2697, created 7, written 18335
0.00 reads/s, 0.00 creates/s, 0.16 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: 2704, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16054
Free buffers       13108
Database pages     2896
Old database pages 1089
Modified db pages  16
Percent of dirty pages(LRU & free pages): 0.100
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2881, created 15, written 20258
0.00 reads/s, 0.00 creates/s, 0.74 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: 2896, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16054
Free buffers       13229
Database pages     2766
Old database pages 1040
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 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2759, created 7, written 8916
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: 2766, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16054
Free buffers       12558
Database pages     3422
Old database pages 1283
Modified db pages  6
Percent of dirty pages(LRU & free pages): 0.038
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3418, created 4, written 36390
0.00 reads/s, 0.00 creates/s, 0.74 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: 3422, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16054
Free buffers       12917
Database pages     3040
Old database pages 1142
Modified db pages  46
Percent of dirty pages(LRU & free pages): 0.288
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 6, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3016, created 24, written 40992
0.00 reads/s, 0.00 creates/s, 1.90 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: 3040, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16054
Free buffers       12885
Database pages     3109
Old database pages 1167
Modified db pages  8
Percent of dirty pages(LRU & free pages): 0.050
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3103, created 6, written 7986
0.00 reads/s, 0.00 creates/s, 0.42 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: 3109, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16054
Free buffers       12712
Database pages     3282
Old database pages 1231
Modified db pages  6
Percent of dirty pages(LRU & free pages): 0.038
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3217, created 65, written 9923
0.00 reads/s, 0.00 creates/s, 0.23 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: 3282, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16054
Free buffers       12708
Database pages     3285
Old database pages 1232
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 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3216, created 69, written 3211
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: 3285, unzip_LRU len: 0
I/O sum[0]: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=7008, Main thread ID=14324, state: sleeping
Number of rows inserted 3871, updated 23464, deleted 2042, read 86268457
0.00 inserts/s, 2.55 updates/s, 0.00 deletes/s, 3252.54 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 345486
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================