Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2025-05-04 23:14:45 0x7f8d6c549700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 63 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 254661 srv_active, 0 srv_shutdown, 1787598 srv_idle
srv_master_thread log flush and writes: 2041678
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4414272
OS WAIT ARRAY INFO: signal count 2537178
RW-shared spins 0, rounds 868139, OS waits 180966
RW-excl spins 0, rounds 159641, OS waits 1157
RW-sx spins 1100, rounds 15478, OS waits 203
Spin rounds per wait: 868139.00 RW-shared, 159641.00 RW-excl, 14.07 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-05-04 21:18:43 0x7f8e680cd700 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 16858023
Purge done for trx's n:o < 16858023 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421724615664120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421724615685400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421724615681144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421724615676888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421724615672632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421724615668376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421724615659864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421724615655608, 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
68179 OS file reads, 3669417 OS file writes, 2777534 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.03 writes/s, 0.03 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 20, seg size 22, 263 merges
merged operations:
 insert 700, delete mark 351, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 78 buffer(s)
Hash table size 1106407, node heap has 80 buffer(s)
Hash table size 1106407, node heap has 286 buffer(s)
Hash table size 1106407, node heap has 33 buffer(s)
Hash table size 1106407, node heap has 6 buffer(s)
Hash table size 1106407, node heap has 236 buffer(s)
Hash table size 1106407, node heap has 95 buffer(s)
Hash table size 1106407, node heap has 169 buffer(s)
0.30 hash searches/s, 0.40 non-hash searches/s
---
LOG
---
Log sequence number 7026989009
Log flushed up to   7026988988
Pages flushed up to 7026986055
Last checkpoint at  7026986046
0 pending log flushes, 0 pending chkp writes
1115866 log i/o's done, 0.03 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 2642608
Buffer pool size   256480
Free buffers       185516
Database pages     69981
Old database pages 25673
Modified db pages  35
Percent of dirty pages(LRU & free pages): 0.014
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 347, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 67102, created 2879, written 1825929
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: 69981, 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   32060
Free buffers       22956
Database pages     8983
Old database pages 3297
Modified db pages  2
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 63, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8680, created 303, written 395848
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: 8983, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32060
Free buffers       23567
Database pages     8371
Old database pages 3070
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 49, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8110, created 261, written 48432
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: 8371, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32060
Free buffers       22990
Database pages     8950
Old database pages 3283
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 49, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8558, created 392, written 164947
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: 8950, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32060
Free buffers       23199
Database pages     8734
Old database pages 3204
Modified db pages  3
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 35, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8405, created 329, written 511460
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: 8734, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32060
Free buffers       22790
Database pages     9151
Old database pages 3359
Modified db pages  19
Percent of dirty pages(LRU & free pages): 0.059
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 29, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8796, created 355, written 303111
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: 9151, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32060
Free buffers       23305
Database pages     8639
Old database pages 3169
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 38, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8264, created 375, written 151702
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: 8639, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32060
Free buffers       23588
Database pages     8341
Old database pages 3059
Modified db pages  3
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 39, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 7881, created 460, written 112682
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: 8341, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32060
Free buffers       23121
Database pages     8812
Old database pages 3232
Modified db pages  2
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 45, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8408, created 404, written 137747
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: 8812, 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=1151, Main thread ID=140240771376896, state: sleeping
Number of rows inserted 245691, updated 252749, deleted 119602, read 26464888080
0.00 inserts/s, 0.03 updates/s, 0.00 deletes/s, 0.29 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 153105
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================