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

Chose free database management system for .NET Web Site

I need help with a chose. I want to chose a database_management_system for my .NET Web Site. My current variants is : - MariaDB - PostgreSQL - Firebird I used MS SQL and have no experience with those ones and can't compare them. What I need from…
cnd
  • 32,616
  • 62
  • 183
  • 313
2
votes
0 answers

How to fix the "server has gone away" warning when mysqli reconnects a persistent connection?

When connecting to the database with a persistent connection (to avoid the connection time overhead), PHP warns that the "server has gone away". This is the code I use: $db = new mysqli("p:10.0.0.1", "user", "pass"); I looked at the following…
Luc
  • 5,339
  • 2
  • 48
  • 48
2
votes
3 answers

Is any working way to set a MySQL row to READ-ONLY?

I have read all threads here and did not found any simple and working solution to my question. So i am running site on php script which is using DB on 10.1.37-MariaDB. I have there 1 table in that i need to set only several rows (from 90k) to be…
Smeklinis
  • 61
  • 8
2
votes
2 answers

PHP Connection Error to MariaDB: Error 1045 Access Denied

I am trying to connect to a mariadb database using PHP without success. Each attempt I get the following: Error: Unable to connect to MySQL. Debugging errno: 1045 Debugging error: Access denied for user 'gt_user'@'localhost' (using password:…
sir_ripsalot
  • 21
  • 1
2
votes
2 answers

How to connect to local mariadb server with node.js

I'm trying to connect to a local mariadb server using node.js. When I try connecting I get the error: "Error: (conn=8, no: 1045, SQLState: 28000) Access denied for user 'root'@'localhost' (using password: NO)" I am not sure why this is, as I have…
John Paul
  • 21
  • 1
  • 2
2
votes
1 answer

How to fix "ERROR 1118 (42000): Row size too large (> 8126)" with MariaDB 5.5?

I am uploading a CSV file with 314 columns to a MariaDB 5.5 server. Currently my code looks like this: CREATE TABLE table_name (column_1 TEXT, column_2 TEXT, ... column_314 TEXT) ROW_FORMAT=DYNAMIC; LOAD DATA LOCAL INFILE filepath …
Jon Riege
  • 35
  • 1
  • 6
2
votes
0 answers

How to launch mysql persistent on openshift OKD?

I am unable to launch mysql deployment with persistent storage, the ephemeral one works fine. I am getting the following error. I tried launching deployment from cli and web console as well. In both cases I get the following error. => sourcing…
user1859366
  • 113
  • 1
  • 9
2
votes
1 answer

Practical implementation of multi-tenant approach in mysql / mariadb (or amazon aurora)

I fully understand the pros and cons of using shared vs separate schemas (or databases in mysql). Looking at those we have chosen to use a shared schema. Looking for ideas on how we can more easily accomplish multi-tenancy. I am happy to add a key…
Regular User
  • 682
  • 7
  • 16
2
votes
0 answers

How to fix error after compiling with GCC on ubuntu? /usr/bin/ ld: cannot find

I'm practicing with the MySQL C API, because I need to do a project for the university. I have a problem after compiling with gcc on ubuntu. I'm working with MariaDB on simple example like this: #include #include int…
Giacomo Intini
  • 21
  • 2
2
votes
2 answers

SQL: Set default value to NULL for all columns without default value

The webhosting I use has enabled StrictMode for the Databases. All my php scripts now stopped working because they report I haven't defined a default value for some columns. As I have a lot of columns in a lot of tables, is there a way to set all…
OpenStudio
  • 41
  • 1
  • 1
  • 6
2
votes
1 answer

How to generate hierarchical result (pedigree) from sql query without CTE?

I have a database of dogs. Each dog has a sire and dam parent. I am not able to use CTE for this due to an issue with phpmyadmin and MariaDB 10.0. I updated to MariaDB 10.2.20 to use CTE. Still getting "Unrecognized Statement type. (near WITH) in…
user1956040
  • 111
  • 2
  • 12
2
votes
0 answers

What is the syntax for MariaDB 'IN NATURAL LANGUAGE MODE'?

According to the MariaDB documentation: There are no special operators, and searches consist of one or more comma-separated keywords. The search clearly does not need to be comma-separated, as replacing commas with spaces gives the same…
Liam
  • 19,819
  • 24
  • 83
  • 123
2
votes
3 answers

Identifying elements in one array of hashes that are not in another array of hashes (perl)

I'm a novice perl programmer trying to identify which elements are in one array of hashes but not in another. I'm trying to search through the "new" array, identifying the id, title, and created elements that don't exist from the "old" array. I…
Alex Regan
  • 477
  • 5
  • 16
2
votes
1 answer

Mariabackup ignoring --target-dir

I'm in the process of automating our mariadb backup jobs into a python program. However for some reason it appears that the --target-directory parameter, although being passed correctly and validated by printing, is ignored when running the actual…
imbrian21
  • 121
  • 8
2
votes
3 answers

SQL show results for A column first then show results for B column

I want SQL to show / order the results for the column name first then show results for the description column last. Current SQL query: SELECT * FROM products WHERE (name LIKE '%$search_query%' OR description LIKE '%$search_query%') I tried adding…
Niels
  • 1,005
  • 1
  • 8
  • 18
1 2 3
…
99
100