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

learn more… | top users | synonyms

3
votes
0answers
417 views

Which is the right way to fix “Error: 1205 Lock wait timeout exceeded; try restarting transaction”

I have a PHP script that sync a local DB against external datasource. Each time the script runs I perform some triggers on the DB where INSERT or UPDATE happen. These are the the triggers for that ...
2
votes
0answers
29 views

Database does not send any data to application when ran for a larger data set

I have a query that runs fine when returning a smaller dataset (~1 million rows), but when I increase the number of rows it returns (~15-20 million) it will send nothing to the application. My query ...
2
votes
0answers
425 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; ...
2
votes
0answers
109 views

Two queries usually run fast but get slow when joined

There are those 2 tables CREATE TABLE IF NOT EXISTS `media` ( `mid` int(11) NOT NULL AUTO_INCREMENT, `user` int(11) NOT NULL, `order_type` int(11) NOT NULL, `media_id` varchar(50) COLLATE ...
2
votes
0answers
109 views

Performance difference between two MariaDB slaves

I have a pool of MariaDB servers like this : master (5.5.38-MariaDB-log) slave1 (5.5.38-MariaDB-log) slave2 (5.5.38-MariaDB-log) The two slaves servers run on the exact same hardware (Dell ...
2
votes
0answers
351 views

Mariadb sharding?

I'm trying to implement a mariadb sharding for learning purpose. I have looked into database sharding in general and found mariadb spider storage engine support sharding. I do not want spider storage ...
2
votes
0answers
568 views

mariadb out of memory crash

I have recently migrated from mysql (5.5.36 MySQL Community Server (GPL)) to MariaDB (10.0.10-MariaDB-1~wheezy), along with switching my cloud hosting provider. Both machines have 2GB RAM and 1GB ...
1
vote
0answers
26 views

Mysql slow copying to tmp table to indexing

I try to indexing table. The table size is about 60GB. But indexing query is hang on 'copying to tmp table' 18 hours. I found advice setting 'myisam_sort_buffer_size' myisam_sort_buffer_size : 128M ...
1
vote
0answers
15 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
0answers
26 views

can't change autoincremet variable in mariadb

I have problem with auto_increment in mariadb. I have 4 galera nodes. but my auto_increment_increment variable is 4.. Can I change dynamic? Is there any problem in big systems when I have billion or ...
1
vote
0answers
59 views

SQL query causes server gone away

I'm developing a database system which stores and caluclates engine performance data. I have been created a new view which selects data from several tables and calculates some values. Now I'm running ...
1
vote
0answers
44 views

mariadb slow when query works update or Insert

My boss said database is bad when query works in update and insert commands. What can I do for tuning? normally queries respond in select commands, It respond little results but page updated about ...
1
vote
0answers
49 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
137 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 ...
1
vote
0answers
64 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
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 ...
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) ...
1
vote
0answers
101 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: ...
1
vote
0answers
56 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
0answers
58 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 ...
1
vote
0answers
119 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
0answers
161 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
32 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 ...
1
vote
0answers
41 views

Migrated servers… Innodb tables stayed innodb, but database is showns as MyISAM. Problem?

I moved servers. I exported DB on old, imported to new. Kept getting syntax error on import until I tried no compression. Weird, but it worked. I was skeptical so I compared the two carefully and ...
1
vote
0answers
113 views

Select SQL_Calc_Found_Rows query extremely slow

I'm Wordpress 4.2.2 on an Ubuntu 14.04 LTS server, with PHP 5.9x and MariaDB 10.0.17. When clicking on a post on my site I see many slow queries that all resemble this and it ends up taking as 8 or 9 ...
1
vote
0answers
187 views

How to create multiple mariaDB mysql instance in CentOS 7?

How to create multiple mariaDB mysql instance in CentOS 7? I have already installed first mariaDB mysql instance in CentOS 7. I've been searching for documentations on how to configure a Multi-Master ...
1
vote
0answers
52 views

Mariadb support rtree index on innodb soon?

I was looking through mariadb bug list online (https://mariadb.atlassian.net/secure/RapidBoard.jspa?rapidView=24&projectKey=MDEV), but I am unfamiliar with JIRA so I am not sure exactly what I am ...
1
vote
0answers
34 views

Need some help building a query to get info from several tables

I have this semi-complex table structure: And I need to return this data: { "id": "10111001", "rep_id": "30000001", "targets_id": "60011001", "brands_id": "10010001", "brand_name": ...
1
vote
0answers
505 views

MariaDB is ignoring /etc/my.cnf

The variable I am trying to change is innodb_buffer_pool_size. As you can see below the settings is 512M. But SELECT @@innodb_buffer_pool_size; returns 134217728. When I execute: /usr/libexec/mysqld ...
1
vote
0answers
171 views

MySQL database table creation is very slow

I´ve run a test script that creates a database and 3 sample tables. Machine: Windows 7 x64 and MariaDB 10.0.17 DROP DATABASE IF EXISTS dbTest; CREATE DATABASE dbTest; USE dbTest; SET profiling = 1; ...
1
vote
0answers
91 views

MySQL replication error: Table doesn't exist

I just run a MySQL database master-slave replication using these instructions. The process seemed to be ok, but when I run some queries on the slave server I get this message on 3 of my tables. ...
1
vote
0answers
400 views

MySQL SSL using MariaDB JDBC Driver

We have the following setup: Ec2 instance running a jboss server with mariadb (1.1.7) datasources setup to connect to an rds instance running MySQL 5.6.21. We would like to turn on SSL on for this ...
1
vote
0answers
833 views

Server version (5.5.40-MariaDB) does not match with the version of the server (10.0.15-MariaDB) with which this program was built/distributed

I just upgrade MariaDB (Mysql) 5.5.40 to MariaDB 10.0.15 by following this step by step. I have failed to enable the mysql and also mysql_upgrade with the following errors mysql_upgrade -u root -p ...
1
vote
0answers
236 views

Galera cluster consume many CPU percent and CPU high load

I have implemented a cluster include three nodes: two stored nodes and one garbd (also haproxy - load balancer). Some information about servers: SSD 480G Raid1 Memory 32G Swap 16G 2xCPU, number of ...
1
vote
0answers
115 views

Sysbench insert data between a given range

I was trying to insert 1000000 records of data into 1000 tables in sysbench. But after installing about 278, sybench just crashed with the following error: FATAL: failed to execute function ...
1
vote
0answers
73 views

pt-online-schema-change with circular replication

So I have an alter table (adding 4 columns) to do on a fairly large table (74 million rows). The problem is this table has firstly to remain online and writable during the whole operation and ...
1
vote
0answers
88 views

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all ...
1
vote
0answers
355 views

Any way to speed up my queries in MariaDB with tables less than a 4 GB in size?

I'm doing some text mining work and a bit frustrated that queries are taking 6 to 10 minutes to run. My workstation has a 3.5ghz Xeon, 32GB of RAM, and 2 SSD as RAID 0. Is it possible to do ...
1
vote
0answers
239 views

MariaDB Galera Cluster

I have two mariadb servers in cluster that is working galera and xtradb. it is my primary server configuration: [mysqld] datadir=/var/lib/mysql query_cache_size=0 binlog_format=ROW ...
1
vote
0answers
234 views

mysql/mariadb: ifnull changes collation

It seems that 'ifnull' changes the default collation that is set to be used. I have tried on both mysql and mariadb: Server version: 5.5.34-MariaDB-1~precise-log mariadb.org binary distribution ...
1
vote
0answers
91 views

Best practice for upgrading mysql on a master-master setup

Anyone have experience upgrading a master-master setup of Mysql 5.1 to a release version of Mysql while trying to keep at least one server online (in my case we are upgrading to MariaDB 5.5).
1
vote
0answers
274 views

MariaDB CUstom Functions

In MySQL, I wrote functions in C++, compiled them as .so, and added them to MySQL. I am trying to find a website that shows an example for doing the same in MariaDB. I cannot find any instructions, ...
1
vote
0answers
766 views

How do I safely import MySQL data in a directory to a running MariaDB server?

We're integrating another office into ours. That includes some of their data. I have a new installed MariaDB 5.5 server. The data dir = /home/data/MariaDB. I've done a new/fresh install into that ...
0
votes
0answers
10 views

Configure encryption in MariaDB specific to Windows/XAMPP

I want to configure encryption in MariaDB specific to Windows/XAMPP. Normal configuration on Linux machine is provided on MariaDB website Can anyone can suggest steps how to configure MariaDB ...
0
votes
0answers
34 views

Is there an equivalent of virtual columns in mysql?

Currently I'm taking a look at amazon's new aurora database and I'd like to check how my current setup performs there. The original table is on maria DB and contains a virtual column ...
0
votes
0answers
22 views

Why is my spatial index not being used on Mariadb?

I have a spatial index on geo column, but when I do EXPLAIN it doesn't show that the index is being used. Can anyone tell why? EXPLAIN SELECT AsText(geo) FROM marker WHERE ...
0
votes
0answers
21 views

MariaDB Galera Cluster Replication

Does the replication between an async slave connected to a master withing the cluster affect the performance of the master in the cluster?
0
votes
0answers
21 views

Is the Aria storage engine really crash safe?

I maintain a PHP/MySql app for a big customer. Many of the tables were on MyISAM b/c that was the default when I started. On a newer server running MariaDB, some of those tables kept crashing. ...
0
votes
0answers
40 views

What is the sync time from master to slave in a mariadb setup?

I am trying to find out how long it takes for data to be synced between the master database and the slave database in a master-slave replication.