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:26 0x3210 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 34 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 268450 srv_active, 0 srv_shutdown, 273271 srv_idle
srv_master_thread log flush and writes: 541721
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1739340
OS WAIT ARRAY INFO: signal count 158920242
RW-shared spins 597279222, rounds 610161190, OS waits 998262
RW-excl spins 19473612, rounds 60171587, OS waits 568482
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 600996
Purge done for trx's n:o < 600938 undo n:o < 0 state: running but idle
History list length 29
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284068190864232, 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 284068190880904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190851728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190876736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190872568, 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 284068190855896, 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 11484510, OS thread handle 11324, query id 95662593 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 >= 600988, sees < 600988
---TRANSACTION 284068190839224, 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 284068190597480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284068190797544, ACTIVE 20 sec fetching rows
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 19 sec
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, 6, 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
23424943 OS file reads, 4789167 OS file writes, 2848831 OS fsyncs
1307.84 reads/s, 16384 avg bytes/read, 8.47 writes/s, 6.12 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 20, seg size 22, 106113 merges
merged operations:
 insert 131465, 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 247 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)
681690.01 hash searches/s, 5696.92 non-hash searches/s
---
LOG
---
Log sequence number 14550597662
Log flushed up to   14550597662
Pages flushed up to 14550593152
Last checkpoint at  14550593143
0 pending log flushes, 0 pending chkp writes
787325 log i/o's done, 1.94 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 3630800
Buffer pool size   256864
Free buffers       2834
Database pages     251326
Old database pages 92691
Modified db pages  9
Percent of dirty pages(LRU & free pages): 0.004
Max dirty pages percent: 75.000
Pending reads 6
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12183975, not young 1926450499
1204.82 youngs/s, 119479.07 non-youngs/s
Pages read 23424900, created 776987, written 3125893
1307.67 reads/s, 0.06 creates/s, 4.76 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 50 / 1000
Pages read ahead 721.89/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 251326, unzip_LRU len: 0
I/O sum[225792]:cur[520], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32108
Free buffers       322
Database pages     31458
Old database pages 11592
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 1533756, not young 245885722
144.11 youngs/s, 17271.87 non-youngs/s
Pages read 2940748, created 97394, written 436161
165.97 reads/s, 0.03 creates/s, 0.38 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 89 / 1000
Pages read ahead 137.47/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31458, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       164
Database pages     31635
Old database pages 11697
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 1426195, not young 244271362
121.23 youngs/s, 17164.61 non-youngs/s
Pages read 2971088, created 97192, written 410535
209.11 reads/s, 0.03 creates/s, 0.74 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 51 / 1000
Pages read ahead 91.20/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31635, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       577
Database pages     31191
Old database pages 11503
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 6
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1503403, not young 247933533
173.11 youngs/s, 10239.17 non-youngs/s
Pages read 3005462, created 97068, written 263218
111.82 reads/s, 0.00 creates/s, 0.24 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 30 / 1000
Pages read ahead 44.65/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31191, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       241
Database pages     31513
Old database pages 11612
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 1499511, not young 243208988
152.47 youngs/s, 20124.61 non-youngs/s
Pages read 2939585, created 97584, written 613244
202.26 reads/s, 0.00 creates/s, 1.35 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 79 / 1000
Pages read ahead 77.70/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31513, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       603
Database pages     31181
Old database pages 11490
Modified db pages  7
Percent of dirty pages(LRU & free pages): 0.022
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1525434, not young 234754117
175.82 youngs/s, 8927.09 non-youngs/s
Pages read 2927602, created 96498, written 488016
96.09 reads/s, 0.00 creates/s, 1.15 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 22 / 1000
Pages read ahead 32.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31181, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       219
Database pages     31543
Old database pages 11623
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 1607516, not young 216695010
140.17 youngs/s, 19075.62 non-youngs/s
Pages read 2657704, created 97699, written 339861
202.35 reads/s, 0.00 creates/s, 0.18 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 79 / 1000
Pages read ahead 191.99/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31543, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32108
Free buffers       128
Database pages     31604
Old database pages 11646
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 1527298, not young 252551959
122.94 youngs/s, 16033.20 non-youngs/s
Pages read 3012854, created 96790, written 232678
208.08 reads/s, 0.00 creates/s, 0.59 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 48 / 1000
Pages read ahead 100.38/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31604, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32108
Free buffers       580
Database pages     31201
Old database pages 11528
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 1560862, not young 241149808
174.97 youngs/s, 10642.89 non-youngs/s
Pages read 2969857, created 96762, written 342180
112.00 reads/s, 0.00 creates/s, 0.15 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 40 / 1000
Pages read ahead 46.50/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31201, unzip_LRU len: 0
I/O sum[28224]:cur[65], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
3 read views open inside InnoDB
Process ID=6628, Main thread ID=12328, state: sleeping
Number of rows inserted 43821832, updated 196642, deleted 21110, read 381628260688
0.82 inserts/s, 0.82 updates/s, 0.00 deletes/s, 995019.06 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
============================