Storage engines

InnoDB

Supports transactions, row-level locking, and foreign keys

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-11-02 18:55:04 0x3f58 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1011 srv_active, 0 srv_shutdown, 369052 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1265
OS WAIT ARRAY INFO: signal count 1222
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-10-31 16:19:46 0x45a4 Transaction:
TRANSACTION 29394, ACTIVE 0 sec inserting, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 11615, OS thread handle 17828, query id 384264 localhost ::1 root update
insert into vtiger_seactivityrel(activityid,crmid) values(43382,'0')
Foreign key constraint fails for table `digitidefeedbackdb`.`vtiger_seactivityrel`:
,
  CONSTRAINT `fk_2_vtiger_seactivityrel` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
Trying to add in child table, in index PRIMARY tuple:
DATA TUPLE: 4 fields;
 0: len 4; hex 80000000; asc     ;;
 1: len 4; hex 8000a976; asc    v;;
 2: len 6; hex 0000000072d2; asc     r ;;
 3: len 7; hex 00000000000000; asc        ;;

But in parent table `digitidefeedbackdb`.`vtiger_crmentity`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 18; compact format; info bits 0
 0: len 4; hex 80000002; asc     ;;
 1: len 6; hex 00000000244e; asc     $N;;
 2: len 7; hex 81000000870110; asc        ;;
 3: len 4; hex 80000001; asc     ;;
 4: len 4; hex 80000001; asc     ;;
 5: len 4; hex 80000001; asc     ;;
 6: len 6; hex 4272616e6368; asc Branch;;
 7: SQL NULL;
 8: len 5; hex 99bb34f92b; asc   4 +;;
 9: len 5; hex 99bb34f92b; asc   4 +;;
 10: SQL NULL;
 11: SQL NULL;
 12: len 4; hex 80000000; asc     ;;
 13: len 4; hex 80000001; asc     ;;
 14: len 4; hex 80000000; asc     ;;
 15: len 4; hex 80000000; asc     ;;
 16: len 6; hex 494d504f5254; asc IMPORT;;
 17: len 10; hex 4b61726f6c2042616768; asc Karol Bagh;;

------------
TRANSACTIONS
------------
Trx id counter 34138
Purge done for trx's n:o < 34138 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284152090927472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090926696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090925920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090925144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090924368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090923592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090922040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090922816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284152090921264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: wait Windows aio ((null))
I/O thread 1 state: wait Windows aio (insert buffer thread)
I/O thread 2 state: wait Windows aio (read thread)
I/O thread 3 state: wait Windows aio (read thread)
I/O thread 4 state: wait Windows aio (read thread)
I/O thread 5 state: wait Windows aio (read thread)
I/O thread 6 state: wait Windows aio (write thread)
I/O thread 7 state: wait Windows aio (write thread)
I/O thread 8 state: wait Windows aio (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
 ibuf aio reads:
Pending flushes (fsync) log: 0; buffer pool: 0
2337 OS file reads, 135046 OS file writes, 97718 OS fsyncs
0.31 reads/s, 16384 avg bytes/read, 3.18 writes/s, 0.10 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 10 buffer(s)
Hash table size 34679, node heap has 4 buffer(s)
Hash table size 34679, node heap has 3 buffer(s)
Hash table size 34679, node heap has 11 buffer(s)
Hash table size 34679, node heap has 7 buffer(s)
Hash table size 34679, node heap has 8 buffer(s)
Hash table size 34679, node heap has 3 buffer(s)
Hash table size 34679, node heap has 5 buffer(s)
2173.07 hash searches/s, 1971.04 non-hash searches/s
---
LOG
---
Log sequence number          381484684
Log buffer assigned up to    381484684
Log buffer completed up to   381484684
Log written up to            381484684
Log flushed up to            381484684
Added dirty pages up to      381484684
Pages flushed up to          381484684
Last checkpoint at           381484684
Log minimum file id is       86
Log maximum file id is       116
76409 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 8209226
Buffer pool size   8191
Free buffers       1024
Database pages     7116
Old database pages 2606
Modified db pages  103
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2886, not young 43854
5.01 youngs/s, 8.71 non-youngs/s
Pages read 2273, created 22683, written 43182
0.31 reads/s, 7.22 creates/s, 0.07 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: 7116, unzip_LRU len: 0
I/O sum[11]: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=15640, Main thread ID=17216 , state=sleeping
Number of rows inserted 973633, updated 1748, deleted 260, read 4713964
586.76 inserts/s, 0.00 updates/s, 0.00 deletes/s, 596.01 reads/s
Number of system rows inserted 15703, updated 22729, deleted 313, read 11299610
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 3673.08 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================