Salvestusmootorid

InnoDB

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

[ Muutujad | Puhvertsoon | InnoDB staatus ]

=====================================
2025-11-27 07:54:03 0x7f14d8433700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 49 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 12165 srv_active, 0 srv_shutdown, 15973 srv_idle
srv_master_thread log flush and writes: 28135
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 45972
OS WAIT ARRAY INFO: signal count 36537
RW-shared spins 0, rounds 18574, OS waits 9225
RW-excl spins 0, rounds 6372, OS waits 215
RW-sx spins 8, rounds 73, OS waits 1
Spin rounds per wait: 18574.00 RW-shared, 6372.00 RW-excl, 9.12 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-11-27 01:27:49 0x7f14d8339700 Transaction:
TRANSACTION 42463, 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 12575, OS thread handle 139727503333120, query id 332386 192.168.30.20 root Update
INSERT INTO Prestamos (ID_Cliente, ID_Libro, FechaPrestamo, FechaDevolucion) VALUES
(1, 2, '2024-02-01', '2024-02-15'),
(2, 4, '2024-02-10', NULL),
(3, 1, '2024-02-05', '2024-02-20')
Foreign key constraint fails for table `Libreria`.`Prestamos`:
,
  CONSTRAINT `Prestamos_ibfk_2` FOREIGN KEY (`ID_Libro`) REFERENCES `Libros` (`ID`) in parent table, in index ID_Libro tuple:
DATA TUPLE: 2 fields;
 0: len 4; hex 80000002; asc     ;;
 1: len 4; hex 80000037; asc    7;;

But in parent table `Libreria`.`Libros`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 7; compact format; info bits 0
 0: len 4; hex 80000006; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 21; hex 4369656e2061c3b16f7320646520736f6c65646164; asc Cien a  os de soledad;;
 4: len 24; hex 4761627269656c2047617263c3ad61204dc3a1727175657a; asc Gabriel Garc  a M  rquez;;
 5: len 16; hex 5265616c69736d6f206dc3a16769636f; asc Realismo m  gico;;
 6: len 4; hex 800007af; asc     ;;

------------
TRANSACTIONS
------------
Trx id counter 91194
Purge done for trx's n:o < 91194 undo n:o < 0 state: running but idle
History list length 20
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421202486010360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421202486006104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421202486001848, 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: 0; buffer pool: 0
869 OS file reads, 181130 OS file writes, 97395 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 14.53 writes/s, 7.59 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 1 buffer(s)
Hash table size 69257, node heap has 1 buffer(s)
Hash table size 69257, node heap has 1 buffer(s)
Hash table size 69257, node heap has 1 buffer(s)
Hash table size 69257, node heap has 1 buffer(s)
Hash table size 69257, node heap has 1 buffer(s)
Hash table size 69257, node heap has 1 buffer(s)
Hash table size 69257, node heap has 0 buffer(s)
9.41 hash searches/s, 0.35 non-hash searches/s
---
LOG
---
Log sequence number 43900723
Log flushed up to   43900602
Pages flushed up to 43894357
Last checkpoint at  43893726
0 pending log flushes, 0 pending chkp writes
57169 log i/o's done, 3.86 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 285212672
Dictionary memory allocated 106880
Buffer pool size   16024
Free buffers       15118
Database pages     899
Old database pages 332
Modified db pages  12
Percent of dirty pages(LRU & free pages): 0.075
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 710, created 189, written 108852
0.00 reads/s, 0.00 creates/s, 9.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: 899, unzip_LRU len: 0
I/O sum[0]:cur[1], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=905, Main thread ID=139726736574208, state: sleeping
Number of rows inserted 31, updated 25931, deleted 5, read 611189
0.00 inserts/s, 2.33 updates/s, 0.00 deletes/s, 4.78 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 6695
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================