Motores de almacenamiento

InnoDB

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

[ Variables | Reserva de búfers | Estado del InnoDB ]

=====================================
2026-08-10 12:33:59 0x2cbc INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 52 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1023621 srv_active, 0 srv_shutdown, 2827413 srv_idle
srv_master_thread log flush and writes: 3851030
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 20440036
OS WAIT ARRAY INFO: signal count 10435523
RW-shared spins 27026732, rounds 480059509, OS waits 9214544
RW-excl spins 7635236, rounds 20979255, OS waits 270599
RW-sx spins 154616, rounds 1848200, OS waits 38577
Spin rounds per wait: 17.76 RW-shared, 2.75 RW-excl, 11.95 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-07-28 11:01:15 0x6428 Transaction:
TRANSACTION 1764545159, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3
MySQL thread id 2129559, OS thread handle 25640, query id 31109221 localhost 127.0.0.1 root Updating
DELETE FROM `sistema_ventas`.`catalogo_links`
Foreign key constraint fails for table `sistema_ventas`.`catalogo_link_usos`:
,
  CONSTRAINT `fk_link_usos_link` FOREIGN KEY (`link_id`) REFERENCES `catalogo_links` (`id`)
Trying to delete or update in parent table, in index PRIMARY tuple:
DATA TUPLE: 11 fields;
 0: len 4; hex 80000003; asc     ;;
 1: len 6; hex 0000692cd287; asc   i,  ;;
 2: len 7; hex 19000001762607; asc     v& ;;
 3: len 5; hex 43414c4f58; asc CALOX;;
 4: len 3; hex 333137; asc 317;;
 5: len 19; hex 43414c4f5820494e5445524e4154494f4e414c; asc CALOX INTERNATIONAL;;
 6: SQL NULL;
 7: len 1; hex 81; asc  ;;
 8: len 5; hex 99ba78a94d; asc   x M;;
 9: len 5; hex 99bab6a94d; asc     M;;
 10: SQL NULL;

But in child table `sistema_ventas`.`catalogo_link_usos`, in index idx_link_usos_link, there is a record:
PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 80000003; asc     ;;
 1: len 4; hex 80000001; asc     ;;

------------
TRANSACTIONS
------------
Trx id counter 1765387376
Purge done for trx's n:o < 1765387376 undo n:o < 0 state: running
History list length 4
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284192089238768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089230432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089180416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089222096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089134568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089217928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089234600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089226264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089213760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089209592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089205424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089184584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089201256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089192920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089172080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089176248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089197088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089155408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089188752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089159576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089097056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089163744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089151240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089147072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089142904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089072048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089138736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089130400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089126232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089122064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089101224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089117896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089113728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089105392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089059544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089109560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089092888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089088720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089076216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089055376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089084552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089080384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089067880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089063712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089167912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: native aio handle (insert buffer thread)
I/O thread 1 state: native aio handle (log thread)
I/O thread 2 state: native aio handle (read thread)
I/O thread 3 state: native aio handle (read thread)
I/O thread 4 state: native aio handle (read thread)
I/O thread 5 state: native aio handle (read thread)
I/O thread 6 state: native aio handle (write thread)
I/O thread 7 state: native aio handle (write thread)
I/O thread 8 state: native aio handle (write thread)
I/O thread 9 state: native aio handle (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
214530203 OS file reads, 25952726 OS file writes, 11592986 OS fsyncs
0 pending reads, 1 pending writes
16.00 reads/s, 16384 avg bytes/read, 22.11 writes/s, 10.77 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 347, seg size 349, 506064 merges
merged operations:
 insert 646799, delete mark 280980, delete 77373
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
29.58 hash searches/s, 80.29 non-hash searches/s
---
LOG
---
Log sequence number 279841891514
Log flushed up to   279841891494
Pages flushed up to 279841777831
Last checkpoint at  279841775473
0 pending log flushes, 0 pending chkp writes
6589462 log i/o's done, 6.94 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 1181888
Buffer pool size   1003
Free buffers       739
Database pages     256
Old database pages 0
Modified db pages  171
Percent of dirty pages(LRU & free pages): 17.169
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 65, flush list 0, single page 0
Pages made young 110521907, not young 4960872863
0.00 youngs/s, 0.00 non-youngs/s
Pages read 214529663, created 352008, written 17682382
16.00 reads/s, 0.35 creates/s, 13.52 writes/s
Buffer pool hit rate 954 / 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: 256, unzip_LRU len: 0
I/O sum[1513]:cur[71], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=14608, Main thread ID=16812, state: sleeping
Number of rows inserted 1196909, updated 79029241, deleted 910044, read 191394394411
0.17 inserts/s, 5.29 updates/s, 0.00 deletes/s, 534.62 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 502073
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================