Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-07-22 08:43:33 0x36dc INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 42 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 82875 srv_active, 0 srv_shutdown, 667 srv_idle
srv_master_thread log flush and writes: 83539
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 912267
OS WAIT ARRAY INFO: signal count 2085570
RW-shared spins 2286281, rounds 14911125, OS waits 352311
RW-excl spins 3837010, rounds 17830930, OS waits 338080
RW-sx spins 567602, rounds 3808200, OS waits 54416
Spin rounds per wait: 6.52 RW-shared, 4.65 RW-excl, 6.71 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 936447202
Purge done for trx's n:o < 936447202 undo n:o < 0 state: running but idle
History list length 10
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283506092298456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283506092294288, 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
756878 OS file reads, 48656497 OS file writes, 20584700 OS fsyncs
0.07 reads/s, 16384 avg bytes/read, 193.57 writes/s, 40.71 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 3129 merges
merged operations:
 insert 1299, delete mark 2210, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 553253, node heap has 143 buffer(s)
Hash table size 553253, node heap has 129 buffer(s)
Hash table size 553253, node heap has 51 buffer(s)
Hash table size 553253, node heap has 9 buffer(s)
Hash table size 553253, node heap has 54 buffer(s)
Hash table size 553253, node heap has 99 buffer(s)
Hash table size 553253, node heap has 439 buffer(s)
Hash table size 553253, node heap has 7 buffer(s)
1868.88 hash searches/s, 4600.03 non-hash searches/s
---
LOG
---
Log sequence number 902484771700
Log flushed up to   902484771466
Pages flushed up to 902484013030
Last checkpoint at  902483591193
0 pending log flushes, 0 pending chkp writes
16861270 log i/o's done, 4.21 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2281701376
Dictionary memory allocated 227864
Buffer pool size   128432
Free buffers       8210
Database pages     119291
Old database pages 43872
Modified db pages  635
Percent of dirty pages(LRU & free pages): 0.498
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1322004, not young 97367354
0.12 youngs/s, 0.17 non-youngs/s
Pages read 756784, created 564652, written 30143283
0.07 reads/s, 0.02 creates/s, 172.52 writes/s
Buffer pool hit rate 999 / 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: 119291, unzip_LRU len: 0
I/O sum[68728]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   16054
Free buffers       1025
Database pages     14929
Old database pages 5490
Modified db pages  116
Percent of dirty pages(LRU & free pages): 0.727
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 180848, not young 12347838
0.00 youngs/s, 0.00 non-youngs/s
Pages read 94715, created 71517, written 3890515
0.00 reads/s, 0.00 creates/s, 24.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: 14929, unzip_LRU len: 0
I/O sum[8591]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16054
Free buffers       1029
Database pages     14904
Old database pages 5481
Modified db pages  58
Percent of dirty pages(LRU & free pages): 0.364
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 118718, not young 12178487
0.00 youngs/s, 0.00 non-youngs/s
Pages read 91351, created 70255, written 3014007
0.00 reads/s, 0.00 creates/s, 19.62 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: 14904, unzip_LRU len: 0
I/O sum[8591]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16054
Free buffers       1026
Database pages     14914
Old database pages 5485
Modified db pages  142
Percent of dirty pages(LRU & free pages): 0.891
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 230181, not young 12080752
0.00 youngs/s, 0.05 non-youngs/s
Pages read 95383, created 70619, written 4229199
0.02 reads/s, 0.00 creates/s, 27.64 writes/s
Buffer pool hit rate 999 / 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: 14914, unzip_LRU len: 0
I/O sum[8591]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16054
Free buffers       1030
Database pages     14910
Old database pages 5483
Modified db pages  63
Percent of dirty pages(LRU & free pages): 0.395
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 132360, not young 12156104
0.00 youngs/s, 0.00 non-youngs/s
Pages read 94597, created 69720, written 4551825
0.00 reads/s, 0.00 creates/s, 21.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: 14910, unzip_LRU len: 0
I/O sum[8591]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16054
Free buffers       1024
Database pages     14899
Old database pages 5480
Modified db pages  64
Percent of dirty pages(LRU & free pages): 0.402
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 175831, not young 12328016
0.00 youngs/s, 0.12 non-youngs/s
Pages read 94894, created 69143, written 4034753
0.05 reads/s, 0.00 creates/s, 21.07 writes/s
Buffer pool hit rate 999 / 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: 14899, unzip_LRU len: 0
I/O sum[8591]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16054
Free buffers       1024
Database pages     14908
Old database pages 5483
Modified db pages  94
Percent of dirty pages(LRU & free pages): 0.590
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 164335, not young 12331098
0.12 youngs/s, 0.00 non-youngs/s
Pages read 96685, created 72041, written 3710788
0.00 reads/s, 0.02 creates/s, 22.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: 14908, unzip_LRU len: 0
I/O sum[8591]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16054
Free buffers       1025
Database pages     14909
Old database pages 5484
Modified db pages  68
Percent of dirty pages(LRU & free pages): 0.427
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 139450, not young 11619909
0.00 youngs/s, 0.00 non-youngs/s
Pages read 93071, created 70042, written 3371314
0.00 reads/s, 0.00 creates/s, 18.88 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: 14909, unzip_LRU len: 0
I/O sum[8591]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16054
Free buffers       1027
Database pages     14918
Old database pages 5486
Modified db pages  30
Percent of dirty pages(LRU & free pages): 0.188
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 180281, not young 12325150
0.00 youngs/s, 0.00 non-youngs/s
Pages read 96088, created 71315, written 3340882
0.00 reads/s, 0.00 creates/s, 16.31 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: 14918, unzip_LRU len: 0
I/O sum[8591]: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=4272, Main thread ID=5704, state: sleeping
Number of rows inserted 14520, updated 13852426, deleted 1795, read 305669089
0.02 inserts/s, 75.09 updates/s, 0.00 deletes/s, 332.87 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 113962
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================