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,027
questions
0
votes
0answers
11 views
Galera Cluster Crashes together?
Hello I'm currently having trouble with my galera cluster. It was working fine earlier but suddenly all of the Nodes crashed. I have 3 local nodes and 1 node on the cloud.
During the time it went down ...
-1
votes
2answers
27 views
mysql vs mariadb query
Hope i don't make any mistakes posting here :)
Hi everyone,
i'm using the following query on mysql and works perfect. But when i use the same query (same database) on a mariadb i'm getting wrong ...
1
vote
2answers
23 views
Is Mysql creating any temp table , when running Mysql delete query?
Server details
We have one Galera cluster Mariadb with 3 nodes . On primary node database size is 200GB & diskspace size is 400GB . On other 2 secondary nodes database size is 200GB & ...
0
votes
2answers
48 views
How to Sync MySQL Databases when offline?
My application that is running on a client uses a MySQL database running on a server. So multiple clients are connected to the same server. That works well when the server is online. But now I would ...
0
votes
0answers
25 views
How to improve efficiency of multiple JSON_EXTRACT SELECT expressions
In MariaDB + InnoDB, I have a table like:
CREATE TABLE `stuff` ( ...
0
votes
1answer
44 views
Sudden Insertion Error to a 3 years old table with 5 million of records - Mysql error 1452 - Insert Problem
I've a table with a 5 million of records. Suddenly Database table stopped inserting a record. while record exists in parent table and record insertion is same in child table as It supposed to be.
But ...
0
votes
1answer
18 views
mysql/mariadb replication with proxy
I have a standard master-slave replication for MariaDB to sync one database (master) to multiple slaves. One of the slaves lives behind a proxy, so I need to proxy the replication request to the proxy ...
2
votes
2answers
43 views
mysqldump all database including user/password and grants
I am running 10.5.12-MariaDB and trying to take full backup of all databases including user accounts/ passwords and Grants but somehow i am not able to take backup of grants so am i missing something.
...
0
votes
0answers
21 views
If 2xssd nvme drives in soft Raid 1 can work efficiently with MariaDB? [closed]
I always used hardware raids but for now my client want to get dedicated server from hetzner and in most options they offer only ssd nvme drives on soft raid 1. We need to run typical LAMP enviroment ...
1
vote
2answers
67 views
Without using 'INTERSECT' , How to retrieve only the rows that exist in both tables?
I am a beginner reading the book Sams Teach Yourself SQL in 10 Minutes (Fifth Edition) to learn SQL.
Here is an expmple SQL query from the book from Chapter 14 - Combining Queries.
My question ...
0
votes
1answer
27 views
How do I prevent users from accessing mysql?
I installed MariaDB. I started the server as a local server(127.0.0.1:3306). I want to make sure that the www-data user can't access it. I tried to disable the mysql command for that user. But anyone ...
1
vote
3answers
31 views
Getting fatal error 1236 from master when reading data from binary log in mariadb master master replication
I am facing the situation similar to this Error 1236 - "Could not find first log file name in binary log index file"
I have tried all the answers but I am still not able to get rid of this ...
6
votes
1answer
233 views
How do you tune innodb_read_io_threads?
The default value of innodb_read_io_threads and innodb_write_io_threads is 4. How do you check if your server load needs a higher number of threads?
As I regularly check show engine innodb status \G, ...
0
votes
0answers
54 views
MariaDB: No database selected error on some query [migrated]
I have a php code that rise a query against a MariaDB (using MariaDB 10.5.11 on debian 11) table; I use php-mysql prepared queries for this task as reported in the code below:
if($this->dbcon->...
1
vote
2answers
57 views
How are SELECT queries isolated from each other with MariaDB 10.1?
Given the following tables..
CREATE TABLE `event` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) COLLATE utf8_general_ci NOT NULL,
`data` longblob NOT NULL,
`...
1
vote
2answers
45 views
Allowing remote connections to mariaDB docker conatiner?
so I'm really new to docker and I may be using it incorrectly here but it makes spinning up a mysql database REALLY easy so thats why I wanted to give it a shot rather than installing an instance on ...
0
votes
1answer
15 views
How to remove a innodb metadata lock with thread_id 0 in mariadb / mysql?
Today, suddenly our mysql database server got down. Few minutes after restarting the server went down again, and again. To see what is happening, we temporarily put our application in maintenance mode ...
1
vote
0answers
18 views
When creating a mapping table with two foreign keys, how does one create a foreign key constraint? [closed]
I'm using MariaDB and have 2 tables I'm trying to map together into another table. I've done foreign key relationships before, but never with a primary key from two tables. How do I go about creating ...
0
votes
1answer
20 views
mariaDB with a 3 node galera cluster is eating more and more RAM
I am running mariaDB 10.3.29 in a 3 node Galera Cluster on 3 VMs with 14G RAM each.
Despite configuring to best knowledge, it continues to eat more and more RAM and after around 3 months the machines ...
-1
votes
2answers
31 views
MariaDB (InnoDB) client disconnect release lock timeout
I have MariaDB (InnoDB). my client is setting lock on table.
In case he would fail for some random reason, what timeout setting I can set on the server, to release locks?
I know that DB discovers that ...
0
votes
1answer
33 views
MariaDB lost database MYSQL after 1-2 days
I have a big problem and i tried to fix this since weeks.
After 1-2 days i lost the database "mysql" in MariaDB (Server version: 10.5.12-MariaDB MariaDB package) running on OpenSuSe Leap 15....
-1
votes
1answer
37 views
Is there any builtin mechanism to stop sql injections in mariadb?
Actually this question is a assignment given to me and I was not able to find any answer by googling. Is there any builtin mechanism in mariadb to stop sql injections?
1
vote
0answers
32 views
Any thoughts on what crashed my database?
A few days ago, our database server, (see specs below), spiked to 4800% CPU usage. The database is about 100GB. For 3 hours we tried to figure out what the issue was. We finally figured out a feature ...
1
vote
1answer
11 views
Does Azure Mariadb/Mysql data-in replication support certificate chains?
I would like to migrate from AWS RDS Mysql to Azure Mariadb managed database.
For this purpose, I would set up data-in replication using TLS, roughly following the provided guide.
AWS provides ...
1
vote
1answer
48 views
Creating MEMORY table with varchar in MySQL
I need to create TEMPORARY tables for processing (via JOIN) a large set of data (1M rows), which have varchar columns. If I use ENGINE=MEMORY, it will change varchar to char. Then, the data will not ...
0
votes
1answer
37 views
MySQLDump understanding
How come when I write the following line in my CMD:
mysqldump -hHOST -uAdmin -p TestDatabase --single-transaction --routines --triggers > "C:\testdump_backup\testdump.sql"
Then the file ...
-4
votes
0answers
12 views
mariadb database explain statement - meaning of select primary, derived and table subquery [closed]
i have a basic understanding of mariadb explain statement, but this is an explain extended output of a big query -
the table size is almost 60G, having this query may or may not impact the performance ...
0
votes
0answers
29 views
Backup a large database with MySqlDump / Import useing MySql
So I'm going to make a backup system for my database and wanted to know if there was something specific I have to know before doing too much. I've read that I mught have to change some database ...
0
votes
1answer
43 views
MySQL table with a lot of text
So I have this database (Size 3.1Gb total), but this is due to one specific table I've got, containing A LOT of console output text, from some test runs. The table itself is 2.7Gb, and I was wondering ...
1
vote
1answer
21 views
Can I set in MariaDB the collation based on a IETF language tag?
I have an application where each user account can set their preferred application language. I store those language preferences as IETF BCP47 language tag (e.g. "de", "en-US"). Now, ...
0
votes
0answers
31 views
UPDATE rows and SET ordering depending on level and parent
I'm trying to write a small UPDATE query that makes sure all rows are reordered considering the parent_id.
Needs to work under MySQL 5.6 / MariaDB 10
This is a DB Fiddle made for testing.
So this is ...
0
votes
4answers
105 views
Why can't set variables related collation as utf8mb4_unicode_ci?
Show mysql version here:
mysql --version
mysql Ver 15.1 Distrib 10.5.11-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
And my mariadb's configuration file.
cat /etc/mysql/mariadb....
0
votes
2answers
184 views
Production database so much slower than development database?
I am running a script on both servers, one in my docker local developement system, and one on production. However, the same script is running much slower on production than on development. I am using ...
0
votes
1answer
22 views
service mysql reload results 'Access denied', but service mysql start works
Using Debian 10.10.
I have a MySQL problem.
service mysql reload
results 'Access denied'
service mysql start
executes correctly.
All databases are working correctly after starting mysql. Strange, ...
4
votes
0answers
31 views
LIFO with stock splits
Background
I am managing a database containing my users' trading of financial products, stocks bonds, ETFs etc. The system offers simple bookkeeping functionality (create portfolio, create instrument, ...
0
votes
1answer
41 views
What does it mean when slave status shows SQL running but IO not running?
What exactly does this mean, when the SQL is running but the IO is not running on the Slave in a Master-Master replication setup?
There are no other errors showing when running show slave status\G
...
1
vote
1answer
35 views
Exporting database using mysql command line
I am using mysql to export a database from my application, the options I have so far:
--skip-comments
--compact
--lock-tables=false
--add-drop-database
--host=localhost
--user=trainer
--password=XXXX
-...
1
vote
2answers
70 views
Under what conditions is it safe to use innodb_flush_method = O_DIRECT_NO_FSYNC?
There seems to be some contention about whether one should use innodb_flush_method = O_DIRECT_NO_FSYNC on XFS or EXT4, and MySQL 8 even turns this on as part of the innodb_dedicated_server=y option.
...
2
votes
1answer
77 views
MARIADB default users
I just installed mariadb 10.6 and can't understand...
SELECT Host,User,Password FROM mysql.user;
mariadb.sys@localhost password is empty.
root@localhost password hashed.
mysql@localhost password has &...
0
votes
1answer
21 views
Select Result Different On Float Data Type MariaDB 10.4.8 [duplicate]
On MariaDB
I have simple table with float data type
CREATE TABLE `testatt` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nilai` float DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=...
0
votes
0answers
8 views
Correct way to setup wsrep_notify in MariaDB
I have been running 5 cluster nodes in MariaDB 10.4/galera setup for quite sometime without any wsrep_notify_cmd configuration.
To test basic functionality, I added the notify script script and ...
0
votes
1answer
36 views
Why Federatedx Engine is very slow in MariaDB 10.6 and have to read all the table to get only first 10 rows? [duplicate]
I am trying to get 10 rows from one MariaDB to another MariaDB. However, It takes one and half minute.
I have created the table with federated engine pointing to remote MariaDB. Including all the ...
0
votes
1answer
15 views
Wordpress crash on slow queries related to wp_term and wp_term_taxonomy
I have a WordPress blog with around 90K articles. The problem is I get frequent crashes on the server and browsing is slow due to some slow queries on the website. I am suspecting the problem is with ...
0
votes
1answer
16 views
Table partitioning on external directory hitting "can't create table" error
I am trying to partition my tables by RANGE with the following command:
ALTER TABLE main_table
PARTITION BY RANGE (TO_DAYS(date_val))(
PARTITION old_db VALUES Less Than (TO_DAYS('2021-01-01')...
1
vote
1answer
33 views
MySQL InnoDB now has error after Windows 10 update [closed]
These two things are seemingly unrelated, but I have just done a Windows update, and all of a sudden, MariaDB won't start up. I get the following errors:
InnoDB: using atomic writes.
2021-08-11 14:10:...
0
votes
2answers
62 views
Why does GROUP BY on table A cause "using temporary; using filesort" on table B? [closed]
Given the following contrived example code:
SELECT A.author_name
, COUNT(T.title) AS num_titles
FROM authors A
JOIN titles T ON T.authorFK = A.authorPK
GROUP BY ...
0
votes
0answers
12 views
Replicating multiple unrelated servers
We have a bunch of live websites running simple LAMP stacks. We have nightly backups to the cloud, but this means that an event like the Strasbourg fire at OVH might happen just before your backup ...
0
votes
1answer
31 views
MariaDB on Ubuntu mysteriously goes away after 15 minutes [closed]
I have an issue I've never seen before...my MariaDB goes away after 1800 seconds, despite having the default configuration for wait_timeout of 28800 seconds.
I checked all my my.cnf files, and there ...
0
votes
1answer
47 views
Restore MySQL MariaDB Database from local files (without sql dump)?
first of all - I already read several other threads like Restoring MySQL database from physical files, but I'm unsure wether this will work for me since I'm running MariaDB and not MyISAM.
Let me ...
0
votes
2answers
34 views
How to resolve SQL error in stored procedure
I'm using MariaDB 10.5.9, my stored procedure:
CREATE DEFINER=`trainer`@`localhost` PROCEDURE `updateTrainee`(
IN `_txtTrainee` TEXT,
IN `_field` TEXT,
IN `_data` VARCHAR(16)
)
...