Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
Variabel
|
Penampungan Penyangga
|
Status InnoDB
]
=====================================
2026-11-01 10:59:19 0x7f836a9f3700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 43 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 194224 srv_active, 0 srv_shutdown, 766370 srv_idle
srv_master_thread log flush and writes: 960307
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1695208
OS WAIT ARRAY INFO: signal count 1525205
RW-shared spins 0, rounds 1780200, OS waits 191379
RW-excl spins 0, rounds 129108, OS waits 1406
RW-sx spins 309, rounds 5340, OS waits 103
Spin rounds per wait: 1780200.00 RW-shared, 129108.00 RW-excl, 17.28 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-11-01 10:05:32 0x7f8364115700 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 720696051
Purge done for trx's n:o < 720696051 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421684265899448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265895192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265903704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265890936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265873912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265882424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265878168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265886680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265869656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421684265865400, 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
116463 OS file reads, 2854016 OS file writes, 2009300 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 3.65 writes/s, 2.70 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 2994 merges
merged operations:
insert 3783, delete mark 73, delete 58
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 6 buffer(s)
Hash table size 1593833, node heap has 97 buffer(s)
Hash table size 1593833, node heap has 696 buffer(s)
Hash table size 1593833, node heap has 155 buffer(s)
Hash table size 1593833, node heap has 416 buffer(s)
Hash table size 1593833, node heap has 103 buffer(s)
Hash table size 1593833, node heap has 521 buffer(s)
Hash table size 1593833, node heap has 327 buffer(s)
17715.52 hash searches/s, 252.60 non-hash searches/s
---
LOG
---
Log sequence number 59045498235
Log flushed up to 59045498214
Pages flushed up to 59045494309
Last checkpoint at 59045485234
0 pending log flushes, 0 pending chkp writes
890723 log i/o's done, 1.26 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size 384720
Free buffers 267349
Database pages 115050
Old database pages 42618
Modified db pages 9
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 308, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 113396, created 1654, written 1480422
0.00 reads/s, 0.00 creates/s, 1.70 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: 115050, 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 33613
Database pages 14189
Old database pages 5257
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 33, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14072, created 117, written 260352
0.00 reads/s, 0.00 creates/s, 0.28 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: 14189, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 48090
Free buffers 33317
Database pages 14478
Old database pages 5364
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 34, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14392, created 86, written 40886
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: 14478, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 48090
Free buffers 33816
Database pages 13979
Old database pages 5179
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 33, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13742, created 237, written 105590
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: 13979, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 48090
Free buffers 33265
Database pages 14535
Old database pages 5383
Modified db pages 4
Percent of dirty pages(LRU & free pages): 0.008
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 31, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14348, created 187, written 436009
0.00 reads/s, 0.00 creates/s, 1.02 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: 14535, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 48090
Free buffers 32712
Database pages 15096
Old database pages 5592
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 39, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14911, created 185, written 288782
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: 15096, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 48090
Free buffers 33365
Database pages 14439
Old database pages 5346
Modified db pages 2
Percent of dirty pages(LRU & free pages): 0.004
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 53, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14078, created 361, written 133836
0.00 reads/s, 0.00 creates/s, 0.12 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: 14439, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 48090
Free buffers 34143
Database pages 13652
Old database pages 5059
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 42, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13383, created 269, written 80591
0.00 reads/s, 0.00 creates/s, 0.28 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: 13652, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 48090
Free buffers 33118
Database pages 14682
Old database pages 5438
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 43, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14470, created 212, written 134376
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: 14682, 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=3916, Main thread ID=140202474325760, state: sleeping
Number of rows inserted 170783, updated 127361, deleted 89299, read 28993732299
0.00 inserts/s, 0.44 updates/s, 0.00 deletes/s, 17952.58 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 223696
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
