Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
Variabel
|
Penampungan Penyangga
|
Status InnoDB
]
=====================================
2026-10-02 16:00:32 0x7f9aa8232700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 47 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 124054 srv_active, 0 srv_shutdown, 421431 srv_idle
srv_master_thread log flush and writes: 545363
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2013373
OS WAIT ARRAY INFO: signal count 1415711
RW-shared spins 0, rounds 1043613, OS waits 120018
RW-excl spins 0, rounds 81742, OS waits 495
RW-sx spins 149, rounds 2836, OS waits 56
Spin rounds per wait: 1043613.00 RW-shared, 81742.00 RW-excl, 19.03 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-10-02 15:51:13 0x7f9c48580700 Transaction:
TRANSACTION 655200872, 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 4179185, OS thread handle 140309205354240, query id 20476684 192.168.123.21 root Update
insert into rujuk_masuk values('2026/10/02/000146','Kebumen I ','-','112036100926Y002687','0','Kebumen I ','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 323032362f31302f30322f303030313436; asc 2026/10/02/000146;;
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 655280734
Purge done for trx's n:o < 655280734 undo n:o < 0 state: running but idle
History list length 5
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421786141899448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141895192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141890936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141873912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141882424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141903704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141865400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141839864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141835608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141861144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141886680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141878168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141869656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141856888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141852632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141848376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141844120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421786141831352, 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
105644 OS file reads, 1828327 OS file writes, 1282389 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 16.49 writes/s, 8.62 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 1044 merges
merged operations:
insert 1258, delete mark 2, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 14 buffer(s)
Hash table size 1593833, node heap has 92 buffer(s)
Hash table size 1593833, node heap has 571 buffer(s)
Hash table size 1593833, node heap has 152 buffer(s)
Hash table size 1593833, node heap has 66 buffer(s)
Hash table size 1593833, node heap has 104 buffer(s)
Hash table size 1593833, node heap has 508 buffer(s)
Hash table size 1593833, node heap has 309 buffer(s)
16688.16 hash searches/s, 454.46 non-hash searches/s
---
LOG
---
Log sequence number 58070056743
Log flushed up to 58070056722
Pages flushed up to 58069915602
Last checkpoint at 58069915602
0 pending log flushes, 0 pending chkp writes
616404 log i/o's done, 7.02 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size 384720
Free buffers 279160
Database pages 103744
Old database pages 38421
Modified db pages 204
Percent of dirty pages(LRU & free pages): 0.053
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 194, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 102605, created 1139, written 927321
0.00 reads/s, 0.00 creates/s, 8.81 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: 103744, 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 34959
Database pages 12903
Old database pages 4782
Modified db pages 19
Percent of dirty pages(LRU & free pages): 0.040
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 15, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12823, created 80, written 164195
0.00 reads/s, 0.00 creates/s, 0.77 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: 12903, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 48090
Free buffers 34719
Database pages 13141
Old database pages 4868
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 31, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13055, created 86, written 25478
0.00 reads/s, 0.00 creates/s, 0.04 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: 13141, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 48090
Free buffers 35244
Database pages 12616
Old database pages 4673
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 19, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12464, created 152, written 63328
0.00 reads/s, 0.00 creates/s, 0.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: 12616, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 48090
Free buffers 34470
Database pages 13395
Old database pages 4957
Modified db pages 78
Percent of dirty pages(LRU & free pages): 0.163
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 31, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13164, created 231, written 296652
0.00 reads/s, 0.00 creates/s, 3.21 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: 13395, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 48090
Free buffers 34584
Database pages 13282
Old database pages 4914
Modified db pages 41
Percent of dirty pages(LRU & free pages): 0.086
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 24, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13126, created 156, written 176193
0.00 reads/s, 0.00 creates/s, 1.91 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: 13282, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 48090
Free buffers 35078
Database pages 12783
Old database pages 4734
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 28, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12690, created 93, written 74068
0.00 reads/s, 0.00 creates/s, 0.55 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: 12783, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 48090
Free buffers 35232
Database pages 12633
Old database pages 4681
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 22, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12487, created 146, written 44506
0.00 reads/s, 0.00 creates/s, 0.04 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: 12633, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 48090
Free buffers 34874
Database pages 12991
Old database pages 4812
Modified db pages 43
Percent of dirty pages(LRU & free pages): 0.090
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 24, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12796, created 195, written 82901
0.00 reads/s, 0.00 creates/s, 2.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: 12991, 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=1102, Main thread ID=140302424925952, state: sleeping
Number of rows inserted 125852, updated 95257, deleted 76458, read 17428171239
0.28 inserts/s, 5.45 updates/s, 0.21 deletes/s, 33437.44 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 625347
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 64.87 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
