Open Questions
-
1062 errors logging to sql errors log file on one of three servers
I have three servers. One master and two are slaves. I have a process tha... -
Adding DataFlex 3.1c .dat Files As An External Table Type With CONNECT
I'm using MariaDB's CONNECT engine to access / utilize a set of Visual FoxP... -
ANALYZE TABLE, Error writing file '/tmp/MYdOeJgz' (Errcode: 28 "No space left on device")
MariaDB [cm]> ANALYZE TABLE X1 PERSISTENT FOR ALL; +-----------------------... -
Async replication channel setup
Hello, We have two MariaDB clusters with 3 nodes each. Setup following asyn... -
Automatically wrapping queries with duplicate columns into CTEs or Derived Tables
The requirement is to automatically wrap existing queries with duplicate co... -
awr kind of report for MariaDB
Hi there Just wonder is there any AWR (Oracle) kind of report or script ava... -
Backup MariaDb
Hi, I use GTID and want to know right way to backup and restore the data. F... -
Best surrogate key for clustered index for receiving mass inserts
I need to choose the best clustered index for a table that will hold real t... -
Breaking changes per every new subversion?
Hello all, Given that MariaDB 10 -> 10.1 -> 10.2 -> 10.3 all require incre... -
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 We configure replication between MariaDB 5.5.56 and MySQL 5.5.21?
Hi Team, We are having a development server with RHEL 5.11 and MySQL 5.5.21... -
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... -
cannot start mariadb
just stoping mariadb server for changing mysql password, when I want to sta... -
cannot use collation with mysql_stmt_prepare
If I want to select with a case insensitive collation SELECT * FROM test WH... -
Changing permissions on auditing files
After enabling auditing plugin, the log file owner is being 'mysql' if I se... -
Character set changes depending upon privs
Not sure if this is a bug or feature but try this experiment. On a MariaDB-... -
Circular replication
I am creating a circular replication for Laravel application, for 6 islands... -
Cobol and Maria DB
Hi, Can I write a routine using C connector provided by Maria DB and call ... -
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... -
CONNCET via ODBC: Logging connect-generated sql
Hello, I want to update an Oracle table via the connect storage engine. For... -
Connecting to MariaDB
Connection string to connect to MariaDB through .net c# application -
Connecting to MariaDB via OPC
I have a synology diskstation NAS running MariaDB. Further there is a Scada... -
Connection Timeout ignored (mariaDB java Client 1.5.3)?
Hi, The problem i'm experiencing is: {tomcat 8 connection pool , spring app... -
Could you *please* elaborate on *how* mariabackup is supposed to be used with galera SST
There's an abundance of different ways to set SST up, xtrabackup/xtrabackup... -
CP437 CharSet
I need to configure the character set of a schema as CP437. Unfortunately, ... -
cpimport with a decimal table bug
I meet with cpimport bug when I use a decimal table. this is the details :... -
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... -
DB administration software that is compatible with MariaDB 10.2.7 'COLUMN_DEFAULT' change.
Hello. Since we updated to 10.2.7+ the tools we used to use all broke in o... -
deadlock in Galera cluster
Hi I have been testing MariaDB with Galera cluster for distributed locking.... -
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 ... -
Derived Tables & Column Store
I have been having trouble with a stored procedure using derived tables joi... -
Disable Server Side Prepare Statements
Is it possible to disable server-side prepared statements in the ODBC conne... -
Does MySQL Enterprise Backup work with MariaDB?
We primarily support MySQL from Oracle. A business group needs an applicat... -
Enabling SSL in mariaDB running on Synology NAS
I am having problems with enabling SSL in MariaDB running on Synology NAS (... -
ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
hi when i loading data to mariadb columnstore and at the same time ru... -
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 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 ... -
Excessive contexting running MariaDB CE Query
I'm working on a MariaDB vs. Oracle query performance issue. We have about... -
Find Queries with huge Result-Set
Hello, we are using MariaDB as DB for our CMS. Lately I noticed a massive g... -
Functional indexes
Any ways or plans to create/implement functional indexes like in MySQL 8.0?... -
Future developments for temporal types
My current project is a forecasting application with dates going out to 263... -
GTID Slave - Behavior
Hi, I have Master -> Slave Replication using GTID enabled. During staging ... -
help mariabackup command
Hi, I have mariadb 10.3.4-MariaDB, i trying to backup with mariabackup com... -
Hibernate
How hibernate can use Maria DB's with noSQL data(flexible columns, JSON)? -
How do you undo replication on the master database
This is my first attempt to configure a master database for replication. I ... -
How execute an insert in a Trigger using table with Engine CONNECT?
Hello Guys I hope you are fine. I have a project, where I need to insert d... -
How to access binary log for Aria tables
The binary log contains a record of all changes to the databases. However, ... -
How to backup 250GB MariaDB database daily in Master-Slave scenario at table level
We have setup MariaDB master-slave in our production environment. We want t... -
How to build mariadb connector c for windows
The release of 2.3.1 have bug, the bug will fix on 2.3.2，so i download the ... -
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 ----------------------------------------------... -
How to configure parameters for each database in one server machine?
We are trying to configure one my.cnf file for a different database on one ... -
How to count items for a specific ordernation
Hi everyone, This is my table: PACKAGE_ID | ITEM_ID 1 ... -
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 get a spool file generated, along with the executed SQL script
We are migrating DB from Oracle to MariaDB. As part of schema objects insta... -
How to Install MARA DB TX 3.0
Hi I am new to MARIA DB and i want to try out MARIADB TX 3.0 for a project... -
How to install MariaDB ColumnStore as a module into existsing MariaDB row database.
In the webinar from 26 April, the narrator mentioned that MariaDB ColumnSto... -
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 install ODBC into Linux?
I am trying to install ODBC into my Linux. I did download the ODBC (mariadb... -
How to tell if replication is working
I have a master to slave replication setup. The slave is running Mariadb 10... -
How to use an insert using variable column names in stored procedure
I am sure that this happens because of my lack of knowledge, but I am in a ... -
I know this has been asked loads before, but...
I have a raspberry pi 3 with an external USB disk mounted at /mnt/database.... -
impossible to get MariaDB-Galera-server.x86_64 via yum on redhat 6
Hi everybody, I have MariaDB-Galera-server 5.5.51 installed on redhat 6 I t... -
index usage on updates
I have seen a few times that even if there is a covering index for an UPDAT... -
innodb large_prefix deprecated- resulting key length?
Q: With innodb_large_prefix being deprecated - does the following mySQL de... -
install issue
Trying to install mariaDB on OpenBSD andhave it working in openbsd:s defaul... -
Is it possible to disable transaction logging for LOAD DATA INFILE into a TokuDB table?
I love TokuDB features a lot, among other for its speed, but I was wonderin... -
Is there "pg_buffercache" / same kind of a functionality in MariaDB?
In PostgreSQL, there is pg_buffercache. Is there similar functionality ava... -
islanded master master recommendation
I have a question regarding the best way to achieve what I want. I have two... -
Issue on High Concurrency
Hello All, We are using apache storm application for message processing. Th... -
Issue with INSERT data not being available for immediate SELECT
I've got an issue where it appears that data that I insert isn't available ... -
IST replication failing on 2 node galera mariadb setup
We have a galera cluster setup with 2 nodes (master-slave setup) in a docke... -
j/connector parameters
I am attempting to connect PENTAHO to a MariaDB environment. I am using th... -
JEMALLOC not found when building on Raspbian Wheezy
I have installed the list of Required tools shown on the Build Environment ... -
JSON document
The JSON documentation, every place, talks about a "JSON document". Where i... -
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.... -
Lack of docuentation and Tutorials
I am using Firebird 3.0 at present. I am intrested to swith over to MariaDB... -
libmariadb on Centos 6
Hi all I install MariaDB on my Centos 6.8 64 bit, following the instruction... -
Location of log files. Containers.
Reference to logs, in maxadmin: MaxScale> add server server1 MariaDB-Monitor RWSplit-Servic -
Lua Filter
Can you provide a Demo for Lua Filter? -
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.... -
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 and Pro*C
Hi, Is there any plugin/code convertor available to perform DB operations o... -
Maria DB Driver with AWS Aurora
Hi, We use MariaDB Connector/J to connect to AWS Aurora RDS. RDS has SSL en... -
Maria DB Spark Connector support Structured Streaming
Hi - Does the Maria DB Spark Connector support Spark Structured Streaming h... -
mariabackup command question (binlog backup)
Hi, I have mariadb 10.3.4-MariaDB, i trying to backup with mariabackup comm... -
MariaDB - online table archiving
We have a script that "rotates"/archive the Syslog tables in MySQL. This sc... -
Mariadb 5.5.56 replication issue
Hi Team, We are using the mariadb replication in our environment, where is ... -
MariaDB and Python
Hello Everyone, So I'm a Python developer and I've recently installed XAMPP... -
MariaDB Connector/ODBC with LibreOffice Base?
When I try to use MariaDB Connector/ODBC with LibreOffice Base, Base crashe... -
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 Federated FederatedX
https://stackoverflow.com/questions/49089641/mariadb-federated-federatedx I... -
MariaDB Galera Cluster on PowerPC
Has someone tried to use MariaDB Galera Cluster with PowerPC? If yes, does it behave well? -
MariaDB Galera Cluster Out of sync suddenly (Only sync the schema change but data not) Innodb engine
Hi We are running a 3 (A,B,C) nodes mariadb galera cluster on productio... -
MariaDB Galera Cluster vs. MySQL NDB Cluster
Has someone made a performance comparison between MariaDB Galera Cluster an... -
MariaDB Installation error
I am getting error with ibdata1 auto extending of the files when running my... -
MariaDB master-slave replication issue
Hi Team, We are having following version of MariaDB and using master-slave ... -
MariaDB Master/Master database replication across regions on Microsoft azure Environment
We would like to implement geo redundant MariaDB Active/Active Database rep... -
MariaDB on a read-only filesystem
Is it possible to start MariaDB with datadir in a read-only mounted filesys... -
mariadb on Ubuntu Erro
Hi all, I have MariaDB installed on my Ubuntu web server, (an AWS instance)... -
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-libs installation conflicts with existing MySQL community libs
During installation of openstack on Redhat LInux7 we were facing the below error. -
Master down event on MMMon
Hello, I use Multi-Master Monitor for two MariaDBs and my network connectio... -
Max rows can stored in a table
Hi, Would like to know what is the maximum rows that can be stored in a table. Thanks -
Maxscale shows slaves as Slave of External Server, Running
We have this setup : 1 master + 3 slaves I want to configure Maxscale with... -
MaxScale, "No Master can be determined"
Hi! I am trying to use maxscale (2.2.15) with mariadb (10.2.15). maxscale i... -
Migrating from Oracle to Mariadb, getting HibernateOptimisticLockingFailureException save and update in same transaction Hibernate, Mariadb and Spring
We are migrating application from oracle to Mariadb. Using container transa... -
Migrating partitioned compressed tables
We are on MySQL 5.6 using partitioned InnoDB Barracuda tables with row_form... -
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... -
Moving Binary Log Files
Hi, I am wondering if I can move binary log files without any issues, like ... -
Moving mariadb to docker installation
I'm running debian jessie and I'm currently trying to replace all my server... -
Moving to the Default Directory
Is there a web page which describes the proper steps to move the default di... -
MultiNode PM installation with replication, can I give "hint" to columnstore to prefer one PM over other's as a dbroot backup
Is there a way to give columnstore a hint on which server to prefer for rec... -
MySQL 5.1.66 cannot grant monitoring user to check SLAVE STATUS
-------------------------------------------------- Problem Summary --------... -
mysql_upgrade -p is failed
Hi Team, We have installed and configure Mariadb 5.5.56 and migrated dtabas... -
Need help related to MariaDB performance behavior
We are working on case related to MariaDB where-in we are observing perform... -
need to load csv date data along with AM/PM values.
Dear Team , we are trying to load date column data along with AM/PM values ... -
Network time of result of select query is too much.
Hello, I'm getting data using select query with column index The number of ... -
New Release
Hello - when is new release scheduled for? -
Node Joining Failure When wsrep_sst_method=mariabackup
Hello, Simplest possible test environment for evaluating MariaDB clustering... -
node sequelize vs mariadb node interface
hello - is there any advantage to skipping the use of sequelize and instead... -
Node.js Connector TypeError: res.status is not a function
Hallo I am learning JS scripting and am making a RESTful API with the Mari... -
ODBC Connector and MS ACCESS 2010 not communicating
My experience is really with MS SQL server so it has been difficult to get ... -
ODBC Level 2 compliant
Is MariaDB ODBC 3.0.2 driver ODBC level 2 compliant? -
on duplicate key work around
Is there a clever way to simulate the on duplicate key behavior on a range ... -
On what macOS releases is MariaDB 10.3 supported?
On what macOS releases is MariaDB 10.3 supported? In general, where would I... -
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... -
Oracle to MariaDB Migration
Hi , I want to migrate my oracle database to mariaDB . Please suggest any m... -
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... -
Percona XtraBackup restore
How do i restore a single database from a full backup or from a single database backup?? -
Pooledconnection with wrong user credentials timeouts without information
Windows 10 MariaDB 10.2.14 mariadb-java-client-2.3.0.jar trying this with ... -
Poor performance on inserts MariaDB
We are running MariaDB Community Edition 10.1.11. We are benchmarking inser... -
Queries of large tables buffers and use memory
Hi, in a data warehouse, one source is MariaDB holding rather large tables ... -
Read path and write path in MariaDB Galera Cluster
Hi Everyone, I'm struggling to understand MariaDB Galera read and write pa... -
Restarting first node in cluster
Hello, I am a relatively new user of mariadb. I have a 3 node mariadb clust... -
Select data on previous month
Hi, Would need some help on how to query previous month data (eg. need to ... -
Select data using between dates
Hi, Would like to know should below query return data for 2018-12-12? Becau... -
ServiceNow Error when trying to use match regex, match pattern
Cannot for the life of me get these options to work in ServiceNow. No matt... -
Simulate SST method
How can I simulate a node being fallen behind the cluster and then enforce ... -
spider/tocudb compatibility
Can the spider engine work with tocudb shard nodes? -
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... -
Swap usage won't decrease
We have a 5 DB nodes Galera Cluster in Production (MariaDB 10.0). About a w... -
Switch over and JDBC connection
When I use JDBC connection and master host is down, how can I switch over t... -
TABLESPACES
[PROBLEM] Why does MariaDB does not support creation of Tablespaces ? Is th... -
temporary tables on mariadb 10.2.8
Because since Mariadb 10.2.4 Information Schema TEMP_TABLES_INFO table was... -
Transparent Huge Pages
How do we fine tune Transparent Huge Pages? Is there a guideline that someo... -
TRUNCATE sub partition?
Hi, The following command will truncate a partition : ALTER TABLE subpartio... -
UDT Options For Development with MariaDB
I am figuring out an alternative to Oracle and am trying out MariaDB. In Or... -
Unable to install MariaDB 10.1 on Ubuntu 18.04 after apt remove --purge mysql*
There is something wrong with the install script for MariaDB 10.1 on Ubuntu... -
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 use connectionpool with namedpipesocketfactory
I have an application that used to connect via the network (jdbc:mariadb:<t... -
Uninstall or delete MariaDB completely for re-installation
I am new to this forum so pse forgive me if I am asking a question which al... -
Unknown global parameter 'substitute_variables'.
I updated MaxScale to 2.3.2 and now I get the following errors: {{{ > Start... -
Updating to newer libreadline?
At the moment, the build dependencies say that mariadb requires a relativel... -
upgrading from 10.0.38 to 10.3.12
Hello, I have a database server with version ==> MySQL Ver 15.1 Distrib 10... -
use events in galera cluster
Hi, We are going to use the galera cluster. Moreover, I have created an eve... -
useLocalTransactionState for mariadb connector/j
The Mysql Connector/J supports the useLocalTransactionState variable (https... -
User Management - admin account to only add users with view rights
Hello, I am looking for a solution to create a user account for MariaDB tha... -
Using HeidiSQL with MariaDB AX Columnstore 10.2.10 Columnstore 1.1.2-1
Hi, I was playing around with my mariadb installation and when I imported a... -
We setted innodb_file_per_table is On. When new table created, What is the Initial tablespace size?
Please Help.. We are setted innodb_file_per_table variable is 'ON'. When n... -
What is the rest api for mariadb for integration purpose?
What is the rest api for mariadb for integration purpose? -
Whenever I try to use API, I'm blocked by this error log
Hello, I'm developing ARM target board. My develop environment is composed ... -
Where are the installation instructions?
Since, for reasons that are anything but obvious, the mariadb connector to ... -
Windows recovery point erases database
I have a situation where the Windows has been recovered. After that the dat... -
yum install Mariabackup fail
Hi,I'm using the CentOS 7,when i install Mariabackup with the command sud...
