Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.5]

100 questions
1
vote
1 answer

MariaDB 10.5.5 Database extremely slow after mysqldump

We have this problem on 2 separate installs. MariaDB 5.x installed. Once the daily backup is done, the database is almost unusable. We have TS environments and a DB server - mysql 5.1 running on the TS machines but we have two older sites doing the…
MortalTree
  • 11
  • 1
1
vote
0 answers

MariaDB query JSON result escapes a double quote in text column as \\"

I'm converting an SQL query to JSON using something like: SELECT JSON_ARRAYAGG(JSON_OBJECT('field1', field1, ...)) FROM db.table One of my columns of string type contain simple ASCII strings with double quotes (") here and there. My problem is that…
meaning-matters
  • 21,929
  • 10
  • 82
  • 142
1
vote
1 answer

Meaning of percentage in rows section in explain output of mariadb 10.5

I recently moved to mariadb 10.5, and have encountered this specific output where a percentage is shown along with rows in explain output. I couldn't find any documentation for the same, probably it's a new feature. What exactly does that mean? Is…
Himanshu Mishra
  • 310
  • 3
  • 13
0
votes
0 answers

MariaDB GRANT command fails with syntax error

I'm trying to execute: GRANT SYSTEM VARIABLES ADMIN on *.* TO thomas; on MariaDB 10.5, but it fails with: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right…
Thomas Larsen
  • 11
  • 2
0
votes
3 answers

MAriadb optimizing query for averaging

I have database like this (in real there are over 30 different sKey): +----+------+------+---------------------+ |ID | sKey | sVal | timestamp | +----+------+------+---------------------+ | 1 | temp | 19 | 2023-07-14 20:32:06 | | 2 |…
eSlavko
  • 348
  • 3
  • 12
0
votes
0 answers

phpMyAdmin not finding/readin config.inc.php

as the topic says, phpMyAdmin isn't finding or reading the config.inc.php file. I found quite a few posts regarding something similar, but they all seem to deal with permissions and this doesn't seem to be the case. To test whether or not…
John
  • 65
  • 2
  • 13
0
votes
1 answer

Using Ansible to change initial mariadb-server root password is giving access denied

I have instaledl mariadb-server using the dnf module and when it comes time to change the default blank password, I have no success with various options passed to the mysql_user module. Access denied even tho I can "login" directly with the root/…
enigmaedge
  • 15
  • 2
0
votes
0 answers

Fresh install of mariadb as a service in nginx container cannot retrieve db data

I've installed linuxserver nginx as a docker container. Which contains PHP. tested, and all works as expected eg can serve PHP pages etc. I've tried to add mariadb as a service to the same stack. The container runs fine. However when trying to…
PHP Addict
  • 71
  • 1
  • 9
0
votes
1 answer

Python mariadb-connector function returns empty cursor.fetchall() on 252nd iteration with different WHERE clauses

Caveats: Linux Distribution prevents upgrade beyond connector 3.1.20 and thus python module 1.0.11 Versions from /usr/bin/mariadb_config Copyright 2011-2020 MariaDB Corporation AB Get compiler flags for using the MariaDB Connector/C. Usage:…
Joe Greene
  • 61
  • 1
  • 7
0
votes
1 answer

Return a record if no other similar record exists

i have a question to ask, it is related to mariadb sql language >10.4. I have this database with these fields and these values entered ir_f id_r description 1 0 linea 1 1 0 linea 2 1 0 linea 3 2 0 linea 15 2 0 linea 16 2 17 linea…
Luigi Brambilla
  • 1
  • 1
  • 2
0
votes
1 answer

MariaDB Galera Cluster configuration file is shutting down mariadb Container

I have 3 instances of MariaDB running in containers in VM host. I set up bridge network for the 3 containers and I can ping the containers from inside each of them. The storage and the config paths are bind-mounted to the directory of the host…
olufemi
  • 13
  • 3
0
votes
1 answer

Atomicity of stored functions

Unlike stored procedures, which can explicitly start & commit transactions, stored functions can't contain "Statements that perform explicit or implicit commits or rollbacks". Documentation is pretty clear about that, it's getting a little vague,…
sp3ctre
  • 1
  • 1
0
votes
0 answers

MySQL QUOTE function returning Japanese (Mojibake)

The QUOTE function is sometimes returning jibberish, instead of the expected behavior. Please see below. Any help or insight you can provide would be greatly appreciated. Thanks! Below QUOTE returns NULL, as expected... mysql -f -h localhost -P…
Victor Rodriguez
  • 11
  • 2
0
votes
2 answers

threadpool thread could not be created

We got this warning on the MariaDb server ,never saw this before Warning : threadpool thread could not be created :Resource temporarily unavailable,current number of threads in pool 12 Google isnt helpful at this time with this & chatGPT is down…
Tarek
  • 3,810
  • 3
  • 36
  • 62
0
votes
2 answers

MariaDB Python OperationalError: This feature is not implemented or disabled

I've compiled and installed Python 3.10.9 (from .tar) and mariadb-c-connector (from official Github repo) on my Debian 11 (bullseye) machine. I also installed: ufw, fail2ban, mariadb-server, mariadb-client. Now if i install mariadb in my Python…
Luca
  • 344
  • 5
  • 18
1 2
3
4 5 6 7