存储引擎

InnoDB

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

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

=====================================
2025-07-02 20:36:59 0x2a74 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 18 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 15614 srv_active, 0 srv_shutdown, 28946 srv_idle
srv_master_thread log flush and writes: 44560
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 73691
OS WAIT ARRAY INFO: signal count 62790
RW-shared spins 116566, rounds 507425, OS waits 11774
RW-excl spins 18728, rounds 143584, OS waits 2672
RW-sx spins 277, rounds 5026, OS waits 132
Spin rounds per wait: 4.35 RW-shared, 7.67 RW-excl, 18.14 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-07-02 17:09:08 0x1434 Transaction:
TRANSACTION 3793241, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1
MySQL thread id 8463, OS thread handle 5172, query id 3938542 DESKTOP-J2OHHFH 192.168.2.28 root Update
insert into rujuk_masuk values('2025/07/02/000154','Klinik Fellita','-','0069B0310725Y000028','0','Klinik Fellita','Z32.0','-','-','')
Foreign key constraint fails for table `mesrabaru`.`rujuk_masuk`:
,
  CONSTRAINT `rujuk_masuk_ibfk_2` FOREIGN KEY (`kd_penyakit`) REFERENCES `penyakit` (`kd_penyakit`) ON UPDATE CASCADE in parent table, in index kd_penyakit tuple:
DATA TUPLE: 2 fields;
 0: len 5; hex 5a33322e30; asc Z32.0;;
 1: len 17; hex 323032352f30372f30322f303030313534; asc 2025/07/02/000154;;

But in parent table `mesrabaru`.`penyakit`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 3; hex 5a3333; asc Z33;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 26; hex 507265676e616e742073746174652c20696e636964656e74616c; asc Pregnant state, incidental;;
 4: len 1; hex 2d; asc -;;
 5: len 1; hex 2d; asc -;;
 6: len 1; hex 2d; asc -;;
 7: len 1; hex 02; asc  ;;

------------
TRANSACTIONS
------------
Trx id counter 3801797
Purge done for trx's n:o < 3801797 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283814739904912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739900744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739825720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739892408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739888240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739871568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739867400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739804880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739850728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739784040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739846560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739942424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739771536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739834056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739921584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739796544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739909080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739950760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739800712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739913248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739859064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739863232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739875736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739896576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739884072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739879904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739842392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739854896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739838224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739829888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739821552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739817384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739813216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739775704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739792376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739788208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739779872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739809048, 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
295494 OS file reads, 267308 OS file writes, 167194 OS fsyncs
0.17 reads/s, 16384 avg bytes/read, 13.28 writes/s, 7.78 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 24, seg size 26, 8697 merges
merged operations:
 insert 10409, delete mark 15021, delete 12676
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 861 buffer(s)
Hash table size 1106407, node heap has 169 buffer(s)
Hash table size 1106407, node heap has 12 buffer(s)
Hash table size 1106407, node heap has 68 buffer(s)
Hash table size 1106407, node heap has 169 buffer(s)
Hash table size 1106407, node heap has 556 buffer(s)
Hash table size 1106407, node heap has 37 buffer(s)
Hash table size 1106407, node heap has 105 buffer(s)
27993.94 hash searches/s, 322.15 non-hash searches/s
---
LOG
---
Log sequence number 10675841347
Log flushed up to   10675841347
Pages flushed up to 10675841347
Last checkpoint at  10675841250
0 pending log flushes, 0 pending chkp writes
47760 log i/o's done, 2.83 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 2511512
Buffer pool size   256864
Free buffers       8192
Database pages     246695
Old database pages 90901
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 7675, not young 3021810
26.22 youngs/s, 1.33 non-youngs/s
Pages read 294486, created 1318, written 175797
0.17 reads/s, 0.00 creates/s, 8.17 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: 246695, unzip_LRU len: 0
I/O sum[4920]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32108
Free buffers       1024
Database pages     30826
Old database pages 11359
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 964, not young 378108
1.33 youngs/s, 0.00 non-youngs/s
Pages read 36403, created 176, written 22858
0.00 reads/s, 0.00 creates/s, 1.61 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: 30826, unzip_LRU len: 0
I/O sum[615]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       1024
Database pages     30836
Old database pages 11362
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 892, not young 409175
3.33 youngs/s, 0.00 non-youngs/s
Pages read 38141, created 76, written 16762
0.00 reads/s, 0.00 creates/s, 0.06 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: 30836, unzip_LRU len: 0
I/O sum[615]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       1024
Database pages     30834
Old database pages 11362
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 907, not young 395623
2.56 youngs/s, 0.00 non-youngs/s
Pages read 36841, created 196, written 17339
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: 30834, unzip_LRU len: 0
I/O sum[615]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       1024
Database pages     30808
Old database pages 11352
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 956, not young 408641
3.89 youngs/s, 1.06 non-youngs/s
Pages read 36910, created 124, written 30853
0.06 reads/s, 0.00 creates/s, 2.50 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: 30808, unzip_LRU len: 0
I/O sum[615]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       1024
Database pages     30862
Old database pages 11372
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 1142, not young 387269
3.94 youngs/s, 0.28 non-youngs/s
Pages read 37437, created 180, written 28959
0.11 reads/s, 0.00 creates/s, 1.44 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: 30862, unzip_LRU len: 0
I/O sum[615]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       1024
Database pages     30852
Old database pages 11368
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 963, not young 279515
3.78 youngs/s, 0.00 non-youngs/s
Pages read 35636, created 169, written 18022
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: 30852, unzip_LRU len: 0
I/O sum[615]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32108
Free buffers       1024
Database pages     30855
Old database pages 11369
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 960, not young 373627
3.72 youngs/s, 0.00 non-youngs/s
Pages read 36618, created 230, written 23709
0.00 reads/s, 0.00 creates/s, 2.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: 30855, unzip_LRU len: 0
I/O sum[615]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
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 891, not young 389852
3.67 youngs/s, 0.00 non-youngs/s
Pages read 36500, created 167, written 17295
0.00 reads/s, 0.00 creates/s, 0.06 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[615]: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=11420, Main thread ID=4512, state: sleeping
Number of rows inserted 49065, updated 3581, deleted 4606, read 6929997394
1.06 inserts/s, 0.00 updates/s, 0.44 deletes/s, 104130.88 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================