Database Administrators

Questions tagged [mariadb-10.5]

Ask Question

The tag has no usage guidance.

15 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0
votes
3answers
28 views

Server with mariadb sometimes dies under high load

I have a dedicated server i7-4770 with 32GB RAM. On server installed CentOs 7.8, MariaDB 10.5.8, PHP 7.4.14, Nginx 16.1. All tables in the database are InnoDB. When the load on the database increases ...
1
vote
2answers
96 views

High CPU usage, low memory usage on Mariadb 10.5.8 — SQL tuner complaining about memory, performance seems fine

I'm hoping to get some friendly advice how to proceed with optimizing this server. VM: 8vCPU - 2.6GHz 32GB mem Disk speed ~3Gbps (380MBps) Application is Librenms my.cnf.d/server.cnf -- Built from ...
0
votes
0answers
17 views

MariaDB doesn't read all options from /etc/mysql/conf.d/ after upgrade

I am using Ubuntu 20.04LTS. I upgraded Mariadb 10.5.5 to 10.5.8 using mariadb's own repositories. After upgrade I noticed API server was unable to connect to DB server through private network. After ...
1
vote
2answers
83 views

Troubleshooting high memory usage on MariaDB 10.5.4

I am experiencing very high memory usage on MariaDB server. I am not sure if it is due to misconfiguration or a bug. Server: MariaDB Server version: 10.5.4-MariaDB MariaDB ...
1
vote
1answer
25 views

Can I upgrade MariaDB replication infrastructure gradually?

I have 2 masters and 1 slave (replicating form both masters). M1- MariaDB 10.4.11 M2- MariaDB 10.4.16 S1- MariaDB 10.4.12 I want to upgrade this LIVE system to 10.5 with possibly 0 downtime. The idea ...
1
vote
2answers
39 views

How to order by COUNT(*) of unique entries in GROUP BY?

I search through a tag_map as SELECT ArticleID,COUNT(*) AS C FROM WordMap WHERE WordID IN( SELECT WordID FROM Words WHERE Word IN ('word1', 'word2') ) GROUP BY ArticleID ORDER BY C DESC I want to ...
0
votes
1answer
15 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
33 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 ...
2
votes
1answer
51 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. ...
1
vote
1answer
22 views

Why is it not a good idea to use MariaDB's extra_port for replication?

MariaDB has an extra_port for administrative access that helps in cases the thread pool or main port is locked up. MariaDB's documentation says it's use case is primarily administrative access and it ...
1
vote
2answers
226 views

How can I use LOAD DATA LOCAL INFILE for specific columns?

I have a directory of text files, as the filename is the id, and the content text for this table: CREATE TABLE texts ( ID int(11) unsigned, Added date, Text MEDIUMTEXT, PRIMARY KEY(ID) ) ENGINE=InnoDB ...
1
vote
1answer
152 views

InnoDB Buffer pool not showing as much I configured in MariaDB 10.5

I'm using MariaDB 10.5 on Centos7 with 4G RAM and 2 CPU. Here's my.cnf configuration [mysqld] log-error=/var/lib/mysql/mysql-3.kannel.com.err max_allowed_packet=1G event_scheduler = ON ...
1
vote
1answer
18 views

How to JOIN a table with itself while using a sub-query?

I JOIN a table to itself as SELECT t1.TagID AS TagID1 ,t2.TagID AS TagID2 ,COUNT(1) FROM TagMap AS t1 JOIN TagMap AS t2 ON t1.ArticleID = t2.ArticleID AND t1.TagID <> t2.TagID GROUP BY ...
0
votes
1answer
27 views

How to COUNT co-tags from a tag_map table in mysql?

I have a simple tag_map table CREATE TABLE TagMap ( TagID mediumint(7) unsigned, ArticleID int(11) unsigned, FOREIGN KEY(TagID) REFERENCES Tags(TagID) ON DELETE CASCADE, FOREIGN KEY(ArticleID) ...
0
votes
1answer
24 views

How to add all combinations of two pairs of key-value to a table?

I have a database of items, as each item has a set of key-value pairs such place => london field => engineering since I frequently need to find items having the same two key-value sets. I ...