Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2026-08-05 22:10:36 0x7efbc408d640 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 4675 srv_active, 0 srv_shutdown, 751797 srv_idle
srv_master_thread log flush and writes: 756419
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 102863
OS WAIT ARRAY INFO: signal count 70279
RW-shared spins 7883, rounds 222614, OS waits 7328
RW-excl spins 1532, rounds 9261, OS waits 113
RW-sx spins 40, rounds 945, OS waits 18
Spin rounds per wait: 28.24 RW-shared, 6.05 RW-excl, 23.62 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 5090393
Purge done for trx's n:o < 5090393 undo n:o < 0 state: running
History list length 20
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421082294841880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421082294837656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421082294833432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421082294829208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
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] , 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
177824 OS file reads, 94730 OS file writes, 55782 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 14.46 writes/s, 2.29 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 11, seg size 13, 7 merges
merged operations:
 insert 7, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
0.00 hash searches/s, 36.11 non-hash searches/s
---
LOG
---
Log sequence number 11268344077
Log flushed up to   11268339326
Pages flushed up to 11268326000
Last checkpoint at  11268326000
0 pending log flushes, 0 pending chkp writes
35798 log i/o's done, 6.11 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 16777216000
Dictionary memory allocated 13000320
Buffer pool size   963217
Free buffers       791561
Database pages     171656
Old database pages 63521
Modified db pages  31
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 171359, created 297, written 42430
0.00 reads/s, 0.00 creates/s, 7.79 writes/s
Buffer pool hit rate 1000 / 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: 171656, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   120390
Free buffers       98122
Database pages     22268
Old database pages 8240
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.001
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22253, created 15, written 4296
0.00 reads/s, 0.00 creates/s, 0.61 writes/s
Buffer pool hit rate 1000 / 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: 22268, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   120397
Free buffers       99009
Database pages     21388
Old database pages 7914
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
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 21371, created 17, written 4707
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 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: 21388, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   120405
Free buffers       99445
Database pages     20960
Old database pages 7757
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
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 20947, created 13, written 1436
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 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: 20960, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   120405
Free buffers       98981
Database pages     21424
Old database pages 7928
Modified db pages  4
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21403, created 21, written 11648
0.00 reads/s, 0.00 creates/s, 3.36 writes/s
Buffer pool hit rate 1000 / 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: 21424, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   120405
Free buffers       98513
Database pages     21892
Old database pages 8100
Modified db pages  22
Percent of dirty pages(LRU & free pages): 0.018
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 21857, created 35, written 7839
0.00 reads/s, 0.00 creates/s, 3.14 writes/s
Buffer pool hit rate 1000 / 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: 21892, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   120405
Free buffers       99475
Database pages     20930
Old database pages 7746
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
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 20882, created 48, written 7234
0.00 reads/s, 0.00 creates/s, 0.04 writes/s
Buffer pool hit rate 1000 / 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: 20930, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   120405
Free buffers       99707
Database pages     20698
Old database pages 7660
Modified db pages  4
Percent of dirty pages(LRU & free pages): 0.003
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 20628, created 70, written 3222
0.00 reads/s, 0.00 creates/s, 0.64 writes/s
Buffer pool hit rate 1000 / 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: 20698, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   120405
Free buffers       98309
Database pages     22096
Old database pages 8176
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
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 22018, created 78, written 2048
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 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: 22096, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=1375, Main thread ID=139590170035776, state: sleeping
Number of rows inserted 5126, updated 4912, deleted 1290, read 12393071
0.00 inserts/s, 2.50 updates/s, 0.00 deletes/s, 3.86 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 19359
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================