Console
Storage engines
InnoDB
Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
=====================================
2026-06-18 00:31:51 6314 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 8410 srv_active, 0 srv_shutdown, 382760 srv_idle
srv_master_thread log flush and writes: 391169
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 12329
OS WAIT ARRAY INFO: signal count 11929
Mutex spin waits 106517, rounds 546263, OS waits 5072
RW-shared spins 28874, rounds 367988, OS waits 6798
RW-excl spins 402, rounds 9363, OS waits 287
Spin rounds per wait: 5.13 mutex, 12.74 RW-shared, 23.29 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 55734487
Purge done for trx's n:o < 55734479 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 52413, OS thread handle 0x6314, query id 716312 localhost 127.0.0.1 root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 55734486, not started
MySQL thread id 52412, OS thread handle 0x6314, query id 716306 localhost 127.0.0.1 pma
---TRANSACTION 55343363, not started
MySQL thread id 1, OS thread handle 0x2504, query id 0 Waiting for requests
--------
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, 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
167307 OS file reads, 86781 OS file writes, 41663 OS fsyncs
5.64 reads/s, 16384 avg bytes/read, 4.21 writes/s, 0.89 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 141, seg size 143, 1 merges
merged operations:
insert 1, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
0.86 hash searches/s, 3.68 non-hash searches/s
---
LOG
---
Log sequence number 1105936873
Log flushed up to 1105936873
Pages flushed up to 1105935581
Last checkpoint at 1105935581
Max checkpoint age 7782360
Checkpoint age target 7539162
Modified age 1292
Checkpoint age 1292
0 pending log writes, 0 pending chkp writes
24191 log i/o's done, 0.43 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 17203200; in additional pool allocated 0
Total memory allocated by read views 43792
Internal hash tables (constant factor + variable factor)
Adaptive hash index 297300 (276764 + 20536)
Page hash 9068 (buffer pool 0 only)
Dictionary cache 559917 (69928 + 489989)
File system 447896 (406136 + 41760)
Lock system 22124 (21188 + 936)
Recovery system 0 (0 + 0)
Dictionary memory allocated 489989
Buffer pool size 1023
Buffer pool size, bytes 16760832
Free buffers 766
Database pages 256
Old database pages 0
Modified db pages 3
Percent of dirty pages(LRU & free pages): 0.293
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2819, not young 257603
0.00 youngs/s, 0.00 non-youngs/s
Pages read 167210, created 648, written 55592
5.64 reads/s, 0.07 creates/s, 3.54 writes/s
Buffer pool hit rate 865 / 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: 256, unzip_LRU len: 0
I/O sum[271]:cur[0], 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 id 9328, state: sleeping
Number of rows inserted 6524, updated 12928, deleted 313, read 43123187
0.00 inserts/s, 0.32 updates/s, 0.00 deletes/s, 21.75 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 48
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================