Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Open source RDBMS designed to be a "drop-in" replacement for MySQL. Add a version-specific tag like mariadb-10.2 if that context is important.

0
votes
0answers
10 views

MariaDB LOAD DATA INFO can't import single column file to single column table?

I am trying to import the 10,000 common password list into a table to ban those passwords from being used in a given system. The file is a single column TXT file. Trying to LOAD DATA INFILE that into ...
4
votes
3answers
53 views

Why the query optimizer choose this bad execution plan?

We have a mariadb table (stories) with above 1TB of data, periodically running a query that fetches recently added rows for indexing somewhere else. innodb_version: 5.6.36-82.1 version : 10.1....
0
votes
0answers
13 views

Database performance improvements for current setup. (mysql - marriaDB)

I've currently got a pretty hefty database (for me anyway) with multiple tables exceeding 15 million rows. I'm trying to improve performance on the whole table lookup, I implemented memcached to cache ...
0
votes
2answers
32 views

Create users identified by the same password as another user in MariaDB 10.0.X

How do I create users with the same password as another user in MariaDB 10.x? I do not know the password of the existing user , so i want to use same hashed password as existing, also do need to ...
1
vote
0answers
13 views

Error with GaleraCluster> [ERROR] WSREP: gcs / src / gcs_group.cpp: gcs_group_handle_join_msg (): 736: Will never receive state. Need to abort [on hold]

I made a cluster with GaleraCluster using 3 virtual machines with Debian 9 and mariadb 10.1 database. The replication works well using rsync method, even if a node is dropped when it recovers, it ...
-1
votes
1answer
10 views

Questions related to begin learning Mariadb (or MySQL) [on hold]

I want to begin learning MySQL/Mariadb. I need help with a few queries: What are the best online resources to learn MariaDB/MySQL from absolute basics to a proficient level? Are there any ...
0
votes
1answer
19 views

Recovering MySQL 5.7 tables in MariaDB 10

I did a very foolish thing... I did not realize installing mariaDB would uninstall MYSQL 5.7 using apt-get. (Using Ubuntu 16.04). So now I am trying to recover my data. So far, I have read many ...
0
votes
0answers
14 views

Ways to automate DBs grants on RDS AWS [closed]

How can one manage/automate the process of executing database grants across several Amazon RDS databases? For example, let's consider that I have 10 AWS accounts with multiple RDS instances running. ...
1
vote
0answers
30 views

Why is this very simple UPDATE so much slower than the SELECT it contains?

In MariaDB 10.3.9: SELECT COUNT(*) FROM photos vs UPDATE counts SET countValue = (SELECT COUNT(*) FROM photos) WHERE countName = 'photos'; The select takes 1.1s vs the update which takes 2.6s. ...
1
vote
2answers
35 views

Repair/Recover data from MySQL database

I have a big problem with a MySQL database stored on my raspberry (InnoDB engine). I'm not very expert in this field but I'll try to explain to you the problem. MySQL crash everytime that I try to ...
0
votes
1answer
11 views

all gradestate.dat seqno: -1 why?

All my 3 nodes in mariadb galera cluster seqno is -1 and when i restart the whole cluster i need to start with --wsrep_new_cluster just to start the other nodes. can anyone help me with this? all 3 ...
0
votes
1answer
12 views

MariaDB - how to drop partition on master but not on slave

I've read about filtering replication and I only run into information I know already, like you can select only a database or a table to do replication on. My use case is that I want to have a slim ...
1
vote
1answer
24 views

MariaDB 10.0.36: Table './mysql/servers.MYI' is read only

Trying to upgrade MariaDB using Generic Linux package from https://downloads.mariadb.org/mariadb/10.0/#os_group=linux_generic on a Debian 8 server: kernel version 2.6.32-49-pve OpenVZ/Virtuozzo ...
1
vote
1answer
24 views

Which file do I need to modify my.cnf MariaDB on Ubuntu 18.04

I want to modify these values: [mysqld] key_buffer_size = 256M max_allowed_packet = 128M thread_stack = 256K query_cache_limit = 64M query_cache_size = 384M innodb_buffer_pool_size = ...
0
votes
0answers
69 views

MariaDB startup failure on Ubuntu 18.04

I have installed MariaDb hundreds of times on previous Ubuntu versions, but on Ubuntu 18.04 I'm struggling. After the installation finishes, once I restart the PC, MariaDB starts for around 2 minutes ...
0
votes
1answer
19 views

Deadlocks in Mariadb

We have hit deadlocks in 10.1.25-MariaDB-1~trusty. Looks like it has something to do with select for update queries. But the deadlock increases when number of tps increases. Is there any alternative ...
1
vote
0answers
14 views

Is this surprising deadlock reasonable or a mariadb bug?

I recently had to diagnose a deadlock in an application that seemed impossible to me. Even after I found out how to reproduce it, I don't really undestand why it happens. I'm considering filing a ...
1
vote
0answers
15 views

MariaDB crashes on mismatched tablespace ID for InnoDB

I'm having an issue with some corrupted InnoDB tables on a stand-alone MariaDB 10.1 server running on Debian Stretch. I've encountered this issue in the past, but never found a working solution, so I ...
3
votes
1answer
45 views

MySQL CPU usage super high since server crashed

I've had a big crash on my server 2 days ago, still don't know why, but after resurrect it the mysql server is consuming a huge amount of cpu and I don't know why: The server is Mariadb installed by ...
0
votes
1answer
18 views

Percona pt-table-sync Can't determine Master

We have following Multi master replication scenario. We are using MariaDB 10.1.34 and Percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica Connection ...
0
votes
1answer
17 views

Percona pt-table-checksum output is in infinite loop “Waiting for the --replicate table to replicate”

We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica ...
2
votes
1answer
62 views

MySQL Workbench Visual Explain not working with MariaDB 10.3.9

I recently installed MySQL Workbench 8.0.12 and MariaDB 10.3.9. I created my database and want to start fine tuning indexes and views. I can run a query with the EXPLAIN button and get the results in ...
0
votes
2answers
36 views

Totals on multple case conditions - mySql

I am attempting to translate the query in this question into mySql, as we moved the data from an access db to a new structure. I have come up with the following, since there are multiple conditions (...
0
votes
1answer
31 views

MySQL compute percent change

I am new in MySQL.. I want to compute for the percent change of this table using MySQL. Can you help me with the script? I am using 10.3.8-MariaDB MariaDB Server.. Thanks.. CREATE TABLE `MyTable` ( ...
0
votes
1answer
39 views

Unable to read master log position while setting up MySQL slave

Hi I am trying to setup a data replication server. I am using MariaDB and phpMyAdmin to interface with the 2 DB's I have set up my master with adding the following configuration to my my.ini file ...
0
votes
1answer
32 views

MariaDB order by before Group by

I have looked around at other solutions, but none seems to work quite right. What I am trying to do is to get the latest result (sorted by date) from a selection, grouped together by sample. Here is ...
0
votes
0answers
22 views

Ordering group by when it's a math equation

I'm using MariaDB's system versioned tables and when querying the version history, I'd like to group the versions by x number of seconds (in my case, 300 - or 5 minute intervals). The problem I'm ...
1
vote
2answers
74 views

Homebrew MariaDB Server Start Error with 'mysql.server start'

When starting MariaDB 10.3.8 on MacOS 10.13.6 the following strange behavior occurs: mac:~user$ mysql.server start Starting MariaDB .180813 17:50:11 mysqld_safe Logging to '/usr/local/var/mysql/mbp....
2
votes
2answers
56 views

How to spec a machine for a particular database load?

Our primary authentication database that is used for 100k+ users, and growing is a VM on a shared machine that we want to extract into its own isolated hardware. This will let us isolate resources, ...
1
vote
0answers
15 views

One node causing entire Galera Cluster to remain in bad state

I have a production MariaDB Galera 5 node cluster that has been running for about 8 months at our factory. One node had a powerfail / un-graceful shutdown (Ubuntu 16.04) and since then if that node is ...
0
votes
1answer
28 views

Code not working due to collation?

Let me preface my question by saying, that my teacher stared at my code for 2h and could only guess that it might be the collation. Here's the problem: for an exercise we were asked to create a movie ...
1
vote
1answer
28 views

Changing mariadb port

I'm trying to change the default port for mariadb to 52000. I've modifed the port in /etc/MySQL/mariadb.conf.d/50-server.cnf and restarted the service. However, each time it still starts up on the ...
2
votes
0answers
52 views

Third node cannot join Galera cluster after mariadb update

I tried to deal with this issue for three days now, but unfortunately without success. I have a Galera cluster (Node1 - donor, Node2 - joiner, Node3 - arbitrator) which was working flawlessly until I ...
-2
votes
1answer
31 views

Subquery and subselection for Count/Number doesnt work

for example, for company (3) and his partners, I need the number of events with payouts. But i get only the number for one partner, im my example i have i have 3 tables (t_company, t_partner, t_event,...
0
votes
3answers
117 views

Query does not use Indexes

This query runs very slowly (over 2 minutes) because it does full table scans. Why does it not use the indexes I created? EXPLAIN SELECT * FROM race_points t1 LEFT JOIN ( SELECT Name ...
0
votes
1answer
57 views

What does MBRContains and MBRWithin test? What does “contains” and “within” mean?

MBRContains(g1, g2) is defined as, Returns 1 or 0 to indicate whether the minimum bounding rectangle of g1 contains the minimum bounding rectangle of g2. This tests the opposite relationship as ...
3
votes
1answer
61 views

Does MySQL or MariaDB support GIS KNN Index Queries (k-nearest neighbors)?

Can you do k-nearest neighbors algorithm (k-NN) queries on MySQL for example, to find the nearest point in PostgreSQL with PostGIS, I can run a kNN query on the spatial index with <-> SELECT ...
0
votes
1answer
32 views

Maria DB (Windows) backup

We have just started a project with Maria DB (Windows) as backend. I have been asked to automate Maria DB backup process. What should be the best approach to automate Maria DB? Backup will be taken ...
0
votes
0answers
38 views

JSON_SEARCH, mysql 5.7 vs mariaDB

I am working with the following two machines and databases: Machine 1 Fedora 26 mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64) using EditLine wrapper** Machine 2 Debian 9 mysql Ver 15.1 ...
1
vote
1answer
21 views

Replication of databases with specific prefix on master

There are options to dynamically set variables on replication slaves, like replicate_wild_do_table and replicate_wild_ignore_table. But, are there any options for replication master to dynamically set ...
3
votes
3answers
884 views

Can I speed up a large MySQL/MariaDB join through partitioning or merging?

I'm trying to run the following join query as part of a more complex one on MariaDB 10.1.26. select distinct project_commits.project_id, date_format(created_at, '%x%v1') as week_commit ...
0
votes
1answer
29 views

MariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting [closed]

I've installed a MariaDB Galera Cluster on Ubuntu 16.04 in 2 nodes. Here the info from node1: root@localhost:~# sudo more /etc/mysql/conf.d/galera.cnf [mysqld] binlog_format=ROW default-storage-...
-1
votes
2answers
110 views

Upgrading MariaDB 10.1.32 version to 10.3.7

Is it possible to upgrade from 10.1.x to 10.3.x directly in one step? or I have to upgrade first to 10.2. x then to 10.3.x. Please it is so important question regarding upgrading our production ...
1
vote
1answer
66 views

Repreparation of prepared statements in MySQL/MariaDB, how to find a cause?

On our server running MariaDB 10.1 (the latest Debian package), with low load (load average: 0.79, 0.88, 1.00), I often receive error message that "Prepared statement needs to be re-prepared". It is ...
1
vote
1answer
53 views

What is a LSN (log sequence number)? How does xtrabackup Incremental Backup work?

I was surprised that xtrabackup supports incremental backups. xtrabackup copies the data files and understand the format of data files (can have a look inside)? What is a LSN for dummies? I found What ...
0
votes
1answer
80 views

MariaDB master-slave replication failover and failback

I'm trying to configure a DR instance of MariaDB (10.1.13) using master-slave replication. I was able to establish the master-slave relationship with GTID by locking the tables on master, backing up ...
1
vote
2answers
56 views

How to remove options from mariadb tables?

Mariadb 10.2.8 I am trying to convert an aria table to InnoDB. My problem is MariaDB> alter table materiales engine=innodb; ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support ...
0
votes
1answer
15 views

MariaDB Update Column Values Based on Another Column's Value

I have a column 'StormID' 'Basin' which both hold text based values. StormID Basin EP012018 NEP EP022018 NEP CP012018 NEP <-- I want this value to change to NCP if the first 2 characters ...
1
vote
1answer
25 views

What data is duplicated when MySQL/MariaDB BLOB columns are copied?

Let table_1 be created as follows: CREATE TABLE table_1 ( id INT AUTO_INCREMENT PRIMARY KEY, some_blob BLOB ); Let table_2 be created as follows: CREATE TABLE table_2 ( id INT ...
0
votes
0answers
42 views

MariaDB Galera Cluster node fail to start after stopping

I try to use Galera Cluster for my mariaDB as failover and backup but i got this error when i started to connect the other node to main node. mysql.service - LSB: start and stop MySQL Loaded: ...