Console
Storage engines
InnoDB
Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
=====================================
2026-07-21 17:11:01 7fbbdd0dbb00 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 58 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 4066 srv_active, 0 srv_shutdown, 121957 srv_idle
srv_master_thread log flush and writes: 126022
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2752
OS WAIT ARRAY INFO: signal count 2688
Mutex spin waits 10710, rounds 89473, OS waits 1365
RW-shared spins 1255, rounds 37492, OS waits 1249
RW-excl spins 4, rounds 3313, OS waits 110
Spin rounds per wait: 8.35 mutex, 29.87 RW-shared, 828.25 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 77000
Purge done for trx's n:o < 76988 undo n:o < 0 state: running but idle
History list length 28
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 17374, OS thread handle 0x7fbbdd0dbb00, query id 275454 localhost root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 76996, not started
MySQL thread id 17373, OS thread handle 0x7fbbec582b00, query id 275442 localhost pma
---TRANSACTION 76999, not started
MySQL thread id 17371, OS thread handle 0x7fbbdd126b00, query id 275450 localhost pma
---TRANSACTION 2819, not started
MySQL thread id 1, OS thread handle 0x7fbbec5cdb00, query id 0 Waiting for requests
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
8924 OS file reads, 28167 OS file writes, 18253 OS fsyncs
2.78 reads/s, 16384 avg bytes/read, 5.14 writes/s, 2.97 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
5.55 hash searches/s, 25.47 non-hash searches/s
---
LOG
---
Log sequence number 10801751
Log flushed up to 10801751
Pages flushed up to 10786172
Last checkpoint at 10784228
Max checkpoint age 7782360
Checkpoint age target 7539162
Modified age 15579
Checkpoint age 17523
0 pending log writes, 0 pending chkp writes
8131 log i/o's done, 1.52 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 17580032; in additional pool allocated 0
Total memory allocated by read views 392
Internal hash tables (constant factor + variable factor)
Adaptive hash index 297776 (277192 + 20584)
Page hash 18136 (buffer pool 0 only)
Dictionary cache 163240 (70736 + 92504)
File system 834872 (812272 + 22600)
Lock system 43816 (42376 + 1440)
Recovery system 0 (0 + 0)
Dictionary memory allocated 92504
Buffer pool size 1023
Buffer pool size, bytes 16760832
Free buffers 763
Database pages 259
Old database pages 0
Modified db pages 26
Percent of dirty pages(LRU & free pages): 2.542
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8890, created 339, written 28081
2.78 reads/s, 0.14 creates/s, 5.47 writes/s
Buffer pool hit rate 971 / 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: 259, unzip_LRU len: 0
I/O sum[464]:cur[7], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
0 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
0 out of 1000 descriptors used
Main thread process no. 277, id 140444910425856, state: sleeping
Number of rows inserted 3, updated 6712, deleted 0, read 22686
0.00 inserts/s, 1.53 updates/s, 0.00 deletes/s, 6.07 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 96
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.03 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================