Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
===================================== 2025-07-09 18:45:06 0x2a44 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 43 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 70983 srv_active, 0 srv_shutdown, 208804 srv_idle srv_master_thread log flush and writes: 279787 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 218276 OS WAIT ARRAY INFO: signal count 196530 RW-shared spins 345933, rounds 1669656, OS waits 43918 RW-excl spins 49160, rounds 444879, OS waits 9995 RW-sx spins 553, rounds 10124, OS waits 236 Spin rounds per wait: 4.83 RW-shared, 9.05 RW-excl, 18.31 RW-sx ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2025-07-09 15:29:46 0x2be4 Transaction: TRANSACTION 4106236, 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 5048881, OS thread handle 11236, query id 29436438 DESKTOP-KUR4QUV 192.168.2.7 root Update insert into rujuk_masuk values('2025/07/09/000473','Simpang Tiga','-','040107010725Y000891','0','Simpang Tiga','Z36.4','-','-','') 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 5a33362e34; asc Z36.4;; 1: len 17; hex 323032352f30372f30392f303030343733; asc 2025/07/09/000473;; 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 5; hex 5a33362e39; asc Z36.9;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 416e74656e6174616c2073637265656e696e672c20756e73706563696669; asc Antenatal screening, unspecifi; (total 32 bytes); 4: len 30; hex 416e74656e6174616c2073637265656e696e672c20756e73706563696669; asc Antenatal screening, unspecifi; (total 32 bytes); 5: len 1; hex 2d; asc -;; 6: len 1; hex 2d; asc -;; 7: len 1; hex 02; asc ;; ------------ TRANSACTIONS ------------ Trx id counter 4120807 Purge done for trx's n:o < 4120807 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 284334009344432, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009331928, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009327760, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009365272, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009398616, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009511152, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009540328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009490312, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009531992, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009436128, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009356936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009515320, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009523656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009519488, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009502816, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009423624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009448632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009481976, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009477808, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009473640, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009465304, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009456968, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009444464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009440296, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009348600, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009336096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009419456, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009415288, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009406952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009386112, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009377776, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009369440, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009340264, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009352768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009427792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009381944, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009373608, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 284334009361104, 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 957538 OS file reads, 1041830 OS file writes, 665650 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.37 writes/s, 1.91 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 434, seg size 436, 25143 merges merged operations: insert 30788, delete mark 12482, delete 10160 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1106407, node heap has 869 buffer(s) Hash table size 1106407, node heap has 345 buffer(s) Hash table size 1106407, node heap has 51 buffer(s) Hash table size 1106407, node heap has 103 buffer(s) Hash table size 1106407, node heap has 167 buffer(s) Hash table size 1106407, node heap has 654 buffer(s) Hash table size 1106407, node heap has 57 buffer(s) Hash table size 1106407, node heap has 138 buffer(s) 91180.79 hash searches/s, 1228.79 non-hash searches/s --- LOG --- Log sequence number 12165437524 Log flushed up to 12165437524 Pages flushed up to 12165437524 Last checkpoint at 12165437515 0 pending log flushes, 0 pending chkp writes 205032 log i/o's done, 0.72 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 246288 Old database pages 90750 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 732570, not young 79476410 0.05 youngs/s, 0.00 non-youngs/s Pages read 956517, created 4278, written 663337 0.00 reads/s, 0.00 creates/s, 1.12 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: 246288, unzip_LRU len: 0 I/O sum[504]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 32108 Free buffers 1024 Database pages 30813 Old database pages 11354 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 90861, not young 9739146 0.00 youngs/s, 0.00 non-youngs/s Pages read 115252, created 632, written 104144 0.00 reads/s, 0.00 creates/s, 0.05 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: 30813, unzip_LRU len: 0 I/O sum[63]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 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 94126, not young 10154059 0.00 youngs/s, 0.00 non-youngs/s Pages read 122513, created 521, written 66545 0.00 reads/s, 0.00 creates/s, 0.02 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: 30746, unzip_LRU len: 0 I/O sum[63]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 32108 Free buffers 1024 Database pages 30776 Old database pages 11340 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 92742, not young 9698200 0.00 youngs/s, 0.00 non-youngs/s Pages read 117559, created 446, written 62105 0.00 reads/s, 0.00 creates/s, 0.05 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: 30776, unzip_LRU len: 0 I/O sum[63]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 32108 Free buffers 1024 Database pages 30788 Old database pages 11345 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 94132, not young 9458933 0.00 youngs/s, 0.00 non-youngs/s Pages read 117905, created 392, written 117001 0.00 reads/s, 0.00 creates/s, 0.47 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: 30788, unzip_LRU len: 0 I/O sum[63]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 32108 Free buffers 1024 Database pages 30770 Old database pages 11338 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 87894, not young 10436522 0.00 youngs/s, 0.00 non-youngs/s Pages read 125981, created 580, written 110543 0.00 reads/s, 0.00 creates/s, 0.05 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: 30770, unzip_LRU len: 0 I/O sum[63]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 32108 Free buffers 1024 Database pages 30801 Old database pages 11349 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 91864, not young 9364231 0.05 youngs/s, 0.00 non-youngs/s Pages read 115749, created 484, written 54615 0.00 reads/s, 0.00 creates/s, 0.30 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: 30801, unzip_LRU len: 0 I/O sum[63]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 32108 Free buffers 1024 Database pages 30801 Old database pages 11349 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 90570, not young 9956901 0.00 youngs/s, 0.00 non-youngs/s Pages read 122066, created 722, written 86847 0.00 reads/s, 0.00 creates/s, 0.19 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: 30801, unzip_LRU len: 0 I/O sum[63]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 32108 Free buffers 1024 Database pages 30793 Old database pages 11346 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 90381, not young 10668418 0.00 youngs/s, 0.00 non-youngs/s Pages read 119492, created 501, written 61537 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: 30793, unzip_LRU len: 0 I/O sum[63]: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=11220, Main thread ID=13620, state: sleeping Number of rows inserted 191539, updated 13628, deleted 14436, read 43991349703 0.19 inserts/s, 0.07 updates/s, 0.00 deletes/s, 238993.44 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 ============================