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

learn more… | top users | synonyms

1
vote
2answers
64 views

Which service to use for unoptimized, slow mysql database ?

This will sound strange, but long story short. I have client running two CS Cart web shops one one dedicated server. Cs Cart is version 3.0.2 and each shop has around 2000 products. Website opens ...
0
votes
0answers
18 views

Can a Galera cluster be configured to allow reads-only while in a non-primary state?

If a node is unable to obtain a quorum, it goes into a non-primary state, where it will not accept any queries until it rejoins other nodes in primary state. There are config options to either ...
1
vote
1answer
70 views

Replicate only some tables of MariaDB database

I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. However I now have the need to create a new similar structure but with one ...
2
votes
1answer
26 views

Which Table Will Get Locked With This Query

INSERT INTO stats.cps (time_stamp,entries,cust_id) select start_time, count(*) , c_id from gb.str where start_time between '$DATE10' and '$DATE' group by start_time, src_id order by start_time ASC ...
0
votes
0answers
12 views

Galera 3 node cluster - force an online state transfer without downtime on existing node

We have 3 node Galera cluster. On node 3 I wish to force a state transfer. We have out of sync issues, because table was MyISAM. Now InnoDB. Howto do that? Delete data files and restart? The cluster ...
0
votes
0answers
31 views

Galera cluster: fix out of sync tables

I have a table XXX, this table has on all 3 nodes different number of records. This table uses auto_increment key. I wish to resync this table from master to slaves. # yum install ...
0
votes
0answers
14 views

user privilege and connection with mysql client

Why this user cannot connect to mysql using the client CLI: show grants for 'user'@'localhost'; ...
1
vote
1answer
26 views

Corruption in mariadb binlog

I have an installation with mariadb version 10.0.21. I need to backup the binlog file every 5 minutes to TSM, but as the binlog is being written every second, i am afraid of the file getting ...
0
votes
1answer
47 views

MariaDB is Forgetting Previous Auto Increment IDs

I'm using MariaDB 5.5.39, and it seems like it is forgetting the max id of the auto-incremented primary key if I delete all rows from the table and then too much time passes before another row gets ...
2
votes
1answer
76 views

Corrupt InnoDB: Start mysqld only innodb_force_recovery=6

I am working with version 10.0.19-MariaDB-1~trusty-log and I'm only able to restart mysqld with innodb_force_recovery=6 and I don't know why. The output of the /usr/sbin/mysqld is the following: ...
0
votes
1answer
64 views

SET or VARCHAR for list of tags in a MySQL photos table?

I just discovered the SET column type for MySQL tables. I have a photos table with ARIA engine where I want to store tags/keywords for each photo. Now I use a VARCHAR type and then find the photos ...
0
votes
0answers
23 views

Data Base Migration - Adaptative Server Anywhere to Maria DB

I need to migrate a data base which is in my local computer to a on-line server. The RDBMS used in my local computer is Adaptative Server Anywhere 9.0.2.2451 while the RDBMS used on the server is ...
0
votes
2answers
63 views

Deleting rows from table where values less than an aggregate value

I'm attempting to remove duplicates from a table. CREATE TABLE media_views ( `companyid` INT (11) NOT NULL, `channel` INT(11) NOT NULL, `date` DATE NOT NULL, `views` INT(11) NOT NULL DEFAULT ...
0
votes
1answer
279 views

mariadb won't start (InnoDB error: space header page consists of zero bytes in data file ./ibdata1)

The following messages are in /var/log/mariadb/mariadb.log when I try to start mariadb: 151103 13:42:01 [Note] InnoDB: Initializing buffer pool, size = 128.0M 151103 13:42:01 [Note] InnoDB: Completed ...
0
votes
0answers
13 views

Basic 'grant proxy' failing

Using MariaDB 10, I'm trying a basic grant proxy... - and getting no success. I've tried many variations on the below session - can anyone hint at the problem? In the below, I'd expect the final ...
1
vote
0answers
51 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
0answers
144 views

WSREP: failed to report last committed and stop

I have galera cluster and I have 4 nodes. I'm importing some data. however one node gives error. Warning. The warning is; warning WSREP: Failed to report last committed 59102, -q (interrupted system ...
0
votes
0answers
37 views

What would cause database CPU load to increase 5x+ during peak hours, when traffic only doubles?

I'll start with a screenshot of CPU load on my database server for the past three days. http://i.imgur.com/sSZJdCb.jpg As you can see, it spikes from 20% to 100% load every day (would be even higher ...
1
vote
0answers
70 views

mariadb galera cluster stop one node automaticly

I have Mariadb galera cluster. I have 4 nodes. but When one node become slow, it stop itself automaticly. that's the error. What should I do? 151030 17:17:14 [Note] WSREP: view((empty)) 151030 ...
1
vote
2answers
68 views

Optimize speed on 400GB MyISAM table

We have MariaDB server with single table with image url information. The table is about 400GB on disk and contains probably 400M rows. Table is partitioned in 1024 partitions. All queries are ...
0
votes
1answer
76 views

install Galera but mariadb existing on system

I try to install galera on ubuntu 14.04 system. It has already got mariadb and it's working. How can I install it? my command : sudo apt-get install -y rsync galera-3 mariadb-galera-server it ...
1
vote
0answers
35 views

Efficiently filtering a self join based on a separate table

I have a table into which I've accidentally introduced mostly duplicate data, and I need to work out what are duplicates so I can have them removed. So I join table x onto itself. Things get slow ...
0
votes
0answers
25 views

How to permanently set log format in MariaDB?

I use a dockerized MariaDB for my OwnCloud server. There is a known bug: The default log format is statement, OwnCloud requires binary. I can fix this by getting a shell to the dockerized MariaDB: ...
0
votes
0answers
53 views

Mariadb, Galera auto_increment_increment

I have a 3 node Galera cluster configured and as a temporary solution so I can re point a client at a time (for testing) I also have a master-master old style slave from the Galera cluster to the old ...
0
votes
0answers
44 views

Galera Cluster crashes because of “ALTER TABLE” statement?

We use on RHEL7 # rpm -qa | grep maria mariadb-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.41-2.el7ost.x86_64 mariadb-galera-server-5.5.41-2.el7ost.x86_64 Do I analyze logs correct that Galera ...
1
vote
1answer
16 views

nohup import not process

I tried to import job but my nohup command seems doesn't work. devinim@koha-db57:~/kohaaktarim$ nohup mysql -u root -p kohadata < kohaaktarim.sql & [1] 9619 devinim@koha-db57:~/kohaaktarim$ ...
1
vote
1answer
136 views

INSERT don't work with NOT NULL but UPDATE does, why?

I have this table definition: CREATE TABLE `media` ( `id` int(11) NOT NULL AUTO_INCREMENT, `brands_id` int(11) DEFAULT NULL, `media_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, ...
2
votes
2answers
101 views

ORDER BY indexedColumn ridiculously slow when used with LIMIT on MySQL

The MyISAM table has 4.5m rows. Query with just LIMIT returns fast; query with just ORDER BY returns fast; combining both it never finishes. I've also tried USE INDEX(indexedColumn, Latitude, ...
1
vote
1answer
39 views

Syntax error in UNION ALL [closed]

I have syntax error in UNION ALL line 8.. what is the mistake? I'm using mariadb, (Innodb) SELECT 'Süre Bitiş Tarihi','Tc Kimlik No', 'Kullanıcı Soyadı, Adı','E-posta', 'Telefon','Diğer ...
1
vote
1answer
20 views

Configure MariaDB to log row deletion ONLY

I'm investigating some rows/tables that intermittently go missing on a Magento site, and of course there's no entries in the error log. (I suspect Magento queries/rules or human error might be the ...
0
votes
2answers
108 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 ...
0
votes
0answers
90 views

Why my mariadb slow when I select all from empty table?

I try to find why my database slow when I select all table . That's empty table... MariaDB [kohadata]> select count(*) from biblio; +----------+ | count(*) | +----------+ | 0 | +----------+ ...
2
votes
1answer
94 views

Is a “Ranking” query's ORDER BY in FROM subquery is preserved?

I've read in the following links that the ORDER BY in FROM subquery can be ignored. Quoted from MariaDB knowledge base A query such as SELECT field1, field2 FROM (SELECT field1, field2 FROM table1 ...
0
votes
0answers
44 views

Can't create TokuDB table due to incorrect “no space left on device” error

It doesn't matter how I create the table, as long as the engine is set to TokuDB I get this error. The error is definitely inaccurate as I'm certain there is plenty of free space left on the disk. ...
0
votes
0answers
23 views

Is it possible to use secondary indexes with Mariadb and Spider?

I'm working upon a Mariadb cluster with 3 data nodes + 1 master node running Spider storage engine. Running queries from spider node, I cannot force data nodes to use secondary indexes, as happens ...
1
vote
1answer
204 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
37 views

Openssl issues with MariaDB

While trying to install Mariadb galera cluster through yum in my RHEL server I get the following error: [root@Arrac1 MongoDB]# yum install MariaDB-Galera-server MariaDB-client galera Loaded ...
0
votes
2answers
49 views

I need to know if a JOIN query is possible

I have one table like this: And one like this: What I want to do is select that "1" from status in the second table if the product_id number matches the number in the query column in the first ...
0
votes
0answers
38 views

MariaDB Database wiping monthly

I have a website running on CentOS 7 using 5.5.37-MariaDB. Every month one of my databases wipes itself. The database still exists, it's just that almost all our tables are missing, of our entered ...
1
vote
1answer
70 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
1
vote
0answers
52 views

Mariadb improve performance while import dumpfile

I have a dumpfile with millions data inside. I want to decrease time because I waited too long. I imported 10 million data (3 GB) and I waited 1:30 hours. I will import nearly 100 million data (30 GB) ...
0
votes
0answers
70 views

Cannot connect to MariaDB (MySQL) in Manjaro Linux

I have just installed mariadb but when I try to create a user or even type mysql -u root it gives me this message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
2
votes
1answer
73 views

MariaDB subquery cache scope and settings

I am migrating an application from MySQL 5.6 to MariaDB 10. One major new feature of MariaDB is the subquery cache. I am trying to determine the expected effect this cache will have on our ...
1
vote
3answers
62 views

MySQL: Why is this UPDATE query so incredibly slow?

So I have a landing table for my data called XMLImport, and a products table called ActiveProducts. When there are changes to a product in the XMLImport table I need it to update the ActiveProducts ...
0
votes
1answer
45 views

Prevent replication of ALTER commands

I am using MariaDB 10.0 multi-source replication for a specific use case. For security reasons, I would like to prevent ALTER commands on master to replicate (such as CREATE, ALTER, DROP...) whatever ...
1
vote
0answers
104 views

Mariadb alongside MySQL Can't start the MariaDB

I'm running MySQL on ubuntu 14.04 and it works great. For development and testing before switching between the two I want to install a separate Mariadb server. I followed this (old) tutorial: ...
0
votes
0answers
32 views

I currently have a stored procedure that contains 5 joins, would it be more efficient to implement it as a view?

My current stored procedure is badly written and needs to be refactored. I've managed to find the time to do that. This procedure will be called every two minutes or so, and as more products are sold ...
1
vote
0answers
57 views

wsrep_slave_threads and tmpdir space usage

After increasing wsrep_slave_threads at Galera nodes I have experienced that the mysql tmpdir, which is a ramdisk, was using much more resources. Especially notable during xtrabackup-v2 STTs. Also ...
1
vote
0answers
85 views

Understanding Galera Status wsrep_local_recv_queue_avg

Does wsrep_local_recv_queue_avg really represent the average size of the wsrep_local_recv_queue? For the MariaDB version below I have problems to understand the status value of it, because the ...
1
vote
1answer
55 views

Database migration - Simply change connection string?

We are migrating our database (MySQL/MariaDB) onto a dedicated server. Previously, our web server hosted the database. I've already set up master-slave replication between the web server and the new ...