Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Storage engines

InnoDB Documentation

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

[ Variables | Buffer Pool | InnoDB Status ] 


=====================================
2026-09-28 13:03:39 0x3ac0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 13 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 268459 srv_active, 0 srv_shutdown, 273274 srv_idle
srv_master_thread log flush and writes: 541733
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1739534
OS WAIT ARRAY INFO: signal count 158923281
RW-shared spins 597289233, rounds 610175438, OS waits 998431
RW-excl spins 19474511, rounds 60171942, OS waits 568483
RW-sx spins 4047, rounds 112290, OS waits 2615
Spin rounds per wait: 1.02 RW-shared, 3.09 RW-excl, 27.75 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 601042
Purge done for trx's n:o < 600938 undo n:o < 0 state: running but idle
History list length 52
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284068190851728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190868400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190847560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190843392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190864232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190614152, 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 11484866, OS thread handle 12816, query id 95669941 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 >= 601038, sees < 601038
---TRANSACTION 284068190839224, ACTIVE 1 sec fetching rows
mysql tables in use 5, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 11484860, OS thread handle 12204, query id 95669904 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 >= 601038, sees < 601038
---TRANSACTION 284068190597480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190797544, ACTIVE 33 sec
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 11479920, OS thread handle 2996, query id 95656781 localhost ::1 root Sending data
SELECT /*!40001 SQL_NO_CACHE */ * FROM `trackersql`
Trx read view will not see trx with id >= 600937, sees < 600937
---TRANSACTION 284068190826720, ACTIVE 32 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 11479912, OS thread handle 9880, query id 95657369 localhost ::1 root Sending data
SELECT /*!40001 SQL_NO_CACHE */ * FROM `trackersql`
Trx read view will not see trx with id >= 600943, sees < 600943
---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 284068190639160, 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
23457434 OS file reads, 4789440 OS file writes, 2848960 OS fsyncs
2499.12 reads/s, 16384 avg bytes/read, 21.00 writes/s, 9.92 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 20, seg size 22, 106132 merges
merged operations:
 insert 131484, delete mark 9794, delete 2970
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 21 buffer(s)
Hash table size 1106407, node heap has 221 buffer(s)
Hash table size 1106407, node heap has 214 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 152 buffer(s)
Hash table size 1106407, node heap has 1109 buffer(s)
649067.15 hash searches/s, 5338.97 non-hash searches/s
---
LOG
---
Log sequence number 14550631761
Log flushed up to   14550631761
Pages flushed up to 14550629526
Last checkpoint at  14550629517
0 pending log flushes, 0 pending chkp writes
787359 log i/o's done, 2.62 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 3630800
Buffer pool size   256864
Free buffers       8076
Database pages     246117
Old database pages 90761
Modified db pages  5
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 12213360, not young 1929063654
2260.21 youngs/s, 200996.46 non-youngs/s
Pages read 23457397, created 776989, written 3126101
2499.58 reads/s, 0.15 creates/s, 16.00 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 82 / 1000
Pages read ahead 1928.01/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 246117, unzip_LRU len: 0
I/O sum[232432]:cur[744], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32108
Free buffers       1024
Database pages     30761
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 1537709, not young 246184983
304.05 youngs/s, 23018.31 non-youngs/s
Pages read 2944396, created 97394, written 436180
280.59 reads/s, 0.00 creates/s, 1.46 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 1 / 1000 not 112 / 1000
Pages read ahead 232.83/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30761, unzip_LRU len: 0
I/O sum[29054]:cur[93], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       972
Database pages     30829
Old database pages 11393
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1429618, not young 244631124
263.29 youngs/s, 27671.87 non-youngs/s
Pages read 2975511, created 97193, written 410560
340.20 reads/s, 0.08 creates/s, 1.92 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 81 / 1000
Pages read ahead 281.52/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30829, unzip_LRU len: 0
I/O sum[29054]:cur[93], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       960
Database pages     30812
Old database pages 11393
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 1506715, not young 248218134
254.75 youngs/s, 21890.70 non-youngs/s
Pages read 3009471, created 97068, written 263230
308.36 reads/s, 0.00 creates/s, 0.92 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 62 / 1000
Pages read ahead 265.83/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30812, unzip_LRU len: 0
I/O sum[29054]:cur[93], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       1024
Database pages     30735
Old database pages 11325
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 1503348, not young 243588566
295.13 youngs/s, 29196.06 non-youngs/s
Pages read 2944269, created 97585, written 613263
360.28 reads/s, 0.08 creates/s, 1.46 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 1 / 1000 not 111 / 1000
Pages read ahead 205.98/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30735, unzip_LRU len: 0
I/O sum[29054]:cur[93], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       1024
Database pages     30764
Old database pages 11336
Modified db pages  4
Percent of dirty pages(LRU & free pages): 0.013
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1529229, not young 234975162
291.90 youngs/s, 17002.15 non-youngs/s
Pages read 2930430, created 96498, written 488072
217.52 reads/s, 0.00 creates/s, 4.31 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 41 / 1000
Pages read ahead 147.68/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30764, unzip_LRU len: 0
I/O sum[29054]:cur[93], 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 1611486, not young 217089753
305.36 youngs/s, 30362.51 non-youngs/s
Pages read 2662274, created 97699, written 339874
351.51 reads/s, 0.00 creates/s, 1.00 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 1 / 1000 not 117 / 1000
Pages read ahead 339.67/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30744, unzip_LRU len: 0
I/O sum[29054]:cur[93], 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 1530936, not young 252925590
279.82 youngs/s, 28738.64 non-youngs/s
Pages read 3017380, created 96790, written 232690
348.13 reads/s, 0.00 creates/s, 0.92 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 85 / 1000
Pages read ahead 280.52/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30710, unzip_LRU len: 0
I/O sum[29054]:cur[93], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32108
Free buffers       1024
Database pages     30762
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 1564319, not young 241450342
265.90 youngs/s, 23116.22 non-youngs/s
Pages read 2973666, created 96762, written 342232
292.98 reads/s, 0.00 creates/s, 4.00 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 82 / 1000
Pages read ahead 173.99/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30762, unzip_LRU len: 0
I/O sum[29054]:cur[93], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
4 read views open inside InnoDB
Process ID=6628, Main thread ID=12328, state: sleeping
Number of rows inserted 43821879, updated 196656, deleted 21110, read 381642786374
3.62 inserts/s, 1.08 updates/s, 0.00 deletes/s, 1117274.13 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
============================