Speicher-Engines

InnoDB

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

[ Variablen | Puffer-Pool | InnoDB-Status ]

=====================================
2026-02-04 18:33:25 0x7f9ea02ce700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 49 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 133483 srv_active, 0 srv_shutdown, 222843 srv_idle
srv_master_thread log flush and writes: 356240
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1902284
OS WAIT ARRAY INFO: signal count 1125672
RW-shared spins 0, rounds 509404, OS waits 102983
RW-excl spins 0, rounds 66600, OS waits 1064
RW-sx spins 148, rounds 2275, OS waits 32
Spin rounds per wait: 509404.00 RW-shared, 66600.00 RW-excl, 15.37 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-02-04 17:47:51 0x7fa0b4475700 Transaction:
TRANSACTION 213248641, 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 3703078, OS thread handle 140328196069120, query id 71757444 192.168.123.31 root Update
insert into telaah_farmasi values('202602040105','Ya','','Ya','','Ya','','Ya','','Ya','','Tidak','','Tidak','','Tidak','','Ya','Ya','Ya','Ya','Ya','202409056')
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 323032363032303430313035; asc 202602040105;;
 1: len 6; hex 00000cb5ea81; 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 323032343039303536; asc 202409056;;

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 323032363032303430313034; asc 202602040104;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 8fd444; asc   D;;
 4: len 3; hex 811bcd; asc    ;;
 5: len 17; hex 323032362f30322f30342f303030303731; asc 2026/02/04/000071;;
 6: len 8; hex 4430303030303032; asc D0000002;;
 7: len 3; hex 8fd444; asc   D;;
 8: len 3; hex 811ba8; asc    ;;
 9: len 1; hex 01; asc  ;;
 10: len 3; hex 800000; asc    ;;
 11: len 3; hex 800000; asc    ;;

------------
TRANSACTIONS
------------
Trx id counter 214068944
Purge done for trx's n:o < 214068939 undo n:o < 0 state: running
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421803186177144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186155864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186202680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186185656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186253752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186206936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186194168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186181400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186172888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186168632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186164376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186160120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186151608, 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
106415 OS file reads, 2055016 OS file writes, 1441698 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 14.31 writes/s, 11.67 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 419 merges
merged operations:
 insert 478, delete mark 1, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 24 buffer(s)
Hash table size 1593833, node heap has 63 buffer(s)
Hash table size 1593833, node heap has 571 buffer(s)
Hash table size 1593833, node heap has 49 buffer(s)
Hash table size 1593833, node heap has 41 buffer(s)
Hash table size 1593833, node heap has 96 buffer(s)
Hash table size 1593833, node heap has 368 buffer(s)
Hash table size 1593833, node heap has 249 buffer(s)
83791.43 hash searches/s, 1078.18 non-hash searches/s
---
LOG
---
Log sequence number 28831543955
Log flushed up to   28831543934
Pages flushed up to 28830969369
Last checkpoint at  28830967117
0 pending log flushes, 0 pending chkp writes
754076 log i/o's done, 10.43 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size   384720
Free buffers       279000
Database pages     104259
Old database pages 38578
Modified db pages  171
Percent of dirty pages(LRU & free pages): 0.045
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 148, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 103376, created 883, written 995541
0.00 reads/s, 0.00 creates/s, 3.29 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: 104259, 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       34918
Database pages     12989
Old database pages 4812
Modified db pages  12
Percent of dirty pages(LRU & free pages): 0.025
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12850, created 139, written 244472
0.00 reads/s, 0.00 creates/s, 0.57 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: 12989, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   48090
Free buffers       34670
Database pages     13242
Old database pages 4905
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 23, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13209, created 33, written 17807
0.00 reads/s, 0.00 creates/s, 0.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: 13242, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   48090
Free buffers       34983
Database pages     12917
Old database pages 4782
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 11, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12823, created 94, written 54299
0.00 reads/s, 0.00 creates/s, 0.10 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: 12917, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   48090
Free buffers       34699
Database pages     13208
Old database pages 4892
Modified db pages  93
Percent of dirty pages(LRU & free pages): 0.194
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 13059, created 149, written 303282
0.00 reads/s, 0.00 creates/s, 0.59 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: 13208, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   48090
Free buffers       34040
Database pages     13871
Old database pages 5135
Modified db pages  38
Percent of dirty pages(LRU & free pages): 0.079
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 13752, created 119, written 191996
0.00 reads/s, 0.00 creates/s, 0.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: 13871, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   48090
Free buffers       34838
Database pages     13066
Old database pages 4829
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 22, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13006, created 60, written 74798
0.00 reads/s, 0.00 creates/s, 0.16 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: 13066, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   48090
Free buffers       35702
Database pages     12208
Old database pages 4495
Modified db pages  11
Percent of dirty pages(LRU & free pages): 0.023
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 12068, created 140, written 42714
0.00 reads/s, 0.00 creates/s, 0.59 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: 12208, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   48090
Free buffers       35150
Database pages     12758
Old database pages 4728
Modified db pages  15
Percent of dirty pages(LRU & free pages): 0.031
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 17, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12609, created 149, written 66173
0.00 reads/s, 0.00 creates/s, 0.63 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: 12758, 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=1110, Main thread ID=140319504148224, state: sleeping
Number of rows inserted 103716, updated 245140, deleted 75006, read 8080954773
1.43 inserts/s, 6.75 updates/s, 1.33 deletes/s, 87041.59 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 783263
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================