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
28 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
71 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
665 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
17 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
1answer
80 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 ...
2
votes
0answers
364 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
46 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
146 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
92 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
93 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
40 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
31 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
77 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
68 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
23 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
168 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
138 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
44 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
25 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
200 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
134 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
148 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
75 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
663 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
48 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
51 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
42 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
97 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
54 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
120 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
97 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
68 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
58 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
162 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
34 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
72 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
127 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
61 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 ...
2
votes
1answer
237 views

Two updates cause a deadlock

I have a mysql queue with the following sheme: CREATE TABLE IF NOT EXISTS `media` ( `mid` int(11) NOT NULL AUTO_INCREMENT, `order_type` int(11) NOT NULL, `media_id` varchar(50) COLLATE ...
0
votes
1answer
92 views

Select not repeated results from same tables in different databases

I have 3 tables in 3 different databases which are exactly the same. I'm trying to sync from this 3 databases to a master database as shown in the picture below: Right now I am running the same ...
3
votes
1answer
323 views

why “select” work in mariadb but doesn't work in mysql

set @row_number = 0; SELECT * FROM (SELECT (@row_number:=@row_number + 1) AS num, id, tbl_user_id, title, description, length lengths, ...
2
votes
2answers
92 views

MariaDB server with 80K-100K DataBases

BACKGROUND : We have an environment where there is a new DB created almost every minute and it will be Dropped after few days or weeks (maximum 1 month) such that the space used is about 300GB~400GB ...
0
votes
1answer
691 views

MariaDB/InnoDB: Temp file write failure

When attempting to alter a table to enable compression by modifying the KEY_BLOCK_SIZE I received the error: ERROR 1296 (HY000): Got error 64 'Temp file write failure' from InnoDB The command ...
1
vote
1answer
125 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
0answers
94 views

Switching from MySQL to MariaDB resulted in a high number of transactions

I switched from MySQL 5.5.44 to MariaDB 10.0 on a server and the number of transactions went through the roof without any increase in website traffic(the website traffic is the only thing that uses ...
0
votes
1answer
74 views

MariaDB: Querying a timestamp partition

I'm having difficulties getting my queries to make use of the partitions when I'm selecting. They need to be able to do > sometime > sometime and between sometime and anothertime. However, if I ...
1
vote
1answer
436 views

Speed up MariaDB?

I have a Wordpress Woocommerce store using WP All Import Pro to run automatic imports on a 15 minute cronjob schedule. It's usually trying to update 400 to 500 items from our supplier every 15 ...
0
votes
1answer
178 views

Fulltext Search Doesn't Match a Hashtag

We maintain a table that looks like this to perform search queries on our forums database. I'll draw your attention to the FULLTEXT columns: CREATE TABLE `forums_posts_search` ( `post_id` ...
1
vote
0answers
60 views

Space usage when copying

Short version Copy table took up more space than I expected or tested Why would that be? Could it be the replication / binlog? If so, what then is written to the binlog during this query: INSERT ...