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
69 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
544 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
46 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
95 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
53 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
115 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
89 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
63 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
56 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
155 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
69 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
121 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
59 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
213 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
81 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
279 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
89 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
621 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
115 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
92 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
66 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
402 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
166 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 ...
0
votes
0answers
24 views

Is there a high ms lag between hosting a database on a separate server versus localhost

I am setting up quite a bit of web servers and finding that MySQL(mariadb) is using a bit of memory with these WordPress sites. Most of the time Nginx and PHP-FPM doesn't use much memory at all and ...
0
votes
2answers
10k views

“Table doesn't exist in engine” after moving tables from one VPS to another

I have two VPS's running right now. One, which I will refer to as the "old" server, runs on Debian 7 and gives this output for mysql --version: mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu ...
1
vote
1answer
2k views

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found

I've got the same error, although I'm running galera cluster with 3 nodes. I tried following the instructions from InnoDB: Error: Table "mysql"."innodb_table_stats" not found after ...
1
vote
0answers
169 views

mysql master/master replication problem

I am having a problem with one of my MySQL servers running CentOS 7. I have it almost setup with a master master replication status. But I keep getting this: MariaDB [(none)]> show slave status\G ...
1
vote
1answer
67 views

How can I Rewrite Update Query to Update Using First Record From Inner Join?

I wrote up a question about trying to do an update with an inner join last week that got a lot of answers that I am currently trying out. Here is the link to the answer I used to get to the point I'm ...
2
votes
0answers
709 views

Connection string for MariaDB using ODBC

What is the connection string for using MariaDB with ODBC? I'm guessing it's something like DRIVER={MariaDB ODBC 5.1 Driver}; SERVER=LOCALHOST; PORT=3306; DATABASE=DatabaseName; UID=root; ...
1
vote
1answer
96 views

mariadb: setting AUTO_INCREMENT using SELECT

I am migrating a MariaDB database from my personal machine to a test server. The database schema has changed so I need to recreate the tables. The source database is also a mix of data that I want ...
2
votes
1answer
490 views

Mariadb galera cluster nodes won't stay joined

I have a fresh install on Mariadb 10.0.20 on three servers. I'm using the same my.cnf from another running cluster, just changed the cluster name and the IPs. I bootstrap the first node, and I get a ...
2
votes
1answer
74 views

SQLyog and MariaDB engine

I am quite new in MariaDB and I use SQLyog Community Edition as the frontend GUI. Whenever I create a new table, on the Engine dropdown, there is no XtraDB option. Is there any additional steps I am ...
1
vote
1answer
342 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
votes
2answers
80 views

Optimize query or split in two queries and process result separately?

I have this DB schema: As you may notice already there is no relationship between tables and won't be on the future. If I run the following queries I will get a lot of rows per table: SELECT ...
1
vote
1answer
957 views

Your PHP MySQL library version 5.5.44 differs from your MySQL server version 10.0.20. This may cause unpredictable behavior

How can I fix this "error" in phpmyadmin ? Is this a serious problem, I should care about? Server Version: 10.0.20-MariaDB-1~trusty-log - mariadb.org binary distribution Apache/2.4.7 (Ubuntu) ...
1
vote
1answer
83 views

MariaDB unicode text got truncated

I'm using 5.5.40-MariaDB in Centos 7. [root@test ~]# /usr/libexec/mysqld -V /usr/libexec/mysqld Ver 5.5.40-MariaDB for Linux on x86_64 (MariaDB Server) I'm trying to insert a unicode string into ...
0
votes
0answers
68 views

Compare values between columns in different tables

I have two tables that looks exactly the same: CREATE TABLE `_sync_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `object_name` varchar(45) DEFAULT NULL, `sync_time` datetime DEFAULT NULL, ...
0
votes
0answers
208 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 ...
1
vote
0answers
37 views

select does not use index when using different column

For my server: > select version(); +---------------------+ | version() | +---------------------+ | 10.0.17-MariaDB-log | +---------------------+ I created a small workable example of ...
2
votes
1answer
283 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 ...
0
votes
0answers
69 views

MariaDB error on alter table - table removed - constraint name is blocked

Today, we experienced a strange behavior in 5.5.41-MariaDB (InnoDB): An ALTER TABLE (add constraint) statement failed with error (mysql server has gone away after that). Then the database table ...
0
votes
0answers
70 views

Change “datadir” before or after installation

I just installed MariaDB 10 on RHEL 7, but I want to store databases in a different directory. So I have to add datadir= to server.cnf file. But it is better to do before or after ...
1
vote
3answers
815 views

Get rows changed between two dates (latest and previous)

I have a table _sync_history with this data: +----+----------------+---------------------+ | id | object_name | sync_time | +----+----------------+---------------------+ | 1 | territory ...
1
vote
1answer
83 views

Int comparison very slow in query

I have this for simplicity fictional table which explains my problem: CREATE TABLE IF NOT EXISTS `posts` ( `pid` int(11) NOT NULL AUTO_INCREMENT, `user` int(11) NOT NULL, `posts` int(11) NOT ...
3
votes
1answer
150 views

MySQL (MariaDB - 10.0.16-MariaDB-1 (Debian) strange performance issues

I am running version 10.0.16-MariaDB-1 (Debian GNU/Linux 8.1 (jessie)) on Dual Xeon CPU, total 32 cores with 128 GB of RAM. This is a dedicated DB server and has been recently migrated over from ...