Storage engines

InnoDB

Supports transactions, row-level locking, and foreign keys

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-11-02 19:29:39 0x4480 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 1 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1258 srv_active, 0 srv_shutdown, 370871 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1277
OS WAIT ARRAY INFO: signal count 1227
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 34212
Purge done for trx's n:o < 34212 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
2411 OS file reads, 135648 OS file writes, 97932 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 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 11 buffer(s)
Hash table size 34679, node heap has 58 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 6 buffer(s)
4056.94 hash searches/s, 1680.32 non-hash searches/s
---
LOG
---
Log sequence number          381498217
Log buffer assigned up to    381498217
Log buffer completed up to   381498217
Log written up to            381498217
Log flushed up to            381498217
Added dirty pages up to      381498217
Pages flushed up to          381498217
Last checkpoint at           381498217
Log minimum file id is       86
Log maximum file id is       116
76508 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 8268619
Buffer pool size   8191
Free buffers       1124
Database pages     6960
Old database pages 2565
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3381, not young 124175
0.51 youngs/s, 0.00 non-youngs/s
Pages read 2325, created 23146, written 43392
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: 6960, unzip_LRU len: 0
I/O sum[2]: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 1011073, updated 1748, deleted 260, read 5598235
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 15703, updated 22766, deleted 313, read 13273924
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 6679.32 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================