Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-07-22 08:41:50 0x3860 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 24 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 82773 srv_active, 0 srv_shutdown, 667 srv_idle
srv_master_thread log flush and writes: 83437
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 911480
OS WAIT ARRAY INFO: signal count 2083065
RW-shared spins 2281449, rounds 14889171, OS waits 351980
RW-excl spins 3830837, rounds 17806812, OS waits 337872
RW-sx spins 566351, rounds 3798369, OS waits 54330
Spin rounds per wait: 6.53 RW-shared, 4.65 RW-excl, 6.71 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 936446568
Purge done for trx's n:o < 936446568 undo n:o < 0 state: running but idle
History list length 21
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
756872 OS file reads, 48635812 OS file writes, 20580550 OS fsyncs
0.37 reads/s, 16384 avg bytes/read, 227.74 writes/s, 40.08 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 3128 merges
merged operations:
 insert 1299, delete mark 2209, 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 53 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)
2052.33 hash searches/s, 5235.20 non-hash searches/s
---
LOG
---
Log sequence number 902471280839
Log flushed up to   902471280839
Pages flushed up to 902470929729
Last checkpoint at  902470929729
0 pending log flushes, 0 pending chkp writes
16860841 log i/o's done, 4.54 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2281701376
Dictionary memory allocated 227864
Buffer pool size   128432
Free buffers       8212
Database pages     119290
Old database pages 43869
Modified db pages  346
Percent of dirty pages(LRU & free pages): 0.271
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1321998, not young 97367341
0.08 youngs/s, 0.67 non-youngs/s
Pages read 756778, created 564651, written 30124728
0.37 reads/s, 0.08 creates/s, 207.24 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: 119290, unzip_LRU len: 0
I/O sum[75376]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   16054
Free buffers       1028
Database pages     14929
Old database pages 5490
Modified db pages  50
Percent of dirty pages(LRU & free pages): 0.313
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 3887847
0.00 reads/s, 0.04 creates/s, 29.92 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[9422]: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  34
Percent of dirty pages(LRU & free pages): 0.213
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 3011920
0.00 reads/s, 0.00 creates/s, 23.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: 14904, unzip_LRU len: 0
I/O sum[9422]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16054
Free buffers       1027
Database pages     14913
Old database pages 5484
Modified db pages  95
Percent of dirty pages(LRU & free pages): 0.596
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 12080749
0.00 youngs/s, 0.00 non-youngs/s
Pages read 95381, created 70619, written 4226192
0.00 reads/s, 0.00 creates/s, 32.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: 14913, unzip_LRU len: 0
I/O sum[9422]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16054
Free buffers       1024
Database pages     14910
Old database pages 5483
Modified db pages  28
Percent of dirty pages(LRU & free pages): 0.176
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.04 youngs/s, 0.21 non-youngs/s
Pages read 94597, created 69720, written 4549560
0.08 reads/s, 0.00 creates/s, 24.42 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: 14910, unzip_LRU len: 0
I/O sum[9422]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16054
Free buffers       1028
Database pages     14898
Old database pages 5479
Modified db pages  48
Percent of dirty pages(LRU & free pages): 0.301
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 12328011
0.00 youngs/s, 0.00 non-youngs/s
Pages read 94892, created 69143, written 4032461
0.00 reads/s, 0.00 creates/s, 25.75 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: 14898, unzip_LRU len: 0
I/O sum[9422]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16054
Free buffers       1025
Database pages     14910
Old database pages 5483
Modified db pages  53
Percent of dirty pages(LRU & free pages): 0.333
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 164330, not young 12331094
0.00 youngs/s, 0.42 non-youngs/s
Pages read 96684, created 72040, written 3708295
0.25 reads/s, 0.04 creates/s, 28.04 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: 14910, unzip_LRU len: 0
I/O sum[9422]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16054
Free buffers       1026
Database pages     14908
Old database pages 5483
Modified db pages  36
Percent of dirty pages(LRU & free pages): 0.226
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 139449, not young 11619908
0.04 youngs/s, 0.04 non-youngs/s
Pages read 93070, created 70042, written 3369281
0.04 reads/s, 0.00 creates/s, 23.21 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: 14908, unzip_LRU len: 0
I/O sum[9422]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16054
Free buffers       1025
Database pages     14918
Old database pages 5486
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.013
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 3339172
0.00 reads/s, 0.00 creates/s, 19.58 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[9422]: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 14518, updated 13845230, deleted 1795, read 305637698
0.08 inserts/s, 83.45 updates/s, 0.00 deletes/s, 369.94 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
============================