Frequently Asked Questions
You are viewing questions related to Frequently Asked Questions.
There are many questions that are frequently asked about MariaDB, the organizations and the software. They have been grouped based on common topics. Click on a topic to find the question you may have. If you don't see it, please click on the button in the left margin labeled, "Ask a Question Here". We'll try to answer you question, quickly.
Open Questions
-
Audit Log Plugin--Filtering & Old Values
Is it possible to use the built-in audit plugin to log only Create, Update/... -
Column Store Cross-Engine join
The cross engine join documentation https://mariadb.com/kb/en/library/confi... -
Completely Unistall and then Reinstall Mariadb 10.3
Hello Members, I installed mariadb 10.3 on my Ubuntu 16.04 server, and then... -
Datafile storage location changing or defining in any CREATE situation
Hi, coming from ORACLE experiences i am used to define, where all the files... -
ERROR INSTALLING MARIADB 10.1.21 64/32 BIT ON WINDOW 8.1
HELLO, I JUST TRIED TO INSTALL MARIADB 10.1.21 64BITS ON WINDOWS 8.1 64bit ... -
ERROR: Got an error writing communication packets
I'm running a query and then I encountered this error: 2023-05-24 12:20:07 ... -
Galera TOI Online schema upgrade method with Mariadb session setting.
According to the https://mariadb.com/kb/en/innodb-online-ddl-operations-wit... -
GTID Slave - Behavior
Hi, I have Master -> Slave Replication using GTID enabled. During staging ... -
How to configure MariaDB Configuration File
OS - Rhel 7 MariaDB version 10.3.9 High Availability - Galera Cluster No of... -
How to configure MariaDB configuration file in recommend way
Following are my environment ---------------------------------------------- OS : RHEL 7 Mar -
HOW TO CREATE A TABLE WITH ARRAY
Hi, We are currently migrate from vision file to mariadb. May i know that... -
Installing ODBC by .msi on Windows server 2008
Good morning, I have a problem with installing "mariadb-connector-ODBC-3.0.... -
is Master-Master scheduled replication a possibility
I have looked at the replication options of several DB's. I have a slightly... -
MariaDB Installation error
I am getting error with ibdata1 auto extending of the files when running my... -
MariaDB OLEDB Provider was not Specified
Is it Possible to connect my MariaDB database using OLED DB? I have this co... -
memory_global_total different to mysql process -> kiling pod
Hi community, We are selfhosting a mariadb database in a kubernetes cluster... -
missing libmariadb.so.3 on redhat 7
I have tried just about everything. But an app that has worked before does ... -
MONyog Replication Error
In replication monitor I am getting an output of Slave_Running as NO but wh... -
Saving records to connected tables
Hi, I have a working MS Access application. Now I am in the process of movi... -
Visual Studio project
Hello, We have a project on Visual Studio 2013 Net Framework 4.8 and My... -
What datatype to use in table when inserting int_16 [ ] array
How should I best construct/define the table and its column that are to hol... -
Why does this query hang on Maria but runs fine on MySQL?
I recently migrated a server from CentOS 6 to CentOS 7. With this migratio... -
With the rocksdb plugin, does the SQL UPDATE leverage rocksdb's merge operator?
Currently I have my data in two normalised tables sharing a clustered prima...
Answered Questions
-
When will transactional fulltext indexes be ready?
There is really only feature in MariaDB that we are desperately waiting for... -
GUI/Workbench for MariaDB Aria?
Does anybody know a good GUI/Work bench tool to handle ARIA transactional=1... -
Can't load MySQL Library
I installed MariaDB 5.2 in ubuntu 11.4, all was normal. However when I run ... -
mariadb is crashing
Hi, I have tried this a few times on both the 5.2.10 and 5.3.2-beta builds ... -
CLOCK_THREAD_CPUTIME_ID undeclared
I am currently trying to get MariaDB to run on a DragonflyBSD system. Both ... -
import
import ms access db -
Embedded engine?
Hi all, Is there an embedded version of MariaDB? If the answer is yes, the... -
noinstall package for MariaDB(such as XAMPP, formerly known as LAMP)
At present, I am using MySQL through XAMPP. As you are aware, I am sure, th... -
Tables apparently dropped but are not!
This is very weird! Tables seem it have been dropped, but they are actuall... -
"wsrep_local_replays" greater than zero
Hi there, I've been having this situation with two different Galera DB Clus... -
Absent Bintars from MariaDB archives
Archive URL: https://archive.mariadb.org/ Artifacts of interest: items matc... -
ANALYZE TABLE, Error writing file '/tmp/MYdOeJgz' (Errcode: 28 "No space left on device")
MariaDB [cm]> ANALYZE TABLE X1 PERSISTENT FOR ALL; +-----------------------... -
Audit plugin is loggin everything, despite the configuration parameters
My goal is to configure audit plugin with MariaDB with the forwarding of th... -
Can CLI mariadb 10.5 environment connect using 10.5 mysql cli to mariadb 5.5
We have a new install of mariadb 10.5. I am trying to use the mysql cli fr... -
Can't run C program using mariaDB on centOS
here is link to my question (still unanswered): http://stackoverflow.com/qu... -
compatibility is required
Information on MarieDB 5.5 and MariFoB 10.3 compatibility is required. -
configure mariabackup
can i install package "yum install rh-mariadb102-mariadb-backup.x86_64" on... -
Connect Spring Hibernate and C3p0 application to Mariadb through SSL certificate authentication.
I have created application in Spring,Hibernate and c3p0 which is now connec... -
Creating forms
I am new to Mariadb and MySQL. I am experienced with MS Access. I have an... -
executing sql statements on a remote mariadb database from stored procedure
Hello, I'm looking for information about executing sql statements on a remo... -
Finding version of mariadb engine
I'm a bit confused about the version of Mariadb... STATUS command gives the... -
For MariaDB server audit plugin - Is it possible to use sql statements to get access to logs for MySQL???
Is there a way to enter logs to tables rather than log files and look at th... -
Galera Cluster In MariaDB Tarball 10.1.14
I am not able to configure mariadb galera cluster using mariadb-enterprise-... -
Grants from host % vs localhost
Hi I googled if I needed a separate user with grants from localhost even if... -
How to change innodb_page_size?
I'm trying to change the innodb_page_size of my MariaDB 10.1.21 X64 install... -
How to identify this mysqld (initiated by: unknown): Normal shutdown
Could you help to elaborate or tell me the reason behind this mysql shutdow... -
HOW TO MADE MARIADB CAN STORE THE CHINESE CHARACTER
Hi, I am having some data is in chinese character and want to store in mar... -
HOW TO MAKE CHANGES AVAILABLE AFTER EACH INSERT AND UPDATE
my application requires changes to be available at once. waiting for the se... -
How to retain Auto Increment value on server restart InnoDB
Hello, We have a table schema as described below and we are setting auto in... -
How to stop database sleeping
I am getting an exception when calling database code after a period of inac... -
I couldn't find bind-address to comment it in my.cnf file to allow remote db access
I couldn't find bind-address to comment it in my.cnf file to allow remote d... -
innoDB and myrocks which one is better
Currently we are using innoDB and facing the max colunm limit. We saw that... -
ipv6
does, will or when (and how) will MariaDB support client-connections via ipv6? -
Is there any way to know if the replication thread is executing the DML?
I have a slave-only trigger. It gets executed by the replication process. I... -
JSON_SET
Hello, I'm working with JSON functions and I have noticed that the followin... -
Maria db installed on Termux -ERROR
Maria db installed on Termux and it worked well for first time . Ones termu... -
Maria db with ssrs reports using Microsoft Report Builder
I tried to use maria db with ssrs reports using ODBC in Microsoft sql repor... -
MariaDB Backup using CommVault MYSQL iDataAgent
Commvault idatagent supports mariadb but i want to know which backup utilit... -
MariaDB Backup using Percona XtraBackup
Percona suggests to use the xtrabackup script for taking backup but it does... -
MariaDb ColumnStore on docker
Hello, I'm trying to evaluate MariaDb ColumnStore and want to do that using... -
MariaDB Connector/J
Hi, We are using MariaDB Connector/J against our production AWS Aurora RDS ... -
MariaDB CPU Performance Monitoring
Hi, Can anyone tell me whether or not it's possible to monitor CPU metrics ... -
MariaDB Hardware requirements
Is there any document which specifies the numeric values of minimal hardwar... -
MariaDB installation in a different directory using RPMs
I am trying to install MariaDB using RPMs packages in a user created direct... -
MariaDB Limitations
Dear sirs, Could you tell me what are the limitations of MariaDB ? I mean s... -
MariaDB maximum number of tables
I am using MariaDB 5.5 for a local centOS server for a drupal 8 website. I ... -
MariaDB migration
how do i migrate MariaDB from windows to linux?? -
MariaDB Monitoring
are there any other monitoring tools other than MONyog and Nagios?? like fo... -
MariaDB Monitoring Using MONyog
can we get summary of all the servers registered which are online and which... -
mariadb os support
does mariadb client binary support both 64bit/32bit. or do you want to install separate binaries -
MariaDB Parallel Replication
Is parallel replication already enabled in MariaDB 10.1.14? I am asking thi... -
MariaDB Partitioning and Stored Procedure Support
Does MariaDB support the use of stored procedures with partitioning of tables. -
MariaDB Patches
Does MariaDB offers patches? For example, MySQL Oracle Offers patches for d... -
MariaDB relocatable rpm packages
I want to know if the mariadb 10.1.13 packages are relocatable or not as i ... -
MariaDB removes all users on restart
I am new to MariaDB and have set 3 instances up on 3 different servers. I c... -
MariaDB Replication: trigger not executed in slave table if master table contains any triggers
https://mariadb.com/kb/en/library/running-triggers-on-the-slave-for-row-bas... -
MariaDB sorting issue
Hi, I have one table with 4 million rows and other table with 1 million row... -
MariaDB Storage Engine
Is Cassandra storage engine available for mariadb-enterprise 10.1.13 tarbal... -
MariaDB support
In the mariadb subscription packages Email and web support is provided. Is... -
MariaDB support
Is 32 bit linux client machines supported...if mariadb server is installed on 64bit machines only? -
mariadb support for 32 bit systems
Is support provided for 32 bit architecture systems(windows and linux) for ... -
MariaDB third party tool support
With mariaDB enterprise third party tools like SQLyog and Monyog (developed... -
MariaDB: is Aria's page cache and InnoDB's buffer pool shared across database connections for an embedded database?
If each thread in a multi-threaded application connects to an embedded data... -
Maximum columns per index
I have a question about the maximum columns per index. In the MariaDB docum... -
Maximum number of columns
Hi there, What is the maximum number of columns a row can have in MariaDB? ... -
Migrating users table from Maria 10.2.22 to MariaDB 10.4.7
I have an application using MariaDB Server version 10.2.22 which I am plan... -
Missing CentOS7 RPM: MariaDB-10.1.16-centos7-x86_64-cassandra-engine.rpm?
It appears the rpm for the Cassandra storage engine is not available in you... -
MONyog Audit Log Monitoring
MariaDB has a plugin server_audit which records all the events happening on... -
MONyog Auto-Discovery of MariaDB Databases
Is it possible to discover all the mariadb instance running on a particular... -
MONyog Cluster Monitoring
Is it possible to see all the monitoring information for galera cluster tog... -
MONyog Monitoring
Is MONyog capable of monitoring INNODB table locks and mutex locks?? Also c... -
MONyog Monitoring when password changed
Is it possible to get an alert whenever the user with which we are monitori... -
MONyog server configuration via command line
Is it possible to add new servers in monyog via shell commands?? -
MONyog SNMP Traps
When we are sending the traps seems like the tags are not present in the ra... -
MONyog ssh authentication using key
I have monyog installed on server a and mariadb on server b. When i give th... -
MONyog ssh authentication using private key
When we configure the ssh connection and we choose the key based authentica... -
MONyog Table Alert
How do i set up an alert for all the tables in all databases if they grow m... -
MONyog version detection
Is it possible to identify which version of MONyog is currently running whe... -
mysql_upgrade -p is failed
Hi Team, We have installed and configure Mariadb 5.5.56 and migrated dtabas... -
No of MariaDB Instances on MONyog
How many instances of mariadb can be installed with MONyog. If it depends o... -
OPTIMIZE my.cnf
I need help for optimize my.cnf what parameters are important and the optim... -
Percona XtraBackup Trigger Restore
How do i restore the triggers using percona xtrabackup?? -
Question about testing
I'd like to run the test suite on MariaDB-5 + MariaDB-10 both. https://mari... -
Reinstall Mysql database with too manny errosr...
My database not responding if i want to make a new database entry. Trying t... -
Replication slave loses connection and does not recover
A recurring problem on a replicated MariaDB 10.3.8 instance (running on Ubu... -
show databases
show databases is returning data folder directory listing instead of inform... -
Snchronizing MONyog on two servers
Is it possible to monitor MariaDB database from two servers where MONyog is... -
Storage engine support and compatibility constraints
Hi, 1- As the storage engine are plugins: - Are there any compatibilit... -
Swap usage won't decrease
We have a 5 DB nodes Galera Cluster in Production (MariaDB 10.0). About a w... -
tarball support
MariaDB Enterprise provides only RPM packages to be downloaded and tarball ... -
temporary tables on mariadb 10.2.8
Because since Mariadb 10.2.4 Information Schema TEMP_TABLES_INFO table was... -
Traffic Handling For Database Monitoring
MONyog uses port 5555 for Monitoring the mariadb database which creates a c... -
understanding Unkwnon error when connection is aborted
[Warning] Aborted connection 290 to db: 'test_db' user: 'dev' host: 'host.s... -
Uninstall mariadb on OSX?
Greetings… The Executive VP here wants to run a test, and requires me to un... -
Upgrading from 5.5 to 10.2
Hi, As part of a Cloudera upgrade, I need to update our MariaDB instance fr... -
Where is mariadb.cnf config file variables, and there meaning?
I cannot find any list of all mariadb.cnf config file options, and their me... -
which is the max storage capacity of Version 5.5 MariaDB?
which is the max storage capacity of Version 5.5 MariaDB? -
Why does MariaDB 10.2 use InnoDB instead of XtraDB?
Up until 10.1, MariaDB used Percona XtraDB as the default 'InnoDB' storage ... -
Windows-Installationsfehler 1603 bei der Installation von: mariadb-10.4.12-winx64.msi
Shortly before the end of the installation, the installer stops and rolls t... -
X protocol
Is there any plans to implement the X protocol or something similar for mar... -
[Warning] 'user' entry 'root@localhost' has both a password and an>
I am not able to restart mariadb service error says Access denied for user 'root'@'localhost'
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.
