Storage engines

InnoDB

Supports transactions, row-level locking, and foreign keys

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-02-19 06:41:41 0x7fc1dc0f5700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 43 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 64 srv_active, 0 srv_shutdown, 588 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 118
OS WAIT ARRAY INFO: signal count 120
RW-shared spins 9, rounds 17, OS waits 8
RW-excl spins 12, rounds 246, OS waits 9
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 1.89 RW-shared, 20.50 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 10086
Purge done for trx's n:o < 10084 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421945761909352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421945761908480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (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
1413 OS file reads, 2815 OS file writes, 734 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.49 writes/s, 0.33 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 2 buffer(s)
Hash table size 34679, node heap has 2 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
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 2 buffer(s)
Hash table size 34679, node heap has 7 buffer(s)
8317.18 hash searches/s, 6611.59 non-hash searches/s
---
LOG
---
Log sequence number          51180399
Log buffer assigned up to    51180399
Log buffer completed up to   51180399
Log written up to            51180399
Log flushed up to            51180399
Added dirty pages up to      51180399
Pages flushed up to          51180399
Last checkpoint at           51180399
568 log i/o's done, 0.12 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 137363456
Dictionary memory allocated 632402
Buffer pool size   8192
Free buffers       6713
Database pages     1463
Old database pages 520
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 459, not young 510
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1286, created 1248, written 1564
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: 1463, unzip_LRU len: 0
I/O sum[8]: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=365, Main thread ID=140470274438912 , state=sleeping
Number of rows inserted 197133, updated 484, deleted 25, read 1501810
4.21 inserts/s, 0.00 updates/s, 0.00 deletes/s, 9551.06 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================