Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-09-02 20:53:45 0x2cc0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 24 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 601111 srv_active, 0 srv_shutdown, 343676 srv_idle
srv_master_thread log flush and writes: 944008
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 43088228
OS WAIT ARRAY INFO: signal count 254117241
RW-shared spins 421182223, rounds 1952144932, OS waits 29987631
RW-excl spins 1027859585, rounds 3441485248, OS waits 3864392
RW-sx spins 127298129, rounds 815351170, OS waits 5448712
Spin rounds per wait: 4.63 RW-shared, 3.35 RW-excl, 6.41 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 30979250
Purge done for trx's n:o < 30979250 undo n:o < 0 state: running but idle
History list length 8
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283782208631792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208627624, 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 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 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
273668440 OS file reads, 212458929 OS file writes, 38040003 OS fsyncs
297.07 reads/s, 16384 avg bytes/read, 232.24 writes/s, 40.96 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 42, seg size 44, 1173059 merges
merged operations:
 insert 3887530, delete mark 3439804, delete 3319549
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 2 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 4 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)
2632.81 hash searches/s, 5292.15 non-hash searches/s
---
LOG
---
Log sequence number 720924212945
Log flushed up to   720924212925
Pages flushed up to 720924071606
Last checkpoint at  720924071570
0 pending log flushes, 0 pending chkp writes
17603603 log i/o's done, 18.54 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 696112
Buffer pool size   1003
Free buffers       675
Database pages     314
Old database pages 0
Modified db pages  65
Percent of dirty pages(LRU & free pages): 6.566
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14573475, not young 13116465561
15.42 youngs/s, 11690.18 non-youngs/s
Pages read 273668403, created 31072016, written 190297774
297.07 reads/s, 33.33 creates/s, 208.57 writes/s
Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 222 / 1000
Pages read ahead 9.33/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 314, unzip_LRU len: 0
I/O sum[25625]:cur[55], 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 786772228, updated 24747746, deleted 783284435, read 18001660106
778.18 inserts/s, 21.83 updates/s, 777.93 deletes/s, 23740.72 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
============================