Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2025-10-22 10:42:09 0x7fed340e5700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 18 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 358870 srv_active, 0 srv_shutdown, 1029743 srv_idle
srv_master_thread log flush and writes: 1388230
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3824119
OS WAIT ARRAY INFO: signal count 2101565
RW-shared spins 0, rounds 827653, OS waits 288011
RW-excl spins 0, rounds 136513, OS waits 2354
RW-sx spins 326, rounds 5804, OS waits 110
Spin rounds per wait: 827653.00 RW-shared, 136513.00 RW-excl, 17.80 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-10-22 10:34:09 0x7fed3404f700 Transaction:
TRANSACTION 92204011, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 12768002, OS thread handle 140656756717312, query id 240472724 192.168.123.60 root Update
insert into rujuk_masuk values('2025/10/22/000120','Kebumen II ','-','112036091025Y001324','0','Kebumen II ','Z09.8','-','-','')
Foreign key constraint fails for table `sik`.`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 5a30392e38; asc Z09.8;;
 1: len 17; hex 323032352f31302f32322f303030313230; asc 2025/10/22/000120;;

But in parent table `sik`.`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 5a3130; asc Z10;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 30; hex 526f7574696e652067656e6572616c206865616c746820636865636b2d75; asc Routine general health check-u; (total 63 bytes);
 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 92208831
Purge done for trx's n:o < 92208831 undo n:o < 0 state: running
History list length 5
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422133706122680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706109912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706182264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706173752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706165240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706092888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706169496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706148216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706156728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706152472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706143960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706139704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706135448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706131192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706126936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706118424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706097144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706114168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706105656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706101400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422133706088632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (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
93578 OS file reads, 5386426 OS file writes, 3788642 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 8.33 writes/s, 5.44 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 1991 merges
merged operations:
 insert 2334, delete mark 22, delete 3
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 61 buffer(s)
Hash table size 1593833, node heap has 21 buffer(s)
Hash table size 1593833, node heap has 312 buffer(s)
Hash table size 1593833, node heap has 44 buffer(s)
Hash table size 1593833, node heap has 50 buffer(s)
Hash table size 1593833, node heap has 173 buffer(s)
Hash table size 1593833, node heap has 121 buffer(s)
Hash table size 1593833, node heap has 214 buffer(s)
19466.97 hash searches/s, 411.98 non-hash searches/s
---
LOG
---
Log sequence number 20976913230
Log flushed up to   20976913209
Pages flushed up to 20976864106
Last checkpoint at  20976864106
0 pending log flushes, 0 pending chkp writes
1845612 log i/o's done, 4.33 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8106848
Buffer pool size   384720
Free buffers       291025
Database pages     92699
Old database pages 34292
Modified db pages  94
Percent of dirty pages(LRU & free pages): 0.024
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 285, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 90540, created 2159, written 2686782
0.00 reads/s, 0.00 creates/s, 3.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: 92699, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   48090
Free buffers       36665
Database pages     11294
Old database pages 4171
Modified db pages  7
Percent of dirty pages(LRU & free pages): 0.015
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 36, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11111, created 183, written 659113
0.00 reads/s, 0.00 creates/s, 0.56 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: 11294, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   48090
Free buffers       36006
Database pages     11962
Old database pages 4422
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 41, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11706, created 256, written 67745
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: 11962, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   48090
Free buffers       36358
Database pages     11611
Old database pages 4282
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 34, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11360, created 251, written 137428
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: 11611, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   48090
Free buffers       36015
Database pages     11954
Old database pages 4431
Modified db pages  63
Percent of dirty pages(LRU & free pages): 0.131
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 29, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11660, created 294, written 785581
0.00 reads/s, 0.00 creates/s, 2.17 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: 11954, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   48090
Free buffers       35687
Database pages     12281
Old database pages 4549
Modified db pages  8
Percent of dirty pages(LRU & free pages): 0.017
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 23, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12059, created 222, written 505012
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: 12281, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   48090
Free buffers       36289
Database pages     11676
Old database pages 4322
Modified db pages  14
Percent of dirty pages(LRU & free pages): 0.029
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 39, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11421, created 255, written 202738
0.00 reads/s, 0.00 creates/s, 0.67 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: 11676, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   48090
Free buffers       37370
Database pages     10591
Old database pages 3914
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 49, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10157, created 434, written 142763
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: 10591, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   48090
Free buffers       36635
Database pages     11330
Old database pages 4201
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.004
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 34, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11066, created 264, written 186402
0.00 reads/s, 0.00 creates/s, 0.11 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: 11330, unzip_LRU len: 0
I/O sum[0]: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=1192, Main thread ID=140650028054272, state: sleeping
Number of rows inserted 326930, updated 403183, deleted 223022, read 15407885727
0.00 inserts/s, 3.78 updates/s, 0.00 deletes/s, 19812.29 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 646688
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 169.32 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================