存储引擎

InnoDB

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

[ 变量 | 缓冲池 | InnoDB 状态 ]

=====================================
2026-10-11 15:04:24 0x2b5c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 42 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 69203 srv_active, 0 srv_shutdown, 563951 srv_idle
srv_master_thread log flush and writes: 633147
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 200794
OS WAIT ARRAY INFO: signal count 196548
RW-shared spins 1628628, rounds 22542243, OS waits 153945
RW-excl spins 8401, rounds 114398, OS waits 3131
RW-sx spins 171, rounds 2699, OS waits 74
Spin rounds per wait: 13.84 RW-shared, 13.62 RW-excl, 15.78 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 17961223
Purge done for trx's n:o < 17961223 undo n:o < 0 state: running
History list length 7
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284190687761256, 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 284190687769608, 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 284190687748728, 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 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
2423971 OS file reads, 992286 OS file writes, 764398 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 6.76 writes/s, 4.38 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 4538 merges
merged operations:
 insert 5536, 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 162 buffer(s)
Hash table size 1106407, node heap has 119 buffer(s)
Hash table size 1106407, node heap has 18 buffer(s)
Hash table size 1106407, node heap has 37 buffer(s)
Hash table size 1106407, node heap has 75 buffer(s)
Hash table size 1106407, node heap has 54 buffer(s)
Hash table size 1106407, node heap has 85 buffer(s)
5.12 hash searches/s, 19.74 non-hash searches/s
---
LOG
---
Log sequence number 31732434824
Log flushed up to   31732434804
Pages flushed up to 31732388528
Last checkpoint at  31732388528
0 pending log flushes, 0 pending chkp writes
353396 log i/o's done, 2.57 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 8764000
Buffer pool size   256864
Free buffers       8192
Database pages     248058
Old database pages 91406
Modified db pages  75
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 398650, not young 153155808
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2420286, created 1319, written 454582
0.00 reads/s, 0.00 creates/s, 3.36 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: 248058, unzip_LRU len: 0
I/O sum[1224]: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  10
Percent of dirty pages(LRU & free pages): 0.031
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 51573, not young 19071148
0.00 youngs/s, 0.00 non-youngs/s
Pages read 301574, created 232, written 74433
0.00 reads/s, 0.00 creates/s, 0.05 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[153]: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 50371, not young 19165175
0.00 youngs/s, 0.00 non-youngs/s
Pages read 304085, created 20, written 21935
0.00 reads/s, 0.00 creates/s, 0.29 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[153]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       1024
Database pages     31005
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 47929, not young 19268719
0.00 youngs/s, 0.00 non-youngs/s
Pages read 306026, created 132, written 26144
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: 31005, unzip_LRU len: 0
I/O sum[153]: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  15
Percent of dirty pages(LRU & free pages): 0.047
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 51124, not young 19058805
0.00 youngs/s, 0.00 non-youngs/s
Pages read 294957, created 154, written 154293
0.00 reads/s, 0.00 creates/s, 1.40 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[153]: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  49
Percent of dirty pages(LRU & free pages): 0.153
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 50523, not young 19486215
0.00 youngs/s, 0.00 non-youngs/s
Pages read 306360, created 272, written 106577
0.00 reads/s, 0.00 creates/s, 1.62 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[153]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       1024
Database pages     30989
Old database pages 11419
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 50136, not young 18922446
0.00 youngs/s, 0.00 non-youngs/s
Pages read 301857, created 138, written 28837
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: 30989, unzip_LRU len: 0
I/O sum[153]: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 49354, not young 18915605
0.00 youngs/s, 0.00 non-youngs/s
Pages read 301147, created 149, written 16285
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[153]: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  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 47640, not young 19267695
0.00 youngs/s, 0.00 non-youngs/s
Pages read 304280, created 222, written 26078
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
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[153]: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 22665, updated 72408, deleted 9482, read 2216414482
0.00 inserts/s, 1.48 updates/s, 0.00 deletes/s, 556.13 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1441617
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================