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.

Filter by
Sorted by
Tagged with
0
votes
1answer
25 views

Match Against search not doing exact search?

I'm using MariaDB version 10.2.22 with a InnoDB engine, utf8 charset, it has one column that is indexed FULLTEXT. The table itself is only 4.4 GB with avg row length at 255. When I do a query such as:...
0
votes
0answers
18 views

Advisable to run MariaDB's AriaDB engine's /var/lib/mysql/[databases] folder over Amazon EFS with transaction = 1 for the database creation process?

Advisable to run MariaDB's AriaDB engine's /var/lib/mysql/[databases] folder over Amazon EFS with transaction = 1 for the database creation process? Since AriaDB performs table level locking and only ....
2
votes
2answers
400 views

Does mysql or mariadb have the concept of SQL Server's “included columns” for indexes?

In SQL Server you can create an index and have additional columns included on that index that can help performance in certain circumstances. Is that same ability available for mysql or mariadb under a ...
1
vote
1answer
46 views

Safe values for InnoDB variables when using FULLTEXT searches

I'm using Maria DB, version 10.2.22, where one database column uses FULLTEXT for a broad document searching. However, I've ran into a "Table handler out of memory" on some searches. The ...
0
votes
1answer
35 views

MariaDB ERROR 1048 GeomFromText returning as null

I am trying to restore a databese from an old server onto a new server and my geomertry columns are not importing example UPDATE `property_floor` SET `floorBounds` = ST_GeomFromText('MULTIPOINT((115....
0
votes
0answers
6 views

How are GTIDs used to determine what transaction should be executed?

I use MariaDB 10.14 on servers M1, S2, S3. M1 is active master, and servers S2 and S3 replicate from M1. S3 also replicates from S2. All servers have GTID domain ID=1 then M1.server_id=100, S2....
1
vote
0answers
273 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 ...
1
vote
0answers
43 views

How to hot merge MariaDb databases from multiple servers into a single one

Current Configuration I currently have 3 servers: server australia with the database canberra servers belgium and germany are a galera cluster with the database bruxelles. Target Configuration My ...
0
votes
1answer
13 views

Does binary logging apply to ColumnStore?

When binary logging is enabled, does MariaDB's binary logging also record ColumnStore events, and not just InnoDB events? For example, does it log an UPDATE made to a ColumnStore table row? I've ...
0
votes
1answer
695 views

MariaDB crashed: Unknown/unsupported storage engine: InnoDB

I've a Debian GNU/Linux 9 (4GB, 2 CPUs) on Digitalocean. Tonight (I've done nothing) my DB (mariaDB) crashed with this errors. I ran a wordpress with InnoDB and myISAM tables: 2020-10-17 0:51:18 ...
0
votes
1answer
61 views

MariaDB: How can I grant read-only privileges for Stored Procedures?

I've granted SELECT privileges for a user to select on all tables of a database. However that user is unsable to view store procedures. I'd want to grant only the permission for SHOW CREATE PROCEDURE (...
0
votes
1answer
102 views

mysql (mariadb) won't start after power outage (MacOS)

/var/log/system.log says (over and over) Oct 13 19:34:01 Data-Server com.apple.xpc.launchd[1] (com.mariadb.server[2128]): Service exited with abnormal code: 1 Oct 13 19:34:01 Data-Server com.apple.xpc....
0
votes
0answers
57 views

Cannot drop empty database in mariadb

I am having trouble dropping a database on my server innodb-file-per-table is set to true We previously had a huge table (1TB) which we used a drop table command. This result i believe was ...
0
votes
0answers
40 views

Does commit after a normal select can call any fsync or flush operations?

I'm using Mariadb 10.2.16. 3 Node cluster. Coms counts taken at particular time for all 3 (insert,update,commit). Com_inserts are in 1.1K Com_updates are in 1.6k Com_commit are in 10K When ...
0
votes
0answers
41 views

ibd + frm file exist after table dropped

I am having trouble with my server running out of space I am currently running a mariadb instance with 27 databases inside. When i dropped the table i can see that the folder and ibd and frm files ...
0
votes
0answers
15 views

MySQL and MariaDB both hanging up with any driver when connecting from a remote client to my VPS

What I did: 1- Changed the bind-address to 0.0.0.0. It didn't work. Then I commented it out. It didn't work. 2- Enabled and disabled skip-networking to no avail. 3- My users are using native password. ...
0
votes
1answer
56 views

MySQL / MariaDB - Start multi-source replication with mariabackup (xtrabackup)

Many times I successfully performed procedure described in the https://mariadb.com/kb/en/setting-up-a-replication-slave-with-mariabackup/ - it's fastest and easiest because replica is restored by ...
0
votes
1answer
28 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
18 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
10 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
32 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
22 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
15 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
23 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
16 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
133 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
36 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
2k 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
18 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
46 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
29 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
30 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
21 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
117 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
18 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
239 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
81 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
36 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
32 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
98 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
40 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
27 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
24 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
67 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
58 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
59 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
43 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: ...

1 2 3
4
5
37