Supports transactions, row-level locking, foreign keys and encryption for tables
===================================== 2025-07-02 21:36:20 0x2db0 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 4 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 16699 srv_active, 0 srv_shutdown, 31387 srv_idle srv_master_thread log flush and writes: 48086 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 77688 OS WAIT ARRAY INFO: signal count 64441 RW-shared spins 117978, rounds 526555, OS waits 12357 RW-excl spins 19181, rounds 149372, OS waits 2815 RW-sx spins 277, rounds 5026, OS waits 132 Spin rounds per wait: 4.46 RW-shared, 7.79 RW-excl, 18.14 RW-sx ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2025-07-02 17:09:08 0x1434 Transaction: TRANSACTION 3793241, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 8463, OS thread handle 5172, query id 3938542 DESKTOP-J2OHHFH 192.168.2.28 root Update insert into rujuk_masuk values('2025/07/02/000154','Klinik Fellita','-','0069B0310725Y000028','0','Klinik Fellita','Z32.0','-','-','') Foreign key constraint fails for table `mesrabaru`.`rujuk_masuk`: , CONSTRAINT `rujuk_masuk_ibfk_2` FOREIGN KEY (`kd_penyakit`) REFERENCES `penyakit` (`kd_penyakit`) ON UPDATE CASCADE in parent table, in index kd_penyakit tuple: DATA TUPLE: 2 fields; 0: len 5; hex 5a33322e30; asc Z32.0;; 1: len 17; hex 323032352f30372f30322f303030313534; asc 2025/07/02/000154;; But in parent table `mesrabaru`.`penyakit`, in index PRIMARY, the closest match we can find is record: PHYSICAL RECORD: n_fields 8; compact format; info bits 0 0: len 3; hex 5a3333; asc Z33;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 26; hex 507265676e616e742073746174652c20696e636964656e74616c; asc Pregnant state, incidental;; 4: len 1; hex 2d; asc -;; 5: len 1; hex 2d; asc -;; 6: len 1; hex 2d; asc -;; 7: len 1; hex 02; asc ;; ------------ TRANSACTIONS ------------ Trx id counter 3803767 Purge done for trx's n:o < 3803767 undo n:o < 0 state: running but idle History list length 3 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283814739846560, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739842392, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739825720, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739904912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739900744, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739871568, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739867400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739804880, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739784040, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739942424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739771536, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739834056, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739921584, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739796544, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739909080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739800712, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739913248, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739859064, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739863232, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739875736, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739884072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739879904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739854896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739838224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739829888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739821552, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739817384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739813216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739775704, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739792376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739788208, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739779872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739809048, 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 296905 OS file reads, 280405 OS file writes, 175569 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 29.99 writes/s, 16.25 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 24, seg size 26, 9049 merges merged operations: insert 10800, delete mark 15058, delete 12676 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1106407, node heap has 861 buffer(s) Hash table size 1106407, node heap has 170 buffer(s) Hash table size 1106407, node heap has 12 buffer(s) Hash table size 1106407, node heap has 71 buffer(s) Hash table size 1106407, node heap has 179 buffer(s) Hash table size 1106407, node heap has 560 buffer(s) Hash table size 1106407, node heap has 37 buffer(s) Hash table size 1106407, node heap has 108 buffer(s) 46.24 hash searches/s, 104.47 non-hash searches/s --- LOG --- Log sequence number 10676887985 Log flushed up to 10676887963 Pages flushed up to 10676886267 Last checkpoint at 10676881757 0 pending log flushes, 0 pending chkp writes 50460 log i/o's done, 6.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4462739456 Dictionary memory allocated 2511512 Buffer pool size 256864 Free buffers 8192 Database pages 246674 Old database pages 90893 Modified db pages 48 Percent of dirty pages(LRU & free pages): 0.019 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 8959, not young 3047600 0.00 youngs/s, 0.00 non-youngs/s Pages read 295897, created 1373, written 183987 0.00 reads/s, 0.00 creates/s, 18.50 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: 246674, unzip_LRU len: 0 I/O sum[1792]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 32108 Free buffers 1024 Database pages 30824 Old database pages 11358 Modified db pages 16 Percent of dirty pages(LRU & free pages): 0.050 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1135, not young 380540 0.00 youngs/s, 0.00 non-youngs/s Pages read 36596, created 204, written 24960 0.00 reads/s, 0.00 creates/s, 5.75 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: 30824, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 32108 Free buffers 1024 Database pages 30831 Old database pages 11360 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 1029, not young 410657 0.00 youngs/s, 0.00 non-youngs/s Pages read 38279, created 77, written 17164 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: 30831, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 32108 Free buffers 1024 Database pages 30829 Old database pages 11360 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 1086, not young 397547 0.00 youngs/s, 0.00 non-youngs/s Pages read 37055, created 202, written 18107 0.00 reads/s, 0.00 creates/s, 3.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: 30829, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 32108 Free buffers 1024 Database pages 30805 Old database pages 11351 Modified db pages 21 Percent of dirty pages(LRU & free pages): 0.066 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1145, not young 411010 0.00 youngs/s, 0.00 non-youngs/s Pages read 37074, created 127, written 32345 0.00 reads/s, 0.00 creates/s, 7.25 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: 30805, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 32108 Free buffers 1024 Database pages 30862 Old database pages 11372 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 1279, not young 397634 0.00 youngs/s, 0.00 non-youngs/s Pages read 37612, created 189, written 30260 0.00 reads/s, 0.00 creates/s, 0.75 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: 30862, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 32108 Free buffers 1024 Database pages 30851 Old database pages 11368 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 1087, not young 281747 0.00 youngs/s, 0.00 non-youngs/s Pages read 35810, created 175, written 18578 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: 30851, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 32108 Free buffers 1024 Database pages 30852 Old database pages 11368 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 1172, not young 376563 0.00 youngs/s, 0.00 non-youngs/s Pages read 36805, created 231, written 24779 0.00 reads/s, 0.00 creates/s, 1.75 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: 30852, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 32108 Free buffers 1024 Database pages 30820 Old database pages 11356 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 1026, not young 391902 0.00 youngs/s, 0.00 non-youngs/s Pages read 36666, created 168, written 17794 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: 30820, unzip_LRU len: 0 I/O sum[224]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=11420, Main thread ID=4512, state: sleeping Number of rows inserted 51280, updated 3744, deleted 4879, read 7330704035 2.75 inserts/s, 0.00 updates/s, 2.50 deletes/s, 103462.13 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================