Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2026-10-02 15:14:18 0x7f9c48328700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 18 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 122186 srv_active, 0 srv_shutdown, 420535 srv_idle
srv_master_thread log flush and writes: 542599
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1972141
OS WAIT ARRAY INFO: signal count 1393935
RW-shared spins 0, rounds 1041574, OS waits 119265
RW-excl spins 0, rounds 81419, OS waits 495
RW-sx spins 149, rounds 2836, OS waits 56
Spin rounds per wait: 1041574.00 RW-shared, 81419.00 RW-excl, 19.03 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-10-02 14:57:22 0x7f9c48085700 Transaction:
TRANSACTION 654568585, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 1 row lock(s)
MySQL thread id 3852089, OS thread handle 140309200131840, query id 19916172 192.168.123.31 root Update
insert into telaah_farmasi values('202610020085','Ya','','Ya','','Ya','','Ya','','Ya','','Tidak','','Tidak','','Tidak','','Ya','Ya','Ya','Ya','Ya','201305014')
Foreign key constraint fails for table `sik`.`telaah_farmasi`:
,
  CONSTRAINT `telaah_farmasi_ibfk_1` FOREIGN KEY (`no_resep`) REFERENCES `resep_obat` (`no_resep`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index PRIMARY tuple:
DATA TUPLE: 25 fields;
 0: len 12; hex 323032363130303230303835; asc 202610020085;;
 1: len 6; hex 00002703ec89; asc   '   ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 1; hex 01; asc  ;;
 4: len 0; hex ; asc ;;
 5: len 1; hex 01; asc  ;;
 6: len 0; hex ; asc ;;
 7: len 1; hex 01; asc  ;;
 8: len 0; hex ; asc ;;
 9: len 1; hex 01; asc  ;;
 10: len 0; hex ; asc ;;
 11: len 1; hex 01; asc  ;;
 12: len 0; hex ; asc ;;
 13: len 1; hex 02; asc  ;;
 14: len 0; hex ; asc ;;
 15: len 1; hex 02; asc  ;;
 16: len 0; hex ; asc ;;
 17: len 1; hex 02; asc  ;;
 18: len 0; hex ; asc ;;
 19: len 1; hex 01; asc  ;;
 20: len 1; hex 01; asc  ;;
 21: len 1; hex 01; asc  ;;
 22: len 1; hex 01; asc  ;;
 23: len 1; hex 01; asc  ;;
 24: len 9; hex 323031333035303134; asc 201305014;;

But in parent table `sik`.`resep_obat`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 12; compact format; info bits 0
 0: len 12; hex 323032363130303230303834; asc 202610020084;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 800000; asc    ;;
 4: len 3; hex 800000; asc    ;;
 5: len 17; hex 323032362f31302f30322f303030303135; asc 2026/10/02/000015;;
 6: len 8; hex 4430303030303034; asc D0000004;;
 7: len 3; hex 8fd542; asc   B;;
 8: len 3; hex 80e15b; asc   [;;
 9: len 1; hex 01; asc  ;;
 10: len 3; hex 800000; asc    ;;
 11: len 3; hex 800000; asc    ;;

------------
TRANSACTIONS
------------
Trx id counter 654635283
Purge done for trx's n:o < 654635283 undo n:o < 0 state: running but idle
History list length 6
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421786141890936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141882424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141873912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141865400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141839864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141835608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141861144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141886680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141878168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141869656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141856888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141852632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141848376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141844120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141831352, 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
105644 OS file reads, 1803170 OS file writes, 1264443 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 17.78 writes/s, 8.06 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 1044 merges
merged operations:
 insert 1258, delete mark 2, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 13 buffer(s)
Hash table size 1593833, node heap has 92 buffer(s)
Hash table size 1593833, node heap has 571 buffer(s)
Hash table size 1593833, node heap has 152 buffer(s)
Hash table size 1593833, node heap has 65 buffer(s)
Hash table size 1593833, node heap has 104 buffer(s)
Hash table size 1593833, node heap has 507 buffer(s)
Hash table size 1593833, node heap has 309 buffer(s)
8679.07 hash searches/s, 246.65 non-hash searches/s
---
LOG
---
Log sequence number 58057816224
Log flushed up to   58057816224
Pages flushed up to 58057782668
Last checkpoint at  58057699747
0 pending log flushes, 0 pending chkp writes
602575 log i/o's done, 6.39 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size   384720
Free buffers       279164
Database pages     103743
Old database pages 38422
Modified db pages  71
Percent of dirty pages(LRU & free pages): 0.019
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 193, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 102605, created 1138, written 917892
0.00 reads/s, 0.00 creates/s, 10.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: 103743, 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       34960
Database pages     12903
Old database pages 4782
Modified db pages  10
Percent of dirty pages(LRU & free pages): 0.021
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 15, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12823, created 80, written 162810
0.00 reads/s, 0.00 creates/s, 0.72 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: 12903, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   48090
Free buffers       34720
Database pages     13141
Old database pages 4868
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 31, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13055, created 86, written 25438
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: 13141, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   48090
Free buffers       35244
Database pages     12616
Old database pages 4673
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 19, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12464, created 152, written 63092
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: 12616, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   48090
Free buffers       34471
Database pages     13394
Old database pages 4957
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 31, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13164, created 230, written 293972
0.00 reads/s, 0.00 creates/s, 4.17 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: 13394, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   48090
Free buffers       34584
Database pages     13282
Old database pages 4914
Modified db pages  21
Percent of dirty pages(LRU & free pages): 0.044
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 24, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13126, created 156, written 174629
0.00 reads/s, 0.00 creates/s, 2.11 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: 13282, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   48090
Free buffers       35078
Database pages     12783
Old database pages 4735
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 27, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12690, created 93, written 72667
0.00 reads/s, 0.00 creates/s, 2.44 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: 12783, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   48090
Free buffers       35233
Database pages     12633
Old database pages 4681
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 22, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12487, created 146, written 44073
0.00 reads/s, 0.00 creates/s, 1.17 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: 12633, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   48090
Free buffers       34874
Database pages     12991
Old database pages 4812
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 24, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12796, created 195, written 81211
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: 12991, 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=1102, Main thread ID=140302424925952, state: sleeping
Number of rows inserted 125361, updated 85558, deleted 76051, read 17374171121
0.00 inserts/s, 5.33 updates/s, 0.00 deletes/s, 13282.48 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 538887
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 169.38 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================