converter.dvl.to / mysql | phpMyAdmin 5.1.3

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

InnoDB

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

===================================== 2026-10-27 02:24:48 0x7458b8145700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 51 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 534452 srv_idle srv_master_thread log flush and writes: 534453 ---------- 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 3349117385 Purge done for trx's n:o < 3349117379 undo n:o < 0 state: running History list length 249 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7458dc542d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7458dc545980), 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 (0x7458dc544e80), 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 (0x7458dc543880), 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 81697 OS file reads, 12746893 OS file writes, 12701161 OS fsyncs 15.63 reads/s, 16384 avg bytes/read, 21.71 writes/s, 21.20 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 789422447502 Log flushed up to 789422447435 Pages flushed up to 789401925358 Last checkpoint at 789401922905 0 pending log flushes, 0 pending chkp writes 12660072 log i/o's done, 20.18 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 167772160 Dictionary memory allocated 7723560 Buffer pool size 8112 Free buffers 11 Database pages 8101 Old database pages 2983 Modified db pages 504 Percent of dirty pages(LRU & free pages): 6.212 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 159332, not young 1705038 58.06 youngs/s, 270.54 non-youngs/s Pages read 74920, created 394103, written 87056 15.63 reads/s, 0.55 creates/s, 1.31 writes/s Buffer pool hit rate 997 / 1000, young-making rate 9 / 1000 not 46 / 1000 Pages read ahead 0.00/s, evicted without access 0.18/s, Random read ahead 0.00/s LRU len: 8101, unzip_LRU len: 0 I/O sum[1237]:cur[358], 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 4457018, updated 3729447, deleted 4298318, read 441802305 6.96 inserts/s, 6.90 updates/s, 5.74 deletes/s, 2552.28 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 ============================

SQL upload ( 0 ) x -

Storage engines

InnoDB