Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mariadb]

Open source RDBMS that forked from MySQL. Add a version-specific tag like mariadb-10.5 if that context is important.

MariaDB Server is a high performing open source (GPLv2) relational databases, forked from MySQL.

The development aims to maintain high compatibility with MySQL, ensuring a library binary equivalency and exact matching with MySQL APIs and commands. MariaDB developers continue to develop new features and improve performance to better serve its users.

For more information, including compatibility details, please see MariaDB versus MySQL - Compatibility

2153 questions
38
votes
5 answers

When is the right time to use MariaDB instead of MySQL, and Why?

What we earn and what we lost with this migration? What should I expect as drawbacks after the migration? Is it really unnecessary to change the applications in any situation?
Maniero
  • 2,478
  • 6
  • 26
  • 29
27
votes
2 answers

How do I properly perform a MySQL bake-off?

I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better understand the methodology behind setting up a proper…
randomx
  • 3,874
  • 3
  • 28
  • 43
27
votes
8 answers

MariaDB Can't init tc log

I've tried every solution on the Internet but my MariaDb server continue to fail, continue to betray me, continue to destroy my tiny DevOps world. My attempts to smooth the situation included all sorts of satisfaction: changing permissions, configs,…
Sam Ivichuk
  • 335
  • 1
  • 3
  • 7
23
votes
3 answers

How do I resolve this error, "ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'"?

When I run the following command I get an error, however one of my scripts requires it. SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
NO WAR WITH RUSSIA
  • 54,954
  • 34
  • 200
  • 411
17
votes
3 answers

Why does importing a 12 GB .sql file take more than 36 hours?

I've been waiting now for 36 hours for a 12 GB .sql file to be imported with a simple type site.sql | mysql command. I can see the ibdata1 is growing still, currently nearly 40 GB. Considering the triggers and stored procedures are at the end of the…
servermanfail
  • 355
  • 1
  • 3
  • 7
16
votes
2 answers

Does MariaDB support native JSON column data type?

I’m not talking about dynamic columns, I’m asking about native column JSON data type. In simple words, can I run the following code on any MariaDB version? CREATE TABLE example (names JSON); As far as I know, it doesn’t but I’m still not sure since…
Omranic
  • 261
  • 1
  • 2
  • 5
15
votes
2 answers

Why does auto increment jumps by more than the number of rows inserted?

I am very perturbed by this weird behaviour I am seeing in the auto_increment value recorded in the bidID of a Bids table after performing bulk insertion using a stored procedure: INSERT INTO Bids (itemID, buyerID, bidPrice) SELECT itemID,…
Question Overflow
  • 909
  • 5
  • 15
  • 21
15
votes
2 answers

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then why isn't Galera cluster as common?
Sam
  • 334
  • 2
  • 12
14
votes
5 answers

How to determine the optimal sort_buffer_size?

I read from a sample configuration file which says the following: # Sort buffer is used to perform sorts for some ORDER BY and GROUP BY # queries. If sorted data does not fit into the sort buffer, a disk # based merge sort is used instead - See the…
Question Overflow
  • 909
  • 5
  • 15
  • 21
13
votes
2 answers

Install MariaDB 10 on Ubuntu without prompt and no root password

Pretty much the same as this question but I don't want to have a root password (this is just a dev machine). Here's what I've got: export DEBIAN_FRONTEND=noninteractive sudo debconf-set-selections <<< 'mariadb-server-10.0 mysql-server/root_password…
mpen
  • 397
  • 2
  • 5
  • 17
13
votes
2 answers

To what extent is MariaDB Java client a perfect replacement for MySQL JDBC (Connector/J)?

Premise: I ship a Java application which will make a JDBC connection to a MySQL database. (At the time of this writing it could be 5.1 or 5.5, but hopefully the question and answer don't rely heavily on the version.) Observation: Clearly, I can use…
mdahlman
  • 349
  • 3
  • 14
13
votes
4 answers

Datatype for phone number: VARCHAR, INT or BIGINT?

So this will be the dummy question of the year but I need to ask since is not the first time I pass through this. Take a look to the following table definition: Take a look at the column from_number which is a VARCHAR(45) right now but it will hold…
ReynierPM
  • 1,690
  • 10
  • 29
  • 44
12
votes
1 answer

mysql to mariadb: unknown collation utf8mb4_0900_ai_ci

I have a mysql 8.0 that I exported using mysqldump. I am trying to import it onto a Mariadb 10.4 database with phpmyadmin, both are the most current versions. Each time I do it though, I get: Error: Unknown collation utf8mb4_0900_ai_ci Then I went…
Frosty
  • 121
  • 1
  • 3
12
votes
1 answer

MariaDB 10.1.38 - Specified key was too long; max key length is 767 bytes

I have a table that has 3 columns: id(int 11) | user_id(int 4) | title(varchar 512) ____________|________________|___________________ 1 | 3 | Thing X 2 | 3 | Something Else 3 | 5 …
Emanuel Ones
  • 421
  • 1
  • 3
  • 8
12
votes
2 answers

How do I disable MySQL on Linux from starting on boot or statup?

After adding MySQL to Ubuntu, it automatically starts up on server boot. I would like it to not start up with the system. How can I disable it and manually start it?
NO WAR WITH RUSSIA
  • 54,954
  • 34
  • 200
  • 411
1
2 3
…
99 100