MariaDB is an open source RDBMS that is designed to be a "drop-in" replacement for MySQL.

learn more… | top users | synonyms

1
vote
1answer
61 views

Will “bridge” storage engines work with MariaDB Galera Cluster?

Galera states that it only supports InnoDB. The reason is quite clear, and it is related with the way synchronous replication is implemented in Galera. However, some storage engines are just ...
1
vote
1answer
348 views

Galera, MariaDB and multiple datacenter

Looking into using Galera and MariaDB across 3 data centers. We have a metroE comnection between the sites. Connectivity is pretty stable, but my concern is if a WAN link goes down at one of the ...
1
vote
0answers
62 views

Mariadb support rtree index on innodb soon?

I was looking through mariadb bug list online (https://mariadb.atlassian.net/secure/RapidBoard.jspa?rapidView=24&projectKey=MDEV), but I am unfamiliar with JIRA so I am not sure exactly what I am ...
0
votes
1answer
127 views

Result occurs often with fast random select query

I have this query to display 4 random photos on a website (I have it from here (when I asked for something faster than ORDER BY RAND())): (SELECT `p1`.`id`, `p1`.`url`, `p1`.`hits`, ...
2
votes
1answer
288 views

unknown variable 'log_slow_verbosity=query_plan'

What is the use of log_slow_verbosity = query_plan parameter in my.cnf ? I got an error when installing MySQL in my machine because of this parameter.
1
vote
1answer
337 views

Debug why MySQL/mariadb table is crashing

I have a MyISAM table that keeps crashing. How would I figure out why it is crashing? The error messages say nothing other than that it crashed. Is there a log setting I could activate? This is ...
3
votes
2answers
853 views

ALTER TABLE … ROW_FORMAT=Compressed times out

I'm trying to change a table with the command: ALTER TABLE ... ROW_FORMAT=Compressed This fails after 15 minutes, the log says: InnoDB: Error: semaphore wait has lasted > 600 seconds InnoDB: We ...
1
vote
1answer
81 views

How to structure this data? (Many columns currently.)

Working in MariaDB, we're trying to figure out how to store this data. All of our other tables have been normalized and are working nicely, but this has me stumped. We have a number of objects and ...
0
votes
1answer
252 views

Non-Replicating commands from (master) Mysql 5.5.40 to (slave) MariaDB 10.0.19

CRUD replicates just fine. But we noticed that DB structure altering commands such as ALTER TABLE and/or adding/updating columns to a table and even creating new ones do not replicate to the slave at ...
1
vote
1answer
53 views

Seemingly simple query…excruciating response time

I am in the process of running what seems to be a simple query and have yet to receive a result set. The purpose of the query is to obtain a list of all records within a table that share the same ...
2
votes
2answers
130 views

INET6_ATON returns NULL for input parameter

I'm making a MySQL Stored Procedure which takes a string representation of an IPv4 or v6 address and converts it to binary using INET6_ATON. I know that my version of MySQL supports this function ...
1
vote
1answer
94 views

Why is MariaDB 10 refusing to use my index on a date field?

I have the following table definition: CREATE TABLE `bets` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `id_mp` bigint(20) NOT NULL DEFAULT '0', `coin` char(3) COLLATE utf8_unicode_ci NOT NULL, ...
1
vote
0answers
37 views

Need some help building a query to get info from several tables

I have this semi-complex table structure: And I need to return this data: { "id": "10111001", "rep_id": "30000001", "targets_id": "60011001", "brands_id": "10010001", "brand_name": ...
0
votes
1answer
219 views

Removing per column and table collation and charset

I recently completed a transition of a database from CHARSET=utf8 COLLATE=latin1 to CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci. During the process tables were migrated one at a time by altering their ...
1
vote
1answer
294 views

How to insert UNIQUE IDs values from several tables into events table

I have a table called events defined as follow: rep_id, hcp_id, brand_id, email_id and content_id is the IDs in other tables. event_type should be kind of array containing this values: [ ...
0
votes
1answer
48 views

Function for generate a huge and possible random relationship between tables

I have this two tables and N:M relationship between them: Let's said I am managed to create a lot of media and emails records but I need to create the relationship between them. I can do this ...
1
vote
2answers
359 views

Slow “CREATE TABLE” and “TRUNCATE” on MySQL / MariaDB

I am fighting with performance issues on a local MariaDB instance. Fun thing: I previously had problems with all my INSERT and UPDATE and DELETE queries. This got signigicantly faster (~40ms -> less ...
0
votes
1answer
66 views

Does MariaDB support schema changes inside a transaction?

MySQL doesn't support schema changes, inside a transaction so there's no way to roll back after during a failed migration involving schema changes. This capability is supported by Postgres and ...
0
votes
1answer
114 views

How can I append new data from a particular mySQL table to an excel spreadsheet?

We have a database trigger that automatically adds new clients to a table when they first contact the server, it takes a number of unique identifiers that the client provides on first contact and ...
1
vote
0answers
823 views

MariaDB is ignoring /etc/my.cnf

The variable I am trying to change is innodb_buffer_pool_size. As you can see below the settings is 512M. But SELECT @@innodb_buffer_pool_size; returns 134217728. When I execute: /usr/libexec/mysqld ...
0
votes
1answer
78 views

MariaDB 10 replication strange behaviour

I have following MariaDB 10 replication setup. Server A MariaDB 10 (master), Server B MariaDB 10 (master), Server C MariaDB 10 (slave/master), Server D MariaDB 10 (slave). A and B are getting new ...
1
vote
2answers
134 views

Awful execution plans after migrating from MySQL 5.5.11 to MariaDB 5.5.41

We just migrated our web site database from a server running MySQL 5.5.11 to one running MariaDB 5.5.41. Everything is working mostly fine, except there's at least one query from our storefront that's ...
3
votes
2answers
4k views

How to enable queries logs in MariaDB

I'm running mysql Ver 15.1 Distrib 5.5.46-MariaDB in CentOS 6.7 server. I'm trying to get queries logged and I'm doing by redirecting log to files as shown below: #/etc/my.cnf.d/server.cnf # this is ...
1
vote
2answers
466 views

MariaDB/InnoDB: What to do on “Locks in Status-Log but no locked table found”

We migrated lately from MySQL to MariaDB. SELECT VERSION() 10.0.13-MariaDB-log When executing this: SHOW ENGINE INNODB STATUS I get (shortened): ... ---TRANSACTION 279257007, ACTIVE 23981 ...
0
votes
1answer
254 views

indexable JSON datatype in MySQL/MariaDB

In PostgreSQL 9.4 there is a JSONB datatype which allows you to index on fields in the stored JSON objects. Does MySQL/MariaDB have an equivalent? I'm specifically interested in the MariaDB Galera ...
0
votes
0answers
100 views

What happens when a mysql connection gets lost?

I hope this is a question for the dba board. Otherwise blame me and i'll switch to unix. imagine the following situation: you have a Mysql server S and two clients A and B. Both clients connect to S ...
4
votes
1answer
747 views

SELECT performance on MariaDB Galera cluster vs. MariaDB is terrible

We are evaluating a Galera setup and so far we have not noticed to many drawbacks except a few queries that have terrible READ performance I cannot put my finger on it. The query by itself isn't ...
1
vote
0answers
233 views

MySQL database table creation is very slow

I´ve run a test script that creates a database and 3 sample tables. Machine: Windows 7 x64 and MariaDB 10.0.17 DROP DATABASE IF EXISTS dbTest; CREATE DATABASE dbTest; USE dbTest; SET profiling = 1; ...
0
votes
1answer
51 views

InnoDB index concurrent inserts

I have an InnoDB table with an index on it. I have a few million rows to insert, so I thought I might take advantage of the row-level locking and do it in parallel. I'm inserting in batches of 10000, ...
0
votes
0answers
278 views

Help with Galera Cluster Auto_Increment

We're currently running a Galera cluster of 3 DB nodes. The way we're set up (due to ORM and automagical locking), we only have one of the 3 DB nodes being written to, and the other two provisioned ...
0
votes
2answers
2k views

mysql connection timeout on small traffic server

How can I set up MySQL so that connections never time out? And how do I even check to see what the current settings for variables such as wait_timeout and interactive_timeout, etc. are? Given that ...
1
vote
1answer
823 views

MariaDB Galera Cluster (master-master) does sync Tables but no data

I'm currently experiencing some sync-issues on my MariaDB Galera Cluster which is a master-master scenario. I've got everything set up properly and the cluster is syncing the DDL changes flawless. ...
0
votes
1answer
192 views

Find all tables in a DB with column names that contain that substring?

Say I have these three columns student_id, name, identify in three different tables in the same database. The query should search for column names that contain that substring. i.e. id should return ...
0
votes
1answer
55 views

Query exceeding 16384 bytes, skipping. Probably a bulk insert query

On MariaDB 5.5, Ubuntu 14.04 What actually happens when I restore a 170mb mysql dump file and info "Query exceeding 16384 bytes, skipping. Probably a bulk insert query." shows on cmon.log? Does it ...
0
votes
1answer
1k views

Hi disk I/O and crash when turning on sync_binlog in MySQL

I have a MySQL master server (MariaDB 10.0.17) that have a very odd behavior. It has one slave fetching data from it. When I set global sync_binlog = 1, the server I/O goes very high and after some ...
0
votes
1answer
118 views

Change MariaDB 10.0.17 (MySQL) master to a slave

I have a MySQL master/slave configuration -------- -------- | master | -> | slave1 | -------- -------- I want to kill my current master, transform slave1 to be the new ...
1
vote
1answer
389 views

mariadb / mysql wont change table_cache / table_open_cache

I've configured my i7 64gb ssd server with centos7 with the following my.cnf [mysqld] key_buffer = 12M max_allowed_packet = 16M table_cache = 4096 table_open_cache = 4096 table_definition_cache = ...
0
votes
1answer
314 views

Complex query performance in MySQL InnoDB versus MyISAM

I am running on MariaDB 10.0.15 on a 4GB RAM cloud server with Local SSD disk for database. My model: users <n---n> right_holders <n---n> tracks ---n> raw_detections I have this ...
0
votes
0answers
220 views

MySQL replication: most important config parameters on slave for performance on master server?

This query is almost the same as this question. But in this case, a configuration to make the master perform faster or just the same. Case We have a Master-Slave setup on a Mysql 5.0.77 - MariaDB ...
1
vote
0answers
516 views

MySQL SSL using MariaDB JDBC Driver

We have the following setup: Ec2 instance running a jboss server with mariadb (1.1.7) datasources setup to connect to an rds instance running MySQL 5.6.21. We would like to turn on SSL on for this ...
0
votes
0answers
150 views

How can I make a copy of a table from information_schema?

I would like to extract meta information from information_schema like count of rows in a table and store the result table into "meta" database. However, while I can query tables in information_schema, ...
2
votes
2answers
117 views

Master/Slave desyncronisation

Some manual operations (writes) have been made on SLAVE instead of MASTER resulting in the replication being stopped. Could not execute Delete_rows_v1 event on table xxx.newsletter; Can't find ...
0
votes
1answer
116 views

Error connecting to 10.0.17-MariaDB-1~trusty

I'm having problem connecting remotely to my MariaDB server. I've tried more or less everything, and can open a socket with nc(nc myserver 3307) but with the mysql (mariadb) client I only get the ...
1
vote
1answer
234 views

PHP / MYSQL connection failures via socket under moderate load

I've done quite a bit of reading before asking this, so let me preface by saying I am not running out of connections, or memory, or cpu, and from what I can tell, I am not running out of file ...
1
vote
2answers
205 views

Force MariaDB Galera to only create InnoDB tables

I successfully run a cluster of 3 DB servers using MariaDB Galera 10.0.16. This setup handels a couple of web apps we have created, plus a dozen medium traffic Joomla websites. My problem is that ...
2
votes
1answer
70 views

How should a numeric value that is an external key be stored?

This is something I was pondering recently. trying to determine how to store certain values. The best wide spread example I can think of is Federal Employee Identification Number - more commonly knows ...
0
votes
1answer
587 views

Mariadb Galera Cluster using Xtradb backup is not working

I am trying out the first test of MariaDB Galera cluster setup without success. This is the error in the log innobackupex: Created backup directory /tmp tar: -: Cannot write: Broken pipe tar: Error ...
0
votes
1answer
37 views

Can mariaDB contain indices only with data coming from remote tables?

I'm trying to think through a setup with a central mariaDB instance (A) accessing data on physically remote servers (B). All queries to the database (A) can be answered from indices only. Indices are ...
-1
votes
1answer
54 views

Query error int/varchar LEFTJOIN [closed]

Can someone tell me what´s wrong with this query? $sql = "select bans.id as banid, bans.type, bans.data, bans.reason, bans.expire, bans.added_by, bans.added_date, players.id as playerid, ...
1
vote
1answer
187 views

What can I do about this MariaDB 10.0 error?

I have a serious error that crashes the mariadb service, and it won't start up again until I delete the database folder in the data directory of the database I was working on at the time. Here is the ...