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

learn more… | top users | synonyms

1
vote
3answers
2k views

How to determine the optimal sort_buffer_size?

I read from a sample configuration file which says the following: # Sort buffer is used to perform sorts for some ORDER BY and GROUP BY # queries. If sorted data does not fit into the sort buffer, a ...
1
vote
1answer
221 views

MySQL/MariaDB stored procedure inserts even with syntax error

createdAt has not been defined, but the query still runs when I call this proc and inserts a "0" date. Why, shouldn't it fail? DELIMITER $$ USE `MobiFit_Dev` $$ DROP PROCEDURE IF EXISTS ...
1
vote
2answers
2k views

Memcached plugin on MariaDB?

I'd like to try new NoSQL feature in MySQL 5.6 but I am using MariaDB 10.0.2 on Debian 6 and don't fancy coming back to MySQL. I'm wondering whether the memcached plugin has been added to MariaDB? ...
1
vote
1answer
42 views

mariadb - EXPLAIN works but ANALYZE throws ERROR 1064 (42000) error in SQL syntax

I want to see the execution plan of a query to find out why it is slow, but ANALYZE does not seem to work, it throws an error on the same query that EXPLAIN accepts. MariaDB [dbx]> explain select ...
1
vote
3answers
56 views

Performance first low, then high after adding index, then keep high after drop index

I am testing performance a complicated select query. It is very slow. using explain, I have found a ALL in type COLUMN. Then I ADD INDEX. result comes out fast. However, when I DROP the INDEX I ...
1
vote
1answer
30 views

How do I create fractal index using tokudb engine?

I install MariaDb and configured it to use TokuDb Engine. I need to use Fractal-Index Built-in on TokuDb Engine. I have create my index as follow: ALTER TABLE `table__name` ADD INDEX ( `column` ); ...
1
vote
1answer
92 views

Threads_cached 0 while thread_cache_size > 0

I'm trying to little bit understand with some MySQL (in my case - MariaDB) performance. One point I found - "threads caching". So - I set: thread_cache_size = 4 in my.cnf and restart server. In ...
1
vote
1answer
147 views

MHA configuration problem with MariaDB10

I am using MHA (MySQL Master High Availability) over a MySQL/MariaDB master-slaves pool. Here is my setup : master1(10.0.0.1:3306) (current master) MySQL 5.1 (log-bin:enabled) ...
1
vote
1answer
51 views

MRG_MyISAM with myisampack tables blocking inserts

I'm using INSERT_METHOD=FIRST and compressing all tables that are members of the union but when I try to insert into the MRG_MyISAM table it tries to insert into the second one (instead of the first). ...
1
vote
1answer
175 views

Best backup strategy for MySQL (MariaDB) replication set

My main concern is getting a proper backup, even more so than a temporary outage. The data is golden. I've been doing reading through the documentation and a lot of the backup strategies seem to be. ...
1
vote
1answer
228 views

mariadb 5.5.36 with innodb plugin

I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to ...
1
vote
1answer
339 views

Connecting to a MySQL database on Mac from a VMWare fusion Virtual Machine

I have MariaDB (5.5.34-MariaDB) installed on a Mac (OS 10.8.5) I can connect to the database fine locally (127.0.0.1) on port 3306. But when I try to connect to the database from windows 7 64bit ...
1
vote
1answer
2k views

MariaDB Galera Cluster Replication error, no state received?

I have a very minimal, fresh out of the box setup for MariaDB with Galera clustering. My master node of the cluster is able to run, and is reporting that there is only one node attached to the ...
1
vote
2answers
2k views

how to import mysql system “mysql” database [closed]

This question might be already answered but it's almost impossible to google it. When I perform full backup of mysql server using mysqldump --all-databases then reinstall it from scratch I want to ...
1
vote
1answer
179 views

Avoiding performance hit from GROUP BY during FULLTEXT search?

Is there any clever way to avoid the performance hit from using group by during fulltext search? SELECT p.topic_id, min(p.post_id) FROM forum_posts AS p WHERE MATCH (p.post_text) AGAINST ('baby ...
1
vote
1answer
646 views

MariaDB allowing select only user to create databases

I'm baffled. I have a select only user, but somehow, the user can create a new database, and create table inside the new database. It can't create tables inside other db. It's really odd. This is ...
1
vote
0answers
11 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
1answer
10 views

Replication on same physical server [duplicate]

I am new to DB. We have galera cluster on Test environment where mariaDB is replicated in 3 servers. Now customer want us to work with only 1 server. they cant provide 3. Can we do replication on ...
1
vote
1answer
13 views

75% of RAM for Innodb_buffer_pool size

I have read many documentation including percona and MariaDB documentation where they recommend setting innodb_buffer_pool_size to 70-80% of RAM. My question is, is that total RAM or available RAM? ...
1
vote
1answer
15 views

MariaDB Galera Cluster wsrep_cluster_address not working

I have configured MariaDB galera cluster with three nodes on CentOS-6.5 64bits: db1 - 192.168.1.111 db2 - 192.168.1.112 db3 - 192.168.1.113 My /etc/my.cnf.d/server.cnf file is configured as ...
1
vote
0answers
58 views

MariaDB Galera Cluster - nodes fail to start

This is a new installation (fresh VM and MariaDB install). For some reason, the nodes are having trouble joining the master server. The master server would pause at Preparing binlog files for ...
1
vote
2answers
348 views

Galera Cluster with MariaDB 10 and asynchronous slave

So, as it's easier to understand what I'm trying to accomplish with a picture. Here's a picture: I'm really not an expert in database administration, so please be patient. I am working on a setup ...
1
vote
1answer
211 views

MySQL (or MariaDB) multi-master without MMM

I've been reading blogs on MySQL multi-master setup. The way I've used MySQL replication in the past was master-slave where if the master died (or was being taken down for maintenance) we would shut ...
1
vote
0answers
920 views

Mariadb new features vs PostgreSQL? [closed]

Mariadb 10 offer lot of new features. ( https://mariadb.com/products/mariadb/mariadb-vs-mysql) . I want to know, with these new features, will PostgreSQL would be a better solution for newly starting ...
1
vote
1answer
851 views

MySQL Workbench Cannot start SSH tunnel manager

I don't know why this error is happening when I try to connect by MySQL Workbench. Cannot start SSH tunnel manager. I'm using slackware 14.1 and installed all dependencies. I already installed the ...
1
vote
1answer
199 views

MariaDB Cluster - data consistency for updates and auto_increment

I have two different MariaDB servers and plan to merge data into one database and create MariaDB Cluster with 3 nodes. I read about Galera and multi-master replication - which MariaDB Cluster use and ...
1
vote
0answers
108 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
128 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
1answer
165 views

MariaDB: Created_tmp_disk_tables high after start

today i looked in the status of my MySQL server which is based on MariaDB and i noticed that Created_tmp_disk_tables is very high (over 168k). I think this is the reason for my high I/O usage. I try ...
1
vote
1answer
60 views

Count/Statistic for number of SHOW INDEX queries in MySQL/MariaDB 5.5 [closed]

We have a lot of SHOW INDEX FROM queries coming from our ORM layer. Usually there is a mechanism to prevent this but it doesn't seem to work at the moment. To better analyze the problem it would be ...
1
vote
0answers
139 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
2answers
668 views

Setting default CHARSET and DB Engine

I recently updated my server's database system from MySQL to MariaDB. After update, everything works well. But, when I went to phpMyAdmin, the default charset and types are changed: At the end of ...
1
vote
0answers
63 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
189 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
348 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 ...
1
vote
1answer
403 views

Why InnoDB ALTER TABLE is so slow? [closed]

The machine has a 4-core hyper-threaded Intel i7 670 @ 2.8GHz, 16G RAM, 8G of which is InnoDB buffer pool. The database resides on Intel SSD disk. DBMS is MariaDB 5.5.30 x64 running under Windows ...
1
vote
2answers
1k views

Install MariaDB without password prompt in Ubuntu

I need to install MariaDB server in Ubuntu without password prompt. For this purpose, I execute the following commands, but it doesn't gave me any progress. It again shows password prompt. I used the ...
1
vote
1answer
282 views

Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?

As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query? LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
0
votes
2answers
4k views

MySQL - Autoincrement does not increment sequentally if last row was deleted

I have a table which contains an auto incremented primary key id. If I delete the last row (highest id, for exampe id = 6) and insert a new row, the new id starts at 7. Which paramater I have to ...
0
votes
2answers
88 views

Is it safe to copy DB files directly from an LVM snapshot?

I saw two different approaches for backing up database with LVM snapshot. This article suggests spawning another MySQL instance to do an SQL dump. MYSQL Performance Blog suggests that it is safe to ...
0
votes
2answers
148 views

What is the best choice for MySQL high availability (zero downtime)? [closed]

As I know there are many solutions for MySQL HA, but most of them are congenitally not zero downtime solution, like MHA, AWS RDS... That said, if zero downtime is "must have", the only choice is ...
0
votes
1answer
1k views

MariaDB header error

I had a MySQL server on my Ubuntu dev box (I use a tutorial "how to install a lamp on ubuntu" type of article) and I decided to install mariadb. So I uninstall mysql and install mariadb. ~$ mysql ...
0
votes
1answer
111 views

Upgrading MariaDB Galera cluster from 5.5 to 10.0 - rolling upgrade possible?

I've had a good search around and cannot find much on the topic. We want to upgrade our live MariaDB 5.5 Galera cluster to the MariaDB 10.0 branch, ideally without any downtime. We installed ...
0
votes
1answer
252 views

Using Galera for simple master-master replication

I was reading the documentation and it specifically mentions that a Galera DB cluster must have at least three nodes to achieve Quorum, although our current setup is working with two. I am tasked ...
0
votes
1answer
133 views

MySQL pivot table via a view

Suppose the following schema CREATE TABLE `log_apache` ( `date` datetime NOT NULL, `count` int(10) unsigned NOT NULL, `input` bigint(20) unsigned NOT NULL, `output` bigint(20) unsigned NOT ...
0
votes
2answers
74 views

Optimize query with indexes

The following query is looking for all towns that are between 5 and 10 kilometers from a hard-coded latitude/logitude (=another town actually). I have 37010 towns. I'm using Symfony 2 which "creates" ...
0
votes
1answer
346 views

Install MariaDB and MySQL in CentOS 6 32bit in same server

I'm trying to install MariaDB with MySQL in the same server but got this errors: Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.i686 ...
0
votes
1answer
2k views

Which is faster among MySQL Community Server, Percona and MariaDB [closed]

I have a small setup of MySQL Community Server version 5.6 running on KVM based VPS. 4 CPU cores are available and total memory is limited to 1GB. I use MyISAM tables mainly for Wordpress and few ...
0
votes
1answer
395 views

UTF8 vs ASCII or custom binary format: high-performance optimization on very big tables

The summary of my question is whether there are advantages, even if minimal, to use ASCII, or even a smaller format designed yet created specifically for the situation, instead of UTF-8 for strings. ...
0
votes
1answer
37 views

In which situations is TokuDB higher performance? [closed]

I noticed that WordPress runs quite a bit faster when I use XtraDB (MariaDB's InnoDB replacement) instead of TokuDB. This is strange, because TokuDB is advertised as being 20x faster. However, I ...