Questions tagged [mariadb]

Open source RDBMS that forked from MySQL. Add a version-specific tag like mariadb-10.5 if that context is important.

670 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
362 views

How can MySQL's data types with 4GB limits be fully used since max_allowed_packet is hard limited to 1GB?

The MySQL types LONGTEXT and LONGBLOB are documented with data limits of L + 4 bytes, where L < 2^32 (~4GB). But max_allowed_packet is only configurable up to 1GB. The largest possible packet ...
5
votes
1answer
1k views

Getting duplicate record errors like "Duplicate Entry for key 'PRIMARY', error code 1062" when importing a full backup into slave

We're restoring our slave with a full backup from our master, and getting a bunch of duplicate key errors. Once the slave gets caught up, it does not throw any errors (only when it is behind the ...
5
votes
1answer
535 views

Running Triggers on Slave with Row-based Events in MySQL >=5.6

We would like to have a setup where a slave has triggers that are not present on the master for the purpose of updating some summary tables or run a specific udfs.sys If one uses statement-based ...
4
votes
0answers
37 views

LIFO with stock splits

Background I am managing a database containing my users' trading of financial products, stocks bonds, ETFs etc. The system offers simple bookkeeping functionality (create portfolio, create instrument, ...
4
votes
0answers
3k views

InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3

I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times Cannot open table mysql/innodb_index_stats [...
4
votes
0answers
1k views

Galera Cluster Failed to report last committed

I'm experimenting with Galera Cluster with 3 nodes, but I'm having some issues but I'm not sure why. What I noticed is that I'm having lots of failed to report last committed (number), -110 (...
4
votes
1answer
908 views

Full database backup using xtrabackup stream

I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server. I just have some questions and I need guides, and I think ...
4
votes
1answer
1k views

Unable to get rid of orphan temporary tables

After migrating from MariaDB 5.5 to 10.0, I noticed an error message mentioning a table named piwik/#sql-1526_3a. From there I started googling and landed on the innodb troubleshooting docs Indeed, ...
4
votes
2answers
5k views

How to fix high memory usage of MariaDB?

I am using MariaDB(10.1.21) with following storage engines: InnoDB TokuDB Spider Engine System Configuration is : 3GB RAM Dual Core Processor I have tried pt-mysql-summary tool to identify the ...
4
votes
1answer
535 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
4
votes
1answer
966 views

Is this surprising deadlock reasonable or a MariaDB bug?

I recently had to diagnose a deadlock in an application that seemed impossible to me. Even after I found out how to reproduce it, I don't really undestand why it happens. I'm considering filing a ...
3
votes
0answers
75 views

MariaDB - Query to find unused indexes

I need to find unused index on a MariaDB database and do not have 'userstat' enabled, I found this query which is supposed to find unused indexes, but I am unable to get a full understanding of this ...
3
votes
1answer
2k views

(Got an error reading communication packets) but no error on client

i've search a lot about this thread without results. we don't know how to resolve this: DB : mariaDB SERVER: Microsoft Azure enviroment: Nodejs with Knex (pool connections, min 0 max 300) our client ...
3
votes
0answers
334 views

Orphan records after delete statement in stored procedure

I have a database where some of the tables have parent --> child --> grandchild relationships through foreign keys as shown below. CREATE TABLE Parent ( ParentID INT UNSIGNED PRIMARY KEY ...
3
votes
0answers
902 views

Mariadb multi-master replication with old gtids

I have a multi-master replication setup up and running well in MariaDB. Each node has its own server-id and gtid_domain_id and is set up with its own master-slave and slave-master (two-way) ...
3
votes
0answers
3k views

Which is the right way to fix "Error: 1205 Lock wait timeout exceeded; try restarting transaction"

I have a PHP script that sync a local DB against external datasource. Each time the script runs I perform some triggers on the DB where INSERT or UPDATE happen. These are the the triggers for that ...
3
votes
0answers
1k views

MySQL SSL using MariaDB JDBC Driver

We have the following setup: Ec2 instance running a jboss server with mariadb (1.1.7) datasources setup to connect to an rds instance running MySQL 5.6.21. We would like to turn on SSL on for this ...
3
votes
0answers
1k views

Galera cluster consume many CPU percent and CPU high load

I have implemented a cluster include three nodes: two stored nodes and one garbd (also haproxy - load balancer). Some information about servers: SSD 480G Raid1 Memory 32G Swap 16G 2xCPU, number of ...
3
votes
1answer
8k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction https://software.mirantis.com/reference-documentation-on-...
3
votes
0answers
1k views

How do I safely import MySQL data in a directory to a running MariaDB server?

We're integrating another office into ours. That includes some of their data. I have a new installed MariaDB 5.5 server. The data dir = /home/data/MariaDB. I've done a new/fresh install into that ...
2
votes
1answer
60 views

Unable to enter characters in MariaDB

I have just switched from MySQL to MariaDB and am running into a very silly problem: I cannot enter any extended characters in the database (for example, ö ä or å). The system is utf8, and I tried ...
2
votes
0answers
38 views

MariaDB suddenly requiring database name prefixed to table name

I'm new to MariaDB (and databases in general). I'm using MariaDB 10.5.9 on Windows 10 from terminal. I'm not sure how/why, but for some reason MariaDB is requiring my SQL statements using table names ...
2
votes
0answers
34 views

mysqlimport vs Loading the SQL Format Dump

Isn't mysqlimport rumoured to be much faster than loading the SQL format dump? We have a database with nearly 60 million entries on the Windows platform, running MariaDB 10.1.21. We created the tab ...
2
votes
1answer
578 views

Very slow query on MariaDB 10.3 compared to MySQL 5.5.50

I already discussed how much slower performance I have experienced on MariaDB 10.3 compared to MySQL 5.5 for some queries in my previously posted thread, but I am now struggling with a specific kind ...
2
votes
2answers
540 views

I deleted a folder from /var/lib/mysql and now all of my databases seem to be unaccessible

I was receiving this error when trying to drop a database: ERROR 1010 (HY000): Error dropping database (can't rmdir './redpopdigital@002ecom', errno: 39 "Directory not empty") So I went ...
2
votes
0answers
1k views

DBeaver connection via SSH tunnel

Using DBeaver, I'm trying to connect to my AWS ec2 instance where I've installed a MariaDB database. I've created a new connection as: Connection: AWS / Maria DB Server Host: localhost (because I'm ...
2
votes
1answer
1k views

InnoDB: Could not find a valid tablespace file for 'database/table'. Mariadb 10.1.40

Generally server works fine without any issues. But recently I enabled error logs to test few things and I noticed an error InnoDB: Could not find a valid tablespace file for 'database/table'. This ...
2
votes
1answer
204 views

MariaDB - Replication - Unable to login remotely

So I've been trying to configure MariaDB replication for our server. Unfortunately I cannot get it replicating correctly. So I've followed the MariaDB guide to the letter to get replication set up. ...
2
votes
0answers
188 views

What is the preferred / common way to separate "access-tokens" in a database design

I'm currently having a case where a user has to verify their email, is able to reset his password and can log into a web-interface (so far and not limited to). There a now 3 places where some kind of ...
2
votes
0answers
160 views

How to prevent MariaDB mysqldump from prepending database name in CREATE VIEW?

I am having the exact same problem as this person here: How can I prevent mysqldump from prepending the database name in CREATE VIEW? I am using MariaDB 10.4.7 x64 on Windows. For just ONE of my ...
2
votes
0answers
44 views

How do I use mariabackup to do point in time restores?

So I've read about the basic way that I can backup my mariadb using mariadb backup... What I don't understand is how to make it point in time...... So I want to restore using mariadbackup full and ...
2
votes
0answers
43 views

Why InnoDB storage engine not loading csv files concurrently?

While loading different csv files to different tables of the same database using innodb storage engine(even tested on aria), csv files seems not to be loaded concurrently. Because, a single csv ...
2
votes
0answers
62 views

Can you force sets of rows to be unique?

Let's say we have a table like this with a primary key of (nr, key): nr | key | val ---|-----|------ 1 | 1 | a 2 | 1 | a 2 | 2 | b 3 | 1 | a 3 | 2 | c Every set of rows (grouped by nr ...
2
votes
1answer
460 views

Mariadb master master replication supported by HAPROXY for automatic failover

We have implemented master-master setup in maria-db. Master A is being used for read\write and Master B is used for backups and MIS operations. We have built this setup so that we do not need to ...
2
votes
1answer
205 views

How to optimize the execution of query that takes too long

I am working with a query that is taking around 53 minutes to execute, which I feel is excessive. Maria DB version: Server version: 10.1.38-MariaDB-1~stretch mariadb.org The declaration of the ...
2
votes
1answer
2k views

Determine cause of "MySQL server has gone away"

I've got a long running process on a headless server. It is a C program that monitors a modem for Caller Id and hangs up on telemarketers. On startup the program opens a connection to a MariaDB 10.3 ...
2
votes
1answer
253 views

innodb_buffer_pool_size, optimize and mysqltunner

I'm trying to understand how to properly size innodb_buffer_pool_size and when to optimize my tables. Questions are: When sizing the innodb_buffer_pool_size, should I take into account the size of ...
2
votes
1answer
2k views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
2
votes
1answer
3k views

Status shows InnoDB: 128 rollback segment(s) are active waiting for purge to start

MySQL process was killed due to memory issues. When start command was issued, server started and is working but a status command shows the following: InnoDB: 128 rollback segment(s) are active. ...
2
votes
0answers
554 views

Third node cannot join Galera cluster after mariadb update

I tried to deal with this issue for three days now, but unfortunately without success. I have a Galera cluster (Node1 - donor, Node2 - joiner, Node3 - arbitrator) which was working flawlessly until I ...
2
votes
0answers
59 views

MariaDB running indefinitely on inner join with count

I am currently experiencing a very, very weird issue with a query in MariaDB. Our server experiences a "504 Gateway Timeout" quite often after a database upgrade, and I was investigating the issue. ...
2
votes
1answer
380 views

Mariadb-10.0.30 Replication drift

We've configured 4 mariadb 10.0.30 slaves, the master also has the same major version and about the same hardware (32 cores, 128Gbs ram, 4.4Tb of data on ssd raid), everything was running fine until ...
2
votes
0answers
2k views

Mariadb connection fails through tunnel when bind address = localhost

I have a MariaDB 10.1.26 virtual server running on Debian 9. It is connected to via ssh tunnel and the bind address = localhost. It has been working without fail untill recently. Now when I connect ...
2
votes
0answers
486 views

Mysql replication does not replicate delete statement

Experiencing a strange issue. MariaDB 5.5.44 on both the master and the slave From the master, if I create a table, it appears on the slave, as well as data written to the master is replicated to ...
2
votes
0answers
563 views

How to order data on Inner Join MySQL?

I have a case to create podcast playlist based on category sorts. For example, I want to join podcast data and category data based on the table below. > SELECT * FROM category_sorts; +----+-------...
2
votes
0answers
3k views

FATAL ERROR: Upgrade failed when running mysql_upgrade on CentOS with SCL

We are a free/open source project. We have a CentOS 7 VM and it needed some software updated because the base CentOS 7 is stuck at PHP 5.4 and MediaWiki 1.26. We enabled Software Collections (SCL), ...
2
votes
1answer
390 views

Query Cache utilisation ~50% Qcache_lowmem_prunes still high

I ran two tests, each running for about a week Test 1 Query Cache Settings query_cache_limit: 50K query_cache_size: 128M query_cache_min_res_unit: 1K Results Qcache_free_blocks: 6,004 ...
2
votes
0answers
1k views

Prevent mysqldump from writing column-level collate and charset?

Using mariadb 10.x, it looks like the mysqldump utility adds column-level collate even if the table was created without them. Is there a way to suppress this behavior? Table created: CREATE TABLE `...
2
votes
1answer
186 views

What dump file options or MariaDB setting is slowing down the load of data?

Context: Loading a copy of a legacy DB for a CRUD app at build by Spring Boot. Primary use case is developers testing the CRUD functionality as it is developed. Problem: The loading operation is ...
2
votes
0answers
397 views

How to find MariaDb/Mysql structure differences

I have two similar databases with many tables, in one of these there was some alter commands maybe changing data types or adding some columns. Exists a free analyzer/merging tool to check their ...

1
2 3 4 5
14