Questions tagged [mariadb-10.6]

This question is related to mariadb-10.6. Also include the mariadb tag to get the attention of general mariadb helpers.

Filter by
Sorted by
Tagged with
0 votes
1 answer
35 views

MariaDB 10.6 join query 10 times slower than 10.3

I have two VPS servers (LEMP) running Wordpress sites. Specs: Old 4GB RAM Ubuntu 18.04 MariaDB 10.3 New 8GB RAM Ubuntu 22.04 MariaDB 10.6 I migrated a site and found that it was around 10 times ...
0 votes
0 answers
26 views

slow queries after migrating from mariadb 10.3 to 10.6

I have a query like this : select t.c1, t2.c2, ... my_function(t1.id) /*this function is used in many queries to avoid repeating code*/, ... from t1 left join ... lot of joins ... where t1.status='...
0 votes
0 answers
38 views

MariaDB SELECT query keeps stuck in one system but not in another

This is the reduced query showing problem: SELECT t.* FROM transactions t LEFT JOIN assignments a ON a.transaction_id = t.id LEFT JOIN users u2 ON u2.id = a.user_id WHERE ( u2....
  • 103
2 votes
1 answer
26 views

How to allow window function in window specification?

I'm trying to run this query: SELECT uuid, brainffa - LAG(brainffa, 1) OVER (ORDER BY brainffa) as brainffa FROM time_played WHERE automatic = 1 AND name LIKE 'all%' ORDER BY uuid DESC ...
  • 145
0 votes
1 answer
17 views

Mariadb: Sometimes inserts made during mysqldump are stuck forever in Updating state, and then service mariadb restart never finishes - how to debug?

I have a simple innodb Mariadb database used for logging (only inserts with insert ignore into a single large table). I back up the database nightly with mysqldump --no-create-info --hex-blob --...
0 votes
2 answers
79 views

MariaDB 10.6 issue with blocked queries that can't be killed

We have AWS RDS database, MariaDB 10.6.8, and we are facing some issues with queries being blocked, the main issue is that queries would lock the table and this would cause more blocked queries: show ...
0 votes
2 answers
32 views

MariaDB 10.6 InnoDB setttings for unit-tests: maximize performance at the expense of persistence

I have a MariaDB 10.6 the db is used for phpunit tests. The database is dropped and recreated each time I run the unit tests. I would like to maximize the speed of the interactions (read/write) with ...
  • 151
0 votes
1 answer
29 views

MariaDB - IODKU, but only if condition met

I have an often offline dev db, and would like to be able to push updates to my live server in the most efficient way possible. I would prefer not to update tens of thousands of rows that have not ...
  • 1
0 votes
0 answers
23 views

move specific MariaDB database to custom folder?

How can I move a specific MariaDB database to a custom folder? I'm not talking about changing the datadir or moving all databases, just a specific one? I have myawesomedb on a MariaDB 10.6 server on ...
0 votes
0 answers
62 views

INSERT .. ON DUPLICATE KEY UPDATE and INSERT IGNORE transaction issue

I have a reproduction where INSERTing a row doesn't actually seem to insert them, if you follow a transaction. Reproduction using docker (I've reproduced on 10.5 and 10.6): docker run -d -e ...
0 votes
1 answer
28 views

How to convert a string year to a DATE

STR_TO_DATE doesn't work like I expect. STR_TO_DATE('2007', '%Y') STR_TO_DATE('2007', '%y') 2006-11-30 2019-11-30 10.6.7-MariaDB-1:10.6.7+maria~bullseye-log
  • 11
0 votes
1 answer
246 views

How to reduce the size of file in innodb_data_file_path (ibdata1) in mariadb without recreate db

I have db with innodb tables and use innodb_file_per_table After OPTIMIZE TABLE `db`.`table` of all tables the size of db on disk reduced (from 3.3G to 2.8G) But size of file ibdata1 is the same (...
  • 101
-1 votes
1 answer
61 views

mysql vs mariadb query [closed]

Hope i don't make any mistakes posting here :) Hi everyone, i'm using the following query on mysql and works perfect. But when i use the same query (same database) on a mariadb i'm getting wrong ...
  • 3