控制台
存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
=====================================
2026-10-11 14:17:24 0x1aac INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 36 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 67804 srv_active, 0 srv_shutdown, 562733 srv_idle
srv_master_thread log flush and writes: 630530
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 198061
OS WAIT ARRAY INFO: signal count 194057
RW-shared spins 1626241, rounds 22481920, OS waits 152336
RW-excl spins 8213, rounds 110478, OS waits 3060
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 17930650
Purge done for trx's n:o < 17930650 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284190687794664, 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 284190687786312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687782136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687761256, not started flushing log
mysql tables in use 1, locked 1
0 lock struct(s), heap size 1128, 0 row lock(s)
---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 284190687773784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284190687790488, 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 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: 1; buffer pool: 0
2417597 OS file reads, 971556 OS file writes, 751511 OS fsyncs
0.19 reads/s, 16384 avg bytes/read, 6.78 writes/s, 5.11 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)
5.97 hash searches/s, 183.38 non-hash searches/s
---
LOG
---
Log sequence number 31727117527
Log flushed up to 31727116196
Pages flushed up to 31727078582
Last checkpoint at 31727078573
1 pending log flushes, 0 pending chkp writes
345248 log i/o's done, 2.97 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 9164640
Buffer pool size 256864
Free buffers 8192
Database pages 248063
Old database pages 91407
Modified db pages 76
Percent of dirty pages(LRU & free pages): 0.030
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 397817, not young 152919044
0.14 youngs/s, 0.86 non-youngs/s
Pages read 2413912, created 1319, written 444074
0.19 reads/s, 0.00 creates/s, 2.75 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 3 / 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[1992]: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 14
Percent of dirty pages(LRU & free pages): 0.044
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 51474, not young 19050280
0.03 youngs/s, 0.00 non-youngs/s
Pages read 300757, created 232, written 72616
0.00 reads/s, 0.00 creates/s, 0.61 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 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[249]: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 50317, not young 19130433
0.03 youngs/s, 0.03 non-youngs/s
Pages read 303048, created 20, written 21690
0.03 reads/s, 0.00 creates/s, 0.11 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 1 / 1000 not 1 / 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[249]: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 47815, not young 19252216
0.03 youngs/s, 0.08 non-youngs/s
Pages read 305300, created 132, written 25428
0.06 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 971 / 1000, young-making rate 14 / 1000 not 42 / 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[249]: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 51003, not young 19029873
0.03 youngs/s, 0.03 non-youngs/s
Pages read 294269, created 154, written 150036
0.03 reads/s, 0.00 creates/s, 0.67 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: 31010, unzip_LRU len: 0
I/O sum[249]: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 48
Percent of dirty pages(LRU & free pages): 0.150
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 19459451
0.00 youngs/s, 0.69 non-youngs/s
Pages read 305568, created 272, written 103410
0.06 reads/s, 0.00 creates/s, 1.11 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 4 / 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[249]: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 50072, not young 18889296
0.00 youngs/s, 0.00 non-youngs/s
Pages read 301145, created 138, written 28807
0.00 reads/s, 0.00 creates/s, 0.03 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[249]: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 49210, not young 18875528
0.03 youngs/s, 0.03 non-youngs/s
Pages read 300346, created 149, written 16243
0.03 reads/s, 0.00 creates/s, 0.00 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: 31028, unzip_LRU len: 0
I/O sum[249]: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 11
Percent of dirty pages(LRU & free pages): 0.034
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 47525, not young 19231967
0.00 youngs/s, 0.00 non-youngs/s
Pages read 303479, created 222, written 25844
0.00 reads/s, 0.00 creates/s, 0.22 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[249]: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 67955, deleted 9480, read 2211481240
0.00 inserts/s, 1.69 updates/s, 0.00 deletes/s, 70.11 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1437943
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================