Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-09-29 16:36:09 0x6a9c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 6 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 15078 srv_active, 0 srv_shutdown, 137176 srv_idle
srv_master_thread log flush and writes: 152254
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 53520
OS WAIT ARRAY INFO: signal count 30468
RW-shared spins 22338, rounds 474132, OS waits 15161
RW-excl spins 37160, rounds 164016, OS waits 1795
RW-sx spins 328, rounds 4999, OS waits 142
Spin rounds per wait: 21.23 RW-shared, 4.41 RW-excl, 15.24 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 1327448
Purge done for trx's n:o < 1327448 undo n:o < 0 state: running but idle
History list length 7
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283987523908376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523904208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523900040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523895872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283987523891704, 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 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 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
27742 OS file reads, 281833 OS file writes, 172385 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 9.33 writes/s, 7.83 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 1053, seg size 1055, 208 merges
merged operations:
 insert 238, 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 17 buffer(s)
Hash table size 553253, node heap has 197 buffer(s)
Hash table size 553253, node heap has 51 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)
22.66 hash searches/s, 63.99 non-hash searches/s
---
LOG
---
Log sequence number 4277091073
Log flushed up to   4277091053
Pages flushed up to 4277050857
Last checkpoint at  4277050857
0 pending log flushes, 0 pending chkp writes
64514 log i/o's done, 6.50 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2684354560
Dictionary memory allocated 6272520
Buffer pool size   128432
Free buffers       102340
Database pages     25510
Old database pages 9568
Modified db pages  83
Percent of dirty pages(LRU & free pages): 0.065
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 25230, created 280, written 170035
0.00 reads/s, 0.00 creates/s, 2.33 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: 25510, 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       13097
Database pages     2844
Old database pages 1069
Modified db pages  3
Percent of dirty pages(LRU & free pages): 0.019
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 2836, created 8, written 20989
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: 2844, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16054
Free buffers       13030
Database pages     2974
Old database pages 1117
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.031
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 2957, created 17, written 24571
0.00 reads/s, 0.00 creates/s, 0.33 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: 2974, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16054
Free buffers       13065
Database pages     2930
Old database pages 1101
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 2923, created 7, written 9265
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: 2930, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16054
Free buffers       12455
Database pages     3523
Old database pages 1320
Modified db pages  24
Percent of dirty pages(LRU & free pages): 0.150
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 3518, created 5, written 43133
0.00 reads/s, 0.00 creates/s, 1.33 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: 3523, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16054
Free buffers       12760
Database pages     3197
Old database pages 1200
Modified db pages  42
Percent of dirty pages(LRU & free pages): 0.263
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 3173, created 24, written 47956
0.00 reads/s, 0.00 creates/s, 0.33 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: 3197, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16054
Free buffers       12656
Database pages     3335
Old database pages 1251
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 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3265, created 70, written 9130
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: 3335, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16054
Free buffers       12694
Database pages     3299
Old database pages 1233
Modified db pages  7
Percent of dirty pages(LRU & free pages): 0.044
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 3220, created 79, written 11612
0.00 reads/s, 0.00 creates/s, 0.33 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: 3299, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16054
Free buffers       12583
Database pages     3408
Old database pages 1277
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 3, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3338, created 70, written 3379
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: 3408, 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 5793, updated 31021, deleted 2259, read 93905610
0.00 inserts/s, 5.17 updates/s, 0.00 deletes/s, 69.16 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 518180
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================