Storage engines

InnoDB

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

[ Variabel | Penampungan Penyangga | Status InnoDB ]

=====================================
2025-12-06 15:37:19 0x7fd6ac3fa700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 59 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 228973 srv_active, 0 srv_shutdown, 567860 srv_idle
srv_master_thread log flush and writes: 796620
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2514111
OS WAIT ARRAY INFO: signal count 1436840
RW-shared spins 0, rounds 602766, OS waits 162472
RW-excl spins 0, rounds 89725, OS waits 1127
RW-sx spins 204, rounds 3616, OS waits 67
Spin rounds per wait: 602766.00 RW-shared, 89725.00 RW-excl, 17.73 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-12-06 15:09:22 0x7fd8c0443700 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
------------
TRANSACTIONS
------------
Trx id counter 137346826
Purge done for trx's n:o < 137346826 undo n:o < 0 state: running but idle
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422043910108760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910104504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910095992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910083224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910113016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910142808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910125784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910117272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910121528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910091736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910100248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910078968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910087480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910074712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422043910070456, 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
100677 OS file reads, 3283807 OS file writes, 2347748 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 13.59 writes/s, 9.37 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 403 merges
merged operations:
 insert 567, delete mark 6, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 11 buffer(s)
Hash table size 1593833, node heap has 363 buffer(s)
Hash table size 1593833, node heap has 684 buffer(s)
Hash table size 1593833, node heap has 46 buffer(s)
Hash table size 1593833, node heap has 17 buffer(s)
Hash table size 1593833, node heap has 248 buffer(s)
Hash table size 1593833, node heap has 236 buffer(s)
Hash table size 1593833, node heap has 222 buffer(s)
10992.46 hash searches/s, 313.99 non-hash searches/s
---
LOG
---
Log sequence number 23771510046
Log flushed up to   23771510025
Pages flushed up to 23771343285
Last checkpoint at  23771343285
0 pending log flushes, 0 pending chkp writes
1158410 log i/o's done, 8.66 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8106848
Buffer pool size   384720
Free buffers       284055
Database pages     98838
Old database pages 36565
Modified db pages  193
Percent of dirty pages(LRU & free pages): 0.050
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 196, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 97613, created 1225, written 1606358
0.00 reads/s, 0.00 creates/s, 4.59 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: 98838, 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       35546
Database pages     12312
Old database pages 4563
Modified db pages  48
Percent of dirty pages(LRU & free pages): 0.100
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 24, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12151, created 161, written 410675
0.00 reads/s, 0.00 creates/s, 0.97 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: 12312, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   48090
Free buffers       35212
Database pages     12651
Old database pages 4658
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 28, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12443, created 208, written 33354
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: 12651, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   48090
Free buffers       35566
Database pages     12305
Old database pages 4561
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.004
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 14, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12221, created 84, written 80106
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: 12305, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   48090
Free buffers       35322
Database pages     12544
Old database pages 4647
Modified db pages  57
Percent of dirty pages(LRU & free pages): 0.119
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 22, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12455, created 89, written 465686
0.00 reads/s, 0.00 creates/s, 1.88 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: 12544, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   48090
Free buffers       34886
Database pages     12977
Old database pages 4809
Modified db pages  47
Percent of dirty pages(LRU & free pages): 0.098
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 17, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12900, created 77, written 295340
0.00 reads/s, 0.00 creates/s, 0.95 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: 12977, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   48090
Free buffers       35443
Database pages     12413
Old database pages 4593
Modified db pages  39
Percent of dirty pages(LRU & free pages): 0.081
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 30, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12295, created 118, written 120525
0.00 reads/s, 0.00 creates/s, 0.68 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: 12413, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   48090
Free buffers       36412
Database pages     11447
Old database pages 4239
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 37, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11210, created 237, written 82519
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: 11447, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   48090
Free buffers       35668
Database pages     12189
Old database pages 4495
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 24, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11938, created 251, written 118153
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: 12189, 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=1272, Main thread ID=140560190072576, state: sleeping
Number of rows inserted 223670, updated 264713, deleted 159995, read 12796699095
0.00 inserts/s, 7.63 updates/s, 0.00 deletes/s, 11845.71 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 2087400
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 51.66 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================