存储引擎

InnoDB

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

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

=====================================
2025-12-06 15:07:36 0x2b28 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 29 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 243704 srv_active, 0 srv_shutdown, 380618 srv_idle
srv_master_thread log flush and writes: 624322
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 367363
OS WAIT ARRAY INFO: signal count 5654972
RW-shared spins 8692839, rounds 19142394, OS waits 229062
RW-excl spins 359494, rounds 1303616, OS waits 11395
RW-sx spins 1558, rounds 38578, OS waits 962
Spin rounds per wait: 2.20 RW-shared, 3.63 RW-excl, 24.76 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-12-06 12:46:53 0x2e8c Transaction:
TRANSACTION 18213457, 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 9308196, OS thread handle 11916, query id 52370387 192.168.2.95 root Update
insert into berkas_digital_perawatan values('2025-12-05','005','pages/upload/2025-12-05005.pdf')
Foreign key constraint fails for table `mesrabaru01`.`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 10; hex 323032352d31322d3035; asc 2025-12-05;;
 1: len 3; hex 303035; asc 005;;
 2: len 30; hex 70616765732f75706c6f61642f323032352d31322d30353030352e706466; asc pages/upload/2025-12-05005.pdf;;
 3: len 6; hex 00000115ea51; asc      Q;;
 4: len 7; hex 8f000006a72b27; asc      +';;

But in parent table `mesrabaru01`.`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 323032352f30312f30312f303030303031; asc 2025/01/01/000001;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 303031; asc 001;;
 4: len 3; hex 8fd221; asc   !;;
 5: len 3; hex 801085; asc    ;;
 6: len 8; hex 4430303030303431; asc D0000041;;
 7: len 6; hex 303535333237; asc 055327;;
 8: len 5; hex 4947444b20; asc IGDK ;;
 9: len 12; hex 53554e41525349482e204e59; asc SUNARSIH. NY;;
 10: len 30; hex 504552554d2e205055524e414d4120424c4f4b2047204e4f2030322c202d; asc PERUM. PURNAMA BLOK G NO 02, -; (total 36 bytes);
 11: len 3; hex 494255; asc IBU;;
 12: len 8; hex 000000000088b340; asc        @;;
 13: len 1; hex 02; asc  ;;
 14: len 1; hex 02; asc  ;;
 15: len 1; hex 01; asc  ;;
 16: len 3; hex 554d31; asc UM1;;
 17: len 4; hex 8000000b; asc     ;;
 18: len 1; hex 01; asc  ;;
 19: len 1; hex 01; asc  ;;
 20: len 1; hex 02; asc  ;;

------------
TRANSACTIONS
------------
Trx id counter 18341421
Purge done for trx's n:o < 18341411 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 282833099040736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098974048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098936536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099057408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099065744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098978216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099019896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099036568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099024064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099078248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099007392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098999056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099099088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098990720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099090752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099061576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098994888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098969880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099003224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099086584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099032400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099074080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099053240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099049072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098961544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099028232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098965712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098949040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099015728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098932368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099011560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098982384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098986552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098944872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098953208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098940704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833098957376, 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
15327816 OS file reads, 2995358 OS file writes, 2035371 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.62 writes/s, 0.62 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 24, seg size 26, 111914 merges
merged operations:
 insert 142612, delete mark 26600, delete 12479
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 46 buffer(s)
Hash table size 1106407, node heap has 718 buffer(s)
Hash table size 1106407, node heap has 91 buffer(s)
Hash table size 1106407, node heap has 15 buffer(s)
Hash table size 1106407, node heap has 320 buffer(s)
Hash table size 1106407, node heap has 688 buffer(s)
Hash table size 1106407, node heap has 134 buffer(s)
Hash table size 1106407, node heap has 61 buffer(s)
50673.36 hash searches/s, 5155.89 non-hash searches/s
---
LOG
---
Log sequence number 53089320472
Log flushed up to   53089320472
Pages flushed up to 53089320472
Last checkpoint at  53089320403
0 pending log flushes, 0 pending chkp writes
618141 log i/o's done, 0.24 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 10684568
Buffer pool size   256864
Free buffers       8192
Database pages     246599
Old database pages 90865
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 17232554, not young 1389115303
11.21 youngs/s, 0.00 non-youngs/s
Pages read 15323240, created 12294, written 1819502
0.00 reads/s, 0.00 creates/s, 0.21 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: 246599, unzip_LRU len: 0
I/O sum[248]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32108
Free buffers       1024
Database pages     30841
Old database pages 11364
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 2150082, not young 177656138
1.97 youngs/s, 0.00 non-youngs/s
Pages read 1896382, created 1376, written 279947
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: 30841, unzip_LRU len: 0
I/O sum[31]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       1024
Database pages     30775
Old database pages 11340
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 2181262, not young 155904192
2.38 youngs/s, 0.00 non-youngs/s
Pages read 1723055, created 1799, written 256930
0.00 reads/s, 0.00 creates/s, 0.07 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: 30775, unzip_LRU len: 0
I/O sum[31]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       1024
Database pages     30816
Old database pages 11355
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 2174696, not young 182487467
0.69 youngs/s, 0.00 non-youngs/s
Pages read 1908106, created 1603, written 155283
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: 30816, unzip_LRU len: 0
I/O sum[31]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       1024
Database pages     30831
Old database pages 11360
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 2154107, not young 176687824
2.72 youngs/s, 0.00 non-youngs/s
Pages read 1982844, created 1283, written 371896
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: 30831, unzip_LRU len: 0
I/O sum[31]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       1024
Database pages     30846
Old database pages 11366
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 2078873, not young 186717905
0.62 youngs/s, 0.00 non-youngs/s
Pages read 2055831, created 2003, written 308031
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: 30846, unzip_LRU len: 0
I/O sum[31]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       1024
Database pages     30803
Old database pages 11350
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 2158745, not young 165114011
0.83 youngs/s, 0.00 non-youngs/s
Pages read 1886594, created 1431, written 133989
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: 30803, unzip_LRU len: 0
I/O sum[31]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32108
Free buffers       1024
Database pages     30822
Old database pages 11357
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 2193617, not young 159632894
1.03 youngs/s, 0.00 non-youngs/s
Pages read 1816406, created 1517, written 154838
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: 30822, unzip_LRU len: 0
I/O sum[31]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32108
Free buffers       1024
Database pages     30865
Old database pages 11373
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 2141172, not young 184914872
0.97 youngs/s, 0.00 non-youngs/s
Pages read 2054022, created 1282, written 158588
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: 30865, unzip_LRU len: 0
I/O sum[31]: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=10872, Main thread ID=3744, state: sleeping
Number of rows inserted 284054, updated 99491, deleted 36483, read 76915928774
0.03 inserts/s, 0.00 updates/s, 0.00 deletes/s, 172758.73 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 2773440
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================