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

learn more… | top users | synonyms

0
votes
1answer
582 views

What does “WSREP Aborter Idle” mean in a MariaDB Galera cluster?

I've tried to Google WSREP Aborter Idle but there are literally 3 results. Does anyone know what this means? Should I be concerned that the these processes have been opened for so long or is this ...
1
vote
1answer
66 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 ...
0
votes
2answers
138 views

Show Users That Connect To DB

We are using Maria DB (v5.3 I believe) in our production environment. One issue that we have, is that historically, the dev user (which has full rights and privileges) is used in all applications ...
3
votes
2answers
198 views

Best Indexing Strategy for Query with Equality[A], Range[B], Group By[C], AND Order By[count(P)]

I have a poorly performing query: SELECT user_id, count(item_id) as count FROM table items WHERE category = 'magazine' AND created_at > 1384754400 GROUP BY user_id ORDER BY count(item_id) desc ...
3
votes
1answer
641 views

MySQL/MariaDB stored procedure compiles with typos

I just asked a similar question to this, but that turned out to be because MySQL column names are case insenstive and I was creating an ambiguity. I took the advice given and prefixed all my params ...
1
vote
1answer
394 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 ...
0
votes
0answers
2k views

Incorrect definition of table mysql.event after migrating database to mariadb

I did a mysqldump to dump all databases into a .sql file, then installed a mariadb server. There are no errors after the installation. But after restoring the databases, I started to observe the ...
1
vote
2answers
1k views

InnoDB + TokuDB fills up RAM then start swapping

I'm trying to face difficulties with my database lately. I've migrated from MyISAM to TokuDB v7.0.4 and InnoDB. I'm using MariaDB - 5.5.34-MariaDB-1~wheezy-log. My problem is that MariaDB fills up RAM ...
0
votes
1answer
110 views

Aria engine - changing block size

It's possible to change aria_block_size from default 8192 without recreating tables? I want try 1024 or 2048 but after change in my.cnf and restart mariadb I got this errors on aria tables: #138 - ...
0
votes
1answer
73 views

Indexes on XtraDB tables

I have old db with myisam tables, using mariadb and want try move to xtradb for row-level locking. Each table have 27 columns, primary index and other 11 indexes. Columns with indexes have many ...
1
vote
0answers
198 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
1k 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 ...
2
votes
3answers
7k views

Purge old records from mysql ibdata1 file

Is it possible to purge old records from an ibdata1 file without taking down the database attached to it? Records that have been deleted from the database are still present when I scan ibdata1 for ...
5
votes
1answer
2k views

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then ...
0
votes
1answer
12k views

node unable to join a galera cluster; it fails during state transfer

It looks like the node is joining the cluster and then it fails… I have tried with both rsync and xtrabackup and it fails during state transfer. I seems to me that I am missing something real simple ...
4
votes
1answer
98 views

Update old database with SQL dump

I had to recover a database with a some months old full backup. I have however in my possession a most recent but unfortunately incomplete SQL dump for this same database done with mysqldump. Is ...
0
votes
1answer
403 views

mariadb-galera-server with Aria?

With Galera now somewhat supporting MyISAM replication, does that also mean that it will replicate Aria databases with storage engine (which is more or less feature complete to MyISAM, and a drop in ...
2
votes
2answers
464 views

Slow query responce on different mysql versions, percona, MariaDB

LEFT JOIN is supposed to be faster than a NOT IN query. This is what I've read online. But practically, this seems to be opposite. I have the following query here, INSERT IGNORE INTO callrequests ...
0
votes
2answers
1k views

How to enable the Federated/FederatedX storage engine on MariaDB 5.5?

I upgraded from MySQL 5.1 to MariaDB 5.3 and then to 5.5 on a Windows machine. Everything works well, except I can't enable the federated storage engine. With MySQL 5.1 and MariaDB 5.3, I just added ...
3
votes
2answers
7k 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 ...
1
vote
2answers
53 views

Indexing a reference column

Say I have a reference table like languages with only 20 records. Is it worth indexing a field like language_code (e.g. en, es) that's frequently used in queries? I'm wondering if an efficient server ...
0
votes
1answer
3k views

Why should I use InnoDB and MySql instead of XtraDB and MariaDB? [closed]

Why should I use InnoDB and MySql instead of XtraDB and MariaDB, except that InnoDB and Mysql happen to be installed by default on my servers? Why isn't MariaDB and XtraDB installed by default ...
0
votes
1answer
491 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
0answers
41 views

Is RI on a parent XtraDB table maintained after Optimize Table?

$ mysql dbnam -e' optimize table theTable' +----------------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | ...
2
votes
2answers
1k views

How do I determine how much data is being written per day through insert, update and delete operations?

The longevity of SSDs is largely determined by the amount of bytes written by insert, update and delete operations. What is the best way to accurately determine how much data is being written by ...
1
vote
0answers
80 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
2answers
3k 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
0answers
243 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
607 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
1answer
3k 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
2k 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
780 views

Is there a system wide way to change MariaDB to create tables using ROW_FORMAT = DYNAMIC

I've got a 700MB dump file from a mysql database that I was trying to undump into a new install of MariaDB and I got this error ERROR 1118 (42000) at line 7481: Row size too large (> 8126). ...
3
votes
2answers
1k views

To what extent is MariaDB Java client a perfect replacement for MySQL JDBC (Connector/J)?

Premise: I ship a Java application which will make a JDBC connection to a MySQL database. (At the time of this writing it could be 5.1 or 5.5, but hopefully the question and answer don't rely heavily ...
2
votes
2answers
3k 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
636 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 ...
2
votes
1answer
670 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. ...
3
votes
3answers
146 views

How can I improve this query?

About a year back I introduced a query which returns a sort of "Customers Also Purchased" data-set. At the time it ran reasonably fast however, as of late it's become very slow, sometimes taking up to ...
1
vote
4answers
3k views

Daily and Differential Backups [closed]

Is there a program with which I can create daily MySQL, PostgreSQL and MariaDB backups with these requirements: The first time, make a full backup. The second time, only the changes since the last ...
3
votes
2answers
2k views

MySQL Full Text search increase relevance for exact matches?

I have a MySQL database of ~10,000 organisation names that I want to be able to search. I would like to use a full text search because this would enable me to find "institute of doobry" by searching ...
4
votes
2answers
2k views

SHOW TABLE STATUS very slow on InnoDB

Recently we've been migrating from MyISAM to InnoDB and I understand that MyISAM uses meta information against each table to track information and such - however, the database is about 1.8gb with 1+ ...
0
votes
0answers
72 views

Autoincrement by 2

I use MariaDB 5.5. It increases every auto_increment value by 2. So all my ai cols look like 1 3 5 7 9 ... Where can I change this behaviour? Or might this be a bug?
2
votes
3answers
592 views

How can I improve my table design for different types of an entity?

Consider an accounting system as an example. I have an Entity called Client. Client can be of different types, with different fields applicable to different types. I consider creating separate tables ...
2
votes
1answer
1k views

MariaDB, Triggers and last_insert_id

I have a situation where I have three tables: sample, sample_name and run (extra columns removed to be only relevant information). CREATE TABLE `sample` ( `sample_id` int unsigned NOT NULL ...
2
votes
2answers
2k 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
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
225 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 ...
0
votes
0answers
532 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)! in Fedora16

I installed MariaDB server in linux using tar file(mariadb-5.5.28a-linux-i686.tar.gz) followed by the instructions from this link : https://kb.askmonty.org/en/installing-mariadb-binary-tarballs/. ...
1
vote
1answer
793 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 ...
2
votes
3answers
424 views

mariadb ignoring force index

I'm trying to tune a relatively simple query: select bt.col1,bt.col2 from bigtable bt join smalltable st on bt.smalltable_id = st.smalltable_id where st.name = 'some name occuring only once in st' ...
1
vote
1answer
332 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 ...