Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2026-06-05 05:59:14 0x7fcf15582700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 37 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1818336 srv_active, 0 srv_shutdown, 582007 srv_idle
srv_master_thread log flush and writes: 2400195
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 10839263
OS WAIT ARRAY INFO: signal count 6377442
RW-shared spins 0, rounds 3309652, OS waits 666533
RW-excl spins 0, rounds 753010, OS waits 19946
RW-sx spins 914, rounds 19572, OS waits 469
Spin rounds per wait: 3309652.00 RW-shared, 753010.00 RW-excl, 21.41 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-06-04 22:44:24 0x7fd17016a700 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 419584782
Purge done for trx's n:o < 419584782 undo n:o < 0 state: running but idle
History list length 12
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422012492640760, 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
115839 OS file reads, 25160215 OS file writes, 16133273 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 14.22 writes/s, 8.62 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 1722 merges
merged operations:
 insert 2068, delete mark 158, delete 124
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 29 buffer(s)
Hash table size 1593833, node heap has 469 buffer(s)
Hash table size 1593833, node heap has 1016 buffer(s)
Hash table size 1593833, node heap has 146 buffer(s)
Hash table size 1593833, node heap has 77 buffer(s)
Hash table size 1593833, node heap has 209 buffer(s)
Hash table size 1593833, node heap has 492 buffer(s)
Hash table size 1593833, node heap has 289 buffer(s)
185.75 hash searches/s, 70.43 non-hash searches/s
---
LOG
---
Log sequence number 46045632278
Log flushed up to   46045632257
Pages flushed up to 46045574797
Last checkpoint at  46045557095
0 pending log flushes, 0 pending chkp writes
7464054 log i/o's done, 4.30 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size   384720
Free buffers       265779
Database pages     116214
Old database pages 42823
Modified db pages  76
Percent of dirty pages(LRU & free pages): 0.020
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 451, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 112772, created 3442, written 13757505
0.00 reads/s, 0.00 creates/s, 7.86 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: 116214, 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       33243
Database pages     14505
Old database pages 5336
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.010
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 41, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13988, created 517, written 2746795
0.00 reads/s, 0.00 creates/s, 1.03 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: 14505, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   48090
Free buffers       32953
Database pages     14808
Old database pages 5463
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 61, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14448, created 360, written 105293
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: 14808, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   48090
Free buffers       33873
Database pages     13877
Old database pages 5129
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 13592, created 285, written 733278
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: 13877, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   48090
Free buffers       32692
Database pages     15069
Old database pages 5542
Modified db pages  16
Percent of dirty pages(LRU & free pages): 0.033
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 47, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14463, created 606, written 4707498
0.00 reads/s, 0.00 creates/s, 3.03 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: 15069, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   48090
Free buffers       32281
Database pages     15472
Old database pages 5725
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 60, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 15181, created 291, written 2787541
0.00 reads/s, 0.00 creates/s, 1.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: 15472, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   48090
Free buffers       33307
Database pages     14446
Old database pages 5313
Modified db pages  14
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 51, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14031, created 415, written 1053023
0.00 reads/s, 0.00 creates/s, 1.19 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: 14446, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   48090
Free buffers       34371
Database pages     13367
Old database pages 4919
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 71, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12935, created 432, written 559757
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: 13367, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   48090
Free buffers       33059
Database pages     14670
Old database pages 5396
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 77, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14134, created 536, written 1064320
0.00 reads/s, 0.00 creates/s, 1.62 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: 14670, 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 414782, updated 3635237, deleted 234972, read 56841433295
0.00 inserts/s, 2.84 updates/s, 0.00 deletes/s, 40.86 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 6095981
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================