Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mariadb-10.5]

89 questions
4
votes
1 answer

How to fix performance issue with row_number and multiple schema?

After receiving answer to How can I get a valid rank counter?, I adapted to my own system. But now, I have a performance issue. All of my requests are very fast (less than 0.0005s for most of them), but when using ROW_NUMBER() with multiple schemas,…
Elikill58
  • 181
  • 3
  • 11
4
votes
2 answers

Having charset "utf8mb4" - does it mean every character takes 4 bytes, or only those that need 4 bytes?

I have a VARCHAR(80) utf8mb4 column, and I'm testing adding some ASCII & Emoji characters, and use LENGTH() and CHAR_LENGTH() to understand the differences. From reading in different places, my understanding is that each character on a utf8mb4…
Nuno
  • 829
  • 1
  • 12
  • 24
4
votes
2 answers

mysqldump select queries appearing in slow query log after upgrade

We recently upgraded from MariaDB 5.5 to MariaDB 10.5 Since doing so, we have a couple of select queries appearing in the slow query log when we backup databases using mysqldump. One of the tables is an InnoDB table with 125,000 records. The other…
MrCarrot
  • 141
  • 6
3
votes
2 answers

MariaDB 10.5 Migration Questions

I have a question, and I've found one similar addressed, which I was going to respond to with my own questions (Live database migration MariaDB 10.5 to MySQL 8.0), however, as that post/question is over a year old, I thought it may be better for me…
BEGRAFX
  • 31
  • 3
3
votes
2 answers

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 Server We are running MariaDB 10.5.4 Our server is…
Dimi
  • 133
  • 1
  • 4
3
votes
1 answer

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. Master and slave are configured and the slave is…
James
  • 31
  • 1
2
votes
1 answer

Unique key allows duplicates

I have a database of members of an organization. The data is really messy - the leader had a catastrophic medical issue, so I'm trying to make a sensible database out of Claris Filemaker Pro. I'm trying to look for duplicates. There are some -…
J. Gwinner
  • 131
  • 7
2
votes
0 answers

SOLVED - Mariadb replication Master Slave fail with error code 1595

I've a strange problem. A Mariadb replication start failing since this morning. Until today everything works fine from month. This is my scenario: I've a server in a DC which is the master, and a server in another DC (slave) Mysql port on master is…
Paolo Daniele
  • 21
  • 4
2
votes
2 answers

Finding gaps between the values of a column in MySQL

At a table of movie actors, CREATE TABLE ArtistMap ( ArtistID int(11) unsigned NOT NULL, MovieID int(11) unsigned NOT NULL, Year year, INDEX(MovieID), INDEX(Year), PRIMARY KEY(ArtistID,MovieID) ) ENGINE=InnoDB How can I select movies of an artist…
Googlebot
  • 4,551
  • 26
  • 70
  • 96
2
votes
4 answers

Tuning innoDB for a write-intensive machine

I have MariaDB 10.5 on my desktop with multiple disks (SSD and HDD) for write-intensive projects. Writing to a single table is fast and the percentage of dirty pages remains close to zero with 1000-3000 writes/s. However, when I actively write to…
Googlebot
  • 4,551
  • 26
  • 70
  • 96
2
votes
1 answer

MariaDB Galera Arbitrator failing to sync with SSL

So the scenario is this. I have already setup a 4 node MariaDB Galera cluster (10.5). I'm also adding on top a 5th Galera Arbitrator and everything syncs and connects just fine. However when I enable SSL on the cluster ( after bootstrapping it from…
LefterisL
  • 147
  • 1
  • 5
2
votes
3 answers

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 can be used to make sure monitoring systems…
wedi
  • 121
  • 3
1
vote
2 answers

How to concatenate multiple JSON arrays into a single array in MariaDB?

I'm working with a MariaDB database where I have a table with two columns: id and values, where values contains JSON arrays. Here is a simplified example of the data: id values 1 "[1, 2, 3]" 1 "[5]" 2 "[4]" I want to group the rows by…
Emax
  • 111
  • 1
1
vote
2 answers

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 reinstalled mariadb and mariadb-server. Mariadb…
jlm
  • 21
  • 4
1
vote
1 answer

Optimize MariaDB for Drupal 10 to handle more users

I have problems with my Drupal 10/MariaDB 10.5/PHP 8.1 website when they are 20 users simultaniously. The website goes down and the response time is really big (up to 30seconds sometimes) because php-fpm process falls (see locust tests). I've…
mt.i.1
  • 11
  • 2
1
2 3 4 5 6