Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-07-22 10:12:51 0x2814 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 34 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 88062 srv_active, 0 srv_shutdown, 826 srv_idle
srv_master_thread log flush and writes: 88885
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 926337
OS WAIT ARRAY INFO: signal count 2111354
RW-shared spins 2322365, rounds 15092170, OS waits 355581
RW-excl spins 3883800, rounds 18094980, OS waits 342322
RW-sx spins 575916, rounds 3884307, OS waits 55406
Spin rounds per wait: 6.50 RW-shared, 4.66 RW-excl, 6.74 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 937511541
Purge done for trx's n:o < 936606340 undo n:o < 0 state: running but idle
History list length 448865
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283506092298456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283506092302624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283506092294288, ACTIVE 4608 sec
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 304060, OS thread handle 16668, query id 84121714 localhost 127.0.0.1 root 
Trx read view will not see trx with id >= 936606338, sees < 936606338
--------
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
813832 OS file reads, 50529297 OS file writes, 21327000 OS fsyncs
0.03 reads/s, 16384 avg bytes/read, 240.43 writes/s, 39.59 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 3459 merges
merged operations:
 insert 1530, delete mark 4838, delete 975
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 553253, node heap has 588 buffer(s)
Hash table size 553253, node heap has 2075 buffer(s)
Hash table size 553253, node heap has 503 buffer(s)
Hash table size 553253, node heap has 20 buffer(s)
Hash table size 553253, node heap has 544 buffer(s)
Hash table size 553253, node heap has 320 buffer(s)
Hash table size 553253, node heap has 485 buffer(s)
Hash table size 553253, node heap has 24 buffer(s)
3246.52 hash searches/s, 3111.41 non-hash searches/s
---
LOG
---
Log sequence number 903119458694
Log flushed up to   903119458694
Pages flushed up to 903118365683
Last checkpoint at  903118299191
0 pending log flushes, 0 pending chkp writes
17392369 log i/o's done, 2.62 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2281701376
Dictionary memory allocated 227864
Buffer pool size   128432
Free buffers       8190
Database pages     115683
Old database pages 42538
Modified db pages  3139
Percent of dirty pages(LRU & free pages): 2.534
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1351523, not young 102200116
0.15 youngs/s, 0.00 non-youngs/s
Pages read 813738, created 586752, written 31391165
0.03 reads/s, 3.26 creates/s, 220.46 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: 115683, unzip_LRU len: 0
I/O sum[91816]:cur[2288], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   16054
Free buffers       1024
Database pages     14442
Old database pages 5311
Modified db pages  344
Percent of dirty pages(LRU & free pages): 2.224
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 185541, not young 13068998
0.00 youngs/s, 0.00 non-youngs/s
Pages read 102436, created 74126, written 4048464
0.00 reads/s, 0.18 creates/s, 26.68 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: 14442, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16054
Free buffers       1023
Database pages     14438
Old database pages 5309
Modified db pages  622
Percent of dirty pages(LRU & free pages): 4.023
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 121945, not young 12820640
0.00 youngs/s, 0.00 non-youngs/s
Pages read 98584, created 73519, written 3169570
0.03 reads/s, 0.91 creates/s, 39.18 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: 14438, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16054
Free buffers       1024
Database pages     14476
Old database pages 5323
Modified db pages  419
Percent of dirty pages(LRU & free pages): 2.703
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 233775, not young 12741477
0.00 youngs/s, 0.00 non-youngs/s
Pages read 103198, created 74072, written 4425128
0.00 reads/s, 0.00 creates/s, 28.68 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: 14476, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16054
Free buffers       1024
Database pages     14478
Old database pages 5324
Modified db pages  247
Percent of dirty pages(LRU & free pages): 1.593
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 135501, not young 12646067
0.03 youngs/s, 0.00 non-youngs/s
Pages read 100832, created 72406, written 4714750
0.00 reads/s, 0.26 creates/s, 21.21 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: 14478, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16054
Free buffers       1024
Database pages     14493
Old database pages 5329
Modified db pages  485
Percent of dirty pages(LRU & free pages): 3.125
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 179844, not young 13013696
0.06 youngs/s, 0.00 non-youngs/s
Pages read 102598, created 71670, written 4203619
0.00 reads/s, 0.76 creates/s, 29.97 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: 14493, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16054
Free buffers       1024
Database pages     14428
Old database pages 5305
Modified db pages  371
Percent of dirty pages(LRU & free pages): 2.401
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 167784, not young 13026242
0.03 youngs/s, 0.00 non-youngs/s
Pages read 103965, created 74590, written 3851106
0.00 reads/s, 0.15 creates/s, 26.71 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: 14428, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16054
Free buffers       1023
Database pages     14446
Old database pages 5312
Modified db pages  436
Percent of dirty pages(LRU & free pages): 2.818
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 142937, not young 11998015
0.00 youngs/s, 0.00 non-youngs/s
Pages read 99018, created 72708, written 3513903
0.00 reads/s, 0.59 creates/s, 28.38 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: 14446, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16054
Free buffers       1024
Database pages     14482
Old database pages 5325
Modified db pages  215
Percent of dirty pages(LRU & free pages): 1.386
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 184196, not young 12884981
0.03 youngs/s, 0.00 non-youngs/s
Pages read 103107, created 73661, written 3464625
0.00 reads/s, 0.41 creates/s, 19.68 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: 14482, unzip_LRU len: 0
I/O sum[11477]:cur[286], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=4272, Main thread ID=5704, state: sleeping
Number of rows inserted 15908, updated 14460404, deleted 2569, read 320169662
0.09 inserts/s, 63.20 updates/s, 0.09 deletes/s, 285.34 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
============================