Questions tagged [mariadb]
Open source RDBMS that forked from MySQL. Add a version-specific tag like mariadb-10.5 if that context is important.
2,863 questions
0 votes
1 answer
44 views
Adding Indexes with type "VECTOR" to Table takes a LOOOONG time
I have a table with around 30Mio entries using around 50GB of space on disk. It is defined as: CREATE TABLE `embeddings_value_def_default-small` ( `embeddings_def` INT(11) UNSIGNED NOT NULL, `...
0 votes
1 answer
27 views
SQL - returning NULLs if a subquery is empty
I have "device" and "event" tables. I want to combine the device record with particular events as columns. There are multiple event types. The number of events is small (below 10) ...
- 197
0 votes
2 answers
58 views
How to resolve "phantom" tables in the tablespace?
We run a Plesk server, for our sins. We yesterday did an update from MariaDB 10.5.17 to 10.11.14 SYSTEM: AlmaLinux 9.6 Plesk Obisidan 18.0.73 An issue that has been identified with this is that ...
- 269
0 votes
0 answers
32 views
Should I Switch from Master–Slave to Master–Master Database Replication in VoIP Environments?
I have two Asterisk+FreePBX servers that share a common database. The services are active on one server at a time, and in the event of a failure of the main server, the services are then started on ...
- 1
0 votes
0 answers
24 views
MariaDB PITR from mariadb-backup (GTID) fails "ERROR: Found out of orders GTID"
I'm trying to perform a Point-in-Time Recovery on a MariaDB 11.4.2 where GTID is enabled. I have successfully restored a full and an incremental backup using mariadb-backup, but I'm failing at the ...
- 163
0 votes
0 answers
8 views
MariaDB Slave replication just for backup
I have a MariaDB Galera master-master replication with 2 nodes. I would like to know if it is a good idea / best practice to add a third slave node just to run periodical dump. Currently dumps are ...
- 211
0 votes
1 answer
47 views
Many mariadb processes running parallelly
I have a tiny Ubuntu 24.04 server with 2GB of memory and running a few basic websites. Since yesterday, I see that the system is running out of memory and swapping a lot so I checked htop and saw that ...
- 101
0 votes
1 answer
22 views
Galera 4.24: Added option to disable application level protocol check to allow migration from MySQL to MariaDB?
The release notes at https://github.com/codership/documentation/blob/master/release-notes/release-notes-galera-26.4.24.txt say Added option to disable application level protocol check to allow ...
- 479