Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2026-04-01 21:47:30 0x7c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 36 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 296423 srv_active, 0 srv_shutdown, 828475 srv_idle
srv_master_thread log flush and writes: 1124895
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2025316
OS WAIT ARRAY INFO: signal count 1677321
RW-shared spins 2751724, rounds 10665690, OS waits 283222
RW-excl spins 148770, rounds 647538, OS waits 14290
RW-sx spins 5165, rounds 45114, OS waits 747
Spin rounds per wait: 3.88 RW-shared, 4.35 RW-excl, 8.73 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-04-01 14:56:40 0x810 Transaction:
TRANSACTION 964211, ACTIVE 0 sec updating or deleting, thread declared inside InnoDB 4999
mysql tables in use 347, locked 347
537 lock struct(s), heap size 57464, 313 row lock(s), undo log entries 32
MySQL thread id 10436983, OS thread handle 2064, query id 57749818 DESKTOP-BFN02VV 192.168.10.190 root Updating
delete from reg_periksa where no_rawat='2026/04/01/000136'
Foreign key constraint fails for table `sikrssi`.`rawat_jl_pr`:
,
  CONSTRAINT `rawat_jl_pr_ibfk_8` FOREIGN KEY (`no_rawat`) REFERENCES `reg_periksa` (`no_rawat`) ON UPDATE CASCADE
Trying to delete in parent table, in index PRIMARY tuple:
DATA TUPLE: 21 fields;
 0: len 17; hex 323032362f30342f30312f303030313336; asc 2026/04/01/000136;;
 1: len 6; hex 0000000eb673; asc      s;;
 2: len 7; hex 760000082a1f17; asc v   *  ;;
 3: len 3; hex 303037; asc 007;;
 4: len 3; hex 8fd481; asc    ;;
 5: len 3; hex 80c708; asc    ;;
 6: len 13; hex 32303230303230333130313134; asc 2020020310114;;
 7: len 6; hex 303737373538; asc 077758;;
 8: len 5; hex 4947444b20; asc IGDK ;;
 9: len 5; hex 4645425249; asc FEBRI;;
 10: len 52; hex 4b4550454e5548414e2053454a4154492c204b4f54412054454e4741482c204b4550454e5548414e2c20524f4b414e2048554c55; asc KEPENUHAN SEJATI, KOTA TENGAH, KEPENUHAN, ROKAN HULU;;
 11: len 4; hex 414e414b; asc ANAK;;
 12: len 8; hex 0000000000000000; asc         ;;
 13: len 1; hex 03; asc  ;;
 14: len 1; hex 02; asc  ;;
 15: len 1; hex 01; asc  ;;
 16: len 3; hex 42504a; asc BPJ;;
 17: len 4; hex 80000044; asc    D;;
 18: len 1; hex 01; asc  ;;
 19: len 1; hex 02; asc  ;;
 20: len 1; hex 01; asc  ;;

But in child table `sikrssi`.`rawat_jl_pr`, in index PRIMARY, there is a record:
PHYSICAL RECORD: n_fields 14; compact format; info bits 0
 0: len 17; hex 323032362f30342f30312f303030313336; asc 2026/04/01/000136;;
 1: len 8; hex 544a323630303939; asc TJ260099;;
 2: len 13; hex 32303232303730363130313939; asc 2022070610199;;
 3: len 3; hex 8fd481; asc    ;;
 4: len 3; hex 80c816; asc    ;;
 5: len 6; hex 000000000000; asc       ;;
 6: len 7; hex 80000000000000; asc        ;;
 7: len 8; hex 000000000088c340; asc        @;;
 8: len 8; hex 0000000000000000; asc         ;;
 9: len 8; hex 0000000000000000; asc         ;;
 10: len 8; hex 0000000000000000; asc         ;;
 11: len 8; hex 0000000000000000; asc         ;;
 12: len 8; hex 000000000088c340; asc        @;;
 13: len 1; hex 02; asc  ;;

------------------------
LATEST DETECTED DEADLOCK
------------------------
2026-03-31 14:37:03 0xeac
*** (1) TRANSACTION:
TRANSACTION 874390, ACTIVE 11 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 9 lock struct(s), heap size 1128, 28 row lock(s), undo log entries 31
MySQL thread id 9584949, OS thread handle 4456, query id 51547215 DESKTOP-M0DDQM1 192.168.10.6 root Update
insert into jurnal values('JR20260331000873','2026/03/31/000223','2026-03-31','14:36:52','U','PEMBATALAN PEMERIKSAAN LABORAT RAWAT JALAN PASIEN OLEH 2023100220284')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 375 page no 62370 n bits 112 index PRIMARY of table `sikrssi`.`jurnal` trx id 874390 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 16; hex 4a523236353630383033303030303031; asc JR26560803000001;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 17; hex 323031392f30352f30382f303030303931; asc 2019/05/08/000091;;
 4: len 3; hex 94c103; asc    ;;
 5: len 3; hex 800000; asc    ;;
 6: len 1; hex 01; asc  ;;
 7: len 30; hex 50454d42455249414e204f42415420524157415420494e41502050415349; asc PEMBERIAN OBAT RAWAT INAP PASI; (total 58 bytes);

*** (2) TRANSACTION:
TRANSACTION 874407, ACTIVE 9 sec inserting, thread declared inside InnoDB 1
mysql tables in use 1, locked 1
13 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 29
MySQL thread id 9820332, OS thread handle 3756, query id 51547584 DESKTOP-E1A9E6K 192.168.10.62 root Update
insert into jurnal values('JR20260331000873','2026/03/31/000037','2026-03-31','14:36:54','U','PIUTANG PASIEN RAWAT JALAN 2026/03/31/000037 118540 BP. RONI PASRAH, DIPOSTING OLEH 2024110520352')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 375 page no 62370 n bits 112 index PRIMARY of table `sikrssi`.`jurnal` trx id 874407 lock mode S locks gap before rec
Record lock, heap no 2 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 16; hex 4a523236353630383033303030303031; asc JR26560803000001;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 17; hex 323031392f30352f30382f303030303931; asc 2019/05/08/000091;;
 4: len 3; hex 94c103; asc    ;;
 5: len 3; hex 800000; asc    ;;
 6: len 1; hex 01; asc  ;;
 7: len 30; hex 50454d42455249414e204f42415420524157415420494e41502050415349; asc PEMBERIAN OBAT RAWAT INAP PASI; (total 58 bytes);

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 375 page no 62370 n bits 112 index PRIMARY of table `sikrssi`.`jurnal` trx id 874407 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 16; hex 4a523236353630383033303030303031; asc JR26560803000001;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 17; hex 323031392f30352f30382f303030303931; asc 2019/05/08/000091;;
 4: len 3; hex 94c103; asc    ;;
 5: len 3; hex 800000; asc    ;;
 6: len 1; hex 01; asc  ;;
 7: len 30; hex 50454d42455249414e204f42415420524157415420494e41502050415349; asc PEMBERIAN OBAT RAWAT INAP PASI; (total 58 bytes);

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 998223
Purge done for trx's n:o < 998223 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 281970589054360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589037656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589033480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589029304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589016776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589008424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970588995896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589020952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589096120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589004248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970588991720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589137880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589087768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589142056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589133704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589108648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589062712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589041832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589012600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589104472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589396792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589363384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589091944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589275688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589284040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589321624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589204696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589121176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589025128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589046008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589050184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589225576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589066888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589000072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589058536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970588987544, 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
401346 OS file reads, 5849752 OS file writes, 3948394 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 4.72 writes/s, 3.72 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 321, seg size 323, 27232 merges
merged operations:
 insert 45233, delete mark 6332, delete 1450
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 8850487, node heap has 3690 buffer(s)
Hash table size 8850487, node heap has 3384 buffer(s)
Hash table size 8850487, node heap has 321 buffer(s)
Hash table size 8850487, node heap has 926 buffer(s)
Hash table size 8850487, node heap has 735 buffer(s)
Hash table size 8850487, node heap has 774 buffer(s)
Hash table size 8850487, node heap has 2256 buffer(s)
Hash table size 8850487, node heap has 696 buffer(s)
1099.50 hash searches/s, 96.16 non-hash searches/s
---
LOG
---
Log sequence number 21327619966
Log flushed up to   21327619966
Pages flushed up to 21327619966
Last checkpoint at  21327619923
0 pending log flushes, 0 pending chkp writes
1311276 log i/o's done, 1.19 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 34896609280
Dictionary memory allocated 3044864
Buffer pool size   2054912
Free buffers       1622421
Database pages     419709
Old database pages 155056
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 2671, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 400258, created 19451, written 3465668
0.00 reads/s, 0.03 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: 419709, 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   256864
Free buffers       202108
Database pages     53141
Old database pages 19635
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 364, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50744, created 2397, written 476325
0.00 reads/s, 0.00 creates/s, 0.08 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: 53141, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   256864
Free buffers       203009
Database pages     52210
Old database pages 19292
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 360, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 49649, created 2561, written 538131
0.00 reads/s, 0.00 creates/s, 0.81 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: 52210, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   256864
Free buffers       202723
Database pages     52557
Old database pages 19420
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 376, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 49815, created 2742, written 224712
0.00 reads/s, 0.00 creates/s, 0.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: 52557, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   256864
Free buffers       202985
Database pages     52328
Old database pages 19334
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 334, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50226, created 2102, written 708464
0.00 reads/s, 0.00 creates/s, 0.81 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: 52328, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   256864
Free buffers       204021
Database pages     51212
Old database pages 18919
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 382, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 48766, created 2446, written 597873
0.00 reads/s, 0.00 creates/s, 0.14 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: 51212, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   256864
Free buffers       202607
Database pages     52748
Old database pages 19470
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 294, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50377, created 2371, written 279065
0.00 reads/s, 0.03 creates/s, 0.33 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: 52748, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   256864
Free buffers       202766
Database pages     52512
Old database pages 19403
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 291, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50172, created 2340, written 316247
0.00 reads/s, 0.00 creates/s, 0.06 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: 52512, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   256864
Free buffers       202202
Database pages     53001
Old database pages 19583
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 270, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50509, created 2492, written 324851
0.00 reads/s, 0.00 creates/s, 0.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: 53001, 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=1804, Main thread ID=3276, state: sleeping
Number of rows inserted 800354, updated 232014, deleted 38212, read 51692275692
0.31 inserts/s, 0.25 updates/s, 0.00 deletes/s, 16205.63 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1854420
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================