存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
变量
|
缓冲池
|
InnoDB 状态
]
=====================================
2026-10-11 17:21:10 0x314 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 59 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 72673 srv_active, 0 srv_shutdown, 568253 srv_idle
srv_master_thread log flush and writes: 640919
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 223112
OS WAIT ARRAY INFO: signal count 218340
RW-shared spins 1631138, rounds 22611039, OS waits 156176
RW-excl spins 8786, rounds 121425, OS waits 3293
RW-sx spins 177, rounds 2753, OS waits 75
Spin rounds per wait: 13.86 RW-shared, 13.82 RW-excl, 15.55 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 18106235
Purge done for trx's n:o < 18106235 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284190687773784, 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 284190687761256, 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 284190687769608, 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 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
2429378 OS file reads, 1038138 OS file writes, 794317 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 4.51 writes/s, 2.86 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 4641 merges
merged operations:
insert 5655, 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 163 buffer(s)
Hash table size 1106407, node heap has 119 buffer(s)
Hash table size 1106407, node heap has 20 buffer(s)
Hash table size 1106407, node heap has 42 buffer(s)
Hash table size 1106407, node heap has 75 buffer(s)
Hash table size 1106407, node heap has 55 buffer(s)
Hash table size 1106407, node heap has 85 buffer(s)
55.10 hash searches/s, 22.12 non-hash searches/s
---
LOG
---
Log sequence number 31747083613
Log flushed up to 31747082873
Pages flushed up to 31747062130
Last checkpoint at 31747057297
0 pending log flushes, 0 pending chkp writes
372951 log i/o's done, 1.71 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 8526120
Buffer pool size 256864
Free buffers 8192
Database pages 248049
Old database pages 91401
Modified db pages 57
Percent of dirty pages(LRU & free pages): 0.022
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 402899, not young 153371652
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2425671, created 1320, written 476207
0.00 reads/s, 0.00 creates/s, 2.25 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: 248049, unzip_LRU len: 0
I/O sum[1064]: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 12
Percent of dirty pages(LRU & free pages): 0.037
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 52317, not young 19122532
0.00 youngs/s, 0.00 non-youngs/s
Pages read 302470, created 232, written 78226
0.00 reads/s, 0.00 creates/s, 0.37 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[133]: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 50792, not young 19173354
0.00 youngs/s, 0.00 non-youngs/s
Pages read 304671, created 20, written 22731
0.00 reads/s, 0.00 creates/s, 0.10 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[133]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 32108
Free buffers 1024
Database pages 31004
Old database pages 11424
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 48421, not young 19291093
0.00 youngs/s, 0.00 non-youngs/s
Pages read 306587, created 132, written 27228
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: 31004, unzip_LRU len: 0
I/O sum[133]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 32108
Free buffers 1024
Database pages 31008
Old database pages 11426
Modified db pages 18
Percent of dirty pages(LRU & free pages): 0.056
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 51586, not young 19093055
0.00 youngs/s, 0.00 non-youngs/s
Pages read 295519, created 154, written 161814
0.00 reads/s, 0.00 creates/s, 0.42 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: 31008, unzip_LRU len: 0
I/O sum[133]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 32108
Free buffers 1024
Database pages 30998
Old database pages 11422
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 50922, not young 19509581
0.00 youngs/s, 0.00 non-youngs/s
Pages read 307011, created 272, written 112528
0.00 reads/s, 0.00 creates/s, 0.37 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: 30998, unzip_LRU len: 0
I/O sum[133]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 32108
Free buffers 1024
Database pages 30988
Old database pages 11418
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 50585, not young 18934943
0.00 youngs/s, 0.00 non-youngs/s
Pages read 302395, created 138, written 29917
0.00 reads/s, 0.00 creates/s, 0.47 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: 30988, unzip_LRU len: 0
I/O sum[133]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 32108
Free buffers 1024
Database pages 31027
Old database pages 11433
Modified db pages 5
Percent of dirty pages(LRU & free pages): 0.016
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 49966, not young 18955947
0.00 youngs/s, 0.00 non-youngs/s
Pages read 301881, created 150, written 16938
0.00 reads/s, 0.00 creates/s, 0.12 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: 31027, unzip_LRU len: 0
I/O sum[133]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 32108
Free buffers 1024
Database pages 31008
Old database pages 11426
Modified db pages 7
Percent of dirty pages(LRU & free pages): 0.022
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 48310, not young 19291147
0.00 youngs/s, 0.00 non-youngs/s
Pages read 305137, created 222, written 26825
0.00 reads/s, 0.00 creates/s, 0.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: 31008, unzip_LRU len: 0
I/O sum[133]: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 22960, updated 84232, deleted 9511, read 2238603060
0.02 inserts/s, 1.15 updates/s, 0.00 deletes/s, 16.17 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 1617724
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
