Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2025-09-04 12:23:46 0x7f94bde84700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 23 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 303884 srv_active, 0 srv_shutdown, 2906747 srv_idle
srv_master_thread log flush and writes: 3210056
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 5568777
OS WAIT ARRAY INFO: signal count 4499160
RW-shared spins 0, rounds 2193325, OS waits 306152
RW-excl spins 0, rounds 2037652, OS waits 25085
RW-sx spins 12448, rounds 147482, OS waits 1426
Spin rounds per wait: 2193325.00 RW-shared, 2037652.00 RW-excl, 11.85 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-09-04 10:38:44 0x7f94bddee700 Transaction:
TRANSACTION 33574679, 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 17539580, OS thread handle 140276817389312, query id 69826367 192.168.123.60 root Update
insert into rujuk_masuk values('2025/09/04/000089','Buluspesantren I','-','112035080625P000626','0','Buluspesantren I','Z48.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 5a34382e38; asc Z48.8;;
 1: len 17; hex 323032352f30392f30342f303030303839; asc 2025/09/04/000089;;

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 5a3439; asc Z49;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 23; hex 4361726520696e766f6c76696e67206469616c79736973; asc Care involving dialysis;;
 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 33745920
Purge done for trx's n:o < 33745920 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421756654684696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654650648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654663416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654654904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654680440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654676184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654688952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654671928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654667672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654659160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654646392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654642136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654637880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654633624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654629368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654625112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421756654620856, 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
176243 OS file reads, 6426518 OS file writes, 3549833 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 6.61 writes/s, 4.74 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 6375 merges
merged operations:
 insert 7055, delete mark 465, delete 171
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 3130 buffer(s)
Hash table size 1106407, node heap has 340 buffer(s)
Hash table size 1106407, node heap has 249 buffer(s)
Hash table size 1106407, node heap has 2504 buffer(s)
Hash table size 1106407, node heap has 786 buffer(s)
Hash table size 1106407, node heap has 450 buffer(s)
Hash table size 1106407, node heap has 165 buffer(s)
Hash table size 1106407, node heap has 1261 buffer(s)
19549.02 hash searches/s, 250.90 non-hash searches/s
---
LOG
---
Log sequence number 15059422741
Log flushed up to   15059422704
Pages flushed up to 15059419151
Last checkpoint at  15059419151
0 pending log flushes, 0 pending chkp writes
1941286 log i/o's done, 2.17 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 10829616
Buffer pool size   256480
Free buffers       8193
Database pages     239402
Old database pages 88210
Modified db pages  24
Percent of dirty pages(LRU & free pages): 0.010
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 66510, not young 13314937
0.00 youngs/s, 0.00 non-youngs/s
Pages read 173989, created 448350, written 3842943
0.00 reads/s, 0.00 creates/s, 3.35 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: 239402, unzip_LRU len: 0
I/O sum[1672]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32060
Free buffers       1025
Database pages     29941
Old database pages 11032
Modified db pages  6
Percent of dirty pages(LRU & free pages): 0.019
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8610, not young 1763127
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22310, created 55436, written 502886
0.00 reads/s, 0.00 creates/s, 1.39 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: 29941, unzip_LRU len: 0
I/O sum[209]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32060
Free buffers       1024
Database pages     29928
Old database pages 11027
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 8053, not young 1667806
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21599, created 55866, written 159198
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: 29928, unzip_LRU len: 0
I/O sum[209]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32060
Free buffers       1024
Database pages     29913
Old database pages 11022
Modified db pages  4
Percent of dirty pages(LRU & free pages): 0.013
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8158, not young 1727836
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21940, created 56376, written 360016
0.00 reads/s, 0.00 creates/s, 0.52 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: 29913, unzip_LRU len: 0
I/O sum[209]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32060
Free buffers       1024
Database pages     29927
Old database pages 11027
Modified db pages  11
Percent of dirty pages(LRU & free pages): 0.036
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8313, not young 1593866
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21284, created 56385, written 1097438
0.00 reads/s, 0.00 creates/s, 1.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: 29927, unzip_LRU len: 0
I/O sum[209]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32060
Free buffers       1024
Database pages     29928
Old database pages 11027
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 9571, not young 1889439
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24217, created 56347, written 728236
0.00 reads/s, 0.00 creates/s, 0.09 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: 29928, unzip_LRU len: 0
I/O sum[209]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32060
Free buffers       1024
Database pages     29920
Old database pages 11024
Modified db pages  3
Percent of dirty pages(LRU & free pages): 0.010
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8006, not young 1676914
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21252, created 56641, written 419371
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: 29920, unzip_LRU len: 0
I/O sum[209]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32060
Free buffers       1024
Database pages     29929
Old database pages 11028
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 7376, not young 1471069
0.00 youngs/s, 0.00 non-youngs/s
Pages read 19769, created 55709, written 225758
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: 29929, unzip_LRU len: 0
I/O sum[209]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32060
Free buffers       1024
Database pages     29916
Old database pages 11023
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 8423, not young 1524880
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21618, created 55590, written 350040
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: 29916, unzip_LRU len: 0
I/O sum[209]: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=1195, Main thread ID=140277036717824, state: sleeping
Number of rows inserted 20509510, updated 124442, deleted 556413, read 51061431156
0.30 inserts/s, 0.52 updates/s, 0.00 deletes/s, 19767.14 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1449635
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================