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
0 votes
1 answer

Next step to configuring MariaDB after successful installation

In addition to the formal documentation (i.e., etc), there are countless tutorials on installing MariaDB, however, not one of ...
user1032531's user avatar
0 votes
2 answers

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 ...
User2910293's user avatar
4 votes
3 answers

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 ...
SkelDave's user avatar
  • 143
1 vote
1 answer

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 <> &...
Tom R's user avatar
  • 11
0 votes
1 answer

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) ...
Cody Ardoin's user avatar
2 votes
2 answers

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 ~...
Jared Beck's user avatar
2 votes
0 answers

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 ...
Tobias Bengtsson's user avatar
1 vote
0 answers

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 = ...
Dark Star1's user avatar
1 vote
1 answer

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 and ...
jgnoss's user avatar
  • 93
2 votes
2 answers

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 ...
Tarcaird's user avatar