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
0
votes
1 answer

unknown variable 'file-key-management-filename'

New installation of Debian 10, with MariaDB 10.3.29. Trying to set up encryption-at-rest, but MariaDB won't start due to an error... 2021-07-16 17:13:16 0 [Note] InnoDB: Using Linux native AIO 2021-07-16 17:13:16 0 [Note] InnoDB: Mutexes and…
Stephen
  • 1
  • 2
0
votes
0 answers

MariaDB crashes frequently

I'm suffering from MariaDB crashing issue for a weeks running on VPS Debian 10. I searched a lot in the internet ,but couldn't found any solution. I tried this , this, this etc... but seriously I didn't found any solution. This is the MariaDB error…
Kiran RS
  • 103
  • 7
0
votes
1 answer

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) as non-root user

Can't connect to a local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) I am getting this message, but only when I am not logged in as root. How come not everyone has access to mysql? It doesn't work on user htorrent, and it works as…
Sayaman
  • 187
  • 1
  • 11
0
votes
1 answer

MySQL High Load CPU

I have problem with MariaDB , when connect analytics ~ 200 mysql started to appear 132% load and pushed the main CPU to about 40%. Making the website extremely slow I'm using centos 7 ( 8GB ram , 2 core , NVME SSD + Nginx + php-fpm…
Mr dung
  • 1
  • 3
0
votes
1 answer

MariaDB Galera Cluster simultaneously got 2000+ Connections on single node How to trace this issue

I am using MariaDB Galera Cluster (Master/Master) having 5 nodes with specs of 32Core 64GB Ram Ubuntu 20.04 Personal Vm-Machines at own Datacenter Top of these nodes, Haproxy is configured which balance the request load for DBs Node each node is…
Qazi
  • 101
  • 4
0
votes
1 answer

I want to install mysql 8 instead of mariadb

Good evening, I did install mariadb 10.4 in order to install magento 2.4.2 but when I did a general update it upgrade to mariadb 10.5 automatically, which is not supported for magento... As I can't succeed in finding the mariadb-main depo and…
cedler
  • 3
  • 2
0
votes
1 answer

Package MariaDB-shared requires MariaDB-common, but none of the providers can be installed

I am trying to update the packages on my CentOS 8 server, but when I run sudo dnf update, the following message shows up: Last metadata expiration check: 0:43:34 ago on Wed 12 May 2021 11:59:25 AM CEST. Error: Problem 1: package…
Alex
  • 61
  • 2
0
votes
1 answer

Postfix/Dovecot cannot connect to MariaDB after crash

I am running a mail server on CentOS 8 using Postfix, Dovecot (virtual users) with MariaDB. ~1 week ago, Mariadb seemingly crashed and deleted most (?!) of the users, but failed "softly" and restarted itself (albeit in a nonfunctioning state). …
SKNB
  • 25
  • 1
  • 10
0
votes
1 answer

Unknown table 'table_io_waits_summary_by_table' in information_schema

how can i get IO stats per table in MySQL/MariaDB? MariaDB [INFORMATION_SCHEMA]> SELECT * FROM INFORMATION_SCHEMA.table_io_waits_summary_by_table \G; ERROR 1109 (42S02): Unknown table 'table_io_waits_summary_by_table' in information_schema ERROR: No…
zdppfareex
  • 3
  • 3
0
votes
1 answer

mariadb oom-killer on CentOS8 in EC2 t2.micro instance

I seem to be having memory problems in my t2.micro instance (1GB) running nginx, mariadb, php and WordPress. I can see that mariadb.service is being killed regularly (I have used grep -e kill /var/log/messages sample output below). As you can see…
dtw
  • 103
  • 3
0
votes
0 answers

Maria.db Service Doest Not Start in Ubuntu. InnoDB: The innodb_system data file 'ibdata1' must be writable

When I try to restart mariadb.service I get this error messages: ● mariadb.service - MariaDB 10.4.12 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In:…
phileoseda
  • 99
  • 1
  • 1
  • 5
0
votes
1 answer

Is it Safe to Use "ufw allow from xx.xx.xx.xx" Command for IP Addresses Which are Faced With UFW_BLOCK?

I have UFW opened on my database servers and I have seen a lot of UFW_BLOCK logs. Is it safe or right to use "ufw allow from xx.xx.xx.xx" and "ufw allow to xx.xx.xx.xx" command for all IP addresses which are blocked? I have allowed blocked IP…
TarabydaVllasıCafcaflıAtArabsı
  • 13
  • 2
0
votes
2 answers

Improve MariaDB Execution Time

I have a database with one table and three fields (id, hash, creation time). This table got around 30 million records, the execution time for a query like SELECT * from `table` WHERE hash='blahblahblah'; This query is taking around 40 seconds to…
Karthik Malla
  • 101
  • 3
0
votes
2 answers

Mysql Server, with Mariadb Slaves, disk usage high and many binlog files

I have a Mysql Master server and a few MariaDB slaves connected to it. I have an issue in that my disk usage on the slaves have gone a bit mad. My master server is 163GB with bin log files of 100Mb each ranging from bin.001260 to bin.001357. On my…
WallyKaye
  • 13
  • 5
0
votes
1 answer

Can I use "Windows Server Backup function" or "wbadmin" to backup MariaDB?

I am making a backup strategy for MariaDB on Windows Server. To make my life easier, I was wondering if I can use the "Windows Server Backup function" or "wbadmin" as a backup tool for MariaDB.
Xin
  • 187
  • 5
1 2 3
…
55 56