Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
Variables
|
Buffer Pool
|
InnoDB Status
]
=====================================
2026-09-02 20:37:44 0x3538 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 48 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 600242 srv_active, 0 srv_shutdown, 343585 srv_idle
srv_master_thread log flush and writes: 943048
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 43038292
OS WAIT ARRAY INFO: signal count 253848837
RW-shared spins 420740739, rounds 1950033088, OS waits 29953731
RW-excl spins 1026761163, rounds 3437687977, OS waits 3859591
RW-sx spins 127170154, rounds 814517648, OS waits 5442650
Spin rounds per wait: 4.63 RW-shared, 3.35 RW-excl, 6.40 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 30937769
Purge done for trx's n:o < 30937769 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283782208619288, 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 283782208627624, 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 283782208677640, 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
273305813 OS file reads, 212211801 OS file writes, 37991115 OS fsyncs
365.68 reads/s, 16384 avg bytes/read, 255.64 writes/s, 48.81 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 42, seg size 44, 1171363 merges
merged operations:
insert 3882145, delete mark 3435369, delete 3315305
discarded operations:
insert 0, delete mark 0, delete 0
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 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)
2973.56 hash searches/s, 6086.23 non-hash searches/s
---
LOG
---
Log sequence number 720163914234
Log flushed up to 720163914081
Pages flushed up to 720163907017
Last checkpoint at 720157483613
0 pending log flushes, 0 pending chkp writes
17580493 log i/o's done, 21.65 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 696112
Buffer pool size 1003
Free buffers 738
Database pages 256
Old database pages 0
Modified db pages 16
Percent of dirty pages(LRU & free pages): 1.608
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14558729, not young 13099928149
13.50 youngs/s, 15470.22 non-youngs/s
Pages read 273305776, created 31037928, written 190079272
365.68 reads/s, 36.52 creates/s, 228.04 writes/s
Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 270 / 1000
Pages read ahead 15.31/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 256, unzip_LRU len: 0
I/O sum[26255]:cur[84], 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 785934912, updated 24716776, deleted 782447947, read 17975413503
934.02 inserts/s, 26.27 updates/s, 933.50 deletes/s, 26696.15 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 25520
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
