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 14:22:00 0x791c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 23 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1028712 srv_active, 0 srv_shutdown, 2828737 srv_idle
srv_master_thread log flush and writes: 3857445
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 20646100
OS WAIT ARRAY INFO: signal count 10496380
RW-shared spins 27141069, rounds 482333818, OS waits 9262034
RW-excl spins 7643683, rounds 21011221, OS waits 271169
RW-sx spins 154883, rounds 1851235, OS waits 38633
Spin rounds per wait: 17.77 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 1765419776
Purge done for trx's n:o < 1765419775 undo n:o < 0 state: running
History list length 9
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284192089230432, 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 284192089180416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284192089222096, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 3012256, OS thread handle 18484, query id 46348916 localhost ::1 root Sending data
SELECT observacion, usuario, fecha FROM auditor_cobros WHERE ncobro = ?
Trx read view will not see trx with id >= 1765419774, sees < 1765419774
---TRANSACTION 284192089217928, 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 284192089226264, 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
215780888 OS file reads, 26055249 OS file writes, 11642730 OS fsyncs
72.21 reads/s, 16384 avg bytes/read, 27.56 writes/s, 13.13 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 347, seg size 349, 508133 merges
merged operations:
insert 650672, delete mark 281667, delete 77573
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)
34.48 hash searches/s, 92.95 non-hash searches/s
---
LOG
---
Log sequence number 279861676424
Log flushed up to 279861676424
Pages flushed up to 279861644354
Last checkpoint at 279861638985
0 pending log flushes, 0 pending chkp writes
6614655 log i/o's done, 8.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 1181888
Buffer pool size 1003
Free buffers 653
Database pages 342
Old database pages 0
Modified db pages 78
Percent of dirty pages(LRU & free pages): 7.831
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 110644244, not young 4984509363
0.52 youngs/s, 2976.65 non-youngs/s
Pages read 215780347, created 352844, written 17750922
72.17 reads/s, 0.22 creates/s, 17.43 writes/s
Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 223 / 1000
Pages read ahead 33.96/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 342, unzip_LRU len: 0
I/O sum[3409]:cur[37], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=14608, Main thread ID=16812, state: sleeping
Number of rows inserted 1199983, updated 79044479, deleted 911356, read 191888755870
0.35 inserts/s, 6.17 updates/s, 0.00 deletes/s, 112467.24 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 578209
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
