Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-10-27 02:23:57 0x7458ba482700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 18 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 534401 srv_idle
srv_master_thread log flush and writes: 534402
----------
SEMAPHORES
----------
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-10-27 02:15:01 0x7458b8433700 Transaction:
TRANSACTION 3349057445, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 1 row lock(s)
MariaDB thread id 846965, OS thread handle 127924397356800, query id 53596065 172.16.238.10 root Update
INSERT INTO `bases_details` (`bases_id`, `norg`, `uname`, `requisites`, `timezone`, `currency`, `count_staff`, `count_shops`, `setting`) VALUES ('', '', '', '', '', '', '', '', '')
Foreign key constraint fails for table `a04004_magelan`.`bases_details`:
,
  CONSTRAINT `bases_details_bases_FK` FOREIGN KEY (`bases_id`) REFERENCES `bases` (`id`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index bases_details_bases_id_IDX tuple:
DATA TUPLE: 11 fields;
 0: len 4; hex 00000000; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 0; hex ; asc ;;
 4: len 0; hex ; asc ;;
 5: len 0; hex ; asc ;;
 6: len 0; hex ; asc ;;
 7: len 0; hex ; asc ;;
 8: len 4; hex 80000000; asc     ;;
 9: len 4; hex 80000000; asc     ;;
 10: len 0; hex ; asc ;;

But in parent table `a04004_magelan`.`bases`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 28; compact format; info bits 0
 0: len 4; hex 0000003a; asc    :;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 7; hex 74657374303030; asc test000;;
 4: len 8; hex 00000000000000e8; asc         ;;
 5: len 5; hex 99a70ae577; asc     w;;
 6: len 30; hex 7b22647269766572223a2250646f222c2264736e223a226d7973716c3a64; asc {"driver":"Pdo","dsn":"mysql:d; (total 194 bytes);
 7: len 1; hex 80; asc  ;;
 8: len 7; hex 74657374303030; asc test000;;
 9: len 6; hex 313233313233; asc 123123;;
 10: len 0; hex ; asc ;;
 11: len 4; hex 80000004; asc     ;;
 12: len 5; hex 99b117190f; asc      ;;
 13: len 5; hex 99c00d7efb; asc    ~ ;;
 14: len 1; hex 81; asc  ;;
 15: len 5; hex 656e5f5553; asc en_US;;
 16: len 8; hex 8000000000000000; asc         ;;
 17: len 1; hex 00; asc  ;;
 18: len 4; hex 000005d2; asc     ;;
 19: len 4; hex 8000000c; asc     ;;
 20: len 1; hex 00; asc  ;;
 21: len 4; hex 00000001; asc     ;;
 22: len 3; hex 776572; asc wer;;
 23: len 1; hex 00; asc  ;;
 24: len 4; hex 80000000; asc     ;;
 25: len 1; hex 80; asc  ;;
 26: len 1; hex 01; asc  ;;
 27: SQL NULL;

------------------------
LATEST DETECTED DEADLOCK
------------------------
2026-10-26 17:54:15 0x7458b8c7f700
*** (1) TRANSACTION:
TRANSACTION 3347582187, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s)
MariaDB thread id 789802, OS thread handle 127924406056704, query id 50429745 172.16.238.10 root Update
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('4aa7e2daefe236d93bc2186034b197e2a718622fcdbec1ad9269d7f6567cf021', 'TLIOxBHfMDogiCnEsphKcTnkRsVbH7sZ1rkLY66ex0w=', UNIX_TIMESTAMP() + 300)
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 55 page no 3 n bits 8 index PRIMARY of table `a04004_magelan`.`lock_keys` trx id 3347582187 lock_mode X locks rec but not gap waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32
 0: len 30; hex 346161376532646165666532333664393362633231383630333462313937; asc 4aa7e2daefe236d93bc2186034b197; (total 64 bytes);
 1: len 6; hex 0000c7880cea; asc       ;;
 2: len 7; hex 0700001d6803ae; asc     h  ;;
 3: len 30; hex 4b535338783071305231434544532b783273337a71732b2b797477437669; asc KSS8x0q0R1CEDS+x2s3zqs++ytwCvi; (total 44 bytes);
 4: len 4; hex 6adf93d1; asc j   ;;

*** CONFLICTING WITH:
RECORD LOCKS space id 55 page no 3 n bits 8 index PRIMARY of table `a04004_magelan`.`lock_keys` trx id 3347582187 lock mode S locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32
 0: len 30; hex 346161376532646165666532333664393362633231383630333462313937; asc 4aa7e2daefe236d93bc2186034b197; (total 64 bytes);
 1: len 6; hex 0000c7880cea; asc       ;;
 2: len 7; hex 0700001d6803ae; asc     h  ;;
 3: len 30; hex 4b535338783071305231434544532b783273337a71732b2b797477437669; asc KSS8x0q0R1CEDS+x2s3zqs++ytwCvi; (total 44 bytes);
 4: len 4; hex 6adf93d1; asc j   ;;

RECORD LOCKS space id 55 page no 3 n bits 8 index PRIMARY of table `a04004_magelan`.`lock_keys` trx id 3347582188 lock mode S locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32
 0: len 30; hex 346161376532646165666532333664393362633231383630333462313937; asc 4aa7e2daefe236d93bc2186034b197; (total 64 bytes);
 1: len 6; hex 0000c7880cea; asc       ;;
 2: len 7; hex 0700001d6803ae; asc     h  ;;
 3: len 30; hex 4b535338783071305231434544532b783273337a71732b2b797477437669; asc KSS8x0q0R1CEDS+x2s3zqs++ytwCvi; (total 44 bytes);
 4: len 4; hex 6adf93d1; asc j   ;;


*** (2) TRANSACTION:
TRANSACTION 3347582188, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s)
MariaDB thread id 789800, OS thread handle 127923998349056, query id 50429746 172.16.238.10 root Update
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('4aa7e2daefe236d93bc2186034b197e2a718622fcdbec1ad9269d7f6567cf021', 'WiahKD9WWxwlSgGW89AnL2+Bn/rNo6QhFpgt+KJL04Q=', UNIX_TIMESTAMP() + 300)
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 55 page no 3 n bits 8 index PRIMARY of table `a04004_magelan`.`lock_keys` trx id 3347582188 lock_mode X locks rec but not gap waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32
 0: len 30; hex 346161376532646165666532333664393362633231383630333462313937; asc 4aa7e2daefe236d93bc2186034b197; (total 64 bytes);
 1: len 6; hex 0000c7880cea; asc       ;;
 2: len 7; hex 0700001d6803ae; asc     h  ;;
 3: len 30; hex 4b535338783071305231434544532b783273337a71732b2b797477437669; asc KSS8x0q0R1CEDS+x2s3zqs++ytwCvi; (total 44 bytes);
 4: len 4; hex 6adf93d1; asc j   ;;

*** CONFLICTING WITH:
RECORD LOCKS space id 55 page no 3 n bits 8 index PRIMARY of table `a04004_magelan`.`lock_keys` trx id 3347582187 lock mode S locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32
 0: len 30; hex 346161376532646165666532333664393362633231383630333462313937; asc 4aa7e2daefe236d93bc2186034b197; (total 64 bytes);
 1: len 6; hex 0000c7880cea; asc       ;;
 2: len 7; hex 0700001d6803ae; asc     h  ;;
 3: len 30; hex 4b535338783071305231434544532b783273337a71732b2b797477437669; asc KSS8x0q0R1CEDS+x2s3zqs++ytwCvi; (total 44 bytes);
 4: len 4; hex 6adf93d1; asc j   ;;

RECORD LOCKS space id 55 page no 3 n bits 8 index PRIMARY of table `a04004_magelan`.`lock_keys` trx id 3347582188 lock mode S locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32
 0: len 30; hex 346161376532646165666532333664393362633231383630333462313937; asc 4aa7e2daefe236d93bc2186034b197; (total 64 bytes);
 1: len 6; hex 0000c7880cea; asc       ;;
 2: len 7; hex 0700001d6803ae; asc     h  ;;
 3: len 30; hex 4b535338783071305231434544532b783273337a71732b2b797477437669; asc KSS8x0q0R1CEDS+x2s3zqs++ytwCvi; (total 44 bytes);
 4: len 4; hex 6adf93d1; asc j   ;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 3349102785
Purge done for trx's n:o < 3349102773 undo n:o < 0 state: running
History list length 465
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION (0x7458dc544380), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc543880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc542d80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc542280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc541780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc540180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc53f680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc540c80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7458dc53eb80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
Pending flushes (fsync) log: 0; buffer pool: 0
80900 OS file reads, 12745786 OS file writes, 12700080 OS fsyncs
32.61 reads/s, 16384 avg bytes/read, 27.61 writes/s, 22.44 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
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 789421744973
Log flushed up to   789421744906
Pages flushed up to 789401925358
Last checkpoint at  789401922905
0 pending log flushes, 0 pending chkp writes
12659043 log i/o's done, 18.94 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 167772160
Dictionary memory allocated 8027688
Buffer pool size   8112
Free buffers       28
Database pages     8084
Old database pages 2964
Modified db pages  1169
Percent of dirty pages(LRU & free pages): 14.409
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 156371, not young 1691240
118.88 youngs/s, 107.33 non-youngs/s
Pages read 74123, created 394075, written 86989
32.61 reads/s, 0.44 creates/s, 8.00 writes/s
Buffer pool hit rate 996 / 1000, young-making rate 13 / 1000 not 11 / 1000
Pages read ahead 0.00/s, evicted without access 0.11/s, Random read ahead 0.00/s
LRU len: 8084, unzip_LRU len: 0
I/O sum[1164]:cur[731], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 read views open inside InnoDB
Process ID=0, Main thread ID=0, state: sleeping
Number of rows inserted 4456663, updated 3729095, deleted 4298025, read 441672136
5.94 inserts/s, 5.94 updates/s, 5.94 deletes/s, 450.47 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 23295
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================