Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-09-28 13:31:14 0x3998 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 39 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 269221 srv_active, 0 srv_shutdown, 274150 srv_idle
srv_master_thread log flush and writes: 543371
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1741286
OS WAIT ARRAY INFO: signal count 159405061
RW-shared spins 599109304, rounds 611959917, OS waits 999593
RW-excl spins 19490256, rounds 60193109, OS waits 568601
RW-sx spins 4064, rounds 112710, OS waits 2622
Spin rounds per wait: 1.02 RW-shared, 3.09 RW-excl, 27.73 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-09-28 11:17:15 0x3178 Transaction:
TRANSACTION 584613, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 11328385, OS thread handle 12664, query id 94100735 localhost ::1 root Update
insert ignore into `referensi_mobilejkn_bpjs_taskid` (`no_rawat`, `taskid`, `waktu`) values (?, ?, ?)
Foreign key constraint fails for table `mesrabaru01`.`referensi_mobilejkn_bpjs_taskid`:
,
  CONSTRAINT `referensi_mobilejkn_bpjs_taskid_ibfk_1` FOREIGN KEY (`no_rawat`) REFERENCES `reg_periksa` (`no_rawat`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index PRIMARY tuple:
DATA TUPLE: 5 fields;
 0: len 17; hex 323032362f30392f32382f303030303436; asc 2026/09/28/000046;;
 1: len 1; hex 03; asc  ;;
 2: len 6; hex 00000008eba5; asc       ;;
 3: len 7; hex fc00000aba2a9d; asc      * ;;
 4: len 5; hex 99baf8b24f; asc     O;;

But in parent table `mesrabaru01`.`reg_periksa`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 21; compact format; info bits 0
 0: len 17; hex 323032362f30392f32382f303030303437; asc 2026/09/28/000047;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 303139; asc 019;;
 4: len 3; hex 8fd53c; asc   <;;
 5: len 3; hex 80bd38; asc   8;;
 6: len 9; hex 313630353135303539; asc 160515059;;
 7: len 6; hex 313032383931; asc 102891;;
 8: len 5; hex 5530303033; asc U0003;;
 9: len 9; hex 59756c696e612e4e79; asc Yulina.Ny;;
 10: len 30; hex 4a4c2053454e474f4e20524159412050414e444155204e4f2031372c202d; asc JL SENGON RAYA PANDAU NO 17, -; (total 39 bytes);
 11: len 7; hex 53415544415241; asc SAUDARA;;
 12: len 8; hex 000000000088b340; asc        @;;
 13: len 1; hex 01; asc  ;;
 14: len 1; hex 02; asc  ;;
 15: len 1; hex 01; asc  ;;
 16: len 3; hex 42504a; asc BPJ;;
 17: len 4; hex 8000003f; asc    ?;;
 18: len 1; hex 01; asc  ;;
 19: len 1; hex 02; asc  ;;
 20: len 1; hex 01; asc  ;;

------------
TRANSACTIONS
------------
Trx id counter 603333
Purge done for trx's n:o < 603333 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284068190839224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190826720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190639160, ACTIVE 0 sec fetching rows
mysql tables in use 5, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 11522096, OS thread handle 3400, query id 95908243 localhost ::1 root Sending data
select resep_obat.no_resep,resep_obat.no_rawat,pasien.nm_pasien,resep_obat.jam_peresepan,
 if(resep_obat.jam='00:00:00','',resep_obat.jam) as jam_validasi,
 if(resep_obat.jam_penyerahan='00:00:00','',resep_obat.jam_penyerahan) as jam_penyerahan,dokter.nm_dokter
 from resep_obat inner join reg_periksa on resep_obat.no_rawat=reg_periksa.no_rawat 
 inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis 
 inner join dokter on resep_obat.kd_dokter=dokter.kd_dokter
 where resep_obat.no_resep not in(select distinct resep_dokter_racikan.no_resep from resep_dokter_racikan) 
 and resep_obat.j
Trx read view will not see trx with id >= 603333, sees < 603333
---TRANSACTION 284068190797544, ACTIVE 0 sec fetching rows
mysql tables in use 5, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 11522091, OS thread handle 2996, query id 95908227 localhost ::1 root Sending data
select resep_obat.no_resep,resep_obat.no_rawat,pasien.nm_pasien,resep_obat.jam_peresepan,
 if(resep_obat.jam='00:00:00','',resep_obat.jam) as jam_validasi,
 if(resep_obat.jam_penyerahan='00:00:00','',resep_obat.jam_penyerahan) as jam_penyerahan,dokter.nm_dokter
 from resep_obat inner join reg_periksa on resep_obat.no_rawat=reg_periksa.no_rawat 
 inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis 
 inner join dokter on resep_obat.kd_dokter=dokter.kd_dokter
 where resep_obat.no_resep not in(select distinct resep_dokter_racikan.no_resep from resep_dokter_racikan) 
 and resep_obat.j
Trx read view will not see trx with id >= 603333, sees < 603333
---TRANSACTION 284068190597480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190614152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190722520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190705848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190818384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190601648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190860064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190780872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190701680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190755864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190772536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190680840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190651664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190830888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190805880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190835056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190810048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190822552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190814216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190760032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190801712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190685008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190676672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190793376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190710016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190785040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190789208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190776704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190726688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190768368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190655832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190630824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190764200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190751696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190739192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190735024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190743360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190747528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190730856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190605816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190664168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190660000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190718352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190714184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190643328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190622488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190647496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190697512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190589144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190668336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190609984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190618320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190693344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190584976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190626656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190634992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190672504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190689176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190593312, 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
23528453 OS file reads, 4808135 OS file writes, 2860351 OS fsyncs
8.33 reads/s, 16384 avg bytes/read, 9.90 writes/s, 5.74 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 20, seg size 22, 107268 merges
merged operations:
 insert 132852, delete mark 9820, delete 2985
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 13 buffer(s)
Hash table size 1106407, node heap has 209 buffer(s)
Hash table size 1106407, node heap has 222 buffer(s)
Hash table size 1106407, node heap has 701 buffer(s)
Hash table size 1106407, node heap has 245 buffer(s)
Hash table size 1106407, node heap has 8 buffer(s)
Hash table size 1106407, node heap has 159 buffer(s)
Hash table size 1106407, node heap has 1110 buffer(s)
677960.41 hash searches/s, 6090.74 non-hash searches/s
---
LOG
---
Log sequence number 14552376270
Log flushed up to   14552376270
Pages flushed up to 14552376270
Last checkpoint at  14552374498
0 pending log flushes, 0 pending chkp writes
790174 log i/o's done, 1.31 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 3630800
Buffer pool size   256864
Free buffers       8192
Database pages     246005
Old database pages 90646
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 12306679, not young 1934988668
6.82 youngs/s, 2877.36 non-youngs/s
Pages read 23528416, created 777070, written 3138944
8.33 reads/s, 0.03 creates/s, 7.20 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 3.10/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 246005, unzip_LRU len: 0
I/O sum[5664]:cur[24], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32108
Free buffers       1024
Database pages     30763
Old database pages 11335
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 1548425, not young 246887243
0.15 youngs/s, 75.72 non-youngs/s
Pages read 2952898, created 97411, written 437919
0.21 reads/s, 0.00 creates/s, 0.69 writes/s
Buffer pool hit rate 999 / 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: 30763, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       1024
Database pages     30782
Old database pages 11342
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 1441148, not young 245305931
1.05 youngs/s, 533.76 non-youngs/s
Pages read 2984068, created 97226, written 412012
1.13 reads/s, 0.00 creates/s, 0.67 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30782, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       1024
Database pages     30756
Old database pages 11333
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 1518714, not young 248954356
1.67 youngs/s, 647.09 non-youngs/s
Pages read 3018392, created 97074, written 264166
1.69 reads/s, 0.03 creates/s, 0.67 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 2 / 1000
Pages read ahead 1.51/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30756, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       1024
Database pages     30750
Old database pages 11331
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 1515397, not young 244470202
0.67 youngs/s, 227.07 non-youngs/s
Pages read 2953275, created 97587, written 615125
1.64 reads/s, 0.00 creates/s, 1.41 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30750, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       1024
Database pages     30754
Old database pages 11332
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 1540708, not young 235694183
0.03 youngs/s, 0.03 non-youngs/s
Pages read 2939124, created 96506, written 491078
0.08 reads/s, 0.00 creates/s, 1.33 writes/s
Buffer pool hit rate 999 / 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: 30754, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       1024
Database pages     30744
Old database pages 11328
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 1623265, not young 217815147
0.00 youngs/s, 0.10 non-youngs/s
Pages read 2671442, created 97702, written 340653
0.21 reads/s, 0.00 creates/s, 0.46 writes/s
Buffer pool hit rate 999 / 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: 30744, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32108
Free buffers       1024
Database pages     30710
Old database pages 11316
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 1542576, not young 253640622
1.51 youngs/s, 723.65 non-youngs/s
Pages read 3026251, created 96795, written 233941
1.59 reads/s, 0.00 creates/s, 0.64 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 2 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30710, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32108
Free buffers       1024
Database pages     30746
Old database pages 11329
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 1576446, not young 242220984
1.74 youngs/s, 669.96 non-youngs/s
Pages read 2982966, created 96769, written 344050
1.79 reads/s, 0.00 creates/s, 1.33 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 2 / 1000
Pages read ahead 1.59/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30746, unzip_LRU len: 0
I/O sum[708]:cur[3], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Process ID=6628, Main thread ID=12328, state: sleeping
Number of rows inserted 43824703, updated 196993, deleted 21168, read 382854621454
1.79 inserts/s, 0.08 updates/s, 0.00 deletes/s, 747176.00 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1134062
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================