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,864 questions
0
votes
0
answers
18
views
How to build dynamic configuration for maxscale to upload it to Galera DB cluster
I need to configure for 1 maxscale, then upload the configuration to Galera DB Cluster of 3 nodes.
Maxscale nodes added later will pull the configuration from the Database cluster, not synchronize ...
Sơn Nguyễn
0
votes
1
answer
72
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
0
answers
20
views
Mysql-Documentation mentions "null" alteration to rebuild an innodb-table. Is this feasible and effective for MariaDB as well?
I have a MariaDB of version 10.6.22-18 (Enterprise) and the disk partition bearing the DB has 98% disk utilization.
Hence, I checked whether we have tables with lots of DATA_FREE, and, fortunately, I ...
- 13
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
1
answer
46
views
MariaDB --skip-grant-tables --skip-networking appears to remain despite removal from cnf files
AlmaLinux 9.6
We have recently been having some big issues with a Plesk update from MariaDB 10.5 to mariaDB 10.11.14 .
This now seems to be resolved (I reinstalled the MariaDB and the data from a dump)...
- 269
0
votes
2
answers
61
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
1
answer
52
views
how to solve SQLSTATE[HY000] [2002] Permission denied on localhost mariaDB 10.11.14
We use Plesk, for our sins.
We have updated MariaDB from 10.5 to 10.11.14 and now all websites on the server that previously connected on "localhost" are coming back with:
SQLSTATE[HY000] [...
- 269
0
votes
0
answers
37
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
1
vote
1
answer
37
views
Best database driver/connector for MariaDB in Go?
What database drivers and libraries do people use with MariaDB in Go? The page https://go.dev/wiki/SQLDrivers lists 3 MySQL drivers, but none for MariaDB. The SqlX seems to use the same drivers as ...
- 479
0
votes
0
answers
25
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
2
answers
40
views
mysqltuner advises to hold all db in ram
I have a small mariadb standalone server (RHEL9 x64), 8GB ram holding a (small) java app and a mariadb 11.4.5 database server (25GB data).
If I run mysqltuner (2.7.0) it tells:
✔ InnoDB Buffer Pool ...
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
66
views
Slow "best so far" query
I want to filter a table with map, playername, timestamp, time (2 million rows) to the rows that had the "best so far" time at their timestamp. So conceptually something like this:
SELECT * ...
- 113
0
votes
1
answer
51
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
0
answers
32
views
MariaDB replication issue between versions 10.6.19 (master) and 10.11.10 (slave)
I’m running into a replication problem between two MariaDB servers:
Master: MariaDB 10.6.19
Slave: MariaDB 10.11.10
Replication appears to start correctly. SHOW SLAVE STATUS\G under the slave shows ...
- 1