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-15 09:33:27 0x7f5e644bf700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 53 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 262226 srv_active, 0 srv_shutdown, 346916 srv_idle
srv_master_thread log flush and writes: 609137
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1532405
OS WAIT ARRAY INFO: signal count 964455
RW-shared spins 0, rounds 641397, OS waits 217318
RW-excl spins 0, rounds 91783, OS waits 1767
RW-sx spins 298, rounds 4851, OS waits 75
Spin rounds per wait: 641397.00 RW-shared, 91783.00 RW-excl, 16.28 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-12-15 09:16:45 0x7f5e441d7700 Transaction:
TRANSACTION 157531917, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 1 row lock(s)
MySQL thread id 5413697, OS thread handle 140042846435072, query id 98820429 192.168.123.31 root Update
insert into telaah_farmasi values('202512150014','Ya','','Ya','','Ya','','Ya','','Ya','','Tidak','','Tidak','','Tidak','','Ya','Ya','Ya','Ya','Ya','202204036')
Foreign key constraint fails for table `sik`.`telaah_farmasi`:
,
CONSTRAINT `telaah_farmasi_ibfk_1` FOREIGN KEY (`no_resep`) REFERENCES `resep_obat` (`no_resep`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index PRIMARY tuple:
DATA TUPLE: 25 fields;
0: len 12; hex 323032353132313530303134; asc 202512150014;;
1: len 6; hex 00000963bf0d; asc c ;;
2: len 7; hex 80000000000000; asc ;;
3: len 1; hex 01; asc ;;
4: len 0; hex ; asc ;;
5: len 1; hex 01; asc ;;
6: len 0; hex ; asc ;;
7: len 1; hex 01; asc ;;
8: len 0; hex ; asc ;;
9: len 1; hex 01; asc ;;
10: len 0; hex ; asc ;;
11: len 1; hex 01; asc ;;
12: len 0; hex ; asc ;;
13: len 1; hex 02; asc ;;
14: len 0; hex ; asc ;;
15: len 1; hex 02; asc ;;
16: len 0; hex ; asc ;;
17: len 1; hex 02; asc ;;
18: len 0; hex ; asc ;;
19: len 1; hex 01; asc ;;
20: len 1; hex 01; asc ;;
21: len 1; hex 01; asc ;;
22: len 1; hex 01; asc ;;
23: len 1; hex 01; asc ;;
24: len 9; hex 323032323034303336; asc 202204036;;
But in parent table `sik`.`resep_obat`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 12; compact format; info bits 0
0: len 12; hex 323032353132313530303133; asc 202512150013;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 3; hex 8fd38f; asc ;;
4: len 3; hex 80940b; asc ;;
5: len 17; hex 323032352f31322f31352f303030303730; asc 2025/12/15/000070;;
6: len 8; hex 4430303030303031; asc D0000001;;
7: len 3; hex 8fd38f; asc ;;
8: len 3; hex 8093f2; asc ;;
9: len 1; hex 01; asc ;;
10: len 3; hex 800000; asc ;;
11: len 3; hex 800000; asc ;;
------------
TRANSACTIONS
------------
Trx id counter 157541695
Purge done for trx's n:o < 157541695 undo n:o < 0 state: running but idle
History list length 5
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421525760367928, 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 421525760359416, not started
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 421525760287064, 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 421525760338136, 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 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 421525760321112, 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 421525760316856, 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 421525760308344, 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 421525760299832, 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: 0; buffer pool: 0
102121 OS file reads, 3766083 OS file writes, 2659234 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 6.77 writes/s, 5.25 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 463 merges
merged operations:
insert 606, delete mark 21, delete 1
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1593833, node heap has 28 buffer(s)
Hash table size 1593833, node heap has 369 buffer(s)
Hash table size 1593833, node heap has 651 buffer(s)
Hash table size 1593833, node heap has 49 buffer(s)
Hash table size 1593833, node heap has 25 buffer(s)
Hash table size 1593833, node heap has 268 buffer(s)
Hash table size 1593833, node heap has 234 buffer(s)
Hash table size 1593833, node heap has 219 buffer(s)
21583.33 hash searches/s, 340.77 non-hash searches/s
---
LOG
---
Log sequence number 24607286952
Log flushed up to 24607286931
Pages flushed up to 24607281958
Last checkpoint at 24607281949
0 pending log flushes, 0 pending chkp writes
1249690 log i/o's done, 2.23 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6610223104
Dictionary memory allocated 8106848
Buffer pool size 384720
Free buffers 282864
Database pages 100013
Old database pages 37065
Modified db pages 9
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 219, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 99083, created 930, written 1888218
0.00 reads/s, 0.00 creates/s, 3.15 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: 100013, 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 35402
Database pages 12452
Old database pages 4616
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.002
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 12352, created 100, written 515966
0.00 reads/s, 0.00 creates/s, 0.79 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: 12452, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 48090
Free buffers 34802
Database pages 13061
Old database pages 4840
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 33, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13014, created 47, written 23284
0.00 reads/s, 0.00 creates/s, 0.06 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: 13061, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 48090
Free buffers 35431
Database pages 12433
Old database pages 4607
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 19, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12342, created 91, written 92495
0.00 reads/s, 0.00 creates/s, 0.04 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: 12433, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 48090
Free buffers 35247
Database pages 12612
Old database pages 4674
Modified db pages 6
Percent of dirty pages(LRU & free pages): 0.013
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 27, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12534, created 78, written 562382
0.00 reads/s, 0.00 creates/s, 1.49 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: 12612, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 48090
Free buffers 34583
Database pages 13276
Old database pages 4919
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 18, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 13101, created 175, written 352981
0.00 reads/s, 0.00 creates/s, 0.21 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: 13276, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 48090
Free buffers 35328
Database pages 12531
Old database pages 4643
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 12407, created 124, written 131853
0.00 reads/s, 0.00 creates/s, 0.08 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: 12531, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 48090
Free buffers 36423
Database pages 11433
Old database pages 4240
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 40, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11272, created 161, written 80406
0.00 reads/s, 0.00 creates/s, 0.04 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: 11433, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 48090
Free buffers 35648
Database pages 12215
Old database pages 4526
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.002
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 12061, created 154, written 128851
0.00 reads/s, 0.00 creates/s, 0.45 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: 12215, 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 114088, updated 395299, deleted 69383, read 9069287266
0.06 inserts/s, 0.66 updates/s, 0.00 deletes/s, 32965.76 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 432074
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================