Motores de almacenamiento

InnoDB

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

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

=====================================
2025-11-09 01:32:36 0x7f0dbc21e700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2920 srv_active, 0 srv_shutdown, 2478 srv_idle
srv_master_thread log flush and writes: 5398
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 9326
OS WAIT ARRAY INFO: signal count 8575
RW-shared spins 0, rounds 3732, OS waits 1858
RW-excl spins 0, rounds 1134, OS waits 38
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 3732.00 RW-shared, 1134.00 RW-excl, 0.00 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-11-09 01:32:35 0x7f0dbc318700 Transaction:
TRANSACTION 51558, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
MySQL thread id 63260, OS thread handle 139696968664832, query id 2213288 192.168.30.20 root Update
INSERT INTO ALUMNO (`MATRICULA`, `APATERNO`, `AMATERNO`, `NOMBRE`, `SEXO`, `EDAD`, `CVECARRERA`) VALUES
(5888, 'MORALES', 'ROSAS', 'ROSALINDA', 'FEMENINO', 23, 'C-02'),
(6999, 'CRUZ', 'CRUZ', 'JUAN', 'MASCULINO', 24, 'C-01'),
(7999, 'NUÑEZ', 'DOMINGUEZ', 'DANIEL', 'MASCULINO', 25, 'C-01')
Foreign key constraint fails for table `ALAZ`.`ALUMNO`:
,
  CONSTRAINT `ALUMNO_ibfk_1` FOREIGN KEY (`CVECARRERA`) REFERENCES `CARRERA` (`CVECARRERA`) in parent table, in index CVECARRERA tuple:
DATA TUPLE: 2 fields;
 0: len 20; hex 432d303220202020202020202020202020202020; asc C-02                ;;
 1: len 4; hex 80001700; asc     ;;

But in parent table `ALAZ`.`CARRERA`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 696e66696d756d00; asc infimum ;;

------------
TRANSACTIONS
------------
Trx id counter 51568
Purge done for trx's n:o < 51568 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421171966899000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421171966894744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421171966886232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421171966890488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421171966881976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (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
863 OS file reads, 44244 OS file writes, 22081 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 9.12 writes/s, 6.87 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 69257, node heap has 0 buffer(s)
Hash table size 69257, node heap has 9 buffer(s)
Hash table size 69257, node heap has 2 buffer(s)
Hash table size 69257, node heap has 25 buffer(s)
Hash table size 69257, node heap has 1 buffer(s)
Hash table size 69257, node heap has 3 buffer(s)
Hash table size 69257, node heap has 25 buffer(s)
Hash table size 69257, node heap has 0 buffer(s)
9.00 hash searches/s, 4.50 non-hash searches/s
---
LOG
---
Log sequence number 18318686
Log flushed up to   18318547
Pages flushed up to 18304396
Last checkpoint at  18292139
1 pending log flushes, 0 pending chkp writes
13487 log i/o's done, 4.12 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 285212672
Dictionary memory allocated 136272
Buffer pool size   16024
Free buffers       15091
Database pages     868
Old database pages 328
Modified db pages  62
Percent of dirty pages(LRU & free pages): 0.388
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 704, created 164, written 27473
0.00 reads/s, 0.00 creates/s, 3.75 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: 868, 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=908, Main thread ID=139696218826496, state: making checkpoint
Number of rows inserted 1, updated 6755, deleted 0, read 803734
0.00 inserts/s, 2.12 updates/s, 0.00 deletes/s, 4.62 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 964
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================