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

learn more… | top users | synonyms

0
votes
0answers
15 views

How can I optimize a query with multiple derived tables containing `IN` and `GROUP BY`?

I'm collecting nmap data every five minutes and storing it in a database. Information about each scan (e.g. start and end time) is stored in the scans table: CREATE TABLE `scans` ( `scan_id` ...
0
votes
1answer
367 views

MariaDB Galera cluster nod won't start

I have configured a MariaDB Galera cluster with three nodes. The master node and one slave-master node is up and running, but the third node just won't run. The system specs and cluster config are the ...
1
vote
1answer
36 views

When to disable MySQL Query Cache

I have a high volume MariaDB 10 server thousands of databases of with over a million tables. Currently we are only hitting around 20% query cache hits. We are already employing Memcache and other ...
1
vote
1answer
31 views

Is the SQL syntax for InnoDB gauranteed to be the same between MySQL, MariaDB and Percona?

I develop an application that uses MySQL and explicitly uses InnoDB table engine. In a few cases we have clients using this application with MariaDB or Percona. I understand that MariaDB and Percona ...
0
votes
0answers
9 views

Silent install of Maria DB on Ubuntu 14.04 is not working

I am using the following commands for the silent installation of Maria DB on ubuntu 14.04. export DEBIAN_FRONTEND=noninteractive sudo debconf-set-selections <<< 'mariadb-server-10.0 ...
1
vote
1answer
67 views

Load Balancing multiple databases in a multi-tenant setup

We have a multi-tenant setup where each client of ours runs a DB that is identical to every other client. We were using Mysql sofar and with CentOS 7.x ,switched to MariaDB. If we want to distribute ...
1
vote
1answer
29 views

Minimizing downtime during MariaDB Replication Setup

I have the task of setting up MariaDB (10.0) replication from a master running in a datacenter to a slave running out in an AWS VPC. Reading up on the instructions on Setting Up Replication - MariaDB ...
1
vote
1answer
323 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 ...
0
votes
0answers
20 views

problem with column oriented dbms features

I am currently looking for a free(or at least low cost) column oriented DBMS with really good compression abilities (at least 10:1 ratio) and fast response time. Having evaluated multiple open source ...
2
votes
3answers
3k views

Could not start mysql or MariaDB. Permissions were ok, but mysql-bin.index permission error

Using MariaDB 5.5.36. Here's what I got while trying to start MariaDB: # syslog Dec 14 09:40:52 vps1497 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Dec 14 09:40:52 vps1497 ...
1
vote
1answer
29 views

Run multiple MySQL instances in Windows

Which is a better way to install multiple instances of MySQL / MariaDB / etc on a single Windows box? Manually setting different ports? Docker? Virtual Box? Something else? (Sandbox, mysql_multi, ...
1
vote
1answer
37 views

Migrate from innodb_file_per_table to off in MySQL ALTER TABLE removing ibd files

Trying to migrate individual tablespaces back into the shared ibdata tablespace. MariaDB version 10.0.16 SET innodb_file_per_table to off in MySQL, restated mysql and new tables are in fact going ...
1
vote
1answer
67 views

Materialized Subquery Not Optimized

I am having trouble optimizing a materialized subquery in MariaDb 10.0.15 and having difficultly understanding the documentation on whether I can even optimize this query any further. This query ...
2
votes
1answer
34 views

Possible causes that a MySQL/MariaDB query is slow under some table conditions

I am having a strange issue with a slow query under certain conditions: I have made a few tests and was able to isolate the issue to one single table called products_description (all the tables are ...
1
vote
1answer
39 views

Changing IP address from existing Mariadb10.1 Galera Cluster

I have a multimaster cluster with MariaDB Galera working properly, it is set to perform the replica through its WAN interface. This configuration was a result of a previous migration from another ...
1
vote
1answer
341 views

MariaDB Galera Cluster without HAProxy, MYSQL Proxy, etc

I'm looking to deploy a MariaDB galera cluster across three servers. However, I've noticed that the documentation often references HAProxy or the like. Does this not cause a single point of failure ...
1
vote
1answer
61 views

Why is MySQL MariaDB GREATEST(timestamp,NOW()) padding appending results with zeros?

Everything works as expected on my development machine, but when deploying to quality assurance environment, tests are failing because MariaDB is padding the result set with extra precision zeros ...
1
vote
1answer
30 views

How to optimize MariaDB database when it is serving queries

We would like to run an optimization on our MariaDB database while still allowing it to serve queries. I see that for MySQL this is possible since 5.7.4 (from this link) For InnoDB tables prior ...
1
vote
1answer
113 views

Question about a two-node MariaDB Galera Cluster

Hypothetical situation: Node1 is where data gets written to by the app server ... it was where the cluster was bootstrapped from. Node 2 is the second node in the cluster. Both these nodes run in the ...
0
votes
1answer
14 views

How to Ensure of Data MariaDB Galera Cluster's Safety?

MariaDB will send a copy of SST to every server which request for it even without checking whether it is in the gcomm:// list. So I can easily get other people's data by simply install a fresh copy of ...
3
votes
1answer
22 views

Performance schema: 'stage/sql/Sending data'

Background I am using MariaDB 10.0 but MySQL 5.6 answers are also of interest. Two machines cloned from the same image, same MariaDB configuration as far as I could tell, same dataset. One machine ...
1
vote
1answer
362 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 = ...
1
vote
1answer
380 views

Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?

As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query? LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
1
vote
2answers
33 views

InnoDB file per tablespace

I am using following syntax to create an InnoDB table: create table InnoDB_Test(a INT) DATA DIRECTORY='/var/log/storage/MySQL' INDEX DIRECTORY='/var/log/storage/MySQL' engine=InnoDB;` I want to ...
0
votes
1answer
13 views

Does MariaDB require aliases for subquery table locks?

MySQL suffers from a bug (which they claim is not a bug) that prevents a table lock from working on a sub-query unless you create a table alias for each mention of the table name. See: ...
1
vote
1answer
345 views

Speeding up a simple select query on Mariadb

I have a 100k rows table with the following structure: +----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | ...
1
vote
1answer
227 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 ...
0
votes
2answers
167 views

Please recommend changes for my.cnf

I am not having any performance problems per se but want to improve my sites' performance if possible. Would appreciate any advice for how I can improve my.cnf. I have just one server, not ...
2
votes
1answer
130 views

Should I use utf8_unicode_ci or utf8_slovak_ci?

I was using utf8_slovak_ci collation until now, but I read that utf8_unicode_ci sorts very wide range of languages. Does it mean, I do not need to use separate collation for every language and I can ...
0
votes
0answers
26 views

How can I create a user that can only create databases and users?

What I want is a user (#1) that can create other users and databases (#2, #3, n). To clarify, user #1 should NOT be able to manipulate any databases. Even the ones created by himself. Users (#2, #3, ...
0
votes
1answer
112 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 ...
0
votes
1answer
234 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
120 views

Why do innodb tables get corrupted so easily?

I'm upgrading a legacy system running MySQL 5.1 all the way to MariaDB 10. We're on a brand new Windows server, running XAMPP. I've done plenty of DB migrations in my time but this one has just been ...
1
vote
1answer
45 views

systemctl startup script gives “WSREP: Failed to recover position” - manual startup works

We have a Galera crash. 3 Nodes on RHEL7. I can start one node with this command # sudo -u mysql /usr/libexec/mysqld --wsrep-cluster-address='gcomm://' 160408 13:36:24 [Warning] Could not increase ...
1
vote
1answer
18 views

Selecting a id from a pivot table

Trying to make a messaging system, similar to FB, people can message more than one person, when they do it creates a row for the user with the conversation id and user_id in conversation_user. ...
0
votes
2answers
2k views

Mariadb on Centos 7 not changing max connections based on my.cnf

The following configuration in my.cnf is not being followed. Max_connections go back to 151. please help as i have 16gb of dedicated ram that i would like to use properly. [mysqld] ...
2
votes
1answer
847 views

UTF8 vs ASCII or custom binary format: high-performance optimization on very big tables

The summary of my question is whether there are advantages, even if minimal, to use ASCII, or even a smaller format designed yet created specifically for the situation, instead of UTF-8 for strings. ...
0
votes
0answers
207 views

MariaDB multi-master replication (star topology) - Bizarre out-of-sync behavior

This may look familiar, I've been learning about this stuff for a few days - but this is a new question. I have a setup like this: Every node is a master, and I have them all replicating to each ...
0
votes
0answers
7 views

Inserting data from external PC faster than from localhost

I've been benchmarking the performance of a new virtual server in order to find out the best engine and database structure for my setup. Currently I am using python with mysql-connector both on the ...
1
vote
1answer
521 views

MySQLWorkbench with MariaDB 10.0 Performance tab not working

I'm using MySQLWorkbench 6.3.3.0 (build 592) and I cannot use the performance tab on a Mariadb10 connection. This is the error I receive: This feature requires MySQL version 5.6.6 or newer ...
0
votes
0answers
29 views

Cannot open InnoDB table though the .frm file for the table exists

tonight, my local Server has crashed because the power went out. I do not have backups because this was only experimental. And for the sake of learning, I'd like to know what to do in this case. ...
2
votes
1answer
68 views

The right way of starting up a Galera Cluster

I am confused about the bootstrap process of MariaDB Galera Cluster. Let's say we have 3 nodes of a MariaDB Galera Cluster, working and functioning normally on CentOS6/7. However, at some point we ...
0
votes
1answer
186 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
0answers
6 views

Does --single-transaction and transaction_isolation level set to repeatable-read does same thing

In my my.cnf file Transaction isolation set to repeatable read. I am trying --single-transaction for dump for consistent backup.As per documents --single-transaction sends signal to server as to set ...
0
votes
1answer
506 views

MariaDB I/O capacity with innodb_io_capacity parameter

I use hdparm to test my SSD hard drive I/O benchmark : [root@mail ~]# hdparm -t -T /dev/xvda2 /dev/xvda2: Timing cached reads: 12906 MB in 1.99 seconds = 6477.79 MB/sec Timing buffered disk ...
0
votes
1answer
282 views

Install MariaDB 10 Generic Binaries + TokuDB

I used to install MariaDB from Generic Binaries on a Debian Wheezy 64bits: mariadb-10.0.13-linux-x86_64.tar.gz (from downloads.mariadb.org) I would like to use TokuDB as Storage Engine. However, ...
4
votes
2answers
138 views

Update old database with SQL dump

I had to recover a database with a some months old full backup. I have however in my possession a most recent but unfortunately incomplete SQL dump for this same database done with mysqldump. Is ...
0
votes
3answers
43 views

How to detect level in nested MySQL table? [duplicate]

I have simple child-parent relation by saving parent_id. Is it possible to count which level each entry? My DB looks like this: As You can see from the image, for example the first item relation ...
2
votes
1answer
278 views

grastate.dat with seqno -1 on a healthy cluster. Why?

We use those versions: # rpm -qa | egrep '(galera|maria)' mariadb-libs-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.40-6.el7ost.x86_64 mariadb-galera-server-5.5.40-6.el7ost.x86_64 ...
1
vote
4answers
51 views

User privileges error on server maria db Create trigger Drop trigger

User privileges error on server maria db User : user1 DB : db1 Error 15:00:46 DROP TRIGGER IF EXISTS audit_trigger Error Code: 1419. You do not have the SUPER privilege and binary logging ...