Speicher-Engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
Variablen
|
Puffer-Pool
|
InnoDB-Status
]
=====================================
2026-08-04 15:06:09 0x7fcf15951700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 21 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 5410649 srv_active, 0 srv_shutdown, 2186217 srv_idle
srv_master_thread log flush and writes: 7596033
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 27492015
OS WAIT ARRAY INFO: signal count 17453187
RW-shared spins 0, rounds 11248657, OS waits 1974631
RW-excl spins 0, rounds 1902090, OS waits 44384
RW-sx spins 2438, rounds 48931, OS waits 1059
Spin rounds per wait: 11248657.00 RW-shared, 1902090.00 RW-excl, 20.07 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-08-04 14:05:41 0x7fcf1497f700 Error in foreign key constraint of table sikbackup/detail_piutang_pasien:
there is no index in the table which would contain
the columns as the first columns, or the data types in the
table do not match the ones in the referenced table
or one of the ON ... SET NULL columns is declared NOT NULL. Constraint:
,
CONSTRAINT `detail_piutang_pasien_ibfk_5` FOREIGN KEY (`no_rawat`) REFERENCES `reg_periksa` (`no_rawat`) ON UPDATE CASCADE
------------
TRANSACTIONS
------------
Trx id counter 545577811
Purge done for trx's n:o < 545577811 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422012492691832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492662040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492704600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492687576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492717368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492679064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492640760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492674808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492670552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492713112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492700344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492683320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492653528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492666296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492657784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492649272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492645016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492636504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492632248, not started
0 lock struct(s), heap size 1136, 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
117050 OS file reads, 64200585 OS file writes, 41721576 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 15.09 writes/s, 7.33 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 1954 merges
merged operations:
insert 2338, delete mark 177, delete 124
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 45 buffer(s)
Hash table size 1593833, node heap has 496 buffer(s)
Hash table size 1593833, node heap has 1436 buffer(s)
Hash table size 1593833, node heap has 158 buffer(s)
Hash table size 1593833, node heap has 106 buffer(s)
Hash table size 1593833, node heap has 325 buffer(s)
Hash table size 1593833, node heap has 566 buffer(s)
Hash table size 1593833, node heap has 333 buffer(s)
7253.94 hash searches/s, 188.66 non-hash searches/s
---
LOG
---
Log sequence number 53472293963
Log flushed up to 53472293942
Pages flushed up to 53472229699
Last checkpoint at 53472229699
0 pending log flushes, 0 pending chkp writes
19797298 log i/o's done, 6.10 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size 384720
Free buffers 256004
Database pages 125251
Old database pages 46071
Modified db pages 111
Percent of dirty pages(LRU & free pages): 0.029
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 895, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 113983, created 11268, written 34515972
0.00 reads/s, 0.00 creates/s, 8.43 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: 125251, 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 48090
Free buffers 31946
Database pages 15701
Old database pages 5775
Modified db pages 13
Percent of dirty pages(LRU & free pages): 0.027
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 88, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14162, created 1539, written 6855001
0.00 reads/s, 0.00 creates/s, 2.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: 15701, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 48090
Free buffers 31895
Database pages 15778
Old database pages 5804
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 108, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14608, created 1170, written 262980
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: 15778, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 48090
Free buffers 32715
Database pages 14947
Old database pages 5497
Modified db pages 22
Percent of dirty pages(LRU & free pages): 0.046
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 82, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13704, created 1243, written 1975628
0.00 reads/s, 0.00 creates/s, 1.38 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: 14947, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 48090
Free buffers 31399
Database pages 16271
Old database pages 5986
Modified db pages 28
Percent of dirty pages(LRU & free pages): 0.059
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 94, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14614, created 1657, written 11559680
0.00 reads/s, 0.00 creates/s, 1.95 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: 16271, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 48090
Free buffers 31027
Database pages 16654
Old database pages 6127
Modified db pages 43
Percent of dirty pages(LRU & free pages): 0.090
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 131, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 15358, created 1296, written 7003290
0.00 reads/s, 0.00 creates/s, 2.67 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: 16654, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 48090
Free buffers 32010
Database pages 15638
Old database pages 5752
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 109, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14135, created 1503, written 2668603
0.00 reads/s, 0.00 creates/s, 0.05 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: 15638, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 48090
Free buffers 33200
Database pages 14437
Old database pages 5309
Modified db pages 3
Percent of dirty pages(LRU & free pages): 0.006
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 145, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13109, created 1328, written 1459609
0.00 reads/s, 0.00 creates/s, 0.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: 14437, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 48090
Free buffers 31812
Database pages 15825
Old database pages 5821
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 138, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14293, created 1532, written 2731181
0.00 reads/s, 0.00 creates/s, 0.10 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: 15825, 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=1126, Main thread ID=140528778766080, state: sleeping
Number of rows inserted 1394102, updated 8984249, deleted 784746, read 199845661103
0.00 inserts/s, 5.00 updates/s, 0.00 deletes/s, 6949.19 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 16501888
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1984.67 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
