Stack Overflow
Stack Overflow

Questions tagged [mariadb]

MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.

MariaDB is an open source database server that offers drop-in replacement functionality for .

This MySQL fork has been made by its own original developers, triggered by doubts over the future management of MySQL after its acquisition by Oracle (through Sun Microsystems) in 2009. MariaDB is now released under the , and maintained by the community with the intent to maintain a high compatibility with MySQL APIs and commands.

Supported Storage Engines:

  • ARCHIVE
  • Aria
  • BLACKHOLE
  • Cassandra (added in 10.0)
  • CONNECT (added in 10.0)
  • CSV
  • FederatedX (drop-in replacement for Federated)
  • InnoDB
  • MEMORY
  • MERGE
  • Mroonga (added in 10.0)
  • MyISAM
  • OQGRAPH
  • S3 (added in 10.5.4)
  • SEQUENCE (added in 10.0)
  • SphinxSE
  • Spider (added in 10.0)
  • TokuDB (added in 5.5)
  • XtraDB (DEFAULT, drop-in replacement for InnoDB)

Legacy storage engines:

  • Federated (still provided, but FederatedX is recommended instead)
  • IBMDB2I (removed in 5.5)
  • PBXT (removed in 5.5)

Resources:

Related tags:

13893 questions
2
votes
1 answer

Fetching object JSON array using JSON_QUERY in MariaDB

How do I access the value of a object property, inside an array, using JSON_QUERY in MariaDB? I have a JSON field with following data, and want to access the value of the section property. [ [ {"section": "search"} ] ] The following SQL is…
Joyce Babu
  • 19,602
  • 13
  • 62
  • 97
2
votes
3 answers

How to avoid duplicates in my mysql query?

I am trying to create a query which - when executed - will show a date, status (where there are there are several status options) and the number of events on that date - distinguished by status. I was able to create a query which shows all data I…
Mal_235
  • 53
  • 8
2
votes
0 answers

Doesn't connect host's DB using docker container with php7.0-fpm

I'm currently trying to link the host's database with php-fpm inside the docker container. However, I have to ask you a question because the area is not working properly. I didn't use php offical base image. so, i created a docker file as shown…
Liquid.Bear
  • 333
  • 6
  • 21
2
votes
2 answers

How do I identify slow queries missing an index?

Using SET GLOBAL log_slow_verbosity='query_plan,explain'; on a slow log, I get a lot of output, but I am struggling to understand the explanation. # User@Host: root[root] @ [10.0.1.5] # Thread_id: 31 Schema: enterprise QC_hit: No # Query_time:…
hendry
  • 9,725
  • 18
  • 81
  • 139
2
votes
1 answer

MariaDB 10.3.14 DELETE statement using CTE results in Syntax Error

I am trying to use CTE in a DELETE statement (as CTEs are much more comfortable to use for me than derived tables) in MariaDB 10.3.14 but I cannot seem to get it working. I have spent quite a lot of time trying to solve this problem but every time…
dfx413
  • 58
  • 5
2
votes
1 answer

Should database users also have access to mysql, information_schema & performance_schema tables?

So I have for example a table in my database called "Test", I have created a user with SELECT,INSERT & UPDATE only privileges. This user will be inserting data to the database. Should this user be limited to only having access to the "Test" table or…
code-is-life
  • 175
  • 2
  • 16
2
votes
2 answers

Symfony 4 after generating user via make:user schema update crashed

I am trying make user via CLI: (symfony doc) php bin/console make:user This command create User.php entity which implements UserInterface. But after command: php bin/console doctrine:schema:update --force I get errors: In AbstractMySQLDriver.php…
Lajdák Marek
  • 2,969
  • 8
  • 29
  • 58
2
votes
1 answer

zeroDateTimeBehavior=convertToNull not working in jdbc url using hibernate

Through an extern properties file url is specified as the following jdbc:mariadb://xxxxx:3306/xxxxx?zeroDateTimeBehavior=convertToNull The connection works fine and am able to query the DB. Through hibernate I made an entity that is mapped to a…
Visker
  • 21
  • 1
  • 2
2
votes
1 answer

How to avoid "too many connections"

2019-04-24 15:52:26.526 9818 ERROR oslo_messaging.rpc.server [req-857fec8a-7196-4425-85e4-389e2655a2c3 - - - - -] Exception during message handling: OperationalError: (pymysql.err.OperationalError) (1040, u'Too many connections') (Background on…
Elliot
  • 598
  • 6
  • 25
2
votes
0 answers

Table size increased after running "optimize table tablename";

I have ran a OPTIMIZE TABLE Table name; where Table name size is around 54GB. to reduce the size of this innodb table i ran optimize table command.But this increased the size of table to 59 GB! Any reasons for this will be more helpful. Edit1: This…
Bannarisamy Shanmugam
  • 112
  • 7
2
votes
2 answers

Retrieve records from pivot matching it's owner

using latest mariaDB release, I have the following table structure (trimmed for example) Table A +--------+------+ | id |name | +--------+------+ | 1 | Bob | | 2 | Jane | +--------+------+ Table B +--------+------+ | id |city …
Dyasis
  • 61
  • 7
2
votes
2 answers

Accessing /docker-entrypoint-initdb.d from helm chart

I am trying to initialize a fresh instance of MariaDB (putting my .sql file inside /docker-entrypoint-initdb.d) using the official helm chart at https://github.com/helm/charts/tree/master/stable/mariadb#initialize-a-fresh-instance. But I find the…
shellwhale
  • 820
  • 1
  • 10
  • 34
2
votes
1 answer

How to insert float numbers from mysqldump

I have sql dump file coming from FirebirdSQL. Looks same as exported from MySQL (MariaDB). In the said file there are table creation statements one of which are the following: CREATE TABLE VALIORS ( ...., STK_SUM FLOAT DEFAULT 0, …
Tsefo
  • 409
  • 4
  • 15
2
votes
0 answers

Unable to configure HikariCP in Spring Boot/JDBI/MySQL application

I am building a RESTful interface to a MariaDB-hosted database, and I cannot figure out how to properly configure HikariCP so that my database connections don't time out after the server has been idle for a while. I am on Linux, Java 1.8, and my…
James A Cubeta
  • 61
  • 1
  • 9
2
votes
0 answers

Can not connect to MariaDB using PAM, Java

I've using Java8, MariaDB, and the PAM module supplied by Percona. $ java -version java version "1.8.0_112" Java(TM) SE Runtime Environment (build 1.8.0_112-b15) Java HotSpot(TM) 64-Bit Server VM (build 25.112-b15, mixed mode) Welcome to the…
Greg Dougherty
  • 3,281
  • 8
  • 35
  • 58
1 2 3
…
99
100