Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

MariaDB is based on MySQL and is available under the terms of the GPL v2 license.

It's developed by the MariaDB community with Monty Program Ab as its main steward.

MariaDB is kept up to date with the latest release from the same branch.

In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB. There is no need to convert databases to switch to MariaDB. MariaDB is a true drop in replacement of MySQL! Additionally, MariaDB has a lot of nice new features that you can take advantage of.

See the MariaDB FAQ for more information.

See also:

837 questions
3
votes
2 answers

Uninstalling MySQL for MariaDB Replacement on cPanel

Well the first part of my day was spent researching how to remove MySQL to install MariaDB and the second part of my day was spent trying to reinstall MySQL cause something was messed up. So now I come to the masses for some help. I have a box with…
n0nag0n
  • 163
  • 1
  • 8
3
votes
1 answer

Can't set binlog_format for MariaDB

I have MariaDB running on my dev server (no replication or anything else) running version 5.3.5. It's an Ubuntu 10.04 server running all the latest patches and updates. I am having issued getting errors regarding the the binlog_format, so I went to…
Dave Long
  • 349
  • 1
  • 4
  • 15
3
votes
2 answers

When - if at all - should I switch from MySQL to MariaDB?

Now that MySQL is owned by Oracle, the future of the RDBMS seems uncertain. The fork by the main developer of MySQL, Monty Widenius, called MariaDB, is a drop-in replacement for MySQL. Version numbers match up of those two DB-Servers, and MariaDB…
polemon
  • 585
  • 2
  • 8
  • 21
3
votes
3 answers

How to disable all MariaDB storage engine except MyISAM?

(in my.cnf) I've tried default-storage-engine = myisam, skip-innodb, and commented out every innodb features, but none of them works
cewebugil
  • 715
  • 3
  • 9
  • 12
3
votes
3 answers

Migrating from MySQL Server to MariaDB

I've heard that MariaDB has better performance than MySQL-Server. I'm running software that makes an intensive use of MySQL, thats why I want to try upgrading to MariaDB. Please tell me your experiences doing this conversion, and instructions or…
Rodrigo
  • 267
  • 3
  • 12
3
votes
2 answers

How to find joins performed without indexes?

I run a WordPress website on Mariadb 10.6, and recently I saw an error Joins performed without indexes in Mysqltuner. Although the number is not very large, Mysqltuner recommends that you keep increasing the Key_buffer_size. However, my VPS doesn't…
Junuk
  • 33
  • 3
3
votes
1 answer

MariaDB using much more memory than it should

We are using MariaDB 10.3.32 on a Ubuntu 20.04.4 machine with 6 GB of memory, about 20 applications running on it. Databases are all InnoDB. Even with mostly default settings (see on the bottom), memory usage increases from day to day, seemingly…
rofire
  • 31
  • 1
  • 4
3
votes
1 answer

mysqld fails to start due to InnoDB

I did install MariaDB on MX Linux, my system info below : System: Kernel: 5.10.0-9-amd64 x86_64 bits: 64 compiler: gcc v: 10.2.1 parameters: BOOT_IMAGE=/boot/vmlinuz-5.10.0-9-amd64 root=UUID= ro quiet splash …
chepakwak
  • 51
  • 1
  • 3
3
votes
2 answers

Importing old mysql database dump into MariaDB docker container fails: Table 'user' already exists

I'm trying to import an older (~version 5) server into a MariaDB docker container. I created a dump using the mysqldump command (with --all-databases), and when I try to import it I get the following error: ERROR 1050 (42S01) at line 2071: Table…
dkd6
  • 155
  • 1
  • 9
3
votes
1 answer

MariaDB table has a metadata lock, but no blocking thread

I have a MariaDB 15.1 installed on a Debian system: $ mariadb --version mariadb Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 A script regularly loads data into a table with LOAD DATA LOCAL INFILE. The script…
monday
  • 185
  • 1
  • 1
  • 5
3
votes
0 answers

MariaDB empty user in user table

I have an issue with a couple of users in the database. I noticed this when tried to add a new user, the CREATE USER, GRANT and FLUSH PRIVILEGES get executed correctly and SHOW GRANTS FOR 'reporte' shows the correct information for the new user, but…
mariofix
  • 131
  • 3
3
votes
3 answers

MariaDB reduce buffer RAM usage per thread

I was looking for an answer to this question, but couldn't find it anywhere. I want to reduce the memory usage per each database connection. Here is what mysql tuner currently says about memory usage for one of my databases: [--] Physical Memory …
djaho
  • 81
  • 1
  • 6
2
votes
1 answer

The target table user of the INSERT is not insertable-into MariaDB 10.4.11

I did a wonderful thing of deleting all root users from mysql by accident. That kind of a day. However before I panic I figured I would use this method here from searching online that didn't seem so bad. "Add 'skip-grant-tables' to my.cnf under…
gstlouis
  • 119
  • 3
  • 12
2
votes
1 answer

How to access mysql console on Docker container using secrets

I've been able to access Mysql console on a Mariadb Docker container. From my local machine I can run this command to access the console (I have mariadb installed locally): mysql -h localhost -P 3306 -u lc -p --protocol tcp The issue rise when I…
a.barbieri
  • 483
  • 1
  • 5
  • 7
2
votes
1 answer

Was I using MariaDB or MySQL?

An Ubuntu upgrade (to 19.10) messed up my database server. After the upgrade, the sql server would not start. So I installed MySQL but later realized that I may have been using MariaDB. Is there a way to find out based on the table's content, what…
MeSo2
  • 254
  • 1
  • 3
  • 18
1 2 3
…
55 56