Questions tagged [mariadb-10.2]

MariaDB 10.2 was released as stable (GA) with version 10.2.6 on 23 May 2017. Please also tag with mariadb for search purposes.

Filter by
Sorted by
Tagged with
1
vote
1answer
26 views

Does a MySQL dump that contains triggers double data on import?

I have a quick and simple question to clarify. I have medium sized database (400 Gigs) running in MariaDB 10.2 with lots of tables and lots of triggers as well. I am planning to take a mysqldump and ...
0
votes
1answer
17 views

Mariadb encryption

I have a requirement to encrypt certain column of DB tables. Going through the links, have followed the below steps: In /etc/my.cnf [mysqld] plugin-load-add = file_key_management ...
0
votes
0answers
16 views

MariaDB Replication - Missing ^M Characters on Slave

I've got a simple single master->slave replication setup with MIXED binlog format for mariadb 10.2.22-1 on RHEL7. I believe I'm having an issue where '^M' characters in a longtext column are not ...
0
votes
1answer
135 views

Mysql_upgrade fails, table is corrupted

I have a mariaDB with a table that is corrupted. It's useless data to me, so I've tried to drop the schema but it won't drop. Instead, it gives me this error when trying to drop it: "Error Code: 1805....
2
votes
1answer
176 views

How to clear the InnoDB redo log before starting mysqld for crash recovery

System: Windows Server 2012 R2, MariaDB 10.2.8 We are currently trying to recover from a quasi-crash (it was a normal shutdown, but mysqld won't start up again) and are having problems with the redo ...
0
votes
1answer
53 views

Can XtraDB be enabled on MariaDB 10.2

Can we create a table in MariaDB 10.2 with XtraDB engine? I have installed MariaDB 10.2 and I am trying to create a table with storage engine XtraDB and I am getting error *mysql> CREATE TABLE T1(ID ...
0
votes
0answers
43 views

Fulltext search in a CTE result - missing fulltext index

My question applies to MariaDB 10.2.7 The query WITH prefiltered AS ( SELECT id, fulltext_indexed_column FROM fulltext_table WHERE id < 30 ) SELECT * FROM prefiltered WHERE MATCH(...
1
vote
1answer
74 views

MariaDB 10.2.22 Galera Cluster Using Bad Indexes After Analyze

I'm using Drupal on a MariaDB Galera 10.2.22 3 node cluster and I'm having some problems with one query. I have a table (InnoDB) called field_data_field_department which has a bunch of indexes. If I ...
0
votes
0answers
142 views

MariaDB 10.2 crash on innodb table corruption - trying to restore the database

I'm running MariaDB 10.2 on Windows and had some hard drive corruption on my server that messed up some innodb tables. Unfortunately this also affected backups, so I'm trying to dump the tables and ...
0
votes
0answers
32 views

Is it possible to get the keys from Vault for MariaDB Data-at-rest Encryption

We are doing a POC on MariaDB Data- at-rest Encryption using File_key_Management_plugin. In order to encrypt the tables this plugin reads a file that contains key and we need to pass the path of the ...
0
votes
1answer
25 views

perform non locking select when updating another table

We need to perform the following (periodic) query in mariadb: update A set status='INACTIVE' where status='ACTIVE' and a.b_id in (select id from B where ... LOCK IN SHARE MODE); Unfortunately it ...
1
vote
1answer
138 views

Prepared statement too slow

have an issue with MariaDB 10.2.12 running in aws rds (single master, no slave) when I run prepared statement using a variable substitution PREPARE stmt1 FROM "select ...quite complex select from ...
1
vote
2answers
450 views

Mysql: set variable in mysqldump

I recently added a global variable in mmy.cnf max_statement_time=120 ; to stop long running queries and to throw an exception. Its working fine. Then I am unable to run mysqldump for backing up all my ...
1
vote
1answer
39 views

Join against two tables to get single combined result set

tl;dr I made a SQLFiddle here http://sqlfiddle.com/#!9/031e71/1 with a minimal, complete, reproducible test case (though very specific to the problem domain of orders and products). I have a Zen Cart ...
-1
votes
1answer
33 views

MySQL - Classic Date Functions

Version: 10.2.18-MariaDB I'm attempting to find the first available room within December (already included in the sample table) that will be free for 3 consecutive days. The expected output should ...
1
vote
1answer
52 views

mysql : ordering a table in the order of the primary key

I have a table with a primary key consisting of two integer columns. I store ~200 millions lines in this table. My program needs to get the full table ordered by the columns of the primary key in the ...
1
vote
1answer
49 views

Finding temporary table name in MariaDB

As I reported some days ago to MariaDB bug tracker the following bug: https://jira.mariadb.org/browse/MDEV-17420, slave replicas with version 10.2.x are leaking temporary tables on MyISAM files. Our ...
1
vote
0answers
428 views

MariaDB 10.3 slave fails to replicate from a MariaDB 10.2 master

We have a 10.2.18 master and 4 slaves with 10.2.18. Because of this bug that I've reported last week (https://jira.mariadb.org/browse/MDEV-17420) we tried to upgrade one of the replicas to 10.3.10 to ...
1
vote
0answers
33 views

MySQL InnoDB stop locking when large sql is executed

We face a issue that the InnoDB table is locked, when a sql file that is executed is large than a certain file size. The problem does not appear when the file size is much lower, for example 25MB. ...
0
votes
1answer
532 views

Add a New Column with ALIASES on 'date' by automation based on search results

I am trying to create a new column based on date search result. I have written a code in the link SQL fiddle as I am looking for date automation on each column based on the date format. the date ...
2
votes
1answer
278 views

Why am I connecting securely to MySQL when I don't have client certificates?

I don't understand the MySQL documentation for encrypted connections. The server is configured with certificates, and unless I am misreading it, the documentation says that the client must have ...
5
votes
1answer
783 views

Allow only unique combination of values for a composite primary key

I created the following table called books: CREATE TABLE IF NOT EXISTS `books` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` TEXT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=...
0
votes
2answers
174 views

Which way should be selected when move from mysql to mariadb? [closed]

Now, the mysql version is 5.1.I plan to move to mariadb 10.2.Use mysqldump and source to update databases. Based on MySQL Upgrade Strategies, Upgrading to the latest release is recommended before ...
1
vote
1answer
458 views

table_open_cache increase issue - MariaDB 10.2

I'm trying to increase to 9000 but MariaDB sets it at 4895 automatically. Here is my simple config https://pastebin.com/raw/4eFiuFSv MySQLTuner output: Control warning line(s) into /var/lib/mysql/...
0
votes
1answer
103 views

Bypass truncated data type error in `CREATE TABLE AS`

I am attempting to recreate the code from this excellent tutorial in MariaDB 10.2 to try and build nested sets from an existing adjacency list. (The goal being to ingest changes to the adjacency list ...
1
vote
1answer
172 views

Setup replication between two Galera nodes

I've been using MariaDB 10.2 Galera with 3 nodes successfully on local servers. Now, I have a second 3-nodes Galera cluster on another location, joined by an Site-to-Site IPSec Tunnel. I can't really ...
2
votes
1answer
352 views

Partitioning increases CPU usage in mariadb

I'm using mariadb 10.2, and I had a table with a structure similar to the one below, currently with 15gb, where I insert a few thousand records per minute all the time, each batch for a specific ...
1
vote
1answer
556 views

MariaDB 10.2: Why does Count(*) work, but not Count(t.*)

I have a table containing transaction details which I am importing from several vendor-provided daily reports.. I want to be sure that I am not skipping any of the files (one file per day) as I do ...
2
votes
1answer
195 views

GSSAPI on MariaDB

I'm using Maria 10.2.13 on Windows Server 2012 and I want to use GSSAPI authentication with it so that we can continue using windows auth. I have followed this tutorial: https://mariadb.com/kb/en/...
1
vote
1answer
246 views

Can sst_state_transfer be set to rsync with innodb as storage engine in Galera cluster?

Galera cluster wsrep-sst-method docs states: You can only use rsync when anode is starting. You cannot use it with a running InnoDB storage engine. I do have InnoDB storage engine configured in ...
1
vote
1answer
302 views

What are some practical use cases for memory tables?

Trying to learn mysql and having tons of other material to learn, I'm considering skipping memory tables, since they have many special characteristics to consider especially that they vanish, after ...
0
votes
1answer
1k views

Next step to configuring MariaDB after successful installation

In addition to the formal documentation (i.e. https://mariadb.com/resources/blog/installing-mariadb-10-centos-7-rhel-7, etc), there are countless tutorials on installing MariaDB, however, not one of ...
0
votes
2answers
476 views

Alternative to ORDER BY GROUP BY to get first matches per ForeignKey

Since there is so much talk and articles about this online. I simply don't seem to have enough SQL knowledge to solve this seemingly simple problem. I have a table with layered data for a Price per ...
2
votes
3answers
3k views

The table is full - MariaDB

I am getting the following error whist trying to execute a long running query. The table 'C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp#sql1664_349_19be' is full The C drive (NTFS) on the server ...
1
vote
1answer
168 views

MariaDB optimisation [closed]

I stuck a bit with setting the best performance of MariaDB on my VPS. I have: 6 cores; 16GB RAM; 300GB SSD; CloudLinux; LiteSpeed >> MySQLTuner 1.7.0 - Major Hayden <major@mhtx.net> &...
0
votes
1answer
367 views

Galera Failures

I have 2 nodes. One a VPS on NFO Servers and another on Azure. I have setup the firewalls/disabled the firewalls. The nodes are CentOS 7, Latest Kernel. The configs are as follows: Node 1 (Master DB) ...
2
votes
2answers
309 views

Configure MariaDB client with host-specific credentials?

How can I configure my MariaDB client (mysql) so that I don't have to enter a password to connect, regardless of which host I am connecting to? I can't just put a password in the [client] section of ~...
2
votes
0answers
11 views

Enforce existence of cartesian product in join table without triggers in MariaDB 10.2

Given tables A, B and C, where C holds a foreign key to both A and B (i.e. C is a "join table"), is it possible to define a constraint so that C contains the whole Cartesian product A x B without ...
1
vote
0answers
263 views

Unable to install Mariadb on Fedora 27 due to SELinux issue

I followed these instructions in installing mariadb on my fedora 27 VM. My mariadb.repo is configured as follows: [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.2.12/fedora26-amd64 ...
0
votes
0answers
41 views

Prepared query refused by MySQL when using placeholders

I'm trying to make a prepared query but MySQL refuses to accept it when I use placeholders: This query works WITH x AS (SELECT 'root' as user_id) SELECT x.user_id FROM x LEFT JOIN user ON (x.user_id ...
0
votes
1answer
660 views

mariadb galera bootstrapping fails

Starting point at the sandbox sb1, sb2, sb3: All boxes identical. A Fresh debian 9 install mariadb 10.2 Galera3 build a test galera cluster with empty databases works fine. All three nodes come up ...
1
vote
2answers
798 views

json functions: double quotes added when going through a variable

Im stuck with what it seems simple question, when I create a JSON using the MariaDB/MySQL json functions going through variables, it adds double quotes which is annoying. However, if I don't go ...