Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-06-17 22:52:45 2c3c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 14 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 7838 srv_active, 0 srv_shutdown, 377440 srv_idle
srv_master_thread log flush and writes: 385277
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 10873
OS WAIT ARRAY INFO: signal count 10581
Mutex spin waits 98640, rounds 487060, OS waits 4628
RW-shared spins 25151, rounds 323547, OS waits 5872
RW-excl spins 328, rounds 7439, OS waits 232
Spin rounds per wait: 4.94 mutex, 12.86 RW-shared, 22.68 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 55709276
Purge done for trx's n:o < 55709271 undo n:o < 0 state: running but idle
History list length 26
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 45753, OS thread handle 0x2c3c, query id 606023 localhost 127.0.0.1 root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 55709273, not started
MySQL thread id 45752, OS thread handle 0x5fdc, query id 606013 localhost 127.0.0.1 pma 
---TRANSACTION 55343363, not started
MySQL thread id 1, OS thread handle 0x2504, query id 0 Waiting for requests
---TRANSACTION 55709275, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 312, 1 row lock(s)
MySQL thread id 45750, OS thread handle 0x5fdc, query id 606021 localhost 127.0.0.1 pma update
REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{\"db\":\"mysql\",\"table\":\"time_zone_transition\"},{\"db\":\"get_data_from_bc\",\"table\":\"pr_header\"},{\"db\":\"get_data_from_bc\",\"table\":\"so_header\"},{\"db\":\"wa_ops_automation\",\"table\":\"batch_logs\"},{\"db\":\"mysql\",\"table\":\"table_stats\"},{\"db\":\"information_schema\",\"table\":\"ENABLED_ROLES\"},{\"db\":\"mysql\",\"table\":\"proc\"},{\"db\":\"phpmyadmin\",\"table\":\"pma__recent\"},{\"db\":\"information_schema\",\"table\":\"INNODB_CMP_RESET\"},{\"db\":\"performance_schema\",\"table\":\"se
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
--------
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: complete io for buf page (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: 1
142467 OS file reads, 73147 OS file writes, 36750 OS fsyncs
1 pending reads, 0 pending writes
106.42 reads/s, 16384 avg bytes/read, 25.43 writes/s, 8.14 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
7.21 hash searches/s, 51.07 non-hash searches/s
---
LOG
---
Log sequence number 1102263764
Log flushed up to   1102263764
Pages flushed up to 1102257860
Last checkpoint at  1102199797
Max checkpoint age    7782360
Checkpoint age target 7539162
Modified age          5904
Checkpoint age        63967
0 pending log writes, 0 pending chkp writes
21165 log i/o's done, 5.14 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 17203200; in additional pool allocated 0
Total memory allocated by read views 26312
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         22436 	(21188 + 1248)
    Recovery system     0 	(0 + 0)
Dictionary memory allocated 489989
Buffer pool size        1023
Buffer pool size, bytes 16760832
Free buffers            765
Database pages          257
Old database pages      0
Modified db pages       11
Percent of dirty pages(LRU & free pages): 1.075
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2483, not young 217417
0.07 youngs/s, 153.63 non-youngs/s
Pages read 142369, created 493, written 45804
106.35 reads/s, 0.29 creates/s, 18.78 writes/s
Buffer pool hit rate 804 / 1000, young-making rate 0 / 1000 not 282 / 1000
Pages read ahead 84.07/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 257, unzip_LRU len: 0
I/O sum[2879]:cur[11], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
1 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
1 out of 1000 descriptors used
Main thread id 9328, state: sleeping
Number of rows inserted 6524, updated 10155, deleted 313, read 41288016
0.00 inserts/s, 4.64 updates/s, 0.00 deletes/s, 1489.54 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 35
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================