Console
Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
=====================================
2026-07-30 15:06:53 0x2704 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 37 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 132610 srv_active, 0 srv_shutdown, 2103364 srv_idle
srv_master_thread log flush and writes: 2235974
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 263722
OS WAIT ARRAY INFO: signal count 292118
RW-shared spins 937652, rounds 10866852, OS waits 175974
RW-excl spins 129985, rounds 1152262, OS waits 28242
RW-sx spins 906, rounds 9457, OS waits 222
Spin rounds per wait: 11.59 RW-shared, 8.86 RW-excl, 10.44 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-07-30 11:51:51 0x23f4 Transaction:
TRANSACTION 1187657, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2
MySQL thread id 799334, OS thread handle 9204, query id 25710243 DESKTOP-GIRCQN8 192.168.10.88 root Update
insert into penjualan values('PJ20260730002','2026-07-30','01102024','099999h','Bebas umum','Eriska','Jual Bebas','0.0','0.0','Belum Dibayar','1','111010','Bayar Cash')
Foreign key constraint fails for table `khanza_pelita`.`penjualan`:
,
CONSTRAINT `penjualan_ibfk_10` FOREIGN KEY (`no_rkm_medis`) REFERENCES `pasien` (`no_rkm_medis`) ON UPDATE CASCADE in parent table, in index no_rkm_medis tuple:
DATA TUPLE: 2 fields;
0: len 7; hex 30393939393968; asc 099999h;;
1: len 13; hex 504a3230323630373330303032; asc PJ20260730002;;
But in parent table `khanza_pelita`.`pasien`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 38; compact format; info bits 0
0: len 6; hex 393930393939; asc 990999;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 16; hex 70617369656e20544553544552204954; asc pasien TESTER IT;;
4: len 1; hex 2d; asc -;;
5: len 1; hex 01; asc ;;
6: len 1; hex 2d; asc -;;
7: len 3; hex 8fa942; asc B;;
8: len 9; hex 544553544552204954; asc TESTER IT;;
9: len 1; hex 2d; asc -;;
10: len 1; hex 05; asc ;;
11: len 1; hex 2d; asc -;;
12: len 1; hex 02; asc ;;
13: len 5; hex 49534c414d; asc ISLAM;;
14: len 3; hex 8fd15f; asc _;;
15: len 9; hex 303839393939393939; asc 089999999;;
16: len 15; hex 3231205468203820426c2039204872; asc 21 Th 8 Bl 9 Hr;;
17: len 1; hex 0e; asc ;;
18: len 1; hex 07; asc ;;
19: len 9; hex 544553544552204954; asc TESTER IT;;
20: len 3; hex 2d2020; asc - ;;
21: len 1; hex 2d; asc -;;
22: len 4; hex 80000001; asc ;;
23: len 4; hex 8000174f; asc O;;
24: len 4; hex 80000203; asc ;;
25: len 9; hex 544553544552204954; asc TESTER IT;;
26: len 1; hex 2d; asc -;;
27: len 1; hex 2d; asc -;;
28: len 1; hex 2d; asc -;;
29: len 1; hex 2d; asc -;;
30: len 1; hex 2d; asc -;;
31: len 4; hex 80000001; asc ;;
32: len 4; hex 80000005; asc ;;
33: len 4; hex 80000001; asc ;;
34: len 1; hex 2d; asc -;;
35: len 1; hex 2d; asc -;;
36: len 4; hex 80002255; asc "U;;
37: len 9; hex 50524f50494e53492d; asc PROPINSI-;;
------------
TRANSACTIONS
------------
Trx id counter 1190487
Purge done for trx's n:o < 1190487 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283937610487776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610483608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610433592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610462768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610479440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610475272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610471104, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610454432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610450264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610421088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610412752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610458600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610446096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610441928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610437760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610429424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610425256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610391912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610387744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610404416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610408584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610396080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610400248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610383576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610379408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610416920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283937610466936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: native aio handle (insert buffer thread)
I/O thread 1 state: native aio handle (log thread)
I/O thread 2 state: native aio handle (read thread)
I/O thread 3 state: native aio handle (read thread)
I/O thread 4 state: native aio handle (read thread)
I/O thread 5 state: native aio handle (read thread)
I/O thread 6 state: native aio handle (write thread)
I/O thread 7 state: native aio handle (write thread)
I/O thread 8 state: native aio handle (write thread)
I/O thread 9 state: native aio handle (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
30485561 OS file reads, 1958106 OS file writes, 1054055 OS fsyncs
11.46 reads/s, 16384 avg bytes/read, 3.24 writes/s, 1.46 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 294, seg size 296, 275028 merges
merged operations:
insert 475134, delete mark 27808, delete 16089
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 2 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 41 buffer(s)
664.68 hash searches/s, 82.13 non-hash searches/s
---
LOG
---
Log sequence number 6901814122
Log flushed up to 6901814102
Pages flushed up to 6901806530
Last checkpoint at 6901806521
0 pending log flushes, 0 pending chkp writes
514573 log i/o's done, 1.05 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 2852056
Buffer pool size 1003
Free buffers 308
Database pages 646
Old database pages 219
Modified db pages 19
Percent of dirty pages(LRU & free pages): 1.990
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 6766749, not young 1473463954
4.97 youngs/s, 402.04 non-youngs/s
Pages read 30484418, created 11387, written 1272574
11.46 reads/s, 0.03 creates/s, 2.05 writes/s
Buffer pool hit rate 994 / 1000, young-making rate 2 / 1000 not 175 / 1000
Pages read ahead 3.95/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 646, unzip_LRU len: 0
I/O sum[362]:cur[1], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=2944, Main thread ID=9672, state: sleeping
Number of rows inserted 184427, updated 134006, deleted 6567, read 4817337421
0.00 inserts/s, 0.65 updates/s, 0.00 deletes/s, 737.76 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1380277
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================