Consola
Motores de almacenamiento
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Reserva de búfers | Estado del InnoDB ]
=====================================
2025-12-18 13:50:45 0x7f5e2f8f7700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 22 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 463857 srv_active, 0 srv_shutdown, 418845 srv_idle
srv_master_thread log flush and writes: 882695
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2885421
OS WAIT ARRAY INFO: signal count 1749998
RW-shared spins 0, rounds 925359, OS waits 300713
RW-excl spins 0, rounds 160183, OS waits 3173
RW-sx spins 488, rounds 8456, OS waits 136
Spin rounds per wait: 925359.00 RW-shared, 160183.00 RW-excl, 17.33 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-12-18 12:15:49 0x7f5e2fd11700 Transaction:
TRANSACTION 172167522, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 8271333, OS thread handle 140042505885440, query id 151230711 192.168.123.60 root Update
insert into rujuk_masuk values('2025/12/18/000069','dr. Uskar Yulinanto','-','0145U0521125Y000215','0','dr. Uskar Yulinanto','Z09.8','-','-','')
Foreign key constraint fails for table `sik`.`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 5a30392e38; asc Z09.8;;
1: len 17; hex 323032352f31322f31382f303030303639; asc 2025/12/18/000069;;
But in parent table `sik`.`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 5a3130; asc Z10;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 30; hex 526f7574696e652067656e6572616c206865616c746820636865636b2d75; asc Routine general health check-u; (total 63 bytes);
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 172490551
Purge done for trx's n:o < 172490551 undo n:o < 0 state: running but idle
History list length 12
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421525760384952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760380696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760376440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760372184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760363672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760342392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760367928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760299832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760359416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760325368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760350904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760346648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760321112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760316856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760287064, not started flushing log
mysql tables in use 1, locked 1
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760355160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760338136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760333880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760329624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760308344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760312600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760304088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760295576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760291320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421525760282808, 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: 1; buffer pool: 0
102514 OS file reads, 6607795 OS file writes, 4413554 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 11.73 writes/s, 11.73 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 531 merges
merged operations:
insert 664, delete mark 37, delete 1
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 29 buffer(s)
Hash table size 1593833, node heap has 402 buffer(s)
Hash table size 1593833, node heap has 744 buffer(s)
Hash table size 1593833, node heap has 51 buffer(s)
Hash table size 1593833, node heap has 42 buffer(s)
Hash table size 1593833, node heap has 270 buffer(s)
Hash table size 1593833, node heap has 348 buffer(s)
Hash table size 1593833, node heap has 233 buffer(s)
55.82 hash searches/s, 253.22 non-hash searches/s
---
LOG
---
Log sequence number 25203043374
Log flushed up to 25203043120
Pages flushed up to 25202886843
Last checkpoint at 25202886843
1 pending log flushes, 0 pending chkp writes
2195920 log i/o's done, 11.73 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8106848
Buffer pool size 384720
Free buffers 281685
Database pages 100916
Old database pages 37345
Modified db pages 259
Percent of dirty pages(LRU & free pages): 0.068
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 291, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 99476, created 1440, written 3429125
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: 100916, 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 35215
Database pages 12605
Old database pages 4668
Modified db pages 21
Percent of dirty pages(LRU & free pages): 0.044
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 43, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12428, created 177, written 898334
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: 12605, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 48090
Free buffers 34703
Database pages 13125
Old database pages 4860
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 44, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13053, created 72, written 37539
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: 13125, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 48090
Free buffers 35301
Database pages 12527
Old database pages 4640
Modified db pages 4
Percent of dirty pages(LRU & free pages): 0.008
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 21, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12377, created 150, written 169535
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: 12527, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 48090
Free buffers 35127
Database pages 12697
Old database pages 4703
Modified db pages 108
Percent of dirty pages(LRU & free pages): 0.226
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 33, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12579, created 118, written 1046123
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: 12697, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 48090
Free buffers 34462
Database pages 13361
Old database pages 4943
Modified db pages 45
Percent of dirty pages(LRU & free pages): 0.094
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 13135, created 226, written 656218
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: 13361, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 48090
Free buffers 35164
Database pages 12662
Old database pages 4674
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 44, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12454, created 208, written 242273
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: 12662, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 48090
Free buffers 36257
Database pages 11564
Old database pages 4287
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 46, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11337, created 227, written 145311
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: 11564, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 48090
Free buffers 35456
Database pages 12375
Old database pages 4570
Modified db pages 22
Percent of dirty pages(LRU & free pages): 0.046
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 32, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12113, created 262, written 233792
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: 12375, 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=1258, Main thread ID=140043963188992, state: sleeping
Number of rows inserted 213596, updated 825965, deleted 138014, read 14400407798
4.73 inserts/s, 1.36 updates/s, 4.68 deletes/s, 108.45 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 2635592
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================