Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2026-04-02 00:45:11 0x134c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 59 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 298638 srv_active, 0 srv_shutdown, 836758 srv_idle
srv_master_thread log flush and writes: 1135393
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2045100
OS WAIT ARRAY INFO: signal count 1685466
RW-shared spins 2755214, rounds 10728357, OS waits 285192
RW-excl spins 150034, rounds 651136, OS waits 14356
RW-sx spins 5268, rounds 46193, OS waits 753
Spin rounds per wait: 3.89 RW-shared, 4.34 RW-excl, 8.77 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 1009265
Purge done for trx's n:o < 1009265 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 281970589012600, 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 281970589079416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589075240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589071064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---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 281970589025128, 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 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 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 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 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 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
401468 OS file reads, 5905696 OS file writes, 3980793 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.31 writes/s, 0.29 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 321, seg size 323, 27296 merges
merged operations:
 insert 45604, delete mark 6335, delete 1450
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 8850487, node heap has 3691 buffer(s)
Hash table size 8850487, node heap has 3384 buffer(s)
Hash table size 8850487, node heap has 322 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 775 buffer(s)
Hash table size 8850487, node heap has 2259 buffer(s)
Hash table size 8850487, node heap has 697 buffer(s)
572.84 hash searches/s, 13.54 non-hash searches/s
---
LOG
---
Log sequence number 21336169215
Log flushed up to   21336169215
Pages flushed up to 21336169215
Last checkpoint at  21336169206
0 pending log flushes, 0 pending chkp writes
1322694 log i/o's done, 0.14 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 34896609280
Dictionary memory allocated 3044864
Buffer pool size   2054912
Free buffers       1622146
Database pages     419977
Old database pages 155146
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 2685, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 400380, created 19597, written 3502024
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: 419977, 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       202077
Database pages     53169
Old database pages 19646
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 365, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50762, created 2407, written 481721
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: 53169, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   256864
Free buffers       202983
Database pages     52234
Old database pages 19300
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 361, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 49659, created 2575, written 542322
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: 52234, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   256864
Free buffers       202694
Database pages     52586
Old database pages 19430
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 377, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 49828, created 2758, written 226810
0.00 reads/s, 0.00 creates/s, 0.03 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: 52586, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   256864
Free buffers       202965
Database pages     52348
Old database pages 19343
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 336, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50241, created 2107, written 716201
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: 52348, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   256864
Free buffers       203998
Database pages     51237
Old database pages 18931
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 384, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 48783, created 2454, written 603461
0.00 reads/s, 0.00 creates/s, 0.03 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: 51237, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   256864
Free buffers       202569
Database pages     52785
Old database pages 19482
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 297, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50392, created 2393, written 283322
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: 52785, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   256864
Free buffers       202690
Database pages     52587
Old database pages 19419
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 293, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50190, created 2397, written 321041
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: 52587, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   256864
Free buffers       202170
Database pages     53031
Old database pages 19595
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 272, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50525, created 2506, written 327146
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: 53031, 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 809322, updated 235426, deleted 38636, read 52096085812
0.03 inserts/s, 0.00 updates/s, 0.00 deletes/s, 4776.73 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1887395
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================