存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
变量
|
缓冲池
|
InnoDB 状态
]
=====================================
2025-12-06 16:41:30 0x3320 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 4 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 247170 srv_active, 0 srv_shutdown, 382781 srv_idle
srv_master_thread log flush and writes: 629951
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 387765
OS WAIT ARRAY INFO: signal count 5680832
RW-shared spins 8713406, rounds 19208956, OS waits 230420
RW-excl spins 360951, rounds 1312724, OS waits 11473
RW-sx spins 1575, rounds 39291, OS waits 984
Spin rounds per wait: 2.20 RW-shared, 3.64 RW-excl, 24.95 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-12-06 15:30:07 0x16e4 Transaction:
TRANSACTION 18396028, 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 9696783, OS thread handle 5860, query id 54246236 192.168.2.77 root Update
insert into timeout_sebelum_insisi values('2025/12/06/000375','2025-12-06 15:29:07','-','REMOVE IMPLANT','160515283','160515283','Ya','Ya','Ya','Ada','','Ditayangkan','Tidak Diperlukan','Tidak Diperlukan','Ya','','','','Ada','','2025-12-06','Ya','Ya','')
Foreign key constraint fails for table `mesrabaru01`.`timeout_sebelum_insisi`:
,
CONSTRAINT `timeout_sebelum_insisi_ibfk_2` FOREIGN KEY (`nip_perawat_ok`) REFERENCES `petugas` (`nip`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index nip_perawat_ok tuple:
DATA TUPLE: 3 fields;
0: len 0; hex ; asc ;;
1: len 17; hex 323032352f31322f30362f303030333735; asc 2025/12/06/000375;;
2: len 5; hex 99b84cf747; asc L G;;
But in parent table `mesrabaru01`.`petugas`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 15; compact format; info bits 0
0: len 1; hex 2d; asc -;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 19; hex 4e732e4d2e20414c46414e44492c532e4b6570; asc Ns.M. ALFANDI,S.Kep;;
4: len 1; hex 01; asc ;;
5: len 12; hex 54414e4a554e47204c4f4c4f; asc TANJUNG LOLO;;
6: len 3; hex 8f9842; asc B;;
7: len 1; hex 01; asc ;;
8: len 5; hex 49534c414d; asc ISLAM;;
9: len 1; hex 01; asc ;;
10: len 14; hex 4a4c2e5041534952205055544948; asc JL.PASIR PUTIH;;
11: len 4; hex 4a303033; asc J003;;
12: len 12; hex 303835323732343538333037; asc 085272458307;;
13: len 0; hex ; asc ;;
14: len 1; hex 01; asc ;;
------------
TRANSACTIONS
------------
Trx id counter 18539262
Purge done for trx's n:o < 18539262 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 282833099032400, 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 282833098978216, 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 282833099024064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282833099040736, 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 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 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 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 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 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
15333827 OS file reads, 3061503 OS file writes, 2074713 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 20.99 writes/s, 7.25 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 24, seg size 26, 113123 merges
merged operations:
insert 143931, delete mark 26651, delete 12480
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 52 buffer(s)
Hash table size 1106407, node heap has 723 buffer(s)
Hash table size 1106407, node heap has 141 buffer(s)
Hash table size 1106407, node heap has 20 buffer(s)
Hash table size 1106407, node heap has 325 buffer(s)
Hash table size 1106407, node heap has 691 buffer(s)
Hash table size 1106407, node heap has 134 buffer(s)
Hash table size 1106407, node heap has 62 buffer(s)
1486.88 hash searches/s, 478.88 non-hash searches/s
---
LOG
---
Log sequence number 53101123345
Log flushed up to 53101122869
Pages flushed up to 53101086898
Last checkpoint at 53101059707
0 pending log flushes, 0 pending chkp writes
632376 log i/o's done, 4.50 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 11320584
Buffer pool size 256864
Free buffers 8192
Database pages 246524
Old database pages 90839
Modified db pages 43
Percent of dirty pages(LRU & free pages): 0.017
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 17245449, not young 1389229096
0.75 youngs/s, 0.00 non-youngs/s
Pages read 15329251, created 12515, written 1860936
0.00 reads/s, 0.00 creates/s, 15.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: 246524, unzip_LRU len: 0
I/O sum[5120]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 32108
Free buffers 1024
Database pages 30833
Old database pages 11361
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 2151553, not young 177667066
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1897054, created 1457, written 286612
0.00 reads/s, 0.00 creates/s, 0.50 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: 30833, unzip_LRU len: 0
I/O sum[640]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 32108
Free buffers 1024
Database pages 30764
Old database pages 11336
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 2183000, not young 155915651
0.75 youngs/s, 0.00 non-youngs/s
Pages read 1723850, created 1807, written 261347
0.00 reads/s, 0.00 creates/s, 2.00 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: 30764, unzip_LRU len: 0
I/O sum[640]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 32108
Free buffers 1024
Database pages 30804
Old database pages 11351
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 2176073, not young 182509810
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1908911, created 1631, written 158398
0.00 reads/s, 0.00 creates/s, 0.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: 30804, unzip_LRU len: 0
I/O sum[640]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 32108
Free buffers 1024
Database pages 30823
Old database pages 11358
Modified db pages 17
Percent of dirty pages(LRU & free pages): 0.053
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2155696, not young 176702409
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1983595, created 1295, written 382126
0.00 reads/s, 0.00 creates/s, 6.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: 30823, unzip_LRU len: 0
I/O sum[640]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 32108
Free buffers 1024
Database pages 30836
Old database pages 11362
Modified db pages 21
Percent of dirty pages(LRU & free pages): 0.066
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2080513, not young 186730961
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2056641, created 2009, written 316846
0.00 reads/s, 0.00 creates/s, 6.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: 30836, unzip_LRU len: 0
I/O sum[640]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 32108
Free buffers 1024
Database pages 30792
Old database pages 11346
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 2160496, not young 165127888
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1887298, created 1499, written 137190
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: 30792, unzip_LRU len: 0
I/O sum[640]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
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 2195280, not young 159645969
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1817005, created 1529, written 157789
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[640]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 32108
Free buffers 1024
Database pages 30856
Old database pages 11370
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 2142838, not young 184929342
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2054897, created 1288, written 160628
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: 30856, unzip_LRU len: 0
I/O sum[640]: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 287210, updated 107202, deleted 36695, read 78010073182
0.00 inserts/s, 3.75 updates/s, 0.00 deletes/s, 149102.22 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 2885425
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
