Speicher-Engines

InnoDB

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

[ Variablen | Puffer-Pool | InnoDB-Status ]

=====================================
2026-06-15 14:01:07 0x7fcf14bd7700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 16 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2475186 srv_active, 0 srv_shutdown, 813775 srv_idle
srv_master_thread log flush and writes: 3288747
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 14194443
OS WAIT ARRAY INFO: signal count 8437025
RW-shared spins 0, rounds 4539045, OS waits 890290
RW-excl spins 0, rounds 1027058, OS waits 26971
RW-sx spins 1230, rounds 26658, OS waits 644
Spin rounds per wait: 4539045.00 RW-shared, 1027058.00 RW-excl, 21.67 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-06-15 11:29:20 0x7fcf14853700 Transaction:
TRANSACTION 442426484, 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 40120644, OS thread handle 140527379232512, query id 897710034 192.168.123.31 root Update
insert into telaah_farmasi values('202606150047','Ya','','Ya','','Ya','','Ya','','Ya','','Tidak','','Tidak','','Tidak','','Ya','Ya','Ya','Ya','Ya','202306049')
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 323032363036313530303437; asc 202606150047;;
 1: len 6; hex 00001a5ee474; asc    ^ t;;
 2: len 7; hex 96000006f3039b; 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 323032333036303439; asc 202306049;;

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 323032363036313530303436; asc 202606150046;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 8fd4cf; asc    ;;
 4: len 3; hex 80b721; asc   !;;
 5: len 17; hex 323032362f30362f31352f303030313338; asc 2026/06/15/000138;;
 6: len 8; hex 4430303030303034; asc D0000004;;
 7: len 3; hex 8fd4cf; asc    ;;
 8: len 3; hex 80b6f9; asc    ;;
 9: len 1; hex 01; asc  ;;
 10: len 3; hex 800000; asc    ;;
 11: len 3; hex 800000; asc    ;;

------------
TRANSACTIONS
------------
Trx id counter 442571167
Purge done for trx's n:o < 442571167 undo n:o < 0 state: running
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422012492662040, 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 422012492708856, 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 422012492696088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422012492691832, 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 422012492683320, 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 422012492670552, 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 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
116245 OS file reads, 34131113 OS file writes, 21748822 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 13.75 writes/s, 8.37 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 1820 merges
merged operations:
 insert 2179, delete mark 169, 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 473 buffer(s)
Hash table size 1593833, node heap has 1117 buffer(s)
Hash table size 1593833, node heap has 148 buffer(s)
Hash table size 1593833, node heap has 87 buffer(s)
Hash table size 1593833, node heap has 212 buffer(s)
Hash table size 1593833, node heap has 506 buffer(s)
Hash table size 1593833, node heap has 300 buffer(s)
5074.12 hash searches/s, 163.55 non-hash searches/s
---
LOG
---
Log sequence number 47903035872
Log flushed up to   47903035872
Pages flushed up to 47903035872
Last checkpoint at  47903020683
0 pending log flushes, 0 pending chkp writes
10146890 log i/o's done, 3.06 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size   384720
Free buffers       263976
Database pages     117872
Old database pages 43387
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 523, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 113178, created 4694, written 18720535
0.00 reads/s, 0.00 creates/s, 8.25 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: 117872, unzip_LRU len: 0
I/O sum[0]:cur[24], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   48090
Free buffers       32990
Database pages     14742
Old database pages 5422
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 49, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14052, created 690, written 3718071
0.00 reads/s, 0.00 creates/s, 2.56 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: 14742, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   48090
Free buffers       32716
Database pages     15032
Old database pages 5532
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 69, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14506, created 526, written 139226
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: 15032, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   48090
Free buffers       33672
Database pages     14060
Old database pages 5170
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 49, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13635, created 425, written 1010934
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: 14060, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   48090
Free buffers       32363
Database pages     15375
Old database pages 5656
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 53, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14524, created 851, written 6401580
0.00 reads/s, 0.00 creates/s, 3.56 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: 15375, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   48090
Free buffers       32149
Database pages     15591
Old database pages 5768
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 15236, created 355, written 3799200
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: 15591, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   48090
Free buffers       33021
Database pages     14707
Old database pages 5408
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 62, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14057, created 650, written 1443605
0.00 reads/s, 0.00 creates/s, 0.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: 14707, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   48090
Free buffers       34226
Database pages     13492
Old database pages 4961
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 84, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12977, created 515, written 762824
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: 13492, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   48090
Free buffers       32839
Database pages     14873
Old database pages 5470
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 86, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14191, created 682, written 1445095
0.00 reads/s, 0.00 creates/s, 1.69 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: 14873, unzip_LRU len: 0
I/O sum[0]:cur[3], 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 576877, updated 4962418, deleted 326865, read 80385190359
0.00 inserts/s, 1.81 updates/s, 0.00 deletes/s, 5147.18 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 8642059
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================