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
1k views

Setting custom MariaDB max_allowed_packet value in Debian 11?

[This is more of an OS config file question, but I have had no response on Unix.SE, so I am hoping that the 'join' of DB admins and sysadmins here may result in better luck…] Our Moodle server, ...
1 vote
1 answer
798 views

MariaDB: Duplicate entry for key on OPTIMIZE with no duplications

There is a table named contracts with following structure: MariaDB [db_name]> DESCRIBE `contracts`; +-----------------------------+--------------+------+-----+---------+----------------+ | Field ...
1 vote
1 answer
442 views

How do I recover from Mariadb(10.4.18) binlog corruption

I have a 3 node Mariadb Galera cluster running Mariadb 10.4.18 on ubuntu 18.4. I applied updates to one of the nodes this morning and now Mariadb doesn't start on that node with the following error. [...
1 vote
1 answer
1k views

Mariadb (MySQL) On Windows- problem entering non-ASCII characters in a query

MariaDB: mysql Ver 15.1 Distrib 10.3.8-MariaDB OS: Windows 7 Pro 64 bit I have my server database and client all set up (I believe) to support utf8 end to end- (**my.cnf**) # # Set everything to ...
0 votes
0 answers
10 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 ...
1 vote
1 answer
3k views

Connecting client application to MariaDB Galera cluster

I currently have a REST API written in Flask that connects to a MariaDB server. I'm thinking about replacing the server with a Galera cluster to improve availability and ensure continuity in case one ...
0 votes
1 answer
278 views

MariaDB Galera estimated database size is different from each node

newbie question, why does my database size differs from other nodes in the cluster when I run: SELECT table_schema "database", sum(data_length + index_length)/1024/1024/1024 "size in GB&...
0 votes
1 answer
2k views

Mariadb/MyISAM: Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an

We have a db with around 150 tables in, of which about 30 or so are partitioned as such : ALTER TABLE `myTable` REORGANIZE PARTITION PFUTURE INTO (PARTITION P201910 VALUES LESS THAN ('2019-11-01'), ...
4 votes
2 answers
6k views

How to fix high memory usage of MariaDB?

I am using MariaDB(10.1.21) with following storage engines: InnoDB TokuDB Spider Engine System Configuration is : 3GB RAM Dual Core Processor I have tried pt-mysql-summary tool to identify the ...
1 vote
1 answer
1k views

deadlock in mariadb: with non-index & fk table

when i try to do an operation concurrently, there exists an deadlock from mariadb show engine innodb status, the deadlock log is as follows ------------------------ LATEST DETECTED DEADLOCK ----------...
0 votes
1 answer
4k views

InnoDB: Error: log sequence number is in the future!

Hi I have 2 node cluster where recently went offline not sure why. Node1 started fine and all the traffic is on node 1 but node 2 still down due to below error. I tried set the inodb recovery to 3 and ...
1 vote
1 answer
2k views

When do you need to run Analyze Table on MariaDB?

We have migrated a few large databases from earlier version of 10.1.22 to 10.6.7 - the latest provided by ubuntu repo for 22.04. All was well for a few weeks and then we started seeing very slow ...
0 votes
0 answers
6 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 ...
0 votes
1 answer
398 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
0 answers
12 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. ...
0 votes
3 answers
847 views

Mysql query that is very quick (but sometimes very slow) versus an alternative version of the same query that is consistently a *bit* slow

I have a query that is part of a larger query. I have tried two versions of the query to try to improve the page run time. One version runs almost instantaneously.. but sometimes (approx one in 50) ...
1 vote
1 answer
3k views

MariaDB crashes on mismatched tablespace ID for InnoDB

I'm having an issue with some corrupted InnoDB tables on a stand-alone MariaDB 10.1 server running on Debian Stretch. I've encountered this issue in the past, but never found a working solution, so I ...
0 votes
0 answers
7 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 ...
5 votes
2 answers
8k views

How to make a FULLTEXT search with ORDER BY fast?

I'm trying to get a simple FULLTEXT match to be faster when using order by on another column on a table with over 100 million rows. The basis is one table with a fulltext on two columns and I want to ...
1 vote
1 answer
1k 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 ...
0 votes
1 answer
374 views

mysql.gtid_executed table is empty

I want to keep track of GTIDs and the corresponding mysqlbin log somewhere. I see this mysql.gtid_executed table, however on my mariadb DB, there are no rows in this table. Any idea how this gets ...
0 votes
2 answers
437 views

MySQL/MariaDB data directory backup

I am using a solution of backblaze B2 / duplicity / duply to create backups of my databases. I upload full backups and incremental backups to B2 using duplicity via duply. The incrementals are done ...
0 votes
1 answer
467 views

MariaDB tmpdir & table copy operations

I have a Linux server & MariaDB v10.0.33, where tmpdir is tmpfs (ram), for fast temporary table access; tmpfs is obviously limited in size. MariaDB seems to use the same tmpdir location for alter ...
3 votes
1 answer
2k views

(Got an error reading communication packets) but no error on client

i've search a lot about this thread without results. we don't know how to resolve this: DB : mariaDB SERVER: Microsoft Azure enviroment: Nodejs with Knex (pool connections, min 0 max 300) our client ...
0 votes
1 answer
3k views

Mysql_upgrade fails, table is corrupted

I have a mariaDB with a table that is corrupted. It's useless data to me, so I've tried to drop the schema but it won't drop. Instead, it gives me this error when trying to drop it: "Error Code: 1805....
0 votes
2 answers
435 views

in Mariadb - Can you cache the indexes and data for Aria Storage engine tables?

I have a table that is a read-only table (real-time view), I used Aria based on the recommendation for read-heavy workload. Based on this What are the main differences between InnoDB and MyISAM? When ...
0 votes
1 answer
610 views

MySQL Conditional Counter Based Other Columns?

I have a query that returns purchases for all customers in a store across a date range. It works fine, but now I've been asked to modify the results so only the first purchase per customer per day is ...
1 vote
1 answer
74 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, `...
0 votes
1 answer
568 views

Deadlocks appeared after moving to MariaDB10.2 from MySQL5.5

After moving to mariadb-server-10.2 from mysql5.5 I am facing deadlock issues. Please see the output of 'show full processlist'. Can someone give some suggestion? | 162506 | catalog | ...
0 votes
2 answers
4k views

SQL Get All Data With The Given IDs And With The Same Data On Single Column

So, basically, I have this table +------------------- |id | col1 | name | |----|------|------| | 1 | a | la | | 2 | b | ria | | 3 | w | la | | 4 | q | la | | 5 | y | ria | ...
2 votes
2 answers
1k views

Mysql And Galera cluster mariaDB , Private and Public IP Addresses multisite

I am just wondering has anyone come accross this before and the best method to go about doing it. We have a customer that wants multi site replication over a galera cluster. I am familiar with setting ...
1 vote
1 answer
466 views

Inconsistent results with MySQL, query never ends on MariaDB

We have some really strange behaviour on MySQL (8.0.29) that we can't explain. We have 2 tables + 1 link table in-between, illustrated by this schema : We run a query whereby we need to fetch the id ...
0 votes
2 answers
5k views

MariaDB Galera Cluster initial rsync replication failing

I'm trying to install a new galera cluster. The primary host started fine, but the secondaries are failing during the state transfer with rsync, and are not starting. I haven't been able to fix the ...
3 votes
1 answer
9k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction https://software.mirantis.com/reference-documentation-on-...
2 votes
1 answer
700 views

MariaDB: Querying a timestamp partition

I'm having difficulties getting my queries to make use of the partitions when I'm selecting. They need to be able to do > sometime > sometime and between sometime and anothertime. However, if I ...
2 votes
1 answer
926 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
1 answer
32 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 ...
1 vote
1 answer
3k views

LOAD_FILE() works on SELECT, but returns NULL on insert

I'm having troubles using the LOAD_FILE() function in my environment. I'm trying to add a file to a BLOB field but whenever I try to insert or update this field with LOAD_FILE(), this field is being ...
2 votes
1 answer
2k views

Very slow query on MariaDB 10.3 compared to MySQL 5.5.50

I already discussed how much slower performance I have experienced on MariaDB 10.3 compared to MySQL 5.5 for some queries in my previously posted thread, but I am now struggling with a specific kind ...
0 votes
1 answer
439 views

InnoDB engine getting disabled after decreasing innodb_page_size to 4K

I'm trying to optimize my database (mariadb) for high write (insert & update). Database is running fine with default innodb_page_size (16K), but when I decrease the value of innodb_page_size=4K. ...
0 votes
1 answer
420 views

Select all customers and number of orders per month as csv

This is what I have: customer -------- customerId INT(10) name TINYTEXT phone VARCHAR(10) ... order ----- orderId int(10) customerId INT(10) dateCompleted DATETIME ... This is what I need: custId ...
2 votes
1 answer
639 views

Why would INSERT, REPLACE or UPDATE statements sometimes take over 1 second to execute?

I have a very good server (great CPU, huge RAM, NVMe) with a huge InnoDB buffer pool that's not full yet. The website is very write-intensive, but it runs fast enough (SELECT queries well optimized, ...
2 votes
1 answer
287 views

What dump file options or MariaDB setting is slowing down the load of data?

Context: Loading a copy of a legacy DB for a CRUD app at build by Spring Boot. Primary use case is developers testing the CRUD functionality as it is developed. Problem: The loading operation is ...
0 votes
1 answer
487 views

Monitor existing cluster using Galera Manager throwing: deployment status error: DB IP address must be provided

I am trying to monitor my existing galera cluster using galera manager. I installed galera manager and chose Monitor existing cluster. I added the ssh keys provided in the manager in the respective ...
0 votes
1 answer
4k views

Mysql innodb recover from frm and ibd

There are numerous question (in this site and elsewhere on the internet) about how to recover innodb database from *.frm and *.ibd file (the point: when you have the undamaged ibdata1). Situation: I ...
0 votes
1 answer
524 views

MariaDB LOAD DATA INFO can't import single column file to single column table?

I am trying to import the 10,000 common password list into a table to ban those passwords from being used in a given system. The file is a single column TXT file. Trying to LOAD DATA INFILE that into ...
2 votes
1 answer
411 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 ...
0 votes
1 answer
453 views

MariaDB large number of sessions waiting on index_tree_rw_lock

I have a MariaDB RDS instance that is mostly saving batched insert statements to 4 tables. These inserts have batches of an average of 200/batch and each statement saves to a single table. However, ...
0 votes
3 answers
5k views

SQL Query to filter from an Array

I wasnt sure how to title this question. I have a database of suppliers, a simplified version is shown below. Company Vehicles X ["Van", "Luton", "Artic"] Y ["Van&...
0 votes
1 answer
282 views

Mariadb: Sometimes inserts made during mysqldump are stuck forever in Updating state, and then service mariadb restart never finishes - how to debug?

I have a simple innodb Mariadb database used for logging (only inserts with insert ignore into a single large table). I back up the database nightly with mysqldump --no-create-info --hex-blob --...

1
2 3 4 5
55