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
11 views

MariaDB shows crashed and PID/Program Name shows -

I have setup alpine linux 3.3 on ubuntu 16.04 as a container using lxc/lxd and setting up mariadb. I am done with the installation and all. When I check for the status of mariadb, it shows crashed ...
1
vote
0answers
17 views

import TSV file into mysql table with SET datatype column

Is it possible to use LOAD DATA INFILE to load data into a mysql/mariadb table, where one column uses the SET datatype? If so, how do I specify the separator for the individual set elements?
1
vote
0answers
33 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
0answers
11 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
40 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 ...
1
vote
1answer
43 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
0answers
23 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 ...
1
vote
1answer
32 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
38 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 ...
2
votes
1answer
35 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
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 ...
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
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: ...
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 ...
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, ...
1
vote
1answer
68 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 ...
1
vote
1answer
46 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
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 ...
0
votes
0answers
30 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. ...
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 ...
2
votes
1answer
70 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
0answers
9 views

Converting ARIA table to Innodb remove PAGE_CHECKSUM option

In the process of converting ARIA tables to InnoDB engine. I need remove the PAGE_CHECKSUM table option that is not used on non-mariadb server. ALTER TABLE table_name, ENGINE=InnoDB ...
0
votes
0answers
6 views

'/etc/init.d/mysql start ­­wsrep­sst_donor=node1' with systemctl (pass WSREP options)

With classic init.d you can pass startup options. /etc/init.d/mysql start ­­wsrep­sst_donor=node1 How to do the same with RHEL7 and systemd (systemctl start mariadb). We use Red Hat provided ...
0
votes
0answers
43 views

How to do rolling upgrade MariaDB 10.0 -> 10.1 on ubuntu 14

I'm trying to figure out how to do a rolling upgrade of our galera cluster running on MariaDB on Ubuntu 14.04. In testing, the first node I upgraded started complaining about the timestamp column in ...
0
votes
0answers
26 views

Slow Join queries using Spider-Storage-Engine on MariaDB

Using: MariaDB 10.1.12 Spider 3.2.27 How can I tell my Spider node to do the JOIN queries on the remote host instead of trying to join over the network one by one? I'm using a query that looks ...
1
vote
0answers
28 views

Using Galera-Replication, what's the use in having a GTID associated with your backup?

On the topic of using a backupscripts the documentation for galera-cluster states that: You can use backups of this kind to recover data, but they are insufficient for use in recovering nodes to ...
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 ...
1
vote
0answers
9 views

need to calculate max_connection

I am trying to calculate max_connections. I already have a formula for it from this forum only which is max_connections = (Available RAM - Global Buffers) / Thread Buffers I am not sure with ...
0
votes
1answer
42 views

Mariadb sql query get stuck

I have table A which size is 32GB and has the following 5 fields: a (int) b (varchar(128) c (varchar(128) d (int) e (int) a, b and c are unique key. Now, when I query like this: select * ...
1
vote
1answer
64 views

How can I randomize primary key values?

I need to avoid having my primary keys sequential. Basically looking for this in MySQL: https://wiki.postgresql.org/wiki/Pseudo_encrypt
1
vote
4answers
52 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 ...
0
votes
0answers
12 views

innotop “Command Summary”

We provide DBaaS. This is innotop C output: We have only 8% read workload? The rest is write? I don't understand this is very uncommon workload for DBaaS? Statistics since last restart? What is ...
1
vote
0answers
234 views

Negative InnoDB Write Log efficiency in mysqltuner.pl results

I noticed something strange in results from mysqltuner.pl. I see this in mysqltuner output from three of my four servers with MariaDB 10.1.12: [OK] You have the latest version of ...
0
votes
0answers
25 views

mariadb can't import sql which contains \' in insert statement

i export a large db from mysql5.6, then i import into a mariadb (xampp) on my localhost by command line C:\Windows\System32>C:\xampp\mysql\bin\mysql -u root -p dbname < D:/folder/filename.sql ...
1
vote
1answer
79 views

How can I efficiently optimise MariaDB?

I am running a 24 GB KVM with 8 Xeon 3.2 SSD RAID 0. And I would like to get the most from my MariaDB sql server. I am using following my.cfg # # This group is read both both by the client and the ...
1
vote
1answer
46 views

MySQL. Capture Cis program makes incorrect query: SELECT DISTINCT “PartType” FROM “Capacitor” ORDER BY “PartType”

I am having problems to get one database running. I have a MySQL in my server, the server is running "5.5.48-MariaDB - MariaDB Server" with "UTF-8 Unicode (utf8)" I have a MySQL ODBC 64 bits 3.51 ...
2
votes
1answer
40 views

Keywords and reserved words: What's a poor boy to do?

We have been using MySQL since its beginnings. Back then we thought that descriptive column names were a good idea. So we created columns like date, open, high, low, close, volume, signal and so on ...
1
vote
1answer
23 views

right join leaving one row from right table

I am using MariaDB,in my sample database I am having two tables department and emp. I want to display all the department having less than 50 employees. In this case it should display all the ...
0
votes
0answers
15 views

What is the most efficient way to represent this relationship?

In the database a user can follow many different users. I'm looking for an efficient way to represent this. In the image above you can see my initial idea. This works however results in duplicated ...
0
votes
1answer
24 views

MariaDB: calculate the reads/writes ratio in percent

I found a blog post howto calculate the reads/writes ratio in percent. I receive NULL values in our env. > SELECT @total_com := SUM(IF(variable_name IN ('Com_select', 'Com_delete', 'Com_insert', ...
2
votes
1answer
43 views

Hybrid Synchronous / Asynchronous Replication?

We have a situation where we would like to have synchronous replication in our main data center, but replicate asynchronously to another region. Our second data center is 3,000 miles away (Site B) and ...
0
votes
0answers
23 views

MariaDB Galera cluster write all nodes

I've setup a MariaDB Galera cluster. It replicates OK, and works OK. I want to be able to allow inserts in all the cluster nodes, not only on the first node, and right now, I can't do it. It allow ...
1
vote
0answers
21 views

Changing tx_isolation and binlog format on master server - do i also need to adjust slave?

We are running a Drupal Commerce site with MariaDB 10.0 and master/slave replication. Because of the way our application works, we end up running in to a ton of deadlocks under heavy load. Apparently ...
1
vote
1answer
53 views

High Availability for MariaDB and Postgres : replication or active-passive (SAN)

During the last weeks I did a lot of research on High Availability for Postgres and MariaDB. Both by my own research and also recommended by vendor's, replications seems to have more advantages. Some ...
0
votes
0answers
35 views

Improving slow queries, slow query log attached

I am running MariaDB under Cpanel and hosting Wordpress websites. My slow query log has reached ~400MB in size, and I would like to know how to eliminate the DB issues. Link to the slow query log. ...
0
votes
0answers
39 views

MariaDB engine choice (Aria vs. XtraDB

I am trying to choose the better of two engines for my particular application: I want to have the DB in Raspberry Pi 1 model B, on a USB pendrive. Limitations are pretty obvious: slow storage access, ...
2
votes
1answer
105 views

ERROR WSREP`: gcs/src/gcs.cpp:gcs_open():1379:` Failed to open channel 'test_cluster'

I have three server that I want to Install Galera clustering on them, I followed this link to install and config it. but when I want to start the first server I got this error : ...