Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-10-13 18:15:50 0xfb8 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 3 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 86 srv_active, 0 srv_shutdown, 2458274 srv_idle
srv_master_thread log flush and writes: 2458360
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1534
OS WAIT ARRAY INFO: signal count 500
RW-shared spins 44, rounds 1268, OS waits 42
RW-excl spins 26, rounds 788, OS waits 26
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 28.82 RW-shared, 30.31 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 20796
Purge done for trx's n:o < 20796 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284047051976992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284047051989496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284047051981160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284047051972824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284047051968656, 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
420 OS file reads, 1339 OS file writes, 606 OS fsyncs
0 pending reads, 1 pending writes
0.00 reads/s, 0 avg bytes/read, 4.33 writes/s, 4.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
12.00 hash searches/s, 29.66 non-hash searches/s
---
LOG
---
Log sequence number 11175969
Log flushed up to   11175969
Pages flushed up to 11165470
Last checkpoint at  11165470
0 pending log flushes, 0 pending chkp writes
384 log i/o's done, 4.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 167772160
Dictionary memory allocated 87640
Buffer pool size   8027
Free buffers       7512
Database pages     513
Old database pages 209
Modified db pages  21
Percent of dirty pages(LRU & free pages): 0.262
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 21, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 382, created 131, written 872
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: 513, unzip_LRU len: 0
I/O sum[0]:cur[21], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=3096, Main thread ID=4948, state: sleeping
Number of rows inserted 0, updated 226, deleted 0, read 4048
0.00 inserts/s, 2.67 updates/s, 0.00 deletes/s, 13.66 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 441
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================