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

2838 questions
152
votes
4 answers

Is it safe to delete mysql-bin files?

I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those files like mysql-bin.000123, mysql-bin.000223 etc.…
user18530
55
votes
5 answers

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
  • 551
  • 1
  • 4
  • 3
39
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,758
  • 6
  • 28
  • 29
30
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
  • 365
  • 1
  • 3
  • 7
26
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,944
  • 4
  • 31
  • 44
26
votes
6 answers

MySQL FOREIGN KEY constraint is incorrectly formed

I have the following table definition: CREATE TABLE `async_task` ( `idasync_task` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `idasync_type` int(10) unsigned NOT NULL, `priority` tinyint(3) NOT NULL, `status` enum('todo','doing','failed')…
Daniel Gray
  • 699
  • 3
  • 11
  • 18
26
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'
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
18
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
  • 365
  • 1
  • 4
  • 7
17
votes
3 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
  • 1,009
  • 6
  • 16
  • 21
17
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
  • 1,009
  • 6
  • 16
  • 21
17
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?
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
17
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
  • 271
  • 1
  • 2
  • 5
16
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
  • 344
  • 1
  • 2
  • 12
14
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
  • 357
  • 3
  • 14
14
votes
2 answers

Cannot drop column : needed in a foreign key constraint

I have a table with two foreign key constraints as below: mysql> SHOW CREATE TABLE `user`; CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `region_id` int(11) unsigned DEFAULT NULL, `town_id` int(11) unsigned DEFAULT…
Sithu
  • 367
  • 3
  • 4
  • 10
1
2 3
…
99 100