Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2025-07-09 16:17:48 0x363c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 54 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 67901 srv_active, 0 srv_shutdown, 203133 srv_idle
srv_master_thread log flush and writes: 271034
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 210162
OS WAIT ARRAY INFO: signal count 186352
RW-shared spins 328563, rounds 1596688, OS waits 42050
RW-excl spins 46700, rounds 427834, OS waits 9648
RW-sx spins 511, rounds 9369, OS waits 217
Spin rounds per wait: 4.86 RW-shared, 9.16 RW-excl, 18.33 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 4109012
Purge done for trx's n:o < 4109012 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284334009511152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334009506984, 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 284334009536160, 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 284334009394448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334009527824, 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 284334009344432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334009498648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334009494480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334009452800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334009431960, 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 284334009331928, 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 284334009402784, 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 284334009486144, 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 284334009469472, 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 284334009461136, 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 284334009411120, 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 284334009398616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334009390280, 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 284334009365272, 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
956235 OS file reads, 994726 OS file writes, 633677 OS fsyncs
0.02 reads/s, 16384 avg bytes/read, 4.35 writes/s, 3.59 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 434, seg size 436, 24434 merges
merged operations:
 insert 29880, delete mark 12478, delete 10160
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 860 buffer(s)
Hash table size 1106407, node heap has 342 buffer(s)
Hash table size 1106407, node heap has 49 buffer(s)
Hash table size 1106407, node heap has 101 buffer(s)
Hash table size 1106407, node heap has 162 buffer(s)
Hash table size 1106407, node heap has 647 buffer(s)
Hash table size 1106407, node heap has 41 buffer(s)
Hash table size 1106407, node heap has 137 buffer(s)
43594.67 hash searches/s, 687.41 non-hash searches/s
---
LOG
---
Log sequence number 12160032350
Log flushed up to   12160032350
Pages flushed up to 12160032350
Last checkpoint at  12160032341
0 pending log flushes, 0 pending chkp writes
193755 log i/o's done, 1.20 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     246333
Old database pages 90769
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 731111, not young 79423892
0.04 youngs/s, 0.00 non-youngs/s
Pages read 955214, created 4027, written 635179
0.02 reads/s, 0.00 creates/s, 2.19 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: 246333, unzip_LRU len: 0
I/O sum[792]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
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 90621, not young 9700893
0.00 youngs/s, 0.00 non-youngs/s
Pages read 115023, created 622, written 100166
0.00 reads/s, 0.00 creates/s, 0.41 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[99]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       1024
Database pages     30753
Old database pages 11332
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 93907, not young 10152499
0.00 youngs/s, 0.00 non-youngs/s
Pages read 122380, created 518, written 63103
0.00 reads/s, 0.00 creates/s, 0.48 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: 30753, unzip_LRU len: 0
I/O sum[99]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       1024
Database pages     30783
Old database pages 11343
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 92560, not young 9697437
0.00 youngs/s, 0.00 non-youngs/s
Pages read 117378, created 411, written 58623
0.00 reads/s, 0.00 creates/s, 0.15 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: 30783, unzip_LRU len: 0
I/O sum[99]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       1024
Database pages     30799
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 93977, not young 9458494
0.02 youngs/s, 0.00 non-youngs/s
Pages read 117762, created 374, written 112233
0.02 reads/s, 0.00 creates/s, 0.28 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: 30799, unzip_LRU len: 0
I/O sum[99]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       1024
Database pages     30777
Old database pages 11341
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 87702, not young 10433627
0.00 youngs/s, 0.00 non-youngs/s
Pages read 125815, created 531, written 105644
0.00 reads/s, 0.00 creates/s, 0.76 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: 30777, unzip_LRU len: 0
I/O sum[99]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       1024
Database pages     30803
Old database pages 11350
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 91688, not young 9360352
0.00 youngs/s, 0.00 non-youngs/s
Pages read 115600, created 410, written 52061
0.00 reads/s, 0.00 creates/s, 0.07 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: 30803, unzip_LRU len: 0
I/O sum[99]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32108
Free buffers       1024
Database pages     30804
Old database pages 11351
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 90392, not young 9952579
0.00 youngs/s, 0.00 non-youngs/s
Pages read 121892, created 664, written 83497
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: 30804, unzip_LRU len: 0
I/O sum[99]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32108
Free buffers       1024
Database pages     30794
Old database pages 11347
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 90264, not young 10668011
0.02 youngs/s, 0.00 non-youngs/s
Pages read 119364, created 497, written 59852
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: 30794, unzip_LRU len: 0
I/O sum[99]: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 180976, updated 13087, deleted 13753, read 42480926490
0.37 inserts/s, 0.06 updates/s, 0.00 deletes/s, 164940.41 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
============================