Skip to main content

Questions tagged [mariadb]

Open source RDBMS that forked from MySQL. Add a version-specific tag like mariadb-10.5 if that context is important.

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

Stuck at finding the syntax error in group_concat and prepare in MariaDB

This is a query to search all databases for a given string: set @searchTerm = 'vidfactor.com'; set @likePattern = concat('%', @searchTerm, '%'); drop table if exists Modules.Queries; drop table if ...
Saeed Neamati's user avatar
0 votes
0 answers
10 views

Compilation of MariaDB on Windows: Multiple cryptic errors

I'm trying to compile MariaDB from source on Windows 64-bit following the official documentation. During the compilation, many errors like the following (first one) occur: [...] pcre2_error.c C:\...
user7427029's user avatar
0 votes
0 answers
25 views

MariaDB completely stuck, can only kill process, what might have happened?

Saturday morning 6:30 I'm getting phone calls that "the server" is down. This thing runs a webserver and various other services, all of which were non-responsive. It turned out that the ...
musbur's user avatar
  • 101
0 votes
1 answer
70 views

MariaDB Crashes Every Time Restarted

OSX Sonoma, OSX Monterey Latest MariaDB from Homebrew (11.4.2-MariaDB, client 15.2 for osx10.17 (x86_64)) MariaDB won't start every time I restart the brew service or restart the computer. I ...
Penyo's user avatar
  • 1
0 votes
0 answers
16 views

Mariabackup incremental backup and prepare process

I want to start using Mariabackup to backup a fairly large MariaDB database (v 10.6, 250GB) - current backup is taken using VMWare snapshots but they are crash consistent. So far I have taken a weekly ...
bhttoan's user avatar
  • 111
0 votes
0 answers
18 views

Mariadb 10.11 on Debian 12 and character_set_database

I have a stock mariadb instance on debian 12 with no edits to the config files. When I create a table w/o specifying character set and collation, the table is created with latin1 and it's collation. ...
user44021's user avatar
0 votes
0 answers
9 views

Galera Cluster: All Nodes Slowed Down After Update Query and Too Many Connections Error

I met a disability while using galeracluser and I have a question. It is an active-active 3-node structure and maintains replication through log_slave_updates=ON. I'm using MariaDB 10.5.13 version ...
samsamsamsmasma's user avatar
1 vote
1 answer
78 views

Why MariaDB 11 isn't using DateTime index?

I've a big table (MariaDB 11.2) with many fields, but I'll resume the table like this: CREATE TABLE `GT_CalendariProfessional` ( `CalendariProfessionalID` BIGINT(20) NOT NULL AUTO_INCREMENT, `...
Dimas's user avatar
  • 131
0 votes
1 answer
36 views

MariaDB Performance Degradation After Brief 20 Hour Massive Improvement

Problem On 2024-05-07 20:00:00 we migrated our DB from MariaDB 10.5 on an 8 core 16GB RAM server with a 10GB innodb buffer pool to a MariaDB 10.11 server with 16 cores 32GB RAM and a 20GB buffer pool ...
Joe Keilty's user avatar
0 votes
1 answer
134 views

Mariadb upgrade from 10.3 to 10.11

Is it possible to upgrade from Maria 10.3 to 10.11. What are the necessary steps or any script that can be followed? Also I’m planning to upgrade my os from rhel7 to 8, what additional steps should I ...
madeinindia's user avatar
1 vote
1 answer
43 views

MySQL Trigger updating second table based on History and computed values

The Goal: Update an secondary table called Lottery_Cycle when an INSERT occours on table Lottery_History with some computed values and checking previous data. Let's say a lottery with 25 numbers of ...
Wisdom's user avatar
  • 11
2 votes
1 answer
45 views

MariaDB general query log - ID meaning

I use MariaDB and I needed general query log for debugging my app DB statements. I wonder what ID column actually means? Is it connection ID?
JohnyProkie's user avatar
1 vote
1 answer
53 views

Upgrading mariaDB from 10.3 to 10.11 InnoDB error

I tried updating my MariaDB server from 10.3 to 10.11.7 on my CentOS Stream virtual machine. I used the following statements: curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -...
Dennis's user avatar
  • 113
1 vote
1 answer
47 views

Weird behaviour with batch and trigger(MariaDB)

I found a weird issue involving mariadb. batch update from hibernate. the original question was added here : https://stackoverflow.com/questions/78204056/hibernate-sqlintegrityconstraintviolation-...
Rudy's user avatar
  • 151
0 votes
0 answers
19 views

MySQL no selected database without setCatalog

I run this query select * from database_name.table_name over JDBC and it fails. It fails with the exception : SQLTransientConnectionException: (conn=4444889) No database selected Caused by: ...
Petar Vasiljevic's user avatar
1 vote
0 answers
35 views

InnoDB LRU buffer issues on MariaDB 10.5

I'm in the process of upgrading all of our replicas from MariaDB 10.3 to 10.5. One of our rotations keeps running out of RAM. These hosts all have 128GB of RAM (for a ~350GB database). Buffer pool ...
radiatorhums's user avatar
0 votes
1 answer
42 views

MariaDB show system variables

I've installed MariaDB 11.2.2 on Windows to play a bit with the new database system and now my confusion. my.ini start parameters: slow_query_log = ON long_query_time = 0 log_slow_verbosity = ALL ...
Mainecoon21's user avatar
0 votes
1 answer
30 views

MariaDB: Why do user sessions sometimes freeze

Sometimes, the sessions I initiate with mariadb -h local freeze. Here's my latest example: MariaDB [(none)]> SELECT u I'm certain that I did not hit any extra keys. Then I did connect once more ...
viator's user avatar
  • 1
0 votes
0 answers
37 views

Mariadb can't enforce charset and collation to clients

I'm trying to force clients to use utf8mb4_unicode_520_ci and uft8mb4. I tried to add this to all my galera cluster nodes [mysqld] ... collation-server = utf8mb4_unicode_520_ci init-connect='SET NAMES ...
Freedo's user avatar
  • 196
2 votes
3 answers
1k views

MariaDB / MariaBackup : What is the best way to export/migrate a 700GB table to another server, but with only 200GB of free space at the origin?

Origin server: 1 table - InnoDB -> 700gb - 1.5 billion records (Free disk space: 200gb) Destination server is in the same network. The destination server will have a lot of free space, the origin ...
Cloud Strifes's user avatar
1 vote
1 answer
53 views

How can I get duplicate entry error on a table that only has one record?

db-fiddle This is the definition of my table: CREATE TABLE `Posts` ( `Id` bigint(20) NOT NULL AUTO_INCREMENT, `Guid` uuid NOT NULL DEFAULT uuid(), `Tenant` varchar(400) DEFAULT NULL, `Slug` ...
Saeed Neamati's user avatar
0 votes
0 answers
48 views

MariaDB Docker image: How to get meaningful log levels (everything is logged as error)?

I'm using the MariaDB docker image with podman for a Nextcloud instance. Everything works, but when I look at the logs (with podman logs or journalctl), everything is logged at log level error. It ...
Timo's user avatar
  • 11
0 votes
1 answer
36 views

Is expected that indexes on binary columns perform slower than those on bigint columns?

Running MariaDB 10.8.8 I've had to implement geo-targeting on my site. For this each night I pull the free IP-to-country dataset from ipinfo.io. I have a PHP script that then creates two tables, ...
Codemonkey's user avatar
1 vote
0 answers
101 views

How to optimize MariaDB for large WordPress/WooCommerce site?

I have moderate experience in working with WordPress and WooCommerce sites but I'm now for the first time working on a site which is a bit bigger and I'm facing issues where the MariaDB process gets ...
user1589375's user avatar
0 votes
0 answers
78 views

How to connect db link from oracle to maria db?

I would like to connect a db link from Oracle 11g built in a Linux environment to MariaDB(10), a package built in a Linux environment (Synology NAS). Please guide me. The IP and port of the two are ...
user avatar
0 votes
0 answers
38 views

How to create all-valid UUIDs from a given text for MariaDB?

I want to transfer data from SQL Server to MariaDB. In SQL Server, the image is stored as /image/id.png. In MariaDB it should be stored as UUID. I'm using C#. I want to convert those URLs to UUIDs. ...
Saeed Neamati's user avatar
-2 votes
1 answer
50 views

Why is it selecting date from another month that requested one? [closed]

I have a table that store time begin and time end of some events. I want to search in this table all even that were occuring during specific day. Here is example data: Id Date begin Date End Name 1 ...
Elikill58's user avatar
  • 221
0 votes
1 answer
212 views

Table 'any table' doesn't exist in engine without moving anything

Today after I guess a month or so I rebooted my server and now I get Table 'ANY TABLE' doesn't exist in engine in every InnoDB table that I want to open in phpMyAdmin. My ISAM tables are fine and ...
user1772630's user avatar
0 votes
0 answers
17 views

Skip Deleterows_v1 event errors MariaDB on replication slave

So i'm running an custom HA setup for CyberPanel. Now their is an issue that stops the replication: skip Could not execute Deleterows_v1 event error mariadb I wanna skip these errors. How can i do ...
KelvinCodes's user avatar
0 votes
1 answer
40 views

Unable to start RDS replication to MariaDB RDS instance from AuroraDB for MySQL instance

I am following this guide in order to migrate MariaDB RDS instance into AuroraDB for MySQL. https://aws.amazon.com/blogs/database/migrate-self-managed-mariadb-to-amazon-aurora-mysql/ Reduce downtime ...
tom10271's user avatar
  • 142
0 votes
0 answers
26 views

MariaDB problem importing timezones with mysql_tzinfo_to_sql

I use a Yocto based linux distribution with MariaDB 10.7.8. The time zones on the system based on /usr/share/zoneinfo work are: root@mymachine:~# date Tue Apr 16 06:05:36 UTC 2024 root@mymachine:~# ...
metalroot's user avatar
2 votes
4 answers
127 views

Performance issues of a queue implemented on top of InnoDB

Brief problem statement First thing first: after posting this question originally and working more with our DBAs, I actually learned that our DB runs in a container, instead of being installed ...
Dmitry Frank's user avatar
2 votes
1 answer
461 views

What is causing my ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)?

I'm using brew install mysql/brew install mariadb, and cannot find a way around the following error: ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2) Here are the ...
It's WPTom's user avatar
0 votes
1 answer
31 views

DBMS for multiple DB Enviroment Management

I have moved into a DBA role where I now manage multiple types of DBs. I used to manage only MS SQL and MySQL, but now I am managing MS SQL, Azure SQL, MySQL, MariaDB and PostgreSQL. I am currently ...
Elene Roos's user avatar
0 votes
0 answers
31 views

Unable to login to MariaDB, as root@localhost, with non root linux user

I have a MariaDB 10.3.13 server installed on Red Hat linux. I can only login to mysql, as root@localhost, through root linux user. Login to mysql server through non root linux user. It fails [dave@...
user3637971's user avatar
0 votes
1 answer
34 views

MariaDB 10.6 Slow replication - Relay log replay possibly?

I have one master and two slaves (will become one slave when this is resolved) The master is on a dedicated server that is very fast. The Old slave server that is in sync is on a busy shared server ...
Kevin Penn's user avatar
1 vote
1 answer
48 views

How I can order my results by relevance when using like?

In a mysql (or mariadb) table: mytable: --- id PK Biginteger Autoincrement name varchar(255) I search stuff like this: select * from mytable where name like "%someval%"; The searchterm ...
Dimitrios Desyllas's user avatar
0 votes
0 answers
26 views

Why my fulltext search fails to return values?

I am experementing upon fulltext search using the following example: CREATE TABLE `search_demo` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`...
Dimitrios Desyllas's user avatar
1 vote
2 answers
107 views

Why is this query running so slowly?

My system (OpenMage / Magento 1) is running some queries like the following and even though it's not using any large tables it seems that they take an abnormally high amount of time to execute. ...
gabtzi's user avatar
  • 161
0 votes
1 answer
22 views

Kubernetes create cluster multimaster using bitnami/mariadb-galera

I'm trying to deploy mariadb-galera multimaster on kubernetes. But when I set external volume I receive this error: mkdir: cannot create directory '/bitnami/mariadb/data': Permission denied this is ...
Marco Ferrara's user avatar
1 vote
2 answers
127 views

ERROR InnoDB: MySQL-8.0 tablespace in ./ibdata1

I am currently unable to restart [what I thought was] a previously working version of mariadb. Rocky Linux 8.6 server crashed during yum update and became unbootable. I installed Rocky Linux 9.3 and ...
jlm's user avatar
  • 21
0 votes
1 answer
41 views

CREATE TABLE vs ALTER TABLE

Is there difference in disk space usage and performance between table (InnoDB) created "at once" with CREATE TABLE or result from multiple structure changes ADD/DROP COLUMN/INDEX.
i486's user avatar
  • 235
0 votes
1 answer
22 views

Change MariaDB "ADMIN_OPTION" of a ROLE after deleting the user who created it

I have a problem in the prod : I have a user named dba who has all privileges with grant option, i used it to create a role named test, i granted some rights to the role test and granted the role test ...
Firas Megrahi's user avatar
2 votes
1 answer
91 views

MySQL default TRANSACTION ISOLATION LEVEL

AFAIK, in MS SQL, PostgreSQL, Oracle and probably others, the default transaction isolation level is READ COMMITTED. Why in MySQL and MariaDB it is REPEATABLE READ?
i486's user avatar
  • 235
1 vote
0 answers
179 views

auto restart mariadb.service if oom-kill killed main process

I need some help trying to figure out why my mariadb service isn't automatically restarting upon crashing, likely due to insufficient memory on the server. Essentially, my server operates at around 75%...
Ryan H's user avatar
  • 111
1 vote
2 answers
48 views

Query performance drops off a cliff with additional JOINs - can I fix this by adjusting a parameter?

Running 10.8.8-MariaDB-log I have a very complex query for a comparison site. Essentially SELECT <columns> FROM <tables> JOIN <derived table 1 for first comparison> ...
Codemonkey's user avatar
0 votes
1 answer
49 views

Mariadb Galera can't start second node

EDIT: the both server was in Azure I tried to install Galera replication on two server. On my first server the "bootstrap" node will correctly start. When i try to start the second node with ...
Inazo's user avatar
  • 101
3 votes
5 answers
865 views

Is COMPACT a better format for fixed length rows than DYNAMIC?

In MySQL / MariaDB I have this table with fixed-length rows (no VARCHAR, TEXT, etc) CREATE TABLE trigram ( id BIGINT(20) NOT NULL, trigram CHAR(3) NOT NULL COLLATE 'utf8mb4_general_ci', ...
O. Jones's user avatar
  • 563
1 vote
2 answers
41 views

MariaDB Foreign Key Pair that references System-Versioned Table Record

I'm altering an open-source booking system to match my employer's needs. I'd like to make it so that editing or deleting a service does not necessarily modify or delete the service that is referenced ...
Nick Parrill's user avatar
0 votes
1 answer
16 views

Maria DB Managing JSON

I have a field in a MariaDB database with the following information: {"Portal Content":{"Colours": {"Primary":"String","Secondary":"String",&...
Adam Hewitt's user avatar

1
2 3 4 5
55