Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mariadb-10.3]

MariaDB 10.3 was released as stable (GA) with version 10.3.7 on 25 May 2018. Please also tag with mariadb for search purposes.

Some of the new features in 10.3 include: system-versioned tables (a.k.a. temporal tables), sequences, table value constructors, new window functions (such as MEDIAN), support for a subset of Oracle PL/SQL (with sql_mode=ORACLE), aggregate stored functions, instant ADD COLUMN for InnoDB tables, two new options for ALTER TABLE ... ALGORITHM (INSTANT and NOCOPY), INTERSECT and EXCEPT, and invisible columns.

127 questions
10
votes
2 answers

Does MariaDB or MySQL implement the VALUES (expression) table value constructor?

I am just wondering if MariaDB or MySQL implements the in the SQL Spec. In SQL Server and PostgreSQL this is done with standardized VALUES (expression)? SELECT * FROM ( VALUES (1) ) AS t(x); x --- 1 (1 row) (syntax from…
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
8
votes
2 answers

Change default collation for character set utf8mb4 to utf8mb4_unicode_ci

When creating a database without specifying a character set or collation the servers defaults are used (as expected). MariaDB [(none)]> SHOW VARIABLES LIKE '%_server' ; +----------------------+--------------------+ | Variable_name | Value …
Peter van der Wal
  • 183
  • 1
  • 1
  • 4
6
votes
4 answers

How to take mysqldump with Generated column?

I am getting below error while importing the dump, ERROR 3105 (HY000) at line 82: The value specified for generated column 'column_name' in table 'table_name' is not allowed. When I describe the table with error, there are some generated columns…
karthikeayan
  • 193
  • 1
  • 1
  • 10
6
votes
3 answers

What are "Invisible Columns" and how are they used?

I saw a new feature Invisible Columns in MariaDB 10.3.x. What are practical use cases for DBA and web developer? When to use this feature? Columns can be given an INVISIBLE attribute in a CREATE TABLE or ALTER TABLE statement. These columns will…
Sybil
  • 2,578
  • 6
  • 34
  • 61
4
votes
1 answer

InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3

I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times Cannot open table mysql/innodb_index_stats [duplicate] InnoDB: Error: Table…
papanito
  • 153
  • 2
  • 6
4
votes
1 answer

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 the tabular format (Tabular Explain). When I try…
AndoverDev
  • 143
  • 3
3
votes
0 answers

MariaDB - Query to find unused indexes

I need to find unused index on a MariaDB database and do not have 'userstat' enabled, I found this query which is supposed to find unused indexes, but I am unable to get a full understanding of this as I am just a beginner, I have an understanding…
DB guy
  • 69
  • 3
  • 8
3
votes
1 answer

JSON field saves as longtext datatype

I'm trying to create JSON column in 10.3.16-MariaDB but every time I save the configuration in PHPMyAdmin, the column saves as longtext datatype. No errors shown :| Where could be the problem? System specs: Apache/2.4.39 (Win64) OpenSSL/1.1.1c…
Armand
  • 133
  • 1
  • 6
3
votes
2 answers

MariaDB 10.3: InnoDB much slower than MyISAM

I'm using MariaDB 10.3.12 on Arch Linux and haven't modified any of the default settings under /etc/mysql. The following script takes 0.75 s to run on average using the default InnoDB engine: drop database if exists test_database; create database…
Raul Laasner
  • 171
  • 10
3
votes
1 answer

Can upgrade from MariaDB 5.5 to MariaDB 10.3 directly?

We have a database running in MariaDB 5.5.60 and we want to upgrade it to the last 10.3.7 version. However I'm looking at MariaDB knowledge base ( https://mariadb.com/kb/en/library/upgrading/ ) and I'm not sure if we can perform a direct in-place…
vegatripy
  • 668
  • 2
  • 7
  • 17
2
votes
1 answer

MariaDB 10.3 on Debian 10 ignores long_query_time value

I have enabled the Slow Query Log on a Mariadb 10.3 server on Debian 10. Below is the implemented configuration MariaDB [(none)]> show session variables like '%slow%'; MariaDB [(none)]> show session variables like…
MJJ
  • 23
  • 4
2
votes
2 answers

How do I find out what's causing processes to wait for table flush?

I'm currently using MariaDB 10.3 and am troubleshooting this case where threads will start to build up until the MySQL service eventually has to be restarted. I was able to capture the process list before restarting MySQL, but I have a few questions…
kenshin9
  • 119
  • 1
  • 3
2
votes
3 answers

How to get more connections for mariaDB or how to reduce RAM usage per thread?

We have an MariaDB 10.3 database server running on an 8 core and 64GB RAM machine. The database engine is innoDB. Our current max_connections = 175 and our DB admin tells me that it is not possible to increase the number of connections any further…
Lonzak
  • 125
  • 1
  • 5
2
votes
1 answer

Authentication relying on mysql_native_password seems to also check for Linux user?

I have a mariaDB 10.3 install. The mysql.table states that 'root' login relies on mysql_native_password plugin, with no password set. If my linux user is root, I am able to connect to mysql using; mysql -u root -h localhost If I login as a non…
nonayme
  • 23
  • 4
2
votes
1 answer

MaridDB 10.3.29 prevents me from deleting a foreign key

This is a minimal example that triggers the error CREATE TABLE A ( id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY ); CREATE TABLE B ( what tinyint NOT NULL, a bigint NOT NULL, CONSTRAINT x FOREIGN KEY (a) REFERENCES A(id), CONSTRAINT y…
Wombatz
  • 131
  • 4
1
2 3
…
8 9