mesra.rumah-sakit.online / 127.0.0.1

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

InnoDB

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

===================================== 2026-09-28 12:44:34 0xd48 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 59 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 267879 srv_active, 0 srv_shutdown, 272721 srv_idle srv_master_thread log flush and writes: 540600 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1729395 OS WAIT ARRAY INFO: signal count 158624317 RW-shared spins 596129442, rounds 608780939, OS waits 988687 RW-excl spins 19462820, rounds 60161248, OS waits 568454 RW-sx spins 4038, rounds 111972, OS waits 2607 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 598680 Purge done for trx's n:o < 598677 undo n:o < 0 state: running but idle History list length 5 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 284068190705848, 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 284068190614152, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284068190597480, 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 11457795, OS thread handle 4084, query id 95407366 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 >= 598676, sees < 598676 ---TRANSACTION 284068190797544, 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 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 284068190826720, 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 284068190722520, 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 23257985 OS file reads, 4776869 OS file writes, 2841535 OS fsyncs 0.05 reads/s, 16384 avg bytes/read, 19.47 writes/s, 10.36 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 20, seg size 22, 105789 merges merged operations: insert 131072, delete mark 9794, delete 2970 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1106407, node heap has 20 buffer(s) Hash table size 1106407, node heap has 221 buffer(s) Hash table size 1106407, node heap has 248 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 145 buffer(s) Hash table size 1106407, node heap has 1113 buffer(s) 653194.27 hash searches/s, 5809.29 non-hash searches/s --- LOG --- Log sequence number 14549033466 Log flushed up to 14549033466 Pages flushed up to 14549023140 Last checkpoint at 14548981442 0 pending log flushes, 0 pending chkp writes 785111 log i/o's done, 4.37 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4462739456 Dictionary memory allocated 3630800 Buffer pool size 256864 Free buffers 8196 Database pages 245967 Old database pages 90633 Modified db pages 27 Percent of dirty pages(LRU & free pages): 0.011 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 12077672, not young 1900888084 0.17 youngs/s, 0.17 non-youngs/s Pages read 23257948, created 776908, written 3117798 0.05 reads/s, 0.14 creates/s, 12.12 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: 245967, unzip_LRU len: 0 I/O sum[5424]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 32108 Free buffers 1025 Database pages 30759 Old database pages 11334 Modified db pages 2 Percent of dirty pages(LRU & free pages): 0.006 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1527550, not young 241865233 0.02 youngs/s, 0.00 non-youngs/s Pages read 2912285, created 97389, written 435265 0.00 reads/s, 0.00 creates/s, 1.53 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: 30759, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 32108 Free buffers 1024 Database pages 30775 Old database pages 11340 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 1417479, not young 240672541 0.02 youngs/s, 0.07 non-youngs/s Pages read 2944774, created 97176, written 409901 0.02 reads/s, 0.00 creates/s, 0.66 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: 30775, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 32108 Free buffers 1025 Database pages 30743 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 1487125, not young 245159576 0.03 youngs/s, 0.00 non-youngs/s Pages read 2988674, created 97064, written 262840 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: 30743, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 32108 Free buffers 1024 Database pages 30729 Old database pages 11323 Modified db pages 12 Percent of dirty pages(LRU & free pages): 0.038 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1483500, not young 240121474 0.05 youngs/s, 0.03 non-youngs/s Pages read 2920184, created 97582, written 611819 0.02 reads/s, 0.00 creates/s, 2.15 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: 30729, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 32108 Free buffers 1024 Database pages 30759 Old database pages 11334 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.009 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1508781, not young 231990456 0.00 youngs/s, 0.00 non-youngs/s Pages read 2911544, created 96455, written 485683 0.00 reads/s, 0.14 creates/s, 3.69 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: 30759, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 32108 Free buffers 1025 Database pages 30737 Old database pages 11326 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 1593956, not young 213705511 0.02 youngs/s, 0.00 non-youngs/s Pages read 2637990, created 97697, written 339520 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: 30737, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 32108 Free buffers 1024 Database pages 30708 Old database pages 11315 Modified db pages 5 Percent of dirty pages(LRU & free pages): 0.016 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1516043, not young 248975715 0.02 youngs/s, 0.07 non-youngs/s Pages read 2988555, created 96789, written 231590 0.02 reads/s, 0.00 creates/s, 2.10 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: 30708, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 32108 Free buffers 1025 Database pages 30757 Old database pages 11333 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 1543238, not young 238397578 0.02 youngs/s, 0.00 non-youngs/s Pages read 2953942, created 96756, written 341180 0.00 reads/s, 0.00 creates/s, 1.98 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: 30757, unzip_LRU len: 0 I/O sum[678]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Process ID=6628, Main thread ID=12328, state: sleeping Number of rows inserted 43820679, updated 195899, deleted 21062, read 380761807093 0.00 inserts/s, 3.63 updates/s, 0.00 deletes/s, 684033.61 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1114966 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Storage engines

InnoDB

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Storage engines

InnoDB