Speicher-Engines

InnoDB

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

[ Variablen | Puffer-Pool | InnoDB-Status ]

=====================================
2026-04-06 06:35:31 0x7f9e5d858700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 48 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2554251 srv_active, 0 srv_shutdown, 3008642 srv_idle
srv_master_thread log flush and writes: 5562041
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 21537237
OS WAIT ARRAY INFO: signal count 12836020
RW-shared spins 0, rounds 6832793, OS waits 1416526
RW-excl spins 0, rounds 1074710, OS waits 21853
RW-sx spins 1517, rounds 29908, OS waits 626
Spin rounds per wait: 6832793.00 RW-shared, 1074710.00 RW-excl, 19.72 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-04-06 05:22:01 0x7fa0404ea700 Error in foreign key constraint of table sikbackup/detail_piutang_pasien:
there is no index in the table which would contain
the columns as the first columns, or the data types in the
table do not match the ones in the referenced table
or one of the ON ... SET NULL columns is declared NOT NULL. Constraint:
,
  CONSTRAINT `detail_piutang_pasien_ibfk_5` FOREIGN KEY (`no_rawat`) REFERENCES `reg_periksa` (`no_rawat`) ON UPDATE CASCADE
------------------------
LATEST DETECTED DEADLOCK
------------------------
2026-03-29 10:31:56 0x7f9e5d7c2700
*** (1) TRANSACTION:
TRANSACTION 308458172, ACTIVE 0 sec starting index read
mysql tables in use 435, locked 435
LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
MySQL thread id 51391003, OS thread handle 140326249776896, query id 1090079755 192.168.123.29 root Updating
update reg_periksa set stts='Sudah' where no_rawat='2026/03/29/000047'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 620 page no 4290 n bits 120 index PRIMARY of table `sik`.`reg_periksa` trx id 308458172 lock_mode X locks rec but not gap waiting
Record lock, heap no 54 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
 0: len 17; hex 323032362f30332f32392f303030303437; asc 2026/03/29/000047;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 303335; asc 035;;
 4: len 3; hex 8fd47d; asc   };;
 5: len 3; hex 809b09; asc    ;;
 6: len 8; hex 4430303030303033; asc D0000003;;
 7: len 6; hex 303734313533; asc 074153;;
 8: len 5; hex 5530303135; asc U0015;;
 9: len 1; hex 2d; asc -;;
 10: len 30; hex 4b414c494241474f5220322f32204b4542554d454e2c204b414c49424147; asc KALIBAGOR 2/2 KEBUMEN, KALIBAG; (total 55 bytes);
 11: len 12; hex 444952492053454e44495249; asc DIRI SENDIRI;;
 12: len 8; hex 0000000000000000; asc         ;;
 13: len 1; hex 04; asc  ;;
 14: len 1; hex 02; asc  ;;
 15: len 1; hex 01; asc  ;;
 16: len 3; hex 413635; asc A65;;
 17: len 4; hex 80000048; asc    H;;
 18: len 1; hex 01; asc  ;;
 19: len 1; hex 02; asc  ;;
 20: len 1; hex 01; asc  ;;

*** (2) TRANSACTION:
TRANSACTION 308458171, ACTIVE 0 sec starting index read
mysql tables in use 435, locked 435
17 lock struct(s), heap size 1136, 8 row lock(s), undo log entries 27
MySQL thread id 51436136, OS thread handle 140318149977856, query id 1090079779 192.168.123.36 root Updating
update reg_periksa set status_bayar='Sudah Bayar' where no_rawat='2026/03/29/000047'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 620 page no 4290 n bits 120 index PRIMARY of table `sik`.`reg_periksa` trx id 308458171 lock mode S locks rec but not gap
Record lock, heap no 54 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
 0: len 17; hex 323032362f30332f32392f303030303437; asc 2026/03/29/000047;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 303335; asc 035;;
 4: len 3; hex 8fd47d; asc   };;
 5: len 3; hex 809b09; asc    ;;
 6: len 8; hex 4430303030303033; asc D0000003;;
 7: len 6; hex 303734313533; asc 074153;;
 8: len 5; hex 5530303135; asc U0015;;
 9: len 1; hex 2d; asc -;;
 10: len 30; hex 4b414c494241474f5220322f32204b4542554d454e2c204b414c49424147; asc KALIBAGOR 2/2 KEBUMEN, KALIBAG; (total 55 bytes);
 11: len 12; hex 444952492053454e44495249; asc DIRI SENDIRI;;
 12: len 8; hex 0000000000000000; asc         ;;
 13: len 1; hex 04; asc  ;;
 14: len 1; hex 02; asc  ;;
 15: len 1; hex 01; asc  ;;
 16: len 3; hex 413635; asc A65;;
 17: len 4; hex 80000048; asc    H;;
 18: len 1; hex 01; asc  ;;
 19: len 1; hex 02; asc  ;;
 20: len 1; hex 01; asc  ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 620 page no 4290 n bits 120 index PRIMARY of table `sik`.`reg_periksa` trx id 308458171 lock_mode X locks rec but not gap waiting
Record lock, heap no 54 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
 0: len 17; hex 323032362f30332f32392f303030303437; asc 2026/03/29/000047;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 303335; asc 035;;
 4: len 3; hex 8fd47d; asc   };;
 5: len 3; hex 809b09; asc    ;;
 6: len 8; hex 4430303030303033; asc D0000003;;
 7: len 6; hex 303734313533; asc 074153;;
 8: len 5; hex 5530303135; asc U0015;;
 9: len 1; hex 2d; asc -;;
 10: len 30; hex 4b414c494241474f5220322f32204b4542554d454e2c204b414c49424147; asc KALIBAGOR 2/2 KEBUMEN, KALIBAG; (total 55 bytes);
 11: len 12; hex 444952492053454e44495249; asc DIRI SENDIRI;;
 12: len 8; hex 0000000000000000; asc         ;;
 13: len 1; hex 04; asc  ;;
 14: len 1; hex 02; asc  ;;
 15: len 1; hex 01; asc  ;;
 16: len 3; hex 413635; asc A65;;
 17: len 4; hex 80000048; asc    H;;
 18: len 1; hex 01; asc  ;;
 19: len 1; hex 02; asc  ;;
 20: len 1; hex 01; asc  ;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 315170093
Purge done for trx's n:o < 315170093 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421803186160120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186155864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421803186151608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (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
109044 OS file reads, 36571699 OS file writes, 24220790 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 21.56 writes/s, 8.92 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 977 merges
merged operations:
 insert 1132, delete mark 194, delete 119
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 33 buffer(s)
Hash table size 1593833, node heap has 448 buffer(s)
Hash table size 1593833, node heap has 1225 buffer(s)
Hash table size 1593833, node heap has 153 buffer(s)
Hash table size 1593833, node heap has 79 buffer(s)
Hash table size 1593833, node heap has 204 buffer(s)
Hash table size 1593833, node heap has 463 buffer(s)
Hash table size 1593833, node heap has 275 buffer(s)
274.02 hash searches/s, 139.39 non-hash searches/s
---
LOG
---
Log sequence number 35552747320
Log flushed up to   35552746733
Pages flushed up to 35552730984
Last checkpoint at  35552729829
0 pending log flushes, 0 pending chkp writes
12111036 log i/o's done, 7.10 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8109520
Buffer pool size   384720
Free buffers       268443
Database pages     113397
Old database pages 41698
Modified db pages  33
Percent of dirty pages(LRU & free pages): 0.009
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 682, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 106005, created 7392, written 19051235
0.00 reads/s, 0.00 creates/s, 13.60 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: 113397, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   48090
Free buffers       33619
Database pages     14117
Old database pages 5191
Modified db pages  15
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 60, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13155, created 962, written 4789520
0.00 reads/s, 0.00 creates/s, 1.17 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: 14117, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   48090
Free buffers       33192
Database pages     14553
Old database pages 5352
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 118, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13686, created 867, written 197465
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: 14553, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   48090
Free buffers       33850
Database pages     13884
Old database pages 5105
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 57, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13051, created 833, written 1060783
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: 13884, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   48090
Free buffers       33283
Database pages     14453
Old database pages 5315
Modified db pages  3
Percent of dirty pages(LRU & free pages): 0.006
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 75, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13343, created 1110, written 5925436
0.00 reads/s, 0.00 creates/s, 3.92 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: 14453, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   48090
Free buffers       32716
Database pages     15011
Old database pages 5521
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 98, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14222, created 789, written 3750267
0.00 reads/s, 0.00 creates/s, 2.48 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: 15011, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   48090
Free buffers       33506
Database pages     14212
Old database pages 5226
Modified db pages  8
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 92, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13365, created 847, written 1345940
0.00 reads/s, 0.00 creates/s, 2.92 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: 14212, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   48090
Free buffers       34488
Database pages     13233
Old database pages 4865
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 102, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12288, created 945, written 738526
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: 13233, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   48090
Free buffers       33789
Database pages     13934
Old database pages 5123
Modified db pages  7
Percent of dirty pages(LRU & free pages): 0.015
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 80, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12895, created 1039, written 1243298
0.00 reads/s, 0.00 creates/s, 3.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: 13934, unzip_LRU len: 0
I/O sum[0]: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=1110, Main thread ID=140319504148224, state: sleeping
Number of rows inserted 1110423, updated 4953961, deleted 717020, read 118735443130
0.00 inserts/s, 5.92 updates/s, 0.00 deletes/s, 169.25 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 12549236
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================