Storage engines

InnoDB

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
============================