Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-10-27 01:47:27 0x7458dc058700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 33 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 532223 srv_idle
srv_master_thread log flush and writes: 532224
----------
SEMAPHORES
----------
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-10-27 01:19:02 0x7458c9483700 Transaction:
TRANSACTION 3348871935, 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 832335, OS thread handle 127924682897152, query id 53108051 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 3348935480
Purge done for trx's n:o < 3348921528 undo n:o < 0 state: running but idle
History list length 7433
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION (0x7458dc541780), 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 (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 (0x7458dc542280), 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
63414 OS file reads, 12686788 OS file writes, 12642284 OS fsyncs
2.09 reads/s, 16384 avg bytes/read, 19.45 writes/s, 19.45 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 789398157912
Log flushed up to   789398157845
Pages flushed up to 789331120047
Last checkpoint at  789331119800
0 pending log flushes, 0 pending chkp writes
12601525 log i/o's done, 19.45 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 167772160
Dictionary memory allocated 7684392
Buffer pool size   8112
Free buffers       0
Database pages     8112
Old database pages 2975
Modified db pages  4608
Percent of dirty pages(LRU & free pages): 56.798
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 144303, not young 1470999
0.27 youngs/s, 15.70 non-youngs/s
Pages read 56637, created 392596, written 85563
2.09 reads/s, 0.61 creates/s, 0.00 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 14 / 1000
Pages read ahead 0.00/s, evicted without access 0.15/s, Random read ahead 0.00/s
LRU len: 8112, unzip_LRU len: 0
I/O sum[58]:cur[11], 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 4436198, updated 3712691, deleted 4277882, read 439620387
6.21 inserts/s, 6.12 updates/s, 6.12 deletes/s, 1484.89 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 11634
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================