Konsol
Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variabel | Penampungan Penyangga | Status InnoDB ]
=====================================
2026-04-01 23:32:51 0x12e8 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 42 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 298091 srv_active, 0 srv_shutdown, 833025 srv_idle
srv_master_thread log flush and writes: 1131113
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2041930
OS WAIT ARRAY INFO: signal count 1683920
RW-shared spins 2754137, rounds 10711469, OS waits 284648
RW-excl spins 149845, rounds 650724, OS waits 14350
RW-sx spins 5262, rounds 46160, 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 1006700
Purge done for trx's n:o < 1006700 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 281970589112824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589100296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 281970589083592, 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 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 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 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 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
401454 OS file reads, 5894082 OS file writes, 3973565 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 2.57 writes/s, 1.40 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 321, seg size 323, 27288 merges
merged operations:
insert 45570, delete mark 6333, 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 2258 buffer(s)
Hash table size 8850487, node heap has 697 buffer(s)
25.88 hash searches/s, 11.95 non-hash searches/s
---
LOG
---
Log sequence number 21334813202
Log flushed up to 21334813166
Pages flushed up to 21334810848
Last checkpoint at 21334789266
0 pending log flushes, 0 pending chkp writes
1319876 log i/o's done, 0.33 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 34896609280
Dictionary memory allocated 3044864
Buffer pool size 2054912
Free buffers 1622187
Database pages 419937
Old database pages 155136
Modified db pages 5
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 2683, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 400366, created 19571, written 3495085
0.00 reads/s, 0.00 creates/s, 1.95 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: 419937, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 256864
Free buffers 202083
Database pages 53166
Old database pages 19645
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 50759, created 2407, written 480096
0.00 reads/s, 0.00 creates/s, 0.24 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: 53166, unzip_LRU len: 0
I/O sum[0]:cur[25], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 256864
Free buffers 202988
Database pages 52228
Old database pages 19298
Modified db pages 1
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 49657, created 2571, written 541873
0.00 reads/s, 0.00 creates/s, 0.24 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: 52228, unzip_LRU len: 0
I/O sum[0]:cur[25], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 256864
Free buffers 202698
Database pages 52583
Old database pages 19429
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 49826, created 2757, written 226359
0.00 reads/s, 0.00 creates/s, 0.17 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: 52583, unzip_LRU len: 0
I/O sum[0]:cur[25], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 256864
Free buffers 202968
Database pages 52343
Old database pages 19341
Modified db pages 4
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 335, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 50238, created 2105, written 714654
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: 52343, unzip_LRU len: 0
I/O sum[0]:cur[25], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 256864
Free buffers 204000
Database pages 51235
Old database pages 18929
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 48781, created 2454, written 602405
0.00 reads/s, 0.00 creates/s, 0.12 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: 51235, unzip_LRU len: 0
I/O sum[0]:cur[25], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 256864
Free buffers 202572
Database pages 52782
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 2390, written 283040
0.00 reads/s, 0.00 creates/s, 0.19 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: 52782, unzip_LRU len: 0
I/O sum[0]:cur[25], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 256864
Free buffers 202703
Database pages 52574
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 2384, written 319736
0.00 reads/s, 0.00 creates/s, 0.31 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: 52574, unzip_LRU len: 0
I/O sum[0]:cur[25], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 256864
Free buffers 202175
Database pages 53026
Old database pages 19593
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 50523, created 2503, written 326922
0.00 reads/s, 0.00 creates/s, 0.12 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: 53026, unzip_LRU len: 0
I/O sum[0]:cur[25], 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 807710, updated 234913, deleted 38540, read 51976442996
0.71 inserts/s, 0.26 updates/s, 0.07 deletes/s, 110.57 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
============================