控制台
存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
=====================================
2026-10-11 14:15:43 0x1b54 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 25 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 67745 srv_active, 0 srv_shutdown, 562701 srv_idle
srv_master_thread log flush and writes: 630439
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 197981
OS WAIT ARRAY INFO: signal count 193994
RW-shared spins 1626199, rounds 22480857, OS waits 152301
RW-excl spins 8210, rounds 110386, OS waits 3057
RW-sx spins 169, rounds 2639, OS waits 72
Spin rounds per wait: 13.82 RW-shared, 13.45 RW-excl, 15.62 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-10-07 17:20:52 0x1f28 Transaction:
TRANSACTION 17613681, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 239433, OS thread handle 7976, query id 8513486 DESKTOP-O7TN5CD 192.168.1.55 joker Update
insert into berkas_digital_perawatan values('','013','pages/upload/013.pdf')
Foreign key constraint fails for table `klinikapril`.`berkas_digital_perawatan`:
,
CONSTRAINT `berkas_digital_perawatan_ibfk_1` FOREIGN KEY (`no_rawat`) REFERENCES `reg_periksa` (`no_rawat`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index PRIMARY tuple:
DATA TUPLE: 5 fields;
0: len 0; hex ; asc ;;
1: len 3; hex 303133; asc 013;;
2: len 20; hex 70616765732f75706c6f61642f3031332e706466; asc pages/upload/013.pdf;;
3: len 6; hex 0000010cc371; asc q;;
4: len 7; hex 80000000000000; asc ;;
But in parent table `klinikapril`.`reg_periksa`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 21; compact format; info bits 0
0: len 17; hex 323032302f31322f31322f303030303031; asc 2020/12/12/000001;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 3; hex 303031; asc 001;;
4: len 3; hex 8fc98c; asc ;;
5: len 3; hex 8177bb; asc w ;;
6: len 7; hex 31303030303031; asc 1000001;;
7: len 6; hex 303039303339; asc 009039;;
8: len 5; hex 5530303039; asc U0009;;
9: len 11; hex 46414a52494e2041444841; asc FAJRIN ADHA;;
10: len 21; hex 53554d414e494b2c202d2c202d2c204b4c4154454e; asc SUMANIK, -, -, KLATEN;;
11: len 5; hex 5355414d49; asc SUAMI;;
12: len 8; hex 000000000088c340; asc @;;
13: len 1; hex 02; asc ;;
14: len 1; hex 02; asc ;;
15: len 1; hex 02; asc ;;
16: len 3; hex 413039; asc A09;;
17: len 4; hex 80000017; asc ;;
18: len 1; hex 01; asc ;;
19: len 1; hex 01; asc ;;
20: len 1; hex 02; asc ;;
------------
TRANSACTIONS
------------
Trx id counter 17926585
Purge done for trx's n:o < 17926585 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284190687748728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687777960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687765432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687769608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687761256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687773784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687723672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687732024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687752904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687736200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687740376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687757080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687744552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687727848, 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
2417578 OS file reads, 970726 OS file writes, 750999 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 7.40 writes/s, 5.32 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 4530 merges
merged operations:
insert 5524, delete mark 138, delete 52
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 64 buffer(s)
Hash table size 1106407, node heap has 161 buffer(s)
Hash table size 1106407, node heap has 119 buffer(s)
Hash table size 1106407, node heap has 16 buffer(s)
Hash table size 1106407, node heap has 36 buffer(s)
Hash table size 1106407, node heap has 75 buffer(s)
Hash table size 1106407, node heap has 53 buffer(s)
Hash table size 1106407, node heap has 85 buffer(s)
3.40 hash searches/s, 24.84 non-hash searches/s
---
LOG
---
Log sequence number 31726913865
Log flushed up to 31726913865
Pages flushed up to 31726911983
Last checkpoint at 31726911974
0 pending log flushes, 0 pending chkp writes
344938 log i/o's done, 2.32 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 8849136
Buffer pool size 256864
Free buffers 8192
Database pages 248063
Old database pages 91407
Modified db pages 6
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 397804, not young 152918970
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2413893, created 1319, written 443653
0.00 reads/s, 0.00 creates/s, 3.60 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: 248063, unzip_LRU len: 0
I/O sum[1392]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 32108
Free buffers 1024
Database pages 31019
Old database pages 11430
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 51471, not young 19050279
0.00 youngs/s, 0.00 non-youngs/s
Pages read 300756, created 232, written 72527
0.00 reads/s, 0.00 creates/s, 0.64 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: 31019, unzip_LRU len: 0
I/O sum[174]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 32108
Free buffers 1024
Database pages 30997
Old database pages 11422
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 50314, not young 19130430
0.00 youngs/s, 0.00 non-youngs/s
Pages read 303045, created 20, written 21678
0.00 reads/s, 0.00 creates/s, 0.28 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: 30997, unzip_LRU len: 0
I/O sum[174]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 32108
Free buffers 1024
Database pages 31006
Old database pages 11425
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 47813, not young 19252212
0.00 youngs/s, 0.00 non-youngs/s
Pages read 305297, created 132, written 25428
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: 31006, unzip_LRU len: 0
I/O sum[174]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 32108
Free buffers 1024
Database pages 31010
Old database pages 11427
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 51002, not young 19029872
0.00 youngs/s, 0.00 non-youngs/s
Pages read 294268, created 154, written 149941
0.00 reads/s, 0.00 creates/s, 0.68 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: 31010, unzip_LRU len: 0
I/O sum[174]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 32108
Free buffers 1024
Database pages 31000
Old database pages 11423
Modified db pages 2
Percent of dirty pages(LRU & free pages): 0.006
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 50401, not young 19459426
0.00 youngs/s, 0.00 non-youngs/s
Pages read 305566, created 272, written 103229
0.00 reads/s, 0.00 creates/s, 1.68 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: 31000, unzip_LRU len: 0
I/O sum[174]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 32108
Free buffers 1024
Database pages 30993
Old database pages 11420
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 50071, not young 18889295
0.00 youngs/s, 0.00 non-youngs/s
Pages read 301144, created 138, written 28805
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: 30993, unzip_LRU len: 0
I/O sum[174]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 32108
Free buffers 1024
Database pages 31028
Old database pages 11433
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 49209, not young 18875491
0.00 youngs/s, 0.00 non-youngs/s
Pages read 300340, created 149, written 16243
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: 31028, unzip_LRU len: 0
I/O sum[174]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 32108
Free buffers 1024
Database pages 31010
Old database pages 11427
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 47523, not young 19231965
0.00 youngs/s, 0.00 non-youngs/s
Pages read 303477, created 222, written 25802
0.00 reads/s, 0.00 creates/s, 0.32 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: 31010, unzip_LRU len: 0
I/O sum[174]: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=4624, Main thread ID=6680, state: sleeping
Number of rows inserted 22607, updated 67769, deleted 9480, read 2211341357
0.00 inserts/s, 0.80 updates/s, 0.00 deletes/s, 35.28 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1391198
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================