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.

59 questions
13
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
  • 555
  • 2
  • 8
  • 19
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
  • 1
  • 6
5
votes
2 answers

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
  • 153
  • 1
  • 6
4
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
  • 143
  • 1
  • 1
  • 4
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
  • 163
  • 1
  • 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
  • 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
  • 187
  • 2
  • 10
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
  • 9
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
  • 3
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
  • 288
  • 3
  • 12
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
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 through variables, it works fine. Unfortunately I have…
Tarcaird
  • 23
  • 1
  • 4
1
vote
0 answers

How can I prevent overload of Mariadb server?

I'm running MariaDB 10.2.27 on Ubuntu 16.04 (10 cores, 40 GB RAM). We have a queued message handling system (using Symfony Messenger) that normally has 20 workers consuming messages from the queue. These spawn jobs that connect to the database and…
lfjeff
  • 101
  • 6
1
vote
1 answer

Mysql service down with [ERROR] InnoDB: Page log sequence number is in the future

I have a Centos 7.9 server with MariaDB version 10.2.43. All of a sudden on May 2 2022, I have started receiving mysql down alerts. On checking I could see below log information in logs. Error 2:- May 2 22:09:03 server1 mysqld: 2022-05-02…
nisamudeen97
  • 210
  • 1
  • 4
  • 8
1
vote
1 answer

Mysql service stops with [ERROR] InnoDB: CORRUPT LOG RECORD FOUND

In my Plesk Obsidian version 18.0.42 running on CentOS Linux release 7.9.2009 with MySQL version 10.2.43-MariaDB. All of a sudden database stopped working. Mysql service never comes up on start request. On checking the logs I found the below…
nisamudeen97
  • 210
  • 1
  • 4
  • 8
1
2 3 4