Questions tagged [mariadb-10.3]

MariaDB 10.3 was released as stable (GA) with version 10.3.7 on 25 May 2018. Please also tag with mariadb for search purposes.

Filter by
Sorted by
Tagged with
0 votes
0 answers
30 views

Problem restoring partial mariabackup

I follow this method to perform a partial and incremental backup of my database on two servers, bskpserver and devserver. Everything works fine except for some tables. When I try to restore them on ...
elarichi.y's user avatar
0 votes
0 answers
2 views

how to solve problem of that IO thread in slave cannot read the correct position in master in mariadb 10.3 ? I tried to use GTID_based replication

I have a problem when using new style GTID_based replication on mariadb 10.3 in case of multi master and slaves replication ..I cannot use auto positioning in case of the IO thread in slave cannot ...
user avatar
0 votes
0 answers
22 views

SELECT for VIEW with steped date dependencies

I have two tables on a mariadb 13.0 - values: id date value1 value2 1 2023-10-01 10 100 2 2023-10-02 20 200 3 2023-10-03 30 300 4 2023-10-04 40 400 5 2023-10-05 50 500 and rates: date rate1 ...
Wookiee's user avatar
0 votes
0 answers
59 views

Upgrade warning when starting MariaDB

When I start up my Mariadb instance I see the following with systemctl: $systemctl status mariadb ● mariadb.service - MariaDB 10.3 database server Loaded: loaded (/etc/systemd/system/mariadb....
Brad's user avatar
  • 191
1 vote
0 answers
51 views

Foreign key constraint wrongly gives the error in mariadb

We are using AWS RDS for mariadb. There are several tables out of which I am mentioning two which are causing the issue: Table 1: PRODUCT_OFFERING Table 2: CHARACTERISTIC Related by foreign key as ...
Arjun Lajpal's user avatar
1 vote
0 answers
21 views

Strange performance difference in update query alternatives in mariadb

We have a table with composite primary key with 1.6M rows where 2 different ways of writing the same query yields vastly different response times. Unfortunately our ORM creates the slow quiry variant. ...
Medisch Labo Bruyland's user avatar
0 votes
1 answer
118 views

MariaDB is in "Sending data" state for too long for COUNT

Recently I have encountered an issue of slow data loads. Upon looking into the Process list I have found out that the issue is on the database side, it gets stuck in the "Sending data" phase ...
jave.web's user avatar
  • 101
0 votes
1 answer
19 views

Sorting data from a given column where the sort order is after a dot

I have the following query: SET @counter = -1; UPDATE domains SET domains.order = @counter := @counter + 1 ORDER BY domains.extension ASC; Where the column extension is comprised of TLD's. Now we ...
Ricardo Mendes's user avatar
1 vote
0 answers
119 views

Mariadb keeps crashing after sometime

I am getting a weird problem with Mariadb server. After starting the service after few mins the service will go down automatically. Upon checking status this is what I find. mariadb.service - MariaDB ...
Hari's user avatar
  • 11
1 vote
1 answer
86 views

MariaDB constraint is incorrectly formed although columns are of the same type

I've got a problem while creating (altering) foreign key. I have two tables in my DB (created via flyway migrations): connector (migration) create table if not exists connector ( id char(36) not ...
Sebastian Lore's user avatar
0 votes
0 answers
204 views

How to optimize this query, mariadb 10.3?

I have a dashboard, which has a search field that runs the following query. s there a way to increase the performance of this query? SELECT cliente.id, cliente.ativo AS cli_ativo, cliente.crm AS ...
Rafael Busz's user avatar
1 vote
1 answer
197 views

Set Default Value of Column Equal to PK of inserted record, and use it as Foreign Key Reference

I'm using MariaDB 10.3, and what I'm trying to do is an establishment of a 1-to-n relationship as for example specified here in the section "One-To-Many-Relationship". I'm trying to do so ...
DevelJoe's user avatar
  • 163
2 votes
1 answer
325 views

MariaDB 10.3 on Debian 10 ignores long_query_time value

I have enabled the Slow Query Log on a Mariadb 10.3 server on Debian 10. Below is the implemented configuration MariaDB [(none)]> show session variables like '%slow%'; MariaDB [(none)]> show ...
MJJ's user avatar
  • 23
0 votes
0 answers
449 views

Memory leak mariaDB 10.3.37

Update: I've upgraded to 10.6, but I'm going to leave this question open for answers and future searches. I have a VPS server on Centos 7 x64 with 8bg ram and I'm using cpanel/whm. Recently the ...
Erik Friesen's user avatar
0 votes
0 answers
61 views

Change query to replace string by values in table of replacement

To store emails list I have two quite simple tables, domain and mailbox, so [email protected] is stored as: domain id domain_name 1 domain.com mailbox id local_part domain_id 1 user 1 (local_part ...
A_C's user avatar
  • 153
-2 votes
1 answer
2k views

Reduce your overall MySQL memory footprint for system stability, Dedicate this server to your database for highest performance

Any suggestion on how can I solve this General recommendations by MySQL tuner? Am using this plugin eningtron Server info **OS: CentOS Linux release 7.9.2009 (Core) Processors: 4 CPU(s)** **RAM: 7.64 ...
Pynman's user avatar
  • 1
0 votes
0 answers
896 views

MariaDB: How to return JSON array instead of string

I am trying to get MariaDB(v.10.3.34) to return a JSON array, but it's returned as a string instead. I'm reading the returned value in Node.js, where the returned array is a string instead of an array....
TTT's user avatar
  • 1
0 votes
1 answer
36 views

Query with EXISTS-subquery taking about 280 ms in 80 % of cases, and less than 1 ms in 20 % of cases

I noticed a query that seemed to take way too long most of the time, so I investigated it with the Laravel query logger (to get the time and the actual SQL from the query builder). Excerpt: >>&...
Leif's user avatar
  • 105
0 votes
1 answer
148 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....
rcbijhamrwwksk's user avatar
1 vote
2 answers
2k 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 ...
kenshin9's user avatar
  • 109
2 votes
3 answers
2k 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 ...
Lonzak's user avatar
  • 125
0 votes
0 answers
459 views

Can't start MariaDB suddenly

● mariadb.service - MariaDB 10.3.32 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: signal) ...
BOY's user avatar
  • 1
0 votes
1 answer
171 views

Replication from multiple masters to one slave

I have 2 Raspberry PI's and each run a MariaDB 10.3 server. Each has the same databases: vennens scheduler On the slave I've configured the 50-server.conf file with follow contents: master_pi1....
Stijn Leenknegt's user avatar
0 votes
1 answer
593 views

fix InnoDB: corrupted TRX_NO after upgrading to 10.3.31

After upgrading mariadb from 10.3.25 to 10.3.31 it fails to start like described in this bug report I temporary fixed it by downgrading mariadb to 10.3.25 again like I described here. To fix this ...
rubo77's user avatar
  • 816
0 votes
1 answer
322 views

MariaDB: Periodic copy of data from local database to remote database

I need to periodically copy the outcome of a view on our local database to another remote database. I've tried using mysqldump which works fine when copying data from tables to tables, but i need to ...
Nicklas Nielsen's user avatar
0 votes
1 answer
510 views

Mariadb can not find system tables

I am running mariadb 10.3.27 and after a erroneus long query maria db stoped working. I restart it and check systemctl status. Mariadb was working but also have the bellow errors: [ERROR] mariadbd: ...
Christoforos's user avatar
0 votes
1 answer
492 views

service mysql reload results 'Access denied', but service mysql start works

Using Debian 10.10. I have a MySQL problem. service mysql reload results 'Access denied' service mysql start executes correctly. All databases are working correctly after starting mysql. Strange, ...
klor's user avatar
  • 157
0 votes
1 answer
83 views

SELECT from table without blocking INSERTs into it?

I have an application where each page load inserts information about the visit into a MariaDB table. There is an analytics hub where statistics from this data can be viewed. In the beginning, this ...
InterLinked's user avatar
0 votes
1 answer
585 views

MariaDB on Ubuntu mysteriously goes away after 15 minutes [closed]

I have an issue I've never seen before...my MariaDB goes away after 1800 seconds, despite having the default configuration for wait_timeout of 28800 seconds. I checked all my my.cnf files, and there ...
andrewniesen's user avatar
2 votes
1 answer
2k views

Authentication relying on mysql_native_password seems to also check for Linux user?

I have a mariaDB 10.3 install. The mysql.table states that 'root' login relies on mysql_native_password plugin, with no password set. If my linux user is root, I am able to connect to mysql using; ...
nonayme's user avatar
  • 23
0 votes
1 answer
334 views

ALTER TABLE statements not replicating in all tested scenarios - MariaDB

Summary Tech: mariadb 10.3 Issue: some attempts to ALTER TABLE to change engine is not replicating. Scenarios tested: command line PHP script running ALTER statements using PDO - did not replicate ...
TheGremlyn's user avatar
0 votes
2 answers
318 views

unknown variable 'file-key-management-filename'

New installation of Debian 10, with MariaDB 10.3.29. Trying to set up encryption-at-rest, but MariaDB won't start due to an error... [ERROR] /usr/sbin/mysqld: unknown variable 'file-key-management-...
Stephen's user avatar
0 votes
0 answers
65 views

Performant way to limit selected rows but make sure the sum of the rows is large enough

Here's a simplified version of the problem. You have a marketplace where users can publish how many items they have for sale and the price. You would like to buy 1 000 000 items, and you want to ...
Alex's user avatar
  • 53
0 votes
1 answer
84 views

Get the next datetime value

I have a MySQL table: SELECT sh.id, sh.DG_ID, sh.START_DATE FROM STATUS_HISTORIES sh order by DG_ID, START_DATE id DG_ID START_DATE 22 212 2021-04-20 14:59:58 66 212 2021-04-21 05:...
Saya's user avatar
  • 3
1 vote
1 answer
2k views

MariaDB mysql.user table shows as a VIEW. Hence, MySQL is not starting

We have a MySQL installation that has mysql.user table a VIEW. So, MySQL is not starting properly. We are now running it with skip grant tables. Is there any option to convert the view to BASE TABLE ...
prime999's user avatar
2 votes
1 answer
89 views

MaridDB 10.3.29 prevents me from deleting a foreign key

This is a minimal example that triggers the error CREATE TABLE A ( id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY ); CREATE TABLE B ( what tinyint NOT NULL, a bigint NOT NULL, CONSTRAINT x ...
Wombatz's user avatar
  • 131
1 vote
2 answers
539 views

Get all rows where specific column value occurs more than once (filter out single occurences)

I am trying to filter all sessionIds that occur once out of an existing result set. This query is being used in a web application and runs on a big dataset (~ 35 million rows), so I want to prevent ...
Theo's user avatar
  • 135
0 votes
2 answers
669 views

Does a NULL DATE use as much storage as a value?

I need to store a DATETIME value that may or may not have a date. My options are: | starts DATETIME | |---------------------| | 0000-00-00 12:38:06 | | starts_date DATE | starts_time TIME | |----...
ᴍᴇʜᴏᴠ's user avatar
0 votes
1 answer
31 views

LEFT and RIGHT JOIN multiple table, show all null data on mariadb 10.3

i want to join 3 table with null value, here i have 3 table folowing tbl_reporting tbl_criteria tbl_student |===============================| |...
Ilyan Aza-lun's user avatar
0 votes
2 answers
798 views

LEFT JOIN subquery fails in the presence of an EXISTS clause in the main query

I have this query: SELECT c.id contact_id, engagement.sent FROM contact c LEFT JOIN ( /* ➊ Inner query */ SELECT eq.contact_id contact_id, COUNT(*) sent FROM mailing_job j INNER JOIN ...
artfulrobot's user avatar
0 votes
2 answers
501 views

How to find unused columns in MariaDB tables

I have a lot of tables in my DB that have a number of columns which might not be getting used as they slowly lost their relevance with time, I need to find such columns and delete those from the ...
DB guy's user avatar
  • 69
0 votes
0 answers
126 views

How to use a query to get the definition of (MariaDB 10.3.27) database objects (specifically the variables they use)

I have written a query to get most of the useful information about the routines in a MariaDB database for a database documenter that I am developing. The code below will return routine name, routine ...
user2834566's user avatar
0 votes
1 answer
271 views

Please help tune MySQL config

Anyone can help me to check this MySQL configuration? I have a VPS 2GB RAM - 2 vcpu, installed cyberpanel from litespeed. Any help would be appreciated! my.cnf settings are: [client] port ...
Роман Охрименко's user avatar
3 votes
0 answers
548 views

MariaDB - Query to find unused indexes

I need to find unused index on a MariaDB database and do not have 'userstat' enabled, I found this query which is supposed to find unused indexes, but I am unable to get a full understanding of this ...
DB guy's user avatar
  • 69
0 votes
2 answers
647 views

Remove unused Indexes MariaDB

I have a big database with 50 tables and each table can contain between 100,000 to 100 million records. On these tables are there are 1000s of indexes, but many of the indexes are now not in use. How ...
DB guy's user avatar
  • 69
0 votes
1 answer
333 views

MariaDB 10.3.27 Memory usage problem

Greetings! I tried to optimize MariaDB configuration with my.cnf. Everything was OK, but available memory falling down each hour. I'm using MariaDB with Zabbix server on the same server. CPU: 4 Cores, ...
Alex R.'s user avatar
  • 103
1 vote
2 answers
878 views

How to limit impact of a bad application on MariaDB Galera Cluster with MaxScale?

I have a Galera Replication cluster with three MariaDB nodes where a Maxscale Active-Passive cluster in front provides a single node image to tis clients. I have a bad behaving client, which opens ...
Amit P's user avatar
  • 111
-1 votes
1 answer
530 views

Can't update database table's column using trigger or from php page but works after using update sql query in phpMyAdmin

After inserting into my audit log table called userUpdateLogand it calls an before insert trigger to insert into userProfiles and users based off the columns insert into their respective table. but ...
Brandon's user avatar
1 vote
0 answers
503 views

Should a mysql slave answer queries much slower then the master?

I am seeing a slight issue on a mysql slave server, or at least on the surface it appears there might be an issue. Both mysql's are virtual machines The master and slave are the same OS (debian10) and ...
Universal4's user avatar
-1 votes
1 answer
128 views

MariaDB CONNECT engine to read external mongodb collections

I want to access MongoDB collections through MariaDB 10.4.17. Both are installed on my local machine running Windows 10. Software listening port MongoDB 27017 MariaDB 15501 I installed the MariaDB ...
DB guy's user avatar
  • 69