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
2 answers

DateTime String via MySQL DATE_FORMAT or DateTime.strftime

I have a function that consumes a datetime string that is returned from a DB query. Right now the query returns a datetime object. What I am looking for is what would be the preferred way to create my datetime string. I have not done any…
Brian M.
  • 67
  • 1
  • 1
  • 4
2
votes
1 answer

Substitution for too large composite key

I'm trying to find the best solution for the given problem: I have an Entity (lets call it Collateral) which consists of several fields. The uniqueness of this entity is defined by the composition of 4 fields (let's call them: user_id (bigint),…
Przemysław Gęsieniec
  • 618
  • 6
  • 15
2
votes
2 answers

How to allow mysql(mariadb) to read files from /tmp - Fedora 30

I've written a program receives data from a socket, formats the data to CSV format, then dumps the data to a file; '/tmp/test_csv.csv'. Next, I execute the following in mysql: LOAD DATA INFILE '/tmp/test_csv.csv' INTO TABLE flow_data FIELDS…
vddox
  • 182
  • 11
2
votes
2 answers

How to configure mutiple DataSource with driver-class in Spring?

Why is the driverclass missing in the following…
membersound
  • 81,582
  • 193
  • 585
  • 1,120
2
votes
1 answer

What does the first part of the MariaDB version string mean?

If I inspect the DB version information from within PHP, MariaDB returns an extra set of version numbers at the front of its version string. >>> DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION); =>…
Erich
  • 2,408
  • 18
  • 40
2
votes
1 answer

MariaDB SELECT multiple rows as single row

How do I SELECT multiple rows of the same data (same table) as a single row? Use case: I'm building a contacts management tool. Some people may have multiple email addresses and/or phone numbers. Instead of having to manually add yet another LEFT…
John
  • 1
  • 13
  • 98
  • 177
2
votes
2 answers

error1064 using phpmyadmin

I can't understand why sql gave me an error #1064. I just followed the instruction at this Full Outer Join - Save Output in new table I tried putting "INSERT" syntax before the "INTO" but the error is the same SELECT * INTO newtable FROM buyers…
Di Masalang
  • 23
  • 4
2
votes
1 answer

MariaDB - Create many to many relationship table between two entities

I am having a problem creating a many to many relationship table in MariaDB. I have tried using the workbench, manual creation scripts and the "Show Create Table xxxxxxx;" from another already created n to n tables but the result is always the same,…
Guido
  • 81
  • 2
  • 9
2
votes
2 answers

MariaDB: How to using "INSERT ... SELECT" with WITH statement

Note: This involves ColumnStore. At work, we have a big SQL statement that takes too much memory to execute on prod. I'm currently working on reducing the size the query consumes. I've tried using different approaches, but nothing has solved the…
mhrvatin
  • 156
  • 2
  • 12
2
votes
4 answers

Simple Select Query taking too much time in mysql-table with large data-set 10M

SELECT * FROM many_leads_lead_details WHERE location LIKE '%Los%Angeles%' AND (keywords LIKE '%Real%' or keywords LIKE '%Real Estate%' or keywords LIKE '%Real Estate Agent%') above query is taking too much time as compared to…
Savan Solanki
  • 140
  • 9
2
votes
1 answer

How to acces MariaDB with NodeJS on Windows

I just downloaded MariaDB 10.3 for Windows ,created a database and trying to connect from a NodeJS server using mysql library. var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password:…
Vlad Constantinescu
  • 101
  • 6
2
votes
0 answers

MySQl MariaDB group timestamp by points

I have the following: data points collected per day with associated date - unix timestamp. I am trying to achieve the following: Filter data points per day. i.e suppose I have 4 data points per day, I am trying to reduce it to n data points per…
Abhilash Gopalakrishna
  • 910
  • 2
  • 22
  • 52
2
votes
2 answers

How to update a table from a select query

i am creating a temp table using DB facade and then using select query i need to update some columns in temp table based on condition DB::update('update table_temp_topcustomer set ordercount = aaa.ordercount from …
Kumar
  • 21
  • 3
2
votes
2 answers

JHipster 6.0.1: Liquibase tasks fail

Just trying out JHipster v6.0.1, following the sample Blog application (http://gist.asciidoctor.org/?github-mraible/jhipster5-demo//README.adoc). Choosing Gradle as the build tool, with MariaDB in development and production, liquibase tasks…
Mike Smith
  • 238
  • 3
  • 14
2
votes
1 answer

loopback: how do I make sure that values are sent to the local db, not the remote db?

I have a version of the api server running locally. In the react-native app, I've pointed the BASEURL from the remote server, to my local address. From there, I start the server via node . Even though I'm able to login/create a new account, I…
VK1
  • 1,676
  • 4
  • 28
  • 51
1 2 3
…
99 100