Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2026-06-04 21:05:42 0x7fcf14b41700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 6 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1787565 srv_active, 0 srv_shutdown, 580967 srv_idle
srv_master_thread log flush and writes: 2368384
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 10573819
OS WAIT ARRAY INFO: signal count 6233028
RW-shared spins 0, rounds 3301560, OS waits 663511
RW-excl spins 0, rounds 745012, OS waits 19706
RW-sx spins 909, rounds 19422, OS waits 464
Spin rounds per wait: 3301560.00 RW-shared, 745012.00 RW-excl, 21.37 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-06-04 19:59:16 0x7fcf0fe3d700 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 408462346
Purge done for trx's n:o < 408462346 undo n:o < 0 state: running
History list length 9
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, 24685063 OS file writes, 15832184 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 10.16 writes/s, 10.16 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)
39.33 hash searches/s, 128.81 non-hash searches/s
---
LOG
---
Log sequence number 45762170562
Log flushed up to   45762170562
Pages flushed up to 45761843595
Last checkpoint at  45761843595
0 pending log flushes, 0 pending chkp writes
7213244 log i/o's done, 10.17 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  250
Percent of dirty pages(LRU & free pages): 0.065
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 13556621
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: 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  20
Percent of dirty pages(LRU & free pages): 0.042
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 2714143
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: 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 105284
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  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 43, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13592, created 285, written 720696
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  117
Percent of dirty pages(LRU & free pages): 0.245
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 4640200
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: 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  53
Percent of dirty pages(LRU & free pages): 0.111
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 2744213
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: 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  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 51, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14031, created 415, written 1034256
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: 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  16
Percent of dirty pages(LRU & free pages): 0.034
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 550520
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  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 77, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14134, created 536, written 1047309
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: 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 414767, updated 3421006, deleted 234970, read 56814291296
0.00 inserts/s, 9.33 updates/s, 0.00 deletes/s, 57.49 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 5807053
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================