Механізми зберігання
InnoDB
Supports transactions, row-level locking, and foreign keys
[
Змінні
|
Буферний пул
|
Статус InnoDB
]
=====================================
2026-04-03 15:14:58 0x7efcf4116700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 59 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 37 srv_active, 0 srv_shutdown, 814 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 107
OS WAIT ARRAY INFO: signal count 106
RW-shared spins 8, rounds 15, OS waits 7
RW-excl spins 4, rounds 120, OS waits 4
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 1.88 RW-shared, 30.00 RW-excl, 0.00 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-04-03 15:14:29 0x7efcf4116700 Transaction:
TRANSACTION 10043, 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 2833, OS thread handle 139624891639552, query id 54303 192.168.30.20 root update
INSERT INTO Location (codeProduit, numeroSSUtilisateur, numeroEvenement,
dateDebut, dateFin) VALUES (8, '100000000000007', 3, '2025-04-15', '2025-06-05')
Foreign key constraint fails for table `GestionProduits`.`Location`:
,
CONSTRAINT `Location_ibfk_1` FOREIGN KEY (`codeProduit`) REFERENCES `Produit` (`codeProduit`) ON DELETE RESTRICT ON UPDATE CASCADE
Trying to add in child table, in index PRIMARY tuple:
DATA TUPLE: 7 fields;
0: len 4; hex 80000008; asc ;;
1: len 15; hex 313030303030303030303030303037; asc 100000000000007;;
2: len 4; hex 80000003; asc ;;
3: len 3; hex 8fd28f; asc ;;
4: len 6; hex 00000000273b; asc ';;;
5: len 7; hex 00000000000000; asc ;;
6: len 3; hex 8fd2c5; asc ;;
But in parent table `GestionProduits`.`Produit`, 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 10044
Purge done for trx's n:o < 10037 undo n:o < 0 state: running but idle
History list length 48
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421099885804136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421099885803264, 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
1282 OS file reads, 1671 OS file writes, 671 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.24 writes/s, 0.17 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 34679, node heap has 2 buffer(s)
Hash table size 34679, node heap has 2 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 2 buffer(s)
Hash table size 34679, node heap has 2 buffer(s)
Hash table size 34679, node heap has 7 buffer(s)
1288.22 hash searches/s, 902.43 non-hash searches/s
---
LOG
---
Log sequence number 51358809
Log buffer assigned up to 51358809
Log buffer completed up to 51358809
Log written up to 51358809
Log flushed up to 51358809
Added dirty pages up to 51358809
Pages flushed up to 51358809
Last checkpoint at 51358809
621 log i/o's done, 0.02 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 137363456
Dictionary memory allocated 792895
Buffer pool size 8192
Free buffers 6789
Database pages 1386
Old database pages 491
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 408, not young 636
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1157, created 235, written 883
0.00 reads/s, 0.00 creates/s, 0.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: 1386, unzip_LRU len: 0
I/O sum[1]: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=365, Main thread ID=139624400746240 , state=sleeping
Number of rows inserted 503, updated 952, deleted 0, read 2475452
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1671.02 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
