Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-09-02 21:00:48 0xda8 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 37 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 601457 srv_active, 0 srv_shutdown, 343752 srv_idle
srv_master_thread log flush and writes: 944430
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 43110098
OS WAIT ARRAY INFO: signal count 254230667
RW-shared spins 421369119, rounds 1953050955, OS waits 30002395
RW-excl spins 1028348781, rounds 3443164154, OS waits 3866566
RW-sx spins 127354373, rounds 815728585, OS waits 5451612
Spin rounds per wait: 4.64 RW-shared, 3.35 RW-excl, 6.41 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 30994011
Purge done for trx's n:o < 30994010 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283782208627624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208598448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208585944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208602616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208619288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208652632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208640128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208594280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209202808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209198640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209194472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209190304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209186136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209181968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209177800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209173632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209169464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209165296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209161128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209156960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209148624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209144456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209136120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209131952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209127784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209123616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209115280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209111112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209106944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209098608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209090272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209086104, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209081936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209077768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209069432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209065264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209061096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209048592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209044424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208965232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208931888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208877704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208869368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208740160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208702648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208698480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208648464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208635960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208623456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208590112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208644296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208581776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208606784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209040256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209036088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209031920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209027752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209023584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209019416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209015248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209011080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209006912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209002744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208998576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208994408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208990240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208986072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208981904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208977736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208961064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208956896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208952728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208948560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208936056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208927720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208919384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208911048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208898544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208890208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208886040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208881872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208856864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208852696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208844360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208836024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208615120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208610952, 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
273820149 OS file reads, 212563392 OS file writes, 38059402 OS fsyncs
330.56 reads/s, 16384 avg bytes/read, 242.75 writes/s, 44.59 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 42, seg size 44, 1173871 merges
merged operations:
 insert 3890219, delete mark 3441873, delete 3321523
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 4441, node heap has 2 buffer(s)
Hash table size 4441, node heap has 2 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
2593.71 hash searches/s, 5334.18 non-hash searches/s
---
LOG
---
Log sequence number 721263016429
Log flushed up to   721263016408
Pages flushed up to 721263015450
Last checkpoint at  721263015156
0 pending log flushes, 0 pending chkp writes
17611969 log i/o's done, 19.62 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 696112
Buffer pool size   1003
Free buffers       713
Database pages     280
Old database pages 0
Modified db pages  7
Percent of dirty pages(LRU & free pages): 0.704
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14578327, not young 13123795133
11.57 youngs/s, 13051.08 non-youngs/s
Pages read 273820112, created 31087005, written 190391543
330.61 reads/s, 32.22 creates/s, 217.78 writes/s
Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 252 / 1000
Pages read ahead 6.92/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 280, unzip_LRU len: 0
I/O sum[28138]:cur[12], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=2904, Main thread ID=7724, state: sleeping
Number of rows inserted 787147523, updated 24759306, deleted 783659233, read 18013825613
829.00 inserts/s, 22.62 updates/s, 828.73 deletes/s, 25394.64 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 29030
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================