Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-07-22 07:14:54 0x1da4 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 14 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 77621 srv_active, 0 srv_shutdown, 632 srv_idle
srv_master_thread log flush and writes: 78250
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 205793
OS WAIT ARRAY INFO: signal count 208819
RW-shared spins 77276, rounds 1034235, OS waits 29313
RW-excl spins 159527, rounds 2415419, OS waits 62995
RW-sx spins 17564, rounds 349949, OS waits 10272
Spin rounds per wait: 13.38 RW-shared, 15.14 RW-excl, 19.92 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 934584531
Purge done for trx's n:o < 903168240 undo n:o < 0 state: running but idle
History list length 15625365
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283506092306792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283506092298456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283506092302624, not started flushing log
mysql tables in use 1, locked 1
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283506092294288, ACTIVE 77137 sec
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 3995, OS thread handle 14968, query id 54615839 localhost 127.0.0.1 root 
Trx read view will not see trx with id >= 903168240, sees < 903168238
--------
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: 1; buffer pool: 0
167802 OS file reads, 41746726 OS file writes, 19326773 OS fsyncs
0.43 reads/s, 16384 avg bytes/read, 721.88 writes/s, 373.76 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 2896 merges
merged operations:
 insert 1233, delete mark 1974, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 553253, node heap has 346 buffer(s)
Hash table size 553253, node heap has 2141 buffer(s)
Hash table size 553253, node heap has 226 buffer(s)
Hash table size 553253, node heap has 18 buffer(s)
Hash table size 553253, node heap has 504 buffer(s)
Hash table size 553253, node heap has 54 buffer(s)
Hash table size 553253, node heap has 396 buffer(s)
Hash table size 553253, node heap has 10 buffer(s)
1848.01 hash searches/s, 5947.00 non-hash searches/s
---
LOG
---
Log sequence number 898633853712
Log flushed up to   898633853306
Pages flushed up to 898632956810
Last checkpoint at  898631975698
1 pending log flushes, 0 pending chkp writes
15913204 log i/o's done, 326.36 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2281701376
Dictionary memory allocated 227864
Buffer pool size   128432
Free buffers       8183
Database pages     116554
Old database pages 42860
Modified db pages  1220
Percent of dirty pages(LRU & free pages): 0.978
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 995142, not young 4530750
1.14 youngs/s, 1.29 non-youngs/s
Pages read 167708, created 543845, written 24349218
0.43 reads/s, 9.07 creates/s, 375.19 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: 116554, unzip_LRU len: 0
I/O sum[149272]:cur[2640], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   16054
Free buffers       1024
Database pages     14522
Old database pages 5340
Modified db pages  91
Percent of dirty pages(LRU & free pages): 0.585
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 137823, not young 220350
0.57 youngs/s, 0.64 non-youngs/s
Pages read 19744, created 67863, written 3135754
0.07 reads/s, 0.50 creates/s, 45.78 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: 14522, unzip_LRU len: 0
I/O sum[18659]:cur[330], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16054
Free buffers       1024
Database pages     14576
Old database pages 5360
Modified db pages  108
Percent of dirty pages(LRU & free pages): 0.692
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 79999, not young 485177
0.07 youngs/s, 0.00 non-youngs/s
Pages read 18157, created 67682, written 2403728
0.00 reads/s, 0.00 creates/s, 50.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: 14576, unzip_LRU len: 0
I/O sum[18659]:cur[330], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16054
Free buffers       1024
Database pages     14584
Old database pages 5363
Modified db pages  149
Percent of dirty pages(LRU & free pages): 0.955
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 187591, not young 289634
0.21 youngs/s, 0.00 non-youngs/s
Pages read 20756, created 68551, written 3419242
0.00 reads/s, 0.36 creates/s, 46.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: 14584, unzip_LRU len: 0
I/O sum[18659]:cur[330], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16054
Free buffers       1024
Database pages     14571
Old database pages 5358
Modified db pages  195
Percent of dirty pages(LRU & free pages): 1.250
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 91880, not young 1083654
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22584, created 67891, written 3761301
0.00 reads/s, 0.29 creates/s, 51.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: 14571, unzip_LRU len: 0
I/O sum[18659]:cur[330], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16054
Free buffers       1024
Database pages     14574
Old database pages 5359
Modified db pages  252
Percent of dirty pages(LRU & free pages): 1.615
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 135137, not young 806328
0.21 youngs/s, 0.14 non-youngs/s
Pages read 22206, created 66801, written 3311555
0.07 reads/s, 1.07 creates/s, 51.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: 14574, unzip_LRU len: 0
I/O sum[18659]:cur[330], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16054
Free buffers       1023
Database pages     14551
Old database pages 5351
Modified db pages  176
Percent of dirty pages(LRU & free pages): 1.130
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 123472, not young 625522
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22324, created 68854, written 2925566
0.00 reads/s, 0.50 creates/s, 47.07 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: 14551, unzip_LRU len: 0
I/O sum[18659]:cur[330], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16054
Free buffers       1016
Database pages     14584
Old database pages 5363
Modified db pages  122
Percent of dirty pages(LRU & free pages): 0.782
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 99938, not young 446184
0.00 youngs/s, 0.14 non-youngs/s
Pages read 20582, created 67337, written 2676984
0.07 reads/s, 5.36 creates/s, 38.43 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: 14584, unzip_LRU len: 0
I/O sum[18659]:cur[330], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16054
Free buffers       1024
Database pages     14592
Old database pages 5366
Modified db pages  127
Percent of dirty pages(LRU & free pages): 0.813
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 139302, not young 573901
0.07 youngs/s, 0.36 non-youngs/s
Pages read 21355, created 68866, written 2715088
0.21 reads/s, 1.00 creates/s, 45.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: 14592, unzip_LRU len: 0
I/O sum[18659]:cur[330], 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 14260, updated 13035503, deleted 1759, read 295465767
0.07 inserts/s, 233.63 updates/s, 0.00 deletes/s, 507.96 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
============================