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
0 answers
119 views

Storing hex and random bytes data in MariaDB

For different password verification mechanisms, we use randomly created variables which we have to store within the db, more precisely we use: bin2hex( random_bytes( x ) ) values that we store in ...
  • 149
0 votes
1 answer
12 views

How to query a condition on a single object of sql record?

I'll try my best to explain the situation here. We are using MariaDB. In certain case we are looping over all the records/rows of a REQUESTS table. and for each object/record we are checking few ...
0 votes
0 answers
68 views

Duplicate foreign key selections when trying to select from dropdown list

I imported information in to phpmyadmin database and every foreign key i select from dropdown list i get duplicates of it. Ones that are sorted by alphabet and ones that are sorted from 1 to ... Like ...
1 vote
2 answers
365 views

How to free up hard drive space after deleting millions upon millions of records in mariadb

We have an application where we are receiving information seconds apart, we record this information in a table that we call events, which currently weighs 240 GB, this is the largest we have so far. ...
0 votes
1 answer
72 views

How do I Convert A Single Database From MySQL DB to MariaDB?

The web host that I use provides free database via MySQL v5.6.38. Recently, they switched to MariaDB v10.3.31 They converted all my databases and all my apps still work as expected. The problem is I'...
0 votes
0 answers
155 views

Can't use ODBC to connect to MariaDB

Linux Mint 20 (Ubuntu 20). MariaDB version: "mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2" LibreOffice 6.4.7.2. I want to run LibreOffice Base ...
0 votes
0 answers
64 views

How to access a VPN client directly from VPN server via IP address

I am running a MariaDB server and an OpenVPN server (SoftEther in this case) on an Ubuntu 20.04 LTS machine. On my Raspberry Pi, I am running a MariaDB server aswell. My goal is to enable a Master-...
user avatar
0 votes
1 answer
70 views

statistics on what queries were executed and how many times

I'd like to monitor how many times certain queries are executed. Take a look at the 3 queries below, the second and third are written as prepared statement. SELECT COUNT(*) FROM TABLE1 UPDATE TABLE2 ...
  • 243
0 votes
0 answers
77 views

How to set up a remote MariaDB server to work on webphpmyadmin/ampache?

I'm trying to setup a remote MariaDB server that I can login to with https://webphpmyadmin.com/index.php. I'm actually using webphpmyadmin to test to see if I can login to my MariaDB server from the ...
  • 1
0 votes
1 answer
49 views

How to log deadlocks for each database separately

I have MariaDB 10.6.5 server with several databases. I added a line innodb_print_all_deadlocks = 1 to config file. Now all deadlocks are logged to one file /var/log/mysql/mariadb.err Is there any way ...
0 votes
2 answers
212 views

Problem importing a Dump on MariaDB (Ubuntu 20.04.4 LTS)

I am writing this post because I cannot import a dump on MariaDB (Version 15.1) using Ubuntu 20.04.4 LTS. I did this dump a few weeks ago and now trying to import it using the command mysql -u root -p ...
0 votes
0 answers
39 views

Does Eperi Gateway for Databases still exist?

Is Eperi Gateway for Databases still offered and maintained? We are interested in implementing TDE (transparent data encryption) on our MariaDB servers in order to have encryption of data at rest. ...
0 votes
1 answer
32 views

CVE Live Patching for Database

Quick question regarding the Database patching, especially on the CVE. Did you see if this technology of live patching is very important to have to our open-source database? Mean I don't even need to ...
0 votes
0 answers
56 views

Add new table to existing Google Data Fusion replication job

I have functional replication job (MariaDB to BigQuery) in Google Data Fusion - replication module (accelerator), which was pretty simple to configure and it works great, even when altering tables. ...
  • 1
0 votes
0 answers
31 views

How do I write MariaDB query results to several different outfiles on client side?

I have MariaDB server and client 10.5.12 both running on the same Debian 11 PC. I am running several SQL queries from a file that I pass to the MariaDB shell client: mysql < autoreport.sql I would ...
  • 1
0 votes
0 answers
166 views

IN clause with large value slower on mariadb compare to mysql 5.5

I'm searching for a reason that explain why a request is slower on mariadb compare to mysql The request is pretty simple : select id, firstname, lastname from users where id in (1,2,...20000); Yes it'...
0 votes
1 answer
218 views

secure_file_priv and mysqlimport

Question: How can we avoid errors of the following type with mysqlimport when the data file is in the current directory? mysqlimport: Error: 13, Can't get stat of '/var/lib/mysql/«dbname»/«tablename»....
  • 245
0 votes
0 answers
15 views

GROUP BY and Clausule are making the query slow

I have a basic query, however for some reason the Group By and "ee.endereco_estado_id=1" are slowing it down, if I take either one it runs fast The cardinality is cliente - endereco NxN(Many ...
0 votes
0 answers
28 views

Error: #1005 - Can't create table `laboras1`.`preke` (errno: 150 "Foreign key constraint is incorrectly formed")

I'm making a new database in MySQL in which after making the PREKE table I receive an error when trying to create table laboras1 CREATE TABLE PREKE ( prekės_kodas int NOT NULL, pavadinimas varchar (50)...
1 vote
0 answers
267 views

MariaDB using 1000+ parameters with EXPLAIN

Can you confirm if this is a bug... I cannot work out if it's MariaDB (10.3.34 or 10.7.3), PHP (mysqlnd), or a mistake I've made: <?php $db = new mysqli('host', 'user', 'pass', 'database'); //...
0 votes
1 answer
58 views

MariaDB database has no 'max_used_connections'

I have a running MariaDB which has no max_used_connections variable. How can I see it? I got the list of all variables using the following command from the shell: SHOW VARIABLES; but it was not there....
2 votes
1 answer
38 views

Does executing mysql dump files trigger replication?

I have two servers A and B that have a source/replica replication set up. I need to bring a new database over from another server, say server C. If I create a dump file of it, and then execute the ...
1 vote
2 answers
259 views

How do I find out what's causing processes to wait for table flush?

I'm currently using MariaDB 10.3 and am troubleshooting this case where threads will start to build up until the MySQL service eventually has to be restarted. I was able to capture the process list ...
  • 109
0 votes
1 answer
55 views

Why is there a big gap in the actual Table space? (calculated vs information_schema vs file size)

I have a InnoDB table with the following columns: BIGINT -> 8 bytes BIGINT -> 8 bytes ENUM(0,1) -> 1 byte MEDIUMINT -> 3 bytes INT -> 4 bytes = 24 bytes per row It contains 10454004 ...
  • 634
0 votes
0 answers
17 views

Recover profile of deleted user from backup, and inject into working MYSQL database

Can someone specify a procedure to recover the complete profile of a deleted user, extracting the old data from a backup (gz compressed MySQL) and injecting it into the empty profile of the working ...
2 votes
0 answers
41 views

mysql stopped working after no free space on file system [corruption]

I am experiencing the following error when launching MySQL. can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket '/var/...
  • 21
0 votes
0 answers
28 views

Does AWS RDS MariabDb supports automatic failover?

We want to use AWS RDS to store our app's data. We are leaning towards MariaDb because of its temporal tables feature. And hence not chosing AWS Aurora with MySQL. Another reason being even though ...
  • 121
0 votes
1 answer
43 views

Using Indexing When Performing JOINs on Part of a Composite Key

I have a table in my database (hosted on MariaDB) that looks like this (I have given the definition in SQLAlchemy), class Address(Base): __tablename__ = 'address' __table_args__ = {'schema': DB_NAME} ...
0 votes
3 answers
819 views

MySQL dump import into MariaDB syntax error to use near '*/'

This is the result from mysqldump 10.13 and MySQL 8.0.28 Server. /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` int(11) DEFAULT ...
  • 121
0 votes
3 answers
161 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) ...
  • 619
-2 votes
2 answers
36 views

Get count of unmapped records when using a mapping table

I have 3 tables as such Product Product ID Product Details 1 ... 2 ... 3 ... Vendor Vendor ID Vendor Details 1 ... 2 ... 3 ... Product Vendors Product ID Vendor ID 1 1 2 1 1 2 2 2 3 2 ...
  • 107
2 votes
3 answers
432 views

How to get more connections for mariaDB or how to reduce RAM usage per thread?

We have an MariaDB 10.3 database server running on an 8 core and 64GB RAM machine. The database engine is innoDB. Our current max_connections = 175 and our DB admin tells me that it is not possible to ...
  • 125
1 vote
0 answers
61 views

SSL connection error when connecting to MySQL, using JDBC

The problem that we are facing is well documented in https://stackoverflow.com/questions/34189756/warning-about-ssl-connection-when-connecting-to-mysql-database. We started facing this issue upon ...
  • 245
2 votes
0 answers
22 views

Why would my MySQL replica server experience an sql integrity constraint error after losing connection and attempting to start again?

I have a master-master replication setup between two different servers using MariaDB. One is the primary server (server A) that is connected to my web applications, and the other is a replica that ...
-2 votes
1 answer
276 views

MariaDb performance issue

Using mysqltuner, we are facing performance issue with application using this db. We have physical memory of 128 GB. But this db is set to 16 GB. How can increase the memory and performance of this db....
  • 1
2 votes
1 answer
75 views

MySql suddenly started to choose different index for query, which causes it to be slow

Database is from Magento 2's site. Issue suddenly started to occur on our live site, dev site has the same database, but just with older data and same query is running completely fine there. I've also ...
  • 21
0 votes
0 answers
60 views

Why MariaDB doesnt respect adaptive flushing setting?

Using MariaDB 10.4.24. I have adaptive flushing enabled (innodb_adaptive_flushing=ON). My understanding is, that InnoDB will flush dirty pages slowly, but steadily. However my checkpoint age keeps ...
  • 115
1 vote
1 answer
266 views

MariaDB Read-Only user can't see database, why?

I have 2 users, one with ALL grants, another with SELECT only. User 1 can see the database, not user 2, why? Read-only user: MariaDB [(none)]> SHOW GRANTS FOR 'readonly'@'%'; +----------------------...
0 votes
1 answer
75 views

How to set the 'source address' ProxySQL uses to connect to MariaDB?

I'm deploying ProxySQL on Docker. When I try connecting to my database via ProxySQL, MariaDB rejected my login attempt as follows: Access denied for user 'usarr'@'172.18.0.1' (172.18.0.1 is the ...
  • 187
0 votes
1 answer
281 views

No free buffers in MariaDB 10.6

I have recently updated MariaDB from 10.4 to 10.6. One major change in the underlying InnoDB engine is the removal of buffer pool instances, so there is always only one. I believe this affects some ...
  • 115
0 votes
0 answers
158 views

Best Practice of High Availability For MariaDB

I'm preparing to run a MariaDB Cluster with High Availability and I'm looking for the best practices. Years back, I used to run MariaDB in master-master mode, and there was a big issue. Whenever any ...
0 votes
0 answers
32 views

replicate_rewrite_db not working on create table

I'm trying to set up replication on Mariadb 10.6 on Debian 9. I'd like to replicate database "DB" on master to database "DB1" on slave. I've configured the following on the slave : ...
  • 1
-1 votes
1 answer
30 views

Sample data for MariaDB Knowledge Base?

Following MariaDB Knowledge Base(kb), I'd like to hands-on query like: https://mariadb.com/kb/en/semi-join-materialization-strategy/ select * from Country where Country.code IN (select City.Country ...
4 votes
1 answer
106 views

Foreign key from one column to two (fixed computed column)?

I am trying to set up some foreign keys for some tables and I have an inheritance scenario with a "supertable" and some "subtables". The basic structure is that the supertable ...
2 votes
1 answer
26 views

Performance difference between using check and a enum type?

What is the performance difference between using a check instead of a enum to make sure a value in the column doesn't exceed X? For recent mariadb setups
  • 188
0 votes
1 answer
56 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&...
  • 3
2 votes
2 answers
635 views

MariaDB - search over multiple rows with same id

I have table with three columns in it. First is product_id linked to another table, second is att_id with link to another table and last one is val_id linked to different table. There are rows with ...
  • 23
0 votes
0 answers
145 views

How to Check Which Node of Galera Cluster Has the Latest Data When the Galera Cluster Fall in Deadlock?

I have a 3-node MariaDB Galera cluster and sometimes I see that the database system doesn't answer to connections. To ask a better question, let me explain with an example situatiın which I faced ...
0 votes
1 answer
275 views

how to recover from failed transaction due to crash [mysql]?

I am trying to start MySQL server, but it keeps throwing errors. Upon inspecting I found out that the server was stopped unexpectedly and there was a transaction in the process that didn't finish. I ...
0 votes
2 answers
35 views

Log only drop queries

I'm having a issue that my tables are being dropped, and I don't know how/where. But enabling the general logs create 2 million records in less than 10 minutes and this is one of my least busy hours. ...
  • 188

1 2 3
4
5
47