Questions tagged [mariadb]
Open source RDBMS designed to be a "drop-in" replacement for MySQL. Add a version-specific tag like mariadb-10.2 if that context is important.
1,696
questions
0
votes
1answer
5 views
Fetching Remote Encryption Key for MariaDB
I've set up encryption at rest for MariaDB but I can't seem to get my key fetching service to fetch the key.
I have the following fetch script and a systemd service set up.
# Fetch the encryption file ...
-1
votes
1answer
6 views
Nullable integer as part of composite primary key
I want to store phone numbers as integers and I've created this SQL:
DROP TABLE `user_id_phone`;
CREATE TABLE `user_id_phone`
(
`user_id` int unsigned NOT NULL,
`country_code` ...
0
votes
0answers
6 views
Is it possible to replicate different Galera MAIN-MAIN clusters (MariaDB) with another Galera MAIN-MAIN cluster but as MAIN-SECONDARY asynchronously?
We are a small team of developers and we usually deal with single database access locally or remotely. We are working on a project that needs to have not only replication on the local network (we'll ...
0
votes
1answer
31 views
order by slowing down query with multiple joins and limit/offset on larger result sets
I am having trouble with the following query taking quite a long time to process when results are large. The limit and offset can change as this is used with pagination. The range on ...
0
votes
0answers
9 views
MariaDB database corruption in MediaWiki install
I'm having an issue with a MariaDB database on a MediaWiki installation on my personal computer (local, personal use). A few days ago I booted it up and tried to access the wiki, and got the following ...
0
votes
0answers
9 views
MariaDB User for both remote access and local access
I want to enable my app to access the database locally, and in the same time access it remotely from a tool like MySQLyog. I'm wondering whether I should be creating two users, one for the local ...
0
votes
1answer
14 views
Temprary tables on Mariadb with no activity on the server
I have a nagios check for mariadb 10.4 server running on Debian9, WARNING - 59.92% of 670 tables were created on disk | pct_tmp_table_on_disk=59.92%;50;75 pct_tmp_table_on_disk_now=77.46%. However, ...
0
votes
1answer
13 views
meaning code at comment part from mysqldump result
on the results from mysqldump i got this part from create procedure before line BEGIN
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @...
1
vote
3answers
32 views
MariaDB master to master replication auto increment is not sequential
I have two master to master MariaDB server replication with the below settings:
server A with 192.168.1.100:
------------------------------
bind-address = 0.0.0.0
server-id = 1
log-...
0
votes
0answers
5 views
In master-master replication when master delete a record , slave also delete same records problem, [closed]
But i dont delete in slave , Only delete master record ” How to restrict it“
help me
0
votes
0answers
18 views
Taking InnoDB MySQL/MariaDB cold file backup and restoring on new Omeka DB
I have an unresponsive Omeka MySQL/MariaDB database on a Windows server. It is unresponsive in the sense that it will not start from the XAMPP panel:
10:44:15 AM [mysql] Attempting to start ...
0
votes
0answers
23 views
MySQL client (Windows) and MySQL Server (Ubuntu VM) showing different result [closed]
I am working for Query profiling. On MySQL Client I executed these three statements
SET PROFILING=ON;
SELECT COUNT(*) FROM EMP;
SHOW PROFILES;
It gives me desired result as :
Query_ID ...
0
votes
0answers
22 views
How to avoid the error “read ECONNRESET”?
I'm building an API that tracks binlog files in order to notify users of some specific changes on database.
My max_binlog_size is set to 1048895 (1M) and after some time running the follow error is ...
0
votes
1answer
13 views
Cannot find aria_s3_copy utility in mariadb 10.5.5
I am not able to find the Aria utility - aria_s3_copy under bin. I use mariadb official docker image and I do find aria_chk but not aria_s3_copy.
Can you tell me where I can find it?
0
votes
0answers
20 views
Can Aria table be changed back to InnoDb with foreign key constraints enabled?
Question is, I am aware that Aria Engine is non-transactional and does not support foreign key, but imagine there is a scenario where I copy in data from S3. Copying in two different tables into ...
0
votes
1answer
26 views
MySQL: Shouldn't these two DATE queries be the same?
I have this query, it tells me what order has expired, immediately after it expires.
(
SELECT
*
FROM
orders as ord
WHERE
DATE_ADD(paid_on, INTERVAL ord.duration HOUR) < NOW()
...
0
votes
1answer
12 views
Mariadb json store with unicode \u sequences
I am using mariadb and I store json data with unicode encoded strings eg \u0395, in a medium text column name remoteData with collation utf8_general_ci.
My problem is where query this column like that
...
0
votes
0answers
8 views
how big is the server load when client hit information_schema for monitoring
when I create some small application monitor for mariadb, and then I send query like
select variable_value from information_schema.global_status where variable_name = 'THREAD_RUNNING'
or
select ...
0
votes
1answer
19 views
Simple Update Join much slower than it should be (MYSQL)
This is a simple Update Join that updates only about 100 rows:
Update A INNER JOIN B using(id) SET A.active = 1 WHERE A.date > '2020'
This takes about 30 seconds to run, despite the fact that:
...
0
votes
1answer
27 views
Covering Index Not Being Used Effectively
I have a unique composite index on three fields (hash, is_customer, user_id) in a table a.
And queries that go like this:
select `a`.`id`, `hash`, `is_customer`, `user_id`
from `a`
where `hash` = ...
1
vote
0answers
32 views
Bad write log efficiency, strange broken relationships
I recently switched galera synchronization method from rsync to mariabackup which greatly reduced CPU usage on our DB servers and also increased the innodb_log_file_size to 2G from about 600M or so. ...
0
votes
1answer
16 views
Collation conflicts between views and functions when using utf8mb4_unicode_ci collation
Currently running MariaDB 10.3.24 and I really want to fully support the utf8mb4 unicode character set in my databases.
The problem I am running into is that when I try and set everything up to use ...
0
votes
1answer
26 views
Can't set root password after fresh installation of mariadb using ansible
Problem:
After a fresh installation of mariadb 10.4 the root password could not be set using ansible.
When installing mariadb from the debian packages by mariadb (not the official debian packages), ...
0
votes
0answers
31 views
Recover MariaDB & Galera from crash
I have two servers in the same network.
Both are ubuntu servers with LAMP.
My main server crashed today because of a power failure, after the server restarted MariaDB was totally unresponsive.
All the ...
0
votes
1answer
26 views
mysql_upgrade affect replication mariadb from mysql
I have one master (MySQL 5.7.29 ) and slave (MariaDB 10.4.12) I have a problem with events after inserting a dump to MariaDB from MySQL.
MariaDB [mysql]> show events;
ERROR 1545 (HY000): Failed to ...
0
votes
1answer
22 views
Memory Used On global_status mariadb
on mariadb at information_schema.global_status they have variable name memory_used in bytes
this is actual memory use from mariadb ?
edit add example case
on my servers i have threads_running=10 and ...
1
vote
1answer
30 views
MariaDB or MySQL @@SESSION.tx_read_only always returns 0
I'm trying to figure out possible "read only" transaction setup leak between pooled connections (on the same physical connection) in Java application which lead me to a question "How ...
0
votes
0answers
21 views
Why “Revoke Priviliges” Command Doesn't Work in MySQL?
I am trying to remove all priviliges of a user on a db, I executed the command below but it doesn't change anything. What is the problem?
revoke all on db.* from 'user'@'host';
2
votes
1answer
26 views
composit index and possible keys specific query
i have query like this
select
date_format(referencedate, '%m/%d/%Y') as PostingDate,
reference_code,
"" as DocNo,
Account_Number,
detail_desc as Description,
case
...
0
votes
1answer
22 views
Understanding data length
How does the LENGTH() query relate to actual size of the data?
I notice that when I save this data to a text file, it's approximately 2% larger than the LENGTH() query. What is happening here? Here'...
0
votes
0answers
66 views
Join on a variable from “CASE” doesn't work
We have a very big PHP function that gets all the orders we have to renew, it takes between 2h and 9h to finish depending on the server and whether it's running PHP 5 or 7.
None of the queries are in ...
2
votes
1answer
51 views
MariaDB wants to use bizarre and extremely inefficient query plan on Aria, but not on InnoDB (5 seconds vs 1+ hour query)
I'm having some troubles getting a query to preform as expected on my MariaDB 10.4.14 system.
We recently migrated the database from InnoDB to Aria so we could store the INDEX separately on a fast PCI-...
1
vote
1answer
54 views
My query is too slow
Please excuse my bad english. I am really frustrated and do not know what to do next. My problem is a sql query. The problem with the query is that the query takes too long and I think that this is my ...
1
vote
1answer
14 views
How to make multiple right joins in one single command for different child tables?
On the followin image you see 3 tables: A, B , C.
A: Is the table that holds the foreign keys from B and C
If I do a right join between A and B on that foreign key, it works, meaning I get the data ...
-1
votes
1answer
29 views
DB Highest usage of available connections increases [closed]
Hi I use aptitude portal and whenever userlimit exceeds 2000 I get 300 dbconnection upto 1000 it was only 18.Kindly help me to rectify issue.Is this configurations enough for 10000 users.
My.cnf: ...
0
votes
0answers
20 views
Database auto master selection
Wondering what database supports auto election of master from it's slaves or replicas?
I tried setting up Postgres and so far I learned that you have to manually configure which of the slaves or ...
0
votes
1answer
19 views
Can I hide my password for data at rest encryption key?
For MariaDB encryption at-rest, my setting is
[mysqld]
# at-rest encryption
plugin_load_add = file_key_management
file_key_management_filename = /etc/mysql/rest/keyfile.enc
...
2
votes
1answer
23 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. ...
0
votes
0answers
16 views
Made a mistake with mysql restore on the production site instead of the staging one. Can I use mysql general log to restore?
Made a mistake with mysql restore on the production site instead of the staging one. Can I use mysql general log to restore? It seems general log is all I have. I dont seem to have a binlog with ...
0
votes
2answers
24 views
how to insert big data in mariadb with execution time less than max_statement_time value
i have some table with this structure.
CREATE TABLE `trcdmppdetail` (
`mpp_code` varchar(50) NOT NULL,
`company_code` varchar(50) NOT NULL,
`mppdetail_date` datetime(3) NOT NULL,
`position_id` ...
0
votes
1answer
37 views
What is the point of encryption at rest?
I am wondering what is the point of encryption at rest?
It is said that a hacker cannot steal the database and look through it. I'm afraid that it does not protect the database while the key is stored ...
2
votes
3answers
54 views
Is it safe to delete “root” user?
I have hosted one web application on a staging server where I have deleted "root" users from the database. I don't want to use a common name for superuser. I have also created another admin ...
0
votes
1answer
44 views
Can I connect mysql client to a mariadb server?
I am new to databases, so I might have done something very simple wrong.
I cannot connect to my Mariadb server via my mysql client. Is this possible at all?
cmd> mysql -h 192.168.0.17 -u root -P ...
1
vote
1answer
56 views
My Mariadb fails and shuts down after running with a timeout
My Mariadb version is
$ mysql -V
mysql Ver 15.1 Distrib 10.3.23-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
My machine is a ubuntu server:
$ uname -a
Linux mypc 5.4.0-42-generic #46-...
0
votes
1answer
19 views
MariaDB subqueries to same table and column resulting in several columns
I have a table and want to pick monthly minute data to compare column wize in 10.3.13-MariaDB
Tested and tested for hours and hours different approaches without success, one example is below. Some ...
0
votes
0answers
36 views
What is mysql version?
I have installed msyql and mariadb.
When checking for the versions, everything I see is the version of mariadb.
How can I know the version of mysql itself?
mysql -V
mysql Ver 15.1 Distrib 10.3.23-...
1
vote
1answer
35 views
mariabackup crashing, help
Hi I'm using mariabackup on one of my MariaDB 10.5.4 nodes from my Galera Cluster and whenever I run it i get this from my output logs:
[00] 2020-08-05 11:26:40 Connecting to MySQL server host: ...
-1
votes
2answers
29 views
Do these joins change anything [closed]
I have a request which looks like this :
SELECT A.*
FROM A
INNER JOIN B
ON A.id_B = B.id
INNER JOIN C
ON B.id_C = C.id
A.id_B and B.id_C are foreign keys NOT NULL
For me the INNER JOIN ...
0
votes
0answers
28 views
Best way to prevent lock wait timeout exceeded try restarting transaction
I'm not totally savvy about databases, I just know the basics. We encountered this problem while trying to query something from our database. This query occurs every 10 seconds. This is the first I ...
0
votes
1answer
30 views
Why are CASE-expressions in the list documenting operator precedence?
In the list here:
https://mariadb.com/kb/en/operator-precedence/
case-expressions are put at the same precedence level as BETWEEN, between the NOT operator and the comparison operators.
However, case-...
