Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

10.2 is again using the InnoDB storage engine by default instead of previously XtraDB. It also introduces Window functions, recursive and non-recursive Common Table Expressions (including the WITH statement), CHECK CONSTRAINT, EXECUTE IMMEDIATE, and supports spatial indexes for InnoDB tables.

For more details see the article Changes & Improvements in MariaDB 10.2.

55 questions
12
votes
4 answers

In the same query INSERT, can two VALUES being NOW() return a different time?

I met a query similar to INSERT INTO mytable (id, Created, Updated) VALUES (null, NOW(), NOW()) having column definitions | Created | datetime | | Updated | datetime | Will in this case MySQL set the NOW() value to the current time and return…
Déjà vu
  • 375
  • 3
  • 16
6
votes
1 answer

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=utf8; I created another tablet called compare to…
Michael Samuel
  • 187
  • 5
4
votes
1 answer

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 certificates as well. But, if I start the client with…
simpleuser
  • 143
  • 6
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 has 135GB free space. The D drive (NTFS) which…
SkelDave
  • 143
  • 1
  • 5
3
votes
2 answers

Dropping a CHECK in mariadb?

I have a schema migration plan to add json column to mariadb 10.2. But I am required to have a reverse plan. Here's the forward plan: ALTER TABLE `mydb`.`table1` ADD COLUMN jsonf JSON DEFAULT NULL; ALTER TABLE `mydb`.`table1` ADD…
mhd
  • 131
  • 2
3
votes
1 answer

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 log of InnoDB during start up. If we start with…
Etienne Ott
  • 133
  • 1
  • 4
2
votes
2 answers

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 databases , obviously its true that we have…
SAGAR Nair
  • 177
  • 1
  • 9
2
votes
1 answer

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 account (AccountId1). AccountId1 bigint PK, AccountId2…
Natan
  • 167
  • 1
  • 8
2
votes
1 answer

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…
Budyn
  • 131
  • 2
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 ~/.my.cnf because that would apply all hosts. For…
Jared Beck
  • 278
  • 3
  • 11
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 using triggers in MariaDB 10.2? (In other words, for…
Tobias Bengtsson
  • 31
  • 3
1
vote
1 answer

Inconsistent results between MySQL and MariaDB when using variables and order

I'm building an accounting table and I need to show the current balance on each transaction. Everything is working fine in my local environment (Windows 10 + MySQL 5.7.19), but the same query gives me strange results on my VPS (Linux + MariaDB…
azeós
  • 113
  • 3
1
vote
2 answers

Missing an inserted row

I am having a strange heisenbug when a set of queries in a transaction (in MariaDB 10.2.38) somehow results in missing rows afterward. I mean that there are rows inserted within the transaction, but when the transaction ends, they are missing in the…
Simbiat
  • 31
  • 6
1
vote
0 answers

JOIN bug in MariaDB 10.2

This is less a question than just a "beware." Thankfully MariaDB 10.2 is an old version, but it does some funky things when joining to nested derived tables. I updated my database from MariaDB 10.0.35 to 10.2.12 and this bug popped up. I tested the…
John Alexander
  • 123
  • 3
1
vote
0 answers

Why is PDO::ATTR_EMULATE_PREPARES = false causing "MySQL server has gone away" errors?

I've been using PHP PDO with the default setting of ATTR_EMULATE_PREPARES = true and it was working fine. However, I wanted to be able to select database values as integers instead of having them converted to strings. When I set…
lfjeff
  • 71
  • 3
1
2 3 4