The Community
You are viewing questions related to The Community.
MariaDB is a project developed by the open source community. The MariaDB Foundation is the main steward for the project. However, anyone can participate in the development.
The following links provides information to help you participate in making MariaDB a success
Open Questions
-
awr kind of report for MariaDB
Hi there Just wonder is there any AWR (Oracle) kind of report or script ava... -
breaking replication then resetting it
mariadb 5.5.60-MariaDB I have a LIVE DB in a database "bugtracker". that m... -
buf_pool_mutex, SERVICE_THREAD_CONTROL::COND_control & other wait events seen during perf test
Did a performance test; & collected events_waits_current on regular interva... -
can anyone identify the error? MySQL keeps shutting down immediately after I turn it on, I'm pretty new to this sutff so I cant really do much, and this is too long to search properly
2024-01-06 11:13:23 0 [Note] Starting MariaDB 10.4.32-MariaDB source revisi... -
Can maria db support Analytics application in cloud?
Team We are planning to deploy Maria DB for one of the Analytics applica... -
Can not load default MySQL library (libmysqlclient.so.18 or libmysqlclient.so)
Hi fellows I have a problem after changing from mysql to mariadb. This has ... -
Can the returned events-bitmask include only `MYSQL_WAIT_TIMEOUT` flag?
The status that is being returned by a non-blocking operation is a bitmask ... -
Can you help me trying to combine multiple triggers into one?
What I have so far throws a: ERROR 1064 (42000): You have an error in your... -
Can't query a table due to capitalization differences
Hi and thanks for reading. So I have a table called gbl_tblusers and that's... -
Cannot access information schema tables via ODBC
I have a Microsoft Access connection to MariaDB 10.5.22. I am using MySQL O... -
Cant Access Stored Procedures After MySQL 5.6 Upgrade to MariaDB 10.3
Hello, I am new here. I am writing because yesterday I had to update from M... -
Circular replication
I am creating a circular replication for Laravel application, for 6 islands... -
collation_connection change
Hello i want to change collation_connection from utf8mb4_general_ci to utf... -
column name work as a case insenstive
In MariaDB , lower_case_table_names is set to 1 then column work as a case ... -
column name work as a case insenstive
we are facing below issue where lower_case_table_names set it to 1. for Ex... -
Comment removed after upgrading MariaDB from 10.3.34 to 10.6.15
Our MariaDB has been upgraded. (10.3.34 -> 10.6.15) After upgrading, the fo... -
Configure timeout inactivity on Windows
Morning guys I have a question on how to configure downtime in MySQL / Mari... -
Connect engine to oracle db error
Connect engine to oracle db using odbc driver is giving TNS error: ERROR 11... -
Connect Engine: behavour on network outage
Dear all, I am working in an environment with worldwide distributed databas... -
Connecting to MariaDB via OPC
I have a synology diskstation NAS running MariaDB. Further there is a Scada... -
Content from TEXT fields not displaying - Classic ASP on Windows Server 2012 machine
Recently I migrated from MSAccess to MariaDB feeding an old Classic ASP Web... -
Count, union all queries are running for very long time.
Query: select COUNT(1) from t1 INNER JOIN t2 use INDEX(idx1) on t2.c1= '... -
Data loss during the time when one node reboots
HI there, I have three mariadb columnstore nodes - node1, node2 and node3; ... -
Determining Root Cause of Aria Recoveries?
I recently migrated (on a WHM Cpanel system) from MySQL to MariaDB (uninten... -
Does binary logging apply to ColumnStore?
When binary logging is enabled, does MariaDB's binary logging also record C... -
Does Mariabackup work with Veritas NetBackup?
Does anyone know whether Mariabackup works with Veritas NetBackup? In Oracl... -
Empty dictionary value in SQL Table
MariaDB (10.3.24) outputs Warning messages as shown below [Warning] Aborte... -
Ensuring Refferential Integrity
I brought in the Primary/Secondary/Foreign keys because it does not exist i... -
Error #1558
I am using a QNAP TS250+ NAS with MariaDB10 which I have used for just Tabl... -
Error 135 "No more room in record file" with enough space on FS
Hi, We are operating a database with the following characteristics : - runn... -
ERROR 1366 (22007): Incorrect string value: '\xAB\xB8\xA3\xCBA/...'
Hi, I am trying to encrypt data in mariadb table but it is giving me error.... -
ERROR 2002 (HY000): Can't Connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
All, I am receiving the above and below error message out of nowhere and I ... -
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hello, We have a MariaDB server that runs for a while and then stops with t... -
ERROR 2013 (HY000) at line 1353: Lost connection to server during query. with Encryption ON with AWS KMS
Hello, I'm trying to import a large data dump from MySQL to MariaDB but ke... -
ERROR 2013 (HY000): Lost connection to MySQL server during query
When I am trying to execute a query from some large table it turns out that... -
Error Code: 1064-You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version
Hi Any suggestions how to resolve this error. Error Code: 1064 You have an ... -
Error connecting to the database: Error: Access denied for user 'new_user'@'localhost' (using password: YES)
Hello, I'm encountering an issue and could use your assistance. I'm receivi... -
Error on delete of .\tmp\mariadb\#sql3c1c_45_31.MAI (Errcode: 13 “Permission denied”)
I continually get the following type of error whenever I modify WordPress w... -
ETL tool recommendations for MariaDB
Please suggest which tools are most suitable for extraction, transform and ... -
Excessive contexting running MariaDB CE Query
I'm working on a MariaDB vs. Oracle query performance issue. We have about... -
failed to call the odbc driver connection utility
Please assist. I am using/testing various versions of ODBC connector 3. Eve... -
Failed to start MariaDB 10.3.23 database server.
How can I solve this? systemctl start mysqld Job for mariadb.service failed... -
Find Queries with huge Result-Set
Hello, we are using MariaDB as DB for our CMS. Lately I noticed a massive g... -
For custom Mariadb ODBC driver, I'm integrating ED25119 authentication mechanism
For custom Mariadb ODBC driver, I'm integrating ED25119 authentication mech... -
force mariadb audit plugin to log drop user as all caps in the audit log
Is there a way to force the audit plugin to log drop user in all caps? I am... -
FreeBSD with MariaDB
Hi! Where to find examples of mariadb(mysql) with wsrep replication. With a... -
Galera Cluster Recovery
Hi all, I faced the following problem. Give me away to resolve this problem... -
Getting Permission denied error while spinning up second node of Galera Mariadb cluster. Any help on how to solve this would be highly appreciated.
Jun 20 09:34:51 ip-172-31-1-164 rsyncd[51650]: rsyncd version 3.1.3 startin... -
getting ssl error after ssl setup
Hi, I set up SSL following this page. Everything is working fine. I can con... -
ha_tokudb.cc:161
Hello guys! Im facing this errors on mysql.log when i restart my database. ... -
Help with Connect and JSON file
I have been trying to learn how to use the connect command with a JSON file... -
High CPU usage when TDE is enabled
Hello everyone, I've ran into an issue when applying TDE on my MariaDB inst... -
How can I prevent record deletion in before delete trigger?
How can I prevent record deletion in before delete trigger? I tried signal ... -
How do you upgrade from mariadb 10.2 to mariadb-galera 10.3 in kubernetes?
Hello, I am using mariadb 10.2 as a container in kubernetes, and what i wan... -
How does MariaDB Galera Cluster authenticate between each node?
I am new to the MariaDB Galera cluster. I have successfully set up my first... -
How to add/remove users to a table
I have a tables called temptoolsdb.users. I can see the user accounts that... -
How to avoid duplicate inserts with python library
The import from a csv with python and with using the import mariadb lib wor... -
how to change tmpdir in galera environment
please share procedure for changing location of tmpdir in galera environment 10.3 version -
how to clear AWS key caching on Mariadb.
hello, I'm new to MariaDB and I'm testing the plugin for aws_key_managemen... -
How to connect visual studio 2019 in c# to MariaDB in Synology DS1513+
I will like to know how to connect the Maria-db using visual studio 2019 sp... -
How to disable logs aria and logs binary.
I installed mariadb on a release of opensuse 13.2, I ask the most experts: ... -
How to Fix MySQL Error: Access Denied for User ‘root’@’localhost’
How to Fix MySQL Error: Access Denied for User ‘root’@’localhost’ -
How to incorporate mariabackup full incrementals with binarylogs
So I'm going to be starting to use MariaDB. Was going to use mariabackup f... -
How to install Mariadb in Linux if mariadb-libs is already installed
Hi. I am trying to fix a security vulnerability in Linux server, and the so... -
how to install mariadb server silent and set password to root with no setup step
hello, i need to include mariadb with my project as server database to my ... -
how to recover from last backup and binary log + relay log on a master master DB cluster
Hi Guys, my name is Tim, i am setting up a db cluster active active. i want... -
How to remove encryption key for an explicitly encrypted table
I have some tables that was created with explicit encryption previously (En... -
how to run a windows cmd file to run commands as an automated job.
I need to automate dataloading into my mariadB database. I'm a super noob.... -
How to solve the limited resource pattern with two replicated db?
Hi everyone, I'm trying to understand if I can switch my application to a r... -
How to trace PHP PDO to MariaDB traffic through mysqlnd driver
I cannot find any documentation on how to obtain a trace of the traffic bet... -
How to use Join or Union to get the data I need.
Hello, I need some assistance pulling data from several tables and insertin... -
ibdata1 keeps growing in size and causing out of space on the disk
we have a mariadb instance running on 10.10.2 version. We are doing nightly... -
Importing CSV File to mariadb
Hello, I am getting the error statement below when I try to import a csv fi... -
Inconsistent results observed with union and distinct
Hi I have UNION of 2 queries(query1 and query2). When i run 2 queries separ... -
information_schema.tables
In the mariadb master-slave structure, the result of count (*) is the same ... -
Installing an authentication plugin in existing MariaDB container
Hello all I want to enable ed25519 authentication plugin in an existing Mar... -
Is chaining UPNs via "authentication_options" when using the GSSAPI Plugin considered safe?
Dear MariaDB-Community, I've a question concerning the GSSAPI plugin an its... -
islanded master master recommendation
I have a question regarding the best way to achieve what I want. I have two... -
Issue in starting Mariadb docker
Hi, I had installed MariaDB using docker (attached volumes for dbroots and ... -
Issue on High Concurrency
Hello All, We are using apache storm application for message processing. Th... -
IST replication failing on 2 node galera mariadb setup
We have a galera cluster setup with 2 nodes (master-slave setup) in a docke... -
Joining on not Unique Columns
I have attached sample data in Excel see https://drive.google.com/file/d/1I... -
JSON With MariaDB in procedure
Hi, All I have problem to create insert procedure in mariadb with COLUMN_CR... -
key-based authentication for MariaDB 10.3 on centos6
I am trying to figure out how to do key-based authentication to MariaDB 10.... -
Loading a Geojson file into a MariaDB table.
I am trying to load a geojson file into a MariaDB table. This is the data. ... -
Lock wait timeout exceeded issue on ALTER/DROP statements to a InnoDB table
Hi all, I have an InnoDB table which prevents me to add a column; whatever ... -
log_warnings=0 does about nothing in my.ini
Hi, MariaDB 10.4.8 installed under Windows as a service "wampmariadb" In th... -
Loop
Hello everyone. What is the syntax to loop through records of a database table? -
Maraidb 10.1.18, node Binlog is not updated for writes in other nodes of the same cluster. Is gtid not working as expected ?
ClusterA and ClusterB are with 3 nodes each. Using version Mariadb 10.1.18.... -
maraiDBserver does not start with galera cluster
I had to shut down all nodes in a previously functioning cluster. Now I can... -
Maria can´t run.
I have the following problem. After a power failure, mariadb stopped workin... -
MARIA DB ODBC DRIVER
Please assist? This driver format seems to be incorrect as it gives an erro... -
Maria DB Spark Connector support Structured Streaming
Hi - Does the Maria DB Spark Connector support Spark Structured Streaming h... -
mariabackup failed running as root.
hello, I'm running the mariabackup as root user and it seems like it failed... -
mariadb - cannot join cluster
Hi, I have a 3 nodes mariadb-galera that was working on linux, firewall was... -
mariaDB 10 on Qnap very slow stored views performance
Hello All I would like to ask for some help please. I have recently install... -
MariaDB 10.3.15 : Referencing OpenSSL library to tar distribution
Hi Everyone, I used MariaDB "tar" distribution [https://downloads.mariadb.c... -
MariaDB 10.5.20 repo CENTOS7 only ， no centos stream repo
Can I upgrade my installation of MariaDB 10.5.19 on CentOS Stream 9 using t... -
mariadb 10.6.4 SSL access with mysql-workbench
hello - i am trying to use google-workbench to connect to a MariaDB server.... -
mariadb access denied to centreon@localhost
Hello, Im trying to migrate centreon to a new server and version debia11. I... -
MariaDB Admin Console protection
Hi All, I'm new to MariaDB, is there any way we can restrict mcsadmin to lo... -
MariaDB AX Cluster Creation and configuring external file system as Data store
Need steps to create MariaDB AX Cluster and configuring external file path ... -
MariaDB crashes on force shutdown of server (cant open gtid_slave_pos)
Hi, we have an enterprise server where we run MariaDB 10.1.14. We are upgra... -
MariaDB does not start after update Solus OS
Would You be so kind to help me? I'm on Linux solusbox 5.2.13-126.current #... -
MariaDB Federated FederatedX
https://stackoverflow.com/questions/49089641/mariadb-federated-federatedx I... -
MariaDB full-text searching skipped a stopword even in Boolean Mode
We are verifying MyISAM and InnoDB in full-text searching following [this p... -
MariaDB Galera Cluster, joining a node
Hi, Is there any good way to see what happens when a node joins a MariaDB G... -
MariaDB issue while upgradin Trac from V 1.0 to 1.2
Running MariaDB 10.1.48 and an upgrade of Trac from V 1.0 to 1.2 I get [...] 2023-05-08 11 -
MariaDB LDAP authentication
Hi there, I'm trying to configure LDAP authentication on MariaDB server on ... -
MariaDB Master/Master database replication across regions on Microsoft azure Environment
We would like to implement geo redundant MariaDB Active/Active Database rep... -
mariaDB not releasing disk space after deleting data rows from table
Good morning Team i have a maria DB (10.4.6-MariaDB-1:10.4.6+mariabionic... -
MariaDB ODBC connector for Windows 7
Hello, I tired to install the latest version of the MariaDB ODBC connector ... -
MariaDB on a read-only filesystem
Is it possible to start MariaDB with datadir in a read-only mounted filesys... -
MariaDB partial backup for tables
I am trying to perform a backup on a specific table within a database. Howe... -
MariaDB query to msql server
Hello everyone, I have a question. I need make a view in MariaDB and I need... -
Mariadb Replication
I have installed mariadb104-server-10.4.6 galera: 25.3.26 FreeBSD 12 This i... -
mariadb server mysteriously seems to be crashing
hello - the last couple of days my server seems to have mysteriously stoppe... -
MariaDB server version for the right syntax to use near 'WHERE id =1'
problem solving help please [ WARN] (AWT-EventQueue-0) Error: 1064-42000 pu... -
mariadb tries to delete the wrong file from tmp directory
Running mariadb-server.x86_64 1:5.5.60-1.el7_5 from Centos Base Repo I have... -
Mariadb upgrade problem
I upgraded mariadb on a Centos 7 box from 5.5 to 10.5 and after updating th... -
MariaDB with Heartbeat on CentOS 7
Hello, I am looking so setup MariaDB in an HA master-slave configuration us... -
mariadb-install-db.exe - defaults-file - unknown variable
Hi. I am just seeking some advise or assistance with initialising a new dat... -
Mariadb-libs installation conflicts with existing MySQL community libs
During installation of openstack on Redhat LInux7 we were facing the below error. -
MariaDB10.6 -- Waiting for log copy thread to read lsn 0
Hi I am getting below error when i do backup on secondary (read only) serve... -
Maridb 10.1.19 breaks the postfix
How to install postfix without removing maridb yum install postfix --skip-b... -
Master down event on MMMon
Hello, I use Multi-Master Monitor for two MariaDBs and my network connectio... -
Maxscale - after update Prepared_stmt_count is getting very high
Hi, After we upgraded our Maxscale instance from 6.3 to 23.08 we had issues... -
Modelling more than one application period per entity?
I am new to MariaDB specifically because of the bitemporal cabablilities wh... -
monitor lag repliaction using mysqld_exporter is not working
Hi all I just migrate from mysql8 to mariaDB 11.1 and have problem with pr... -
Moving mariadb to docker installation
I'm running debian jessie and I'm currently trying to replace all my server... -
multiple regexp_replace
hello - i am using regexp_replace with much success. however, i am trying... -
Mutex at 0x559264fa6a00, Mutex LOCK_SYS created lock0lock.cc:460, lock var 2
Hi, I need some advice. The log started spamming the Title entry. Is there ... -
My MariaDB suddenly not working and it is looking a table that does not exist when uploading my csv
For 4 years my MariaDB has been working but this month it suddenly became l... -
MySQL and MariaDB on same macOS via brew
How do I install mariadb on my macOS Mojave via brew without destroying my ... -
MySQL service
A previously working Windows 11 release preview, now at Build 23451.1000, i... -
Mysql Services stops by itself
Hi, I am running "mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64... -
Mysqldump Options
Hi i have some backup script using mysqldump. like this mysqldump --defaults-extra-file=/e -
mysqldump restore with poor performance
Hello, we need to migrate our platform from an on premise location to azure... -
mysterious diskspace usage by mariadb
Hi all, Working on debian 10 (4.19.0-16-amd64 #1 SMP Debian 4.19.181-1 (202... -
native authentication plugin replacement/substitute
Hi all I am working with a MariaDB C++ connector which we are using to conn... -
need extra info for ed25519 plugin
Hi, For https://github.com/mariadb-corporation/mariadb-connector-c , mariad... -
Need help for SQL syntax for modifying table content
Hi, I have an issue with application "Roundcube" and this could be fixed by... -
Need help related to MariaDB performance behavior
We are working on case related to MariaDB where-in we are observing perform... -
Network time of result of select query is too much.
Hello, I'm getting data using select query with column index The number of ... -
node sequelize vs mariadb node interface
hello - is there any advantage to skipping the use of sequelize and instead... -
Not able to start galera cluster
Hi, I am working on a project where I need to install mariadb galera on Lin... -
Notification from MariaDB Table - Streaming Vs Trigger
We are working on an application that requires data from mariadb table as s... -
Percona pt-table-checksum output is in infinite loop "Waiting for the --replicate table to replicate"
We have following Multi master replication scenario. We are using Mariadb 1... -
Performance improvement
Hi All, Recently we migrated from MySQL to Maria DB, there were views with ... -
Poor performance with MariaDB (11) and utf8mb4_unicode_ci (vs utf8mb4_general_ci)
We have a large database using MariaDB 11, and up until now, we have been w... -
Problem installing MariaDB mariadb-11.4.0-winx64 on windows server 2016
Hi all, I have a problem installing MariaDB on windows server 2016. I've tr... -
problem to insert non-ASCII characters
Hi, I have a hard time trying to insert values with non-ascii characters. I... -
Python - How to retry requesting a connection from a ConnectionPool
Can anyone recommending how to retry getting a connection from a Connection... -
Query in a MariaDB cluster 10.3.13 of 3 nodes get slow responses in nodes 2 and 3
Query in a MariaDB cluster 10.3.13 of 3 nodes get different EXPLAIN ( using... -
Query on partition with like take forever
HI, I created a table like this: Create Table: CREATE TABLE `cdr_03` ( `TimeStamp` dateti -
Regading Varchar(10) behaviour in two different platform
i have two setup(X,Y) where i have a one column abc varchar(20); i n tabl... -
Remote access database without password
Is it possible to access a remote database without using a password? Such ... -
Remove MariaDB Failed
I am using a server with Centos 7.9 and Plesk 18. There is a MariaDB 10.1 i... -
Replication error : Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
Hello I use mariadb 10.3.36-MariaDB-log MariaDB Server I have issue with r... -
Replication Master slave and SSL
I am planning to setup Master Slave replication of MariaDB 10.x DB's , both... -
replication, existing table on Master do not replicate to slave.
hello, I'm new to MariaDB replication. I stood up a master and a slave and... -
Restoring data from old mariadb columnstore to new one without disrupting the old one
From an old MariaDB columnstore, a live and running one, which cannot be st... -
Restoring MariaDB Backu
Hi Expert Need your help. Restoring maridb backup on backup server, Backup... -
Row order in binary log event
A binary log contains events. Insert/update/delete events may contain multi... -
SELECT INTO variable does not work with WITH clause
Hello! I have a stored procedure, which worked in MariaDB 10.2 but it does ... -
SELECT joining non-overlapping rows when two tables are referenced
Hello! We have multiple, connected tables that change over time and we need... -
service mysql start command is cleaning up all the files under /var/lib/mysql
Hello All, We have 2 node Mariadb Galera cluster. Found out that mysql serv... -
Slow Query result
hi, good day. im encountering slow query result in mariadb if the sleep pro... -
SSL connection error: block type is not 01 with fips enabled
Hi, We are facing a strange issue when fips is enabled. After executing few... -
SST failing, foreign key issue?
Hello! Last night one node in a two node cluster left for some reason. Not ... -
Start replication with clones?
I want to improve availability of an application by distributing it to two ... -
storage/retrieval of ASCII(32)
problems storing/retrieving (ascii 32) value, it can be stored, but cannot... -
Stored Procedure with a parameter intended to test membership in list does not work as expected
The following code shows the problem, as I see it. The "SELECT * FROM Beds... -
Subpartitioning using two different columns
Hi All, We are looking for solution where we want to apply list partition ... -
Tablespaces
Hi, It looks like having one tablespace per table is set on by default and ... -
The table name could not be retrieved from the script provided
I am having trouble moving data with ssis fromSQL Sever to Maria DB. When i... -
Timezones help
Hi there, Sorry for what may be a silly question. I am very new to MariaDB ... -
Transactional commit not supported by involved engine(s)
Hi team, I have upgraded MariaDB from version 10.6.11 to 10.11.7 After the ... -
transfer data directory to a NAS file server
Dear all, I'm trying to transfer the MariaDB data directory to a Synology N... -
Trying to insert if not exist in a recursive statement
Hi MariaDB users, I'm from Chile and i need to make a question. I'm tryin... -
UDF crashes on View
When using a UDF in the WHERE clause of a view, mariadb segfaults with mysqld[17525]: segfa -
Unable to Fold Query using MariaDB Direct Query Adapter for Power BI
I installed the mariadb-connector-ODBC-3.1.20-win64 ODBC connector and used... -
Unable to migrate one Db from MySql to Maria 10
Hi I'm wanting to copy a database from a MySql 5.6 server to a MariaDb 10.0... -
Unable to snapshot mariadb galera using Kasten
Pls find log snippet below. {"File":"kasten.io/k10/kio/exec/internal/runner... -
Undo tablespaces keep growing
Hello everyone, I can use your help. We are running MariaDB 10.5.20, with d... -
Upgrade from old Mysql install to recent Mariadb.
I have an old server that is due for an upgrade. But I have lots of special... -
UTF-8 character set issue
Hello, Can you help me how to configure UTF-8 on existing table ?As we are ... -
What you mean "InnoDB: Warning: CHECK TABLE on index `column` of table `db`.`tb` returned 12" ?
Why is it so hard to find in the documentation what code 12 means? Where do... -
where is the header file "conncpp.hpp" ?
i'm following https://mariadb.com/docs/connect/programming-languages/cpp/in... -
Why does changing the time precision of MariaDB from datetime to datetime(6) reduce the amount of space used?
When I execute ALTER TABLE test_table MODIFY COLUMN update_time datetime(6... -
Why does it seem Ssl_ca / CA authority is not being set for MariaDB server?
So I have my MariaDB server version: 10.6.12-MariaDB-0ubuntu0.22.04.1 Ubunt... -
Why its mysqld error occurs during Mariabackup
The error message is shown below. [00] 2020-01-14 16:06:37 Using server version 10.4.8-Mari -
Will MariaDb preserves subquery result order in outer query ?
For the below query I'm using ORDER BY in one of the subqueries to fetch re... -
Windows 32-bit support discontinued?
Hi all, I just spent some time trying in vain to find out if the Windows 32...
Answered Questions
-
Help, Install server db4free.net style but with MariaDB
Hello, I would like to know who is interested in renting a dedicated server... -
Could you suggest a connector which can work for Django and mariaDB?
Hi, sirs. I am a new guy to learn Django and MariaDB. Could you suggest a ... -
#1067 - Invalid default value for 'created_datetime'
Please assist? -- SQLINES LICENSE FOR EVALUATION USE ONLY create table `Ord... -
10.4.14 cluster + rsync + ssl
Hello! I am asking to assist to setup MariaDB cluster + State Snapshot Tran... -
Aborted connections
Hello, we are using MariaDB 10.2.13.0 on Windows Server 2016 for a long tim... -
access database row and edit one line of existing user
ok what i am trying to do to the best of my ability is create a user userna... -
Access Denied
All my directories are correct, how come I'm getting a message "Access Deni... -
Access denied for user 'root'@'localhost'
Hi, I'm getting the above error when using Adminer to access my MariaDB dat... -
Access internal variables when performance_schema is disabled
Hi folks, by default the performance_schema¹ is disabled, so that informati... -
Access to more databases
Hello, I would like to know what is the correct way to access two databases... -
According to wikipedia link, MariaDB does not have Security Evaluation Assurance Level (EAL)
Looking at the link below, MariaDB shows "No" for Security Certification. ... -
Adding a latin name to a larin1 column works on 10.4, doesn't work on 10.5
I'm trying to add this name: Gdynia (Orłowo) into a varchar(255) column whi... -
AES_ENCRYPT() and AES_DECRYPT() with other than ECB mode?
Since MySQL 5.6.17, MySQL supports block_encryption_mode to change encrypti... -
Aggregating data with help tables will raise open table cache - solution?
Hello, I need some inspiration :-) Currently we have 10 tables, each around... -
Altering column length is consuming double the space at Storage level
Altering the length of an innodb table column takes double the space to per... -
are there any known issues running MariaDB on RockyLinux 8.4?
hello - i have recently installed MariaDB 10:5.11 on RL 8.4 and seem to ru... -
Attempting to download MariaDB 10.5 for Debian
I am attempting to download MariaDB 10.5 using apt on Debian Buster (10), i... -
Audit parameters getting reset after MySQL DB restart
Hi I am working on automating the installation and configuration of MySQL f... -
audit plugin download
Hi I'm searching the audit plugin for mysql 5.1 to download but theres's no... -
Auto Increment Option in Maria DB
Hi: This is my first day using Maria DB and pardon me if my question is ele... -
Automated
To create an output like this: https://drive.google.com/file/d/1NlImnhE35Za... -
Basic works for hardening MariaDB.
Hello, I'm using "mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_6... -
Best practice for open application time period
In part 4 and part 5 of the temporal tables blog series, an Employ -
BIGINT UNSIGNED with LEAST() or GREATEST() : Unexpected result
Below codes are showing LEAST() and GREATEST() function with both BIGINT UN... -
Breaking changes per every new subversion?
Hello all, Given that MariaDB 10 -> 10.1 -> 10.2 -> 10.3 all require incre... -
Broken foreign key constraint
We've recently migrated a Mariadb instance and a foreign key constraint got... -
Can I insert plenty of values into a table without a lot of redundant character in python?
I want to insert a row in a table by a python code with all of the columns.... -
Can I Unencrypt an encrypted innodb space
I encrypted the Innodb space and its working. I can see the tables were enc... -
Can MaxScale proxy to MariaDB_ColumnStore
Hi community ! My question is - can i realise the following scenario with M... -
can not get past 150+1 as my max connections
I am running under Windows Server 2016. Maria database version 10.3.15. I... -
Can't connect to MariaDB through mysql command line client
I have installed the xampp stack which now includes MariaDB. I have been ... -
Can't backup galera cluster with wsrep_sst_mariabackup.sh
I have configured a galera cluster with 2 nodes. All work fine, but when I ... -
Can't create/write to file '/d/data/myhost.err' (Errcode: 13 "Permission denied")
Hello everyone, I am installing MariaDB 10.1.21 on RHEL 6.7. I am experienc... -
can't determine proper JOIN query construct
Hello, I have a newbie question: Running Mariadb 10.4, I'm using a baseball... -
Can't install MariaDB 10.5.8 on Windows 2012R2
When I try to install MariaDB 10.5.8 on a Windows 2012R2 box as administrat... -
Can't login anymore over ssh with options `skip-name-resolve` and `skip-host-cache`
that options was required because one of your mysql servers had a problem w... -
can't start mariadb on MacOS
Through my research, even though other users have encountered similar issue... -
Cannot connect to 10.4.11 from "localhost" (Windows)
Hi, I installed MariaDB 10.4.11 on a Windows server. Everything seems to wo... -
Cannot create user account
Server version: 10.0.23-MariaDB Fedora 23 64 bit I am logged in as root. MariaDB -
Cannot find the constants for the Optimizer Cost Model in v11.5
We are using MariaDB v11.5, and according to the New Cost Model in MariaDB ... -
cannot start mariadb
just stoping mariadb server for changing mysql password, when I want to sta... -
cannot start mariadb after migration on centos7(Note: my.cnf changed)
[root@localhost ]# systemctl status mariadb.service -l â mariadb.service - ... -
centos8
mariadb columnstore will it work on centos8 -
Changing permissions on auditing files
After enabling auditing plugin, the log file owner is being 'mysql' if I se... -
ColumnStore engine missing in MariaDB 10.6.7
I have installed latest MariaDB version 10.6.7 in Windows 10 64 bit. Column... -
Compatibility between RH 7.3 and RH 6.4
If I'm using master-master replication using two RH servers, and both of th... -
Connector-C error
I have written a windows OleDB provider for MySQL using the MariaDB connect... -
Consistently able to crash MariaDB 10.0.25 and 10.1.4 - Signal 11
We are able to consistently reproduce the crash of MariaDB with the followi... -
convert_unixtime outputs wrong date time
Behind the scene: Basically I operate an app that heavily relies on time ca... -
Crash of MariaDB 10.1.21 on IBM i (ZendDBI 10) when do DB2 Data engine tables import
Mariadb imports a lot of InnoDB tables without any problems. MariaDB crashe... -
Crash when inserting or selecting large amounts of text in/from LongText field
Update: This appears to only happen on Windows/Ubuntu 16. It seems very p... -
Create dump and restore all databases
I have 2 mariadb servers: please note both are IDENTICAL version installed ... -
Create Stored Procedure with vb.net
I try to create a stored procedure with vb.net and MySqlConnector. When run... -
CSV style LONGTEXT string into table splitted by comma TO multiple rows (PERFORMANCE)
I have a LONGTEXT string as "A20210917_0701000,B20210917_0701033,A20210917... -
data base issue
hello im using xampp because im doing some web programming with php and i a... -
Database Cluster Replication
Hi All, I have two database cluster, let say cluster A with cluster B. Clus... -
Database Fails To Start After Docker Upgrade
I'm using Docker Containers to manage a reverse proxy (jc21/nginx-proxy-man... -
Databases automatically deleted
Hi, I have a linux server with wordpress and some sites (centos with vestac... -
Datetime behavior in MariaDB vs MySQL
Hi, I have a MariaDB db and MySQL db. My question is why do I see the foll... -
Datetime format YYYYMMDD hh:mm:ss.fff
I need to insert the following query in MariaDB : INSERT INTO Table (ID, Va... -
Delayed retrieve of updated field
Hi, we are working with MariaDB creating an app that needs to check a field... -
Delete partially and gradually a very large table (1 million records)
Hello, I would like to know, in your opinion what's the best way to create ... -
DELETE syntax error
DELETE bsbp FROM b_sale_basket_props AS bsbp INNER JOIN b_sale_basket AS bsb ON bsbp.B -
Do not understand why MariaDB rejected REGEXP with 42000 You have an error in your SQL syntax
When I issue the following prepared statement: SELECT COUNT(*) FROM Methodi... -
Do you use any hot backup software on MariaDB? Do you know any for Slackware 14.2?
We would like to make a hot backup in the Zabbix database which is on a ser... -
Docker + MariaDB Community Edition + ColumnStore
I've installed MariaDB Community Edition 10.11.2 on Docker (on Windows) and... -
dumb question about enabling error logs
hello - i thought i understood that error logs are ALWAYS enabled. so i a... -
Encryption Innodb
I have setup MariaDB to encrypt the whole InnoDB space. Here's what's in my.cnf plugi -
ERROR 1366 (22007): Incorrect string value
I am trying to migrate a database from MySQL 5.0 to MariaDB 10.3 and I am g... -
Error installing AUDIT Plugin in MySQL 5.7
I downloaded mariadb-10.1.11 for Linux x86-64 and copied the auth_pam.so to... -
Error on SINGAL permissions
Hi all, I have this script {{{ DROP DATABASE IF EXISTS `ERPUniversitario`; ... -
error upgrading from 10.1 to 10.2
hello - i have attempted to upgrade to 10.2 on my centos-7 by following the... -
ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.4.21-MariaDB]You have an error in your SQL syntax
Please assist, where is the error in this code? CREATE TABLE App_menu_filte... -
Error: SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('root'@'localhost') does not exist
I am receiving this error when trying to add/remove database users on my Pl... -
Execute Immediate in a Stored Procedure
I would like to execute 2 insert statements within and Execute Immediate co... -
Export Table / Error?
Hello, i want to export a table from my MariaDB (v10.3.24) - I tried the ex... -
Export User Accounts from MySQL 8 and Import to MariaDB
Hi, Is there any way to export user accounts/passwords and privileges from ... -
Extract values with escaped characters from JSON Document
I am using the json_value function to extract values from a json document p... -
Failed upgrade 5.5 to 10.3
Hi - I upgraded from mysql 5.1 to MariaDB 5.5 That went perfectly fine. ... -
figuring out which binary logs of master are applied on slaves from the master itself
Hello everybody!! We have set up a replication and need to figure out which... -
Find all users with certain role
I need to be able to generate a list of users that have been granted a cert... -
Force IP address instead of domain in error.log "Access denied" record
Dear Members, How Can I force IP address instead of domain in error.log "Ac... -
Future of MariaDB?
Where I work, we depend heavily on MySQL. We were recently made aware tha... -
Galera Cluster - Adding node after crash
I'm working on a project in which I have a cluster of 3 nodes. On each one ... -
galera cluster - all nodes down, restart query
We are seeking a replacement for standard replication. One possibility that... -
Galera cluster consisting of more than one Linux distro?
Is it possible/supported to run a galeracluster, (MariaDB10.2) where exisit... -
Galera cluster mariadb - binlog ?
Hi all, My environment : I have a galera cluster Mariadb with 3 nodes (10.1... -
Getting started on OS X with Homebrew MariaDB
I just installed MariaDB on my iMac yesterday using Homebrew and am getting... -
Haproxy mysql-check user removal
HI , I am using the galera cluster and haproxy mysql-check with the user, I... -
Help changing update command to trigger (answered)
Current command: MariaDB [sensor_logs]> UPDATE telemetry_log JOIN id_name_u... -
High Latency Issue between Master -> Slave (MariaDB)
We are facing latency issues between Master and 2 Slave DB's. Platform - GC... -
How are the data encryption settings on mariadb
Hi everyone, how are the data encryption settings on mariadb for example th... -
how do I get a nice gui interface to a database?
I'd like a user to be able to make queries against a database to be able to... -
How enable log on odbc windows
HI, I'm trying to enable the odbc log on a connection string on a programmi... -
How to connect to maxscale by using hibernate?
Hello, Can some specialists tell me how to connect to maxscale by using hib... -
How to convert datetime format while importing xml
I have an xml file. A sample: <?xml version="1.0" standalone="yes"?> <testD... -
how to create fake DATA inside MariaDB SQL database???
Hello World, I am trying to create some TEST DATA, meaning fake date for pl... -
How to disable system command on mariadb shell
I have a layer of customised shell on linux through which i am giving acces... -
How to export MariaDB to Microsoft SQL
I started with a MariaDB for a bunch of data logging, and now we're expandi... -
how to see cipher suites allowed in Mariabd server for client.
Hello, Currently, we have a tool that has an issue connecting with our Mar... -
How to Upsert on Application-Time Periods?
Hi, I have table Application-Time Periods (https://mariadb.com/kb/en/applic... -
I forgot to backup my InnodB database then i want to restore the table and data
Dear ALL, im a newbie in mariadB, i was use the mariadB 10.4(via Heidi SQL... -
I want to help MariaDB community and execute Test Cases and provide results how can I do that?
I am a QA Analyst and I love open source. I want to gain access to MariaDB ... -
Identifying and removing duplicates
I have a table that contains duplicates of some rows on all fields except t... -
Import of a 2.2 MB dump incredibly slow
I tried to import a dump of 2.2 MB and this takes more than 15 minutes. I a... -
Incorrect definition of table mysql.column_stats: after upgrade from 10.6.5 to 10.8.3 with docker container
After upgrading the mariadb docker-container from 10.6.5 to 10.8.3 I am get... -
Incorrect integer value
Im using $insertQuery = "INSERT INTO workorders (`priority`, `request_type`... -
Incorrect string value
I am trying to store fields from an RSS feed. The feed is UTF-8. The data... -
index usage on updates
I have seen a few times that even if there is a covering index for an UPDAT... -
information_schema.files is empty in mariadb 10.2
Please let me know how this table is populated. -
InnoDB: Upgrade after a crash is not supported…
Upgrade MariaDB 10.4.24 to 10.11.2, XAMPP, Windows 10 Old MariaDB is in dir... -
Insert into table using select based on date does not work
Hello, when testing a select query like : select SYSD FROM Table fwt WHERE... -
Install MariaDB without root nor sudo privilege
Hi All, I'm in project to install and configure MariaDb for icinga monitori... -
INTO OUTFILE error 2
Good day, I am trying to run the following command but it does not seem to ... -
Is "LOCK=EXCLUSIVE" supported in "ALTER TABLE ... CONVERT TO" statement?
Dear community, I get the following error: {{{ MariaDB> ALTER TABLE events ... -
Is it possible to have two write-able mariadb's in a set of four?
I have a pair of mariadb servers running on CentOS 7, version 5.5.52. Curre... -
Is it safe to change ft_min_word_len without rebuilding indexes?
Is changing ft_min_word_len without rebuilding old myisam indexes safe? Ass... -
is this a bug using TRIM using a space character before the open parenthesis ?
hello - is an opening parenthesis immediately following TRIM a requirement ... -
JDBC driver configuration error
I am attempting to connect to MariaDB from a command line Java program. I ... -
JDBC URL & special character support
Hello, Is there a way to use a password with & character in the JDBC URL w... -
json_table like mysql 8
Hi, Do you have any plans to implement JSON_TABLE support? like mysql 8.0.4 ? -
keeping out hackers
hello - (and THIS is embarrassing) for the third time now, all my databases... -
Life is feudal
So im hosting my own Life is feudal your own server. And then I realised th... -
load data infile referencing one path while mariadb uses a totally different path and can't find input file
hi. I'm a beginner at this point. Decided to try importing a text file. I m... -
Looking for an equivalent of DBID (Oracle) or GUID method to uniquely identify Database
Im trying to find an equivalent of DBID (In Oracle) or some means that uniq... -
Mac Install for local testing
Hi I have MariaDB installed on my Mac. Yet when I try to connect, with Navi... -
MacBook user wonders if macport was installed incorrectly, of if she is just stupid.
Hi, I am (unsuccessfully) trying to help a friend who is setting up a small... -
Maria 10.2.18: error with Galera joining the second node
We are trying to create a Galera cluster using "mariabackup". The first nod... -
Maria DB Connection with Cognos 10.2.1
Hi Team - i am trying to Connect Cognos 10.2.1 with Maria DB, but could not... -
Maria db replication
trying to make a master slave replication but when i start the replication ... -
Mariab not hanging when trying start
Please help me resolve this issue. I have installed WordPress on AWS EC2 in... -
mariabackup gives core dump
Linux, Fedora 64, up to date. /data/docs/2022/power 16:27 > mariabackup --... -
MariaDB - MySQL connection
Hi, I have below questions: 1. Can I know which version of MySQL compatibil... -
MariaDB - What's the max blob size?
MariaDB - What's the max blob size? I've seen data exceed 64k on mysql data... -
Mariadb 10 installation on rhel 6.2 failing asking dependancy
Hi Team, I did installation using yum last time and it got success with sam... -
mariadb 10 multi master galera cluster + streaming replication for backup
Hi, im playing arround with a multi (3 nodes) master galera cluster... it i... -
MariaDB 10.0: copying data folder into another engine with the same version reduces in one day the data fields
Hello... I did try to find a related bug but I couldn't ... I'm sorry if th... -
MariaDB 10.1.13 Changing MySQL version
Hi, At present I have MariaDB version 10.1.13 installed on a Debian 8 serve... -
MariaDB 10.1.41 won't start
I have some trouble with my MariaDB Server, it was working ok but it won't ... -
MariaDB 10.2.10 tar ball linux_64 is not working with HAproxy
Dear Team, I just install tarball installation of MariaDB 10.2.10 using ub... -
MariaDB 10.2.13 CALL PROCEDURE PARAM LAST_INSERT_ID ()
Before the update MariaDB 10.2.13 I was able to call a procedure inside the... -
MariaDB 10.3 crashing and restarting intermittently - segfault at 0
Hello, We are using a Debian 10 server with MariaDB 10.3.27. It use to work... -
MariaDB 10.3.32 and Jira 8.20 - possible? I can't get the set-up right
I have tried everything, I just can't get a Jira 8.20.6 set up together wit... -
MariaDB 10.4 / 10.5 crashing and restarting intermittently - status=11/SEGV
Hello, I am installing a new server with MariaDB 10.4 or 10.5, but I am fac... -
MariaDB 10.4 Password Reset
I don't know the current password. When I try to change, it says it is not ... -
MariaDB 10.4.19 reboots itself and gets message "[ERROR] mysqld got signal 6"
I'm running MariaDB 10.4.19 on CentOS 7.7.1908. Almost every day my databas... -
MariaDB 5.5 - Centos 7 - last version not available
Hello, I'm using MariaDB 5.5 on Centos 7. Yum is configured to use CentOS-B... -
MariaDB 64bit eats virtual memory
Hello together, I'm running two different instance of MariaDB 10.2.6. One i... -
MariaDB architecture
Hi all, I am new to MariaDB so i would like to learn MariaDB architecture b... -
MariaDB Audit Plug-in Can't initialitize function 'server_audit' on MySQL Community Server 5.6.28
I am receiving a warning when installing the MariaDB Audit Plugin on MySQL ... -
MariaDB backups logs
Hi Every One, Where we can find the mysql database backup logs, any table t... -
MariaDB binary logging and master-master replication
I am trying to set up MariaDB master-master replication on a Debian server.... -
Mariadb Columnstore on Windows
Does anyone know if the upcoming Columnstore storage engine will be usable on Windows? -
Mariadb Crash importing tablespace
I am trying to recover a database but while importing tablespace mariadb ge... -
MariaDB database server crashes due to audit plugin
For MariaDB database server version 10.3.17 enabled the audit using the fol... -
mariadb drop user "wildcard"
hello - suppose i create these two users: CREATE USER 'ILOVEMARIADB'@'123.... -
MariaDB errors after OpenSUSE Leap update
I have an OpenSimulator virtual world that has been running on MariaDB and ... -
MariaDB For Loop
Hi I am trying to create 100 empty rows using a for loop, the insert statem... -
MariaDB for windows fails to bind=0.0.0.0
The version for windows fails to recognize bind=0.0.0 in the ini file, und... -
MariaDB Galera cluster gtid's falling out of sync inspite of setting wsrep_cluster
I have asynchronous replication between 2 clusters (calling master cluster,... -
Mariadb Galera Cluster | Table Update Issue
We created a 3 node galera cluster in our system and then moved our existin... -
MariaDB innodb Tablespace on a Raspberry Pi
Hi Everyone, I'm on a very steep learning curve here, just hoping someone o... -
MariaDB installations
Is it absolutely necessary to follow YUM based MariaDB installation in Redh... -
MariaDB is not starting with InnoDB.
Hi, One of our server's MariaDB has crushed. It crashed due to innodb_buffe... -
Mariadb keeps crashing under windows
Im using Mariadb 10.4 with Win2019. Sometimes mariadb crashes. I dont know ... -
mariaDB Limit Issue
We I run the below query on mariaDB 5.6 With the "LIMIT 100000" query get r... -
Mariadb Master to Slave Configuration
Hello , Slave shows message "Slave_IO_State: Waiting for master to send ev... -
Mariadb not releasing disk space after deleting data rows from table
I have one Maria Db table it contains about 2M data rows. When I deleted ... -
mariadb on Ubuntu Erro
Hi all, I have MariaDB installed on my Ubuntu web server, (an AWS instance)... -
MariaDB performance issues
Server version: 10.2.27-MariaDB MariaDB Server hello - i am really not much... -
MariaDB Quarterly patch schedules with all Bug Fixes availability
Will there be a Quarterly or half yearly release of Mariadb Patches, which ... -
MariaDB Replication
Hi we have 2 servers 1 master 1 slave the master 5.5.42-cll MySQL Communit... -
MariaDB responds with -> and refuses to respond to any other commands
I have MariaDB installed onto my VPS but every time i try to run a command ... -
MariaDB support for sequelize
hello - i thought i remembered hearing a webinar recently indicating that M... -
MariaDB thread-handling -> no-threads
Hi everybody! in MariaDB documentation on the following page: https://maria... -
MariaDB troubles, only running after reboot, times out when trying restart, not stable when running.
For a baseline, I have a recently upgraded Ubuntu Server 18.04 LTS from Ubu... -
Mariadb | restrict check table tablename command for a user
A user with select access is querying a check table tablename. How do I res... -
mariadb-c-connector for MySQL 8.19
We've been using mariadb-c-connector-2.3.7 for MySQL 5.7. We upgraded MySQ... -
mariadb-connector-c 3.3.2 on macOS doesn't connect to remote MariaDB sever
Hi there, I updated recently the mariadb-connector-c view homebrew on macOS... -
Maxscale Read-Only server
Hi, Can maxscale be setup to designate one or more servers to remain slaves... -
Migrate from MySQL 8 to MariaDB 10.3.24 - HowTo?
I would like to migrate from MySQL 8 to MariaDB 10.3. (the reason why i wan... -
Migrating from Mysql 8.0 to MariaDB 10.5
Hello people, i am using an Ubuntu 20.04 Server and trying to perform a mig... -
Multi-Tennat Setup MariaDB
Hi, We have a requiremnet to support multi-tenant system for MariaDB. We cu... -
multiple indexes with different Collation on same column
G'day, is it possible to have multiple indexes with different Collation on ... -
MyISAM plus INNODB enable query cache?
We have 2GB of MyISAM plus 2GB INNODB data. Running MariaDB 10.* Should we... -
MySQL 5.1.66 cannot grant monitoring user to check SLAVE STATUS
-------------------------------------------------- Problem Summary --------... -
Mysql dump is not full
Hello, I have installed fresh ubuntu 16.04 with apache2.4 and php7.0 on it ... -
MySQL shutdown unexpectedly.
I have HyperW virtual Win10 machine with Xampp. Host machine restarted and ... -
MySQL Workbench Replacement?
Hello all. What client is popular as a replacement for MySQL Workbench? -
mysqldump to sql file creates new tables starting with pma__
I just used mysqldump, created a new database, edited the sql file to point... -
mysql_setpermission depracated
mysql_setpermission is a Perl script that automates setting of permissions ... -
No GTID in xtrabackup_binlog_info
Hi, I'm setting up a slave for a multi-master cluster, following this post:... -
No Rocky-Linux support yet??
https://mariadb.com/docs/deploy/upgrade-community-server-cs105-centos8/ hel... -
Node Joining Failure When wsrep_sst_method=mariabackup
Hello, Simplest possible test environment for evaluating MariaDB clustering... -
non-blocking API appears to be blocking for secure connections
I am encountering delays when using secure connections to AuroraDB, and won... -
odd mariadb-connector-c error on update
Server version: 10.5.5-MariaDB MariaDB Server hello - after installing 10.5... -
odd message in my /var/log/message file
hello - i finally figured out to do: grep mysqld /var/log/messages ; an... -
Oracle GoldenGate cannot Extract Mariadb 10.2.9 binlog to Oracle 12c
Dear I use OGG 12c for CDC of MySQL 5.5.6 source to Oracle target It work... -
ORDER BY before GROUP BY
I have the tb_user idnameinfo 01Petertext1 02Paultext1 03Petertext2 04Peter... -
Order Value per Region
Please assist. I would like to answer this question: "What is the average o... -
Performance Tuning
Hi, We started up a new DB that has 50plus tables. Each table may have 10-... -
PHP query is not working.
I'm building a browser based app using mysql, php, and apache. I have so fa... -
possible inconsistency on foreign key definition
hello - i am trying to wrap my head around foreign keys in 10.6. the foll... -
Presence In Other Countries
Does MariaDB have a presence in India or other countries? If not, I am inte... -
Problem with ALTER TABLE and ADD CONSTRAINT
My MariaDB version id 10.5.9, running on Manjaro Nibia (20.2.1). I am tryin... -
Problem with my set file my.cnf
Hello everyone, I have a problem with my.cnf file from MariaDB. I created a... -
Problem with the Galera wsrep_sst_method xtrabackup-v2
We are trying to create a Galera cluster. We have our first node running. W... -
Problems with Table / View / Function Collations conflicts
Currently running MariaDB 10.3.24 and I really want to fully support the ut... -
Process: 1037 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Moin, ich bin neu bei MariaDB... Problem: Ich habe einen Zabbix 6.0 Server ... -
Query Not Using Index as Expected
I an using phpMyAdmin with MariaDB Server version: 10.3.31-MariaDB-0ubuntu0... -
Querying An Int Column From Table That Also Stores Blob Column (Performance)
If you select an INT column from a table that also has a medium/large BLOB ... -
Question about encrypting multiple MariaDB schemas on the same server
Hello: I have 1 server running 1 installation of MariaDB In that installati... -
Questions about backup database using idb files
hello i have three questions about database backup using idb files. suppose... -
Recover deleted MariaDB database from disk
A Mariadb database was accidently deleted. Unfortunately a backup of the da... -
Redirect URLs from yum.mariadb.org
Hi there, I recently realized that yum.mariadb.org now redirects to mirror.... -
Regexing cyrillic characters prior to mdb 10
It appears that I cannot use unicode ranges ("[\p{IsCyrillic}]" nor "[U+040... -
Relocate to Mysql to MariaDb?
Hello All, I am currently using MySQL 5.7 version, I look after websites i... -
Replication feasibility check
Hello, We have our Old Maria DB server working with version 10.0.28. Now we... -
Replication from MySQL 5.5.24 (master) to 10.2.11-MariaDB (Slave)
When starting the slave on mariadb 10.2.11 with the "start slave" command, ... -
replication issue for 4 servers
I have 4 mariadb servers. - data update on server_id=1, data will replicate... -
Replication Using Sketchy Cellular VPN Connection 2021-02-08
I have a master and slave both running 10.3.13 configured to replicate. The... -
Reset values of per user settings max_user _connections
Hello, when doing a lookup with: SELECT User, Host, max_connections, max_us... -
revoking drop privileges
hello - i am trying to get "revoke drop" working and not having any success... -
ROW() OVER() slow query
I have a query which in MySql only takes 1 second and in MariaDB (10.6) abo... -
Sakila DB errors
I downloaded the above db from here https://dev.mysql.com/doc/index-other.h... -
Search is not working
Hello dear Community! I'm new in the Database world and I have a question: ... -
Sequence creation error
Hi, I am new to this so any help appreciated. I have installed MariaDB 10.2... -
setting GTID replication
mysql Ver 15.1 Distrib 10.1.19-MariaDB, for Linux (x86_64) using readline ... -
Setting up replication
Hello all, I am trying to setup replication from Debian 9.0 to Debian ... -
Share mysql databases between windows/linux partitions; ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded
Hi! I decided to do this little project because I got tired of updating tw... -
SHOW CREATE ROLE
The SHOW CREATE ROLE command does not exist. I am trying to export users, r... -
SLES 10.2 32 bit - latest usable stable
Salve a tutti, I have to install MariaDB on a SuSE Enterprise Linux 10 patc... -
some Records are deleted from two tables ...which way is best to restore these deletes records?
Hello I'v got a "simple" DBA end-user question I have a simple two table da... -
Spatial Ref Sys
How do I add SRIDs ? Are there an eqvivalent to MySQL: CREATE SPATIAL REFE... -
SSL - FILES mariadb 10.4.12
I followed the tutorial: https://www.cyberciti.biz/faq/how-to-setup-mariadb... -
Stored Procedure for remote backup
I am trying to create a stored procedure that can be triggered via laravel ... -
subquery in FROM clause not working
hi all, i have portable version of XAMPP v3.3.0 (showing on its control pan... -
Supper slow `UPDATE WHERE IN` after moving from MySql 5.5 to MariaDB 10.1.26 (maybe waiting to lock?)
I had just moved from MySql 5.5 to MariaDB 10.1.26. And suddenly some queri... -
Suppress MariaDB 11 deprecation warnings
Is there a way to prevent deprecation warnings from appearing when executin... -
Table and Column
I have created a new table called 'B' using a table called 'A'. My question... -
Table spaces
Hello, I am wanting to split some tables between disks and I would expect t... -
Tablespcaes and frm metadata files support.
Hi, The current version of MariaDB does not support tablespace https://mari... -
Transaction and locking performance
Hi! I'm asking about the performance impact of a long running (5min) transa... -
transaction control
hi, i was using: { set autocommit off start transaction lock tables insert ... -
Transfer of a website on a MySQL8.0.27 server onto a MariaDB 10.4 server
Hi, I have a website designed on a localserver using MySQL8.0.27, functionn... -
TrueNAS plug in root password error
hi All, I'm trying to set up the Mariadb;- plug in for TrueNAS (v12.3). a... -
TSQL To Maria DB
I am trying to load data from TSQL Into Mysql/Maria DB. I get an autamic wa... -
TSQL To Maria DB SQL
Please assist, converting this to Maria DB SQL? CREATE TABLE Order_Detail (... -
Turn Off SSL in my.ini
How do I turn off SSL in the my.ini? SSL is giving us some issues. -
Two days in, and I still can't find the cause of this 1064 error.
I have some DB experience, new to MariaDB. Writing a procedure, but always ... -
Udpate tables usinh Heidisql
Hello, I have a database with a lot of tables. During the development proce... -
Unable to LOAD_FILE in Maria DB
I am using Maria DB on Ubuntu 1804 : Welcome to the MariaDB monitor. Comma... -
unable to UPDATE, no errors, no update, what am I doing wrong?
I'm not able to do and update, there aren't any errors, the table doesn't g... -
Understanding replication and read lock contention problems
Hi, I'm a novice SQL admin and have set up replication according to this pa... -
Unknown database 'mysql'
Hey guys i have installed mariadb on arch, started "sudo mysql_secure_inst... -
unknown root username
hello - when i look in the mysql.user table, i see the following entry for root: MariaDB [( -
Update mariadb-10.6.5 to mariadb-10.6.7 on Windows ? which way to update?
Hello I would like to update the current installed Mariadb V10.6.5 to Mari... -
Update Statement for a Varchar Field Causes Separate TimeStamp Field to Update to Current TimeStamp
MariaDB 10.3.12 fresh install, Windows 10 Enterprise Version 1607, OS Build... -
Updating mariadb 10.1.25 to mariadb 10.2.9 with galera cluster
I'm currently running the former version on three servers with galera clust... -
Upgrade of MariaDB, how to recover the database schema's in the data directory?
Hello, I want to upgrade MariaDB on a Windows enviroment. I have it running... -
Upgrading fomr MySQL to MariaDB, stored procedure with union
Hello all, I'm new here and to MySQL/MariaDB. Now changed jobs and have to ... -
upgrading from 10.0.38 to 10.3.12
Hello, I have a database server with version ==> MySQL Ver 15.1 Distrib 10... -
Upgrading from 10.1.32 version to 10.3.7
Is it possible to upgrade from 10.1.x to 10.3.x directly in one step? or I ... -
uploading 50GB dump to ubuntu server
Hi there, I have a dump of 50GB on my local that i need upload restore to a... -
US Export Control Classification Number (ECCN)
I can't find reference to this on any of the pages, so apologies if this is... -
Using C connector without mysql_config
Hi everybody, I am moving from mysql to MariaDB. With mysql I was linking t... -
Using UPDATE with a recursive query - not working (error #1241)
I have a recursive query that works perfectly. Here it is: WITH RECURSIVE mgmt_levels AS ( -
Want to start contributing in MariaDB
Hello all, I want to contribute to this project. I have ampl... -
What hardware configuration I need for my sceneario?
Hi everyone, I need help to create an structure for a project. The main pro... -
What is the difference between '<username>'@localhost vs '<username>'@'%'?
Hello, What is the difference between the next two lines: CREATE USER '<username>'@localhos -
What's wrong with my trigger?
I created this trigger: BEGIN DECLARE current_id bigint(20); DECLARE mail_a... -
When 2nd node attempts to add to galera, donor gets: --innobackupex: unknown option '--wsrep-new-cluster'
Hi community, I am standing up a galera cluster like others have set up, so... -
when might 10.2.2 be stable?
hello - sorry if this has been asked before but i am somewhat new to MariaD... -
Where can I find the questions I posted on this website?
Simple as the title sais: I wrote a question some time ago, on this communi... -
Which disk does innodb_io_capacity impact?
I have MariaDB installed along with my database on an SSD. All of my data f... -
Why doesn't MariaDB use delta RPMs?
Yeah every time I do an update I am downloading about 150MB of data. Other ... -
Why in mariadb 10.6.11 does copy to tmp table occur when adding a field to the end of a table with default value NULL?
There are two large tables (> 10GB). When adding a field to one of them to ... -
why the filebase option is not working on /etc/maxscale.cnf
hi, I have a doubt, the option filebase is not working, after i set it on /... -
WITH RECURSIVE not working
Hi, Im trying to run a query in phpmyadmin with "WITH", after updating mari... -
[INSERT .. WITH RECURSIVE] statement generates strange [AUTO_INCREMENT] value
/* The following code is showing [INSERT .. WITH RECURSIVE] statement generates strange [AU
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
