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,069
questions
0
votes
1answer
12 views
Optimize MariaDB query large dataset
We have a web application that uses MariaDB relational mode using tables with "InnoDB" engine, because our application inserts and updates many data each second. Also, we have a table to ...
0
votes
1answer
12 views
gtid_binlog_pos variable contains two values
I am trying to setup a master-slave replication with galera-cluster (choose 1 node as the primary master) and a standalone mariadb server (slave).
I have successfully setup the replication and data is ...
0
votes
0answers
13 views
MariaDB "freezes" during mariabackup operation
The Scenario:
I have a MariaDB running in a server named dbmaster, in a dedicated ProxMox server. This dbmaster runs:
Ubuntu 20.04
MariaDB 10.3.31 (installed from repository)
maria-backup 1:10.3.31-...
0
votes
1answer
25 views
Subquery not using Index, even if forcing
Using MariaDB 10.5.12 on CentOS 7
If it makes any difference, my "optimizer_use_condition_selectivity" = 1
If I run:
EXPLAIN SELECT COUNT(*) FROM ips WHERE ip="1.2.3.4"
This query ...
1
vote
1answer
19 views
What does running "show slave status" on a master server show?
We are using monitoring software that is throwing an error saying that Slave_IO_Running is returning No for replication on our master server. It is in fact true that when running show slave status on ...
0
votes
1answer
6 views
problem installing mariadb using mysql_secure_installation
I started secure install of MySQL with sudo mysql_secure_installation command, and I got that message:
Securing the MySQL server deployment.
Enter password for user root:
Error: Can't connect to ...
0
votes
0answers
33 views
MariaDB replication error 1236: 'Could not find first log file name in binary log index file'
I received an error during MariaDB replication that I'm not sure how to fix. Replication is a new topic to me and I acquired these databases and their architecture through a job, so I've done some ...
1
vote
2answers
47 views
Best way to store encrypted API identifiers (MariaDB)
So for max security I have to encrypt some string keys which I need to call specific actions of an API, at a very regular basis of the use of an application, so performance should also be considered.
...
0
votes
1answer
25 views
Unable to import data into MySQL table
We are having an issue importing entries into a table on MySQL version 8.0.27-0. I have been able to reproduce the problem with a simple example. Kindly note that all privileges have been granted to ...
0
votes
1answer
30 views
Data Encryption in MariaDB
It's the first time I'm using encryption in MariaDB, so I need to assure that I'm getting it right. I need to simply store some identifiers in an encrypted way, and am wondering if I'm doing it ...
0
votes
1answer
17 views
Best practice for data archiving
I am trying to figure out the best practice for data archiving. I have 1 pair of Master/Slave MariaDB servers where data is replicated from Master to slave. Since this is a very old app I am not able ...
1
vote
0answers
11 views
Mariadb galera cluster with galera load balancer and master-slave replication: Errorno 1062 handler error HA_ERR_FOUND_DUPP_KEY
I have the following setup in my environment.
Galera cluster with 2 nodes: db01 and db02.
Server with galera load balancer installed: glb01, applications/clients connect to the cluster via port 8010 ...
0
votes
1answer
18 views
After a database upgrade from MariaDB 10.1 to 10.6 new ODBC connections are returning wrong values
In somewhat related questions I notice the discusions of Data Engines. I have some tables set to MyISAM and some set to InnoDB but not sure if this could be causing the problem.
I used to connect to ...
0
votes
1answer
19 views
Large join on multiple indexed tables fails on copy of the schema but not on another
We have two schemas, both from the same template and with near identical record count (less than 100). They are both running in the same MariaDB 5.5.68. We also have existing schemas that run this ...
1
vote
1answer
15 views
WSREP connection to peer timed out, no messages seen in PT3S
I'm running 3 node Galera cluster using MariaDB-server-10.3.13-1.el7.centos.x86_64 and periodically seeing following errors in logs. I did google about this error but didn't find any good answer. Does ...
-2
votes
2answers
32 views
Why is my update so slow compared to select?
MariaDB 10.2.21 on Amazon RDS InnoDB
I am running a convoluted update (lots of subqueries in the where statement). And it takes many minutes to complete.
If I change the update to select, it takes ...
-1
votes
0answers
27 views
MariaDB 10.5.12 RDS lockup
My RDS locked up with nothing able to write to it and no data in performance insights after a massive spike of "Query end" (<1 -> 265). Only thing that helped was to reboot it, and ...
0
votes
2answers
35 views
Disabling Aria INSERT log in MariaDB [closed]
When I bulk INSERT into an Aria table, it creates a copy of the INSERT in a series of log files (aria_log.%). It can lead to full disk and crash of MySQL.
As I understand, Aria keeps a redo log for ...
-1
votes
2answers
62 views
MariaDB seems to be locking all the tables
I am running MariaDB locally on
windows 10. XAMPP version 3.2.4 and MariaDB Version 10.4.7
I am moving MYISAM tables to INNODB and trying to prove that the locking issues we seem to be having will be ...
0
votes
2answers
15 views
How to find which transaction is being rolled back
My MariaDB server crashed earlier today and is still recovering. The error log shows
InnoDB: To roll back: 1 transactions, 519345 rows
From the log entries it appears that the rollback is going to ...
0
votes
1answer
28 views
Mariadb: Access denied for user 'repl'@'xxx'- Replication slave permission getting revoked
I have 2 nodes running MySQL setup using Pacemaker.
Every time I standby the slave node and unstandby it later, it is not able to catch up and says the error as:
Last_IO_Error: error connecting to ...
0
votes
1answer
23 views
CockroachDB or mariaDB cluster for many read slaves, 1 master?
I am after a recommendation on the following setup...
1 Master that has all tables.
1 main table ( table A ) that master will write to, and read. often.
5+ tables ( tables B+ ) master will read from ...
0
votes
0answers
8 views
SqlError: (conn=46, no: 1045, SQLState: 28000) Access denied for user 'Raccoon'@'localhost' (using password: NO)
Im trying to set up one of mariadb's sample application, which is orders(https://github.com/mariadb-corporation/dev-example-orders). When starting the back end part it always shows "
SqlError: (...
-1
votes
0answers
10 views
Random Failure On MariaDb Start
Refer to the link xampp mysql Failed to initialize multi master structures
=> The Database Server fails to start randomly by creating the garbage in the data folder, Although a solution has been ...
0
votes
0answers
28 views
Convert a directory into a mysql database
(I use MariaDB, in case this helps)
Hey guys, I recently had problems with my hosting provider and I backed up my files, well, they just gave me the raw files and I didn't even have choice to dump the ...
1
vote
2answers
63 views
Multiple MySQL Instances Using systemd upgrade-safe/restart-safe?
We run MySQL 5.7.36 under Debian Buster with several instances.
For this we use the feature of Systemd described at https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html to work with argv[0]. (&...
0
votes
0answers
27 views
How To replicate from same database name on multiple site
I have a few dozens of sites (with replication enabled, and multiple satellite on each) where there is a standardized database (same schema), let's said its named "prod" everywhere.
I would ...
0
votes
1answer
43 views
How to Tune MariaDB Database System With Right Parameters
I have a MariaDB Galera 3-Node Cluster as the DB system but since I built, it is working with the default parameters. I only changed the parameter as max_connections=3000. It has been about 6 months ...
0
votes
0answers
34 views
How to avoid subquery duplication? Getting multiple rows of subquery
I need to create a view like this:
CREATE OR REPLACE VIEW bayer_pss_dashboard AS
SELECT
m.machine_id AS machine,
t.name AS time_interval,
(
SELECT SUM(TIMESTAMPDIFF(MINUTE, me....
0
votes
1answer
27 views
Mysql Dump directly into SFTP or into another server
I just have a quick question : I have a MariaDb Database ( with 1Tb of data) running on a dedicated server, I only have 2gb left on my storage and I would like to backup a few databases on my SFTP ...
0
votes
1answer
41 views
MariaDB: Periodic copy of data from local database to remote database
I need to periodically copy the outcome of a view on our local database to another remote database.
I've tried using mysqldump which works fine when copying data from tables to tables, but i need to ...
0
votes
0answers
20 views
MariaDB Encryption at Rest encryption algorithm
I'm trying to find out exactly what encryption algorithm MariaDB uses?
Does the following line in the mysql.cnf file note that the database is encrypted with aes-ctr or is just the encryption used on ...
0
votes
0answers
21 views
Where Should I Install Galera Load Balancer? On Cluster Nodes?
I want to install Galera Load Balancer for my 3-Node Galera Cluster, but where should I install the galera load balancer? Can I install on the cluster nodes or should I build a new server for galera ...
2
votes
1answer
55 views
MariaDB table is broken after failed dump process
I need to dump MariaDB InnoDB-database consists of several tables. One table that causes problems has nearly 13 Million rows. A fresh install of XAMPP(V.3.2.2) dump process was successful, after that, ...
0
votes
0answers
16 views
MariaDB rotated logs are empty on CentOS7
I've been having the same problem for a couple of weeks now. I have the following /etc/logrotate.d/mariadb file configuration:
/var/log/mariadb/*.log {
create 600 mysql mysql
...
1
vote
1answer
35 views
Monitoring MySQL/innoDB post-process
I did INSERT INTO SELECT of a huge table (1TB). When the process is finished, MySQL/InnoDB still does post-processing (creating updating secondary indices, etc.) for hours.
Since these are internal ...
1
vote
0answers
23 views
mysqldump increases SQL server process memory footprint
i mentioned my initial problem here in this question (config is still the same):
mariaDB with a 3 node galera cluster is eating more and more RAM
Now I have narrowed the problem down. I found out, ...
0
votes
2answers
34 views
How to Prevent the Connections for MariaDB Galera-Cluster When There is Only One Active Node?
I was using "rsync" as the wsrep_sst_method in my galera.cnf files on 3-Node Galera Cluster. When it was so, the system served when there was at least 2 active node. So when any two node ...
0
votes
0answers
24 views
MariaDB upgrade fails on replication slaves
I am having problems when a MariaDB replication slave wants to upgrade its tables after a server was patched. This happens consistently with any sort of OS patching.
The system has several slave ...
0
votes
1answer
38 views
MariaDB Galera 3-Node Cluster Sometimes Doesn't Serves
I have 3 Node MariaDB Galera cluster. I am using "mariabackup" as the wsrep_sst_method, but the database system doesn't work properly. I can say that sometimes there are 100 connection ...
0
votes
2answers
50 views
Improving query (Doing a nasty self join on a range with ctes)
-- The CTE1 is just to create columns that dictate the bound of what is considered the same entry
-- Also I do a dense rank by ACT_TIME, and a PARITION BY on ID1, ID2
-- so all ID1/ID2 combos are ...
0
votes
1answer
35 views
Create new sql table based on a query from another table MariaDb
Just to preface this I am very much a noob when it comes to dbs.
As the title states I want to create a new table based on query I do on an already existing table. At first I thought a view would be a ...
0
votes
0answers
50 views
Install Percona Data Recovery Tool for InnoDB on Ubuntu 18
Has anyone successfully installed the Percona Data Recovery Tool for InnoDB on Ubuntu 18? I downloaded the tool here: https://launchpad.net/percona-data-recovery-tool-for-innodb/trunk/release-0.5/+...
0
votes
0answers
25 views
MariaDB veryslow Inserts Query/Import via Dbeaver
I have a MariaDB server that via DBeaver is getting very slows insert times.
Tables with 10.000 lines only is getting imported in 2minutes
The DB Manager is trying to import CSVs, some with only 80mb ...
3
votes
1answer
111 views
MySQL/MariaDB: can a SELECT query block an INSERT query?
Let's suppose that I have a query in the form:
INSERT INTO tableA (...) select ... from tableB;
Now, is it possible that this query, while executing, blocks plain INSERT statements to tableB? ...
0
votes
1answer
37 views
MariaDB 0th day?
Today is the 2nd of october, I added a line to my table using curdate() -2 and now it shows the 0th of October when it's supposed to show September 30th. Anyone know why this is happening?
0
votes
1answer
13 views
MariaDB How to Change Slave Replication to New Master
I need help to change the master from my slave.
let's say i have 3 DB Server:
Master-1
Slave-2
Slave-3
Currently the Slave-2 and Slave-3 replicate from Master-1, i want to make Slave-2 into new ...
3
votes
1answer
59 views
How do I aggregate related rows when there's no group key?
I'm using MariaDB 10.6 and have a table:
CREATE TABLE velocities (
`state` int(8) NOT NULL,
`timestamp` datetime NOT NULL,
`velocity` decimal(5,2) NOT NULL,
`name` varchar(15) NOT NULL
) ...
0
votes
0answers
19 views
MariaDB: User password gets reset even after ALTER USER command fails
On MariaDB 10.5.10.
I create a DB user with a complex password. Then I change the password to say 1 char, it throws an Error 1396 but resets the password to NULL.
So now I can login as the user ...
0
votes
1answer
32 views
Suddenly, started getting "ERROR 2026 (HY000): Unknown SSL error"
MariaDB instance has been running well for ages, and suddenly, starting about 30 minutes ago, my apps get this error trying to connect:
# mysql
ERROR 2026 (HY000): Unknown SSL error
My certs have ...