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

2723 questions
8
votes
1 answer

How to reset MariaDB into a "fresh install" state?

I had InnoDB corruption and managed to start the server in read only mode and perform a fresh backup using innodb_force_recovery=5. This way of starting the service puts the databases in read only mode, even deletion is disallowed. Is there an…
Sebastián Grignoli
  • 223
  • 1
  • 2
  • 7
4
votes
3 answers

How to get the data of a recent year

I have a table in a MariaDB database. The structure of this table is as follows CREATE TABLE `EntityMonthlyQuantities` ( `Id` bigint(20) NOT NULL AUTO_INCREMENT, `EntityType` varchar(400) NOT NULL, `EntityGuid` uuid NOT NULL, `Year` int(11)…
Mohammad Miras
  • 149
  • 3
3
votes
1 answer

using ON UPDATE for non-timestamp columns

Timestamp columns may have DEFAULT NOW() ON UPDATE NOW() which is awesome to keep track of when the row was updated. I want to have similar functionality with user id, such that when an update statement is executed with last_user_id = 42 then the…
Tomas
  • 31
  • 1
3
votes
1 answer

MariaDB - Host is blocked because of many connection errors

We have a simple monitoring that opens a TCP connection on port 3306 of the mariadb server to check if the server is reachable. mariadb logs this with the following message: [Warning] Aborted connection to db: 'unconnected' user: 'unauthenticated'…
fx123
  • 31
  • 3
3
votes
1 answer

How to create a 10 year calendar in MariaDB with 30 minute time slots

First time posting here, I need to create a table in MariaBD which will to the following: Add dates for the next 10 years for Mon - Sat with 30 minute time slots between 9am and 9pm Does anyone have an idea how to do this, I have had a few people…
Peter H
  • 31
  • 1
3
votes
2 answers

MariaDB 10.6 Performace

I'm migrating my database more to my surprise I had a drop in the performance search, I already checked all the indexes of the tables and they are the same Server New MariaDB 10.6.8 CentOS 7 8 VCpu 2.8 16…
Elvis Reis
  • 41
  • 4
3
votes
2 answers

Why is my database name truncated?

I'm using MariaDB v5.x and want to return a long database's name with the query. I can successfully do this with a simple query, but with a more involved query the database name comes back truncated [34 characters]. Why does this happen and is there…
dave
  • 45
  • 3
3
votes
2 answers

I deleted a folder from /var/lib/mysql and now all of my databases seem to be unaccessible

I was receiving this error when trying to drop a database: ERROR 1010 (HY000): Error dropping database (can't rmdir './redpopdigital@002ecom', errno: 39 "Directory not empty") So I went into /var/lib/mysql and just did an rm -rf. I did not know…
Blaine Lafreniere
  • 131
  • 1
  • 2
3
votes
3 answers

Is it safe to delete "root" user?

I have hosted one web application on a staging server where I have deleted "root" users from the database. I don't want to use a common name for superuser. I have also created another admin user(Same as root user). After this change I have tested my…
Kreya
  • 155
  • 5
3
votes
1 answer

Error 1046 Mariadb: No database selected

GRANT ALL ON my-database.* TO my-user@10.0.0.1 IDENTIFIED BY 'password'; ERROR 1046 (3D000): No database selected Ok, I have created a database with a "-" on the name (did the same thing on the user)... then when I try to set the grants on it the…
maniat1k
  • 305
  • 3
  • 7
  • 17
3
votes
3 answers

OS error 13 when running mariabackup as non-mysql user

All: I'm trying to set up regularly-scheduled backups of our MariaDB cluster with mariabackup, and have set up an account for this purpose. The account is a member of group mysql. But when I run the backup as that user: $ mariabackup --backup -u…
Thomas J. Girsch
  • 51
  • 1
  • 3
2
votes
0 answers

Trying to Authenticate the Slurm User via Keys Instead of Password Using the pam Plugin on MariaDB

The expected behavior is for MariaDB to prompt me for a passphrase, not a password. Any help with troubleshooting would be appreciated. ~$ getenforce Permissive ~$ uname -r 5.14.0-362.13.1.el9_3.x86_64 ~$ mariadb -V mariadb from 11.2.2-MariaDB,…
George
  • 21
  • 1
2
votes
0 answers

MariaDB server, after LARGE migration, some FK go missing but they come back after server reboot

I have a MariaDB server (v10.6.11 also tried on 10.11.6). I run some massive migrations which also modify a lot of primary keys on a large number of tables. When the migration starts, I disable the FK constraints and enable them again at the…
ptheofan
  • 121
  • 1
2
votes
1 answer

Performance difference between using check and a enum type?

What is the performance difference between using a check instead of a enum to make sure a value in the column doesn't exceed X? For recent mariadb setups
Freedo
  • 198
  • 1
  • 9
2
votes
2 answers

MariaDB - search over multiple rows with same id

I have table with three columns in it. First is product_id linked to another table, second is att_id with link to another table and last one is val_id linked to different table. There are rows with same product_id with val_id and att_id…
Venom
  • 23
  • 3
1
2 3
…
15 16