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

learn more… | top users | synonyms

1
vote
0answers
58 views

floating point exception in isql with mariadb

I have this problem in my Debian server : $ isql -v asterisk-connector [1] 13397 floating point exception isql -v asterisk-connector I already checked logs / google and got nothing ...
1
vote
2answers
32 views

Interested in counting number of threshold crossings

I would like to determine the number of times that a value has crossed a threshold in either direction in a specified time frame. As an example, lets say that I am interested in the number of times ...
0
votes
0answers
23 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 ...
1
vote
2answers
52 views

mysql query gets slower with increasing page number

I use laravel 5.2 with mariadb (ARIA engine) and found that my query for creating a gallery gets slower with increasing page number. select `pics`.`id`, `pics`.`title`, `pics`.`hits`, ...
0
votes
0answers
44 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
31 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 ...
1
vote
0answers
57 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 ...
0
votes
1answer
37 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
70 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. ...
2
votes
0answers
32 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 ...
0
votes
0answers
53 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.
1
vote
1answer
88 views

Slow query performance on large table with no unique keys

I have a table that has approximately 20 million records and I'm having a very hard time improving the performance of the following query. It's taking well over a minute to run. SELECT ...
1
vote
1answer
33 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 ...
0
votes
1answer
24 views

How do I stop, tune and restart a MariaDB Galera cluster?

So I have 4 nodes running on some fast but smallist (ram wise) vps machines. This is very cool but they are using 100% of the memory available. I need to turn off performance schema and possibly lower ...
0
votes
0answers
7 views

Committing one transaction halts another transaction with InnoDB tables on MariaDB?

I was hoping someone could clarify what is happening and what the effect is. I need to wrap a process in a database transaction to protect against failure. The problem is that as things stand the ...
0
votes
0answers
46 views

Why dropping TokuDB partition so slow

I have defined a simple time series table partitioned by UNIX timestamp (into 32 days). I then loaded ~17K entries, which were distributed among 8 partitions. There were at most 2880 rows in any ...
0
votes
1answer
53 views

MariaDB ignores binlog_format

I'm trying to make moodle work on my system, so i need to change bin_log format to MIXED or ROW. But, i'm having a lot of problems doing that. Any changes i try to do don't work; MariaDB ...
0
votes
0answers
36 views

Can't log in to MariaDB with --password=<password> but not with user-interactive login?

I can log into my MariaDB server when I put the password directly in the bash command, but not when I'm doing the user-interactive login (which is of course safer). root@vm# mysql -u root --password ...
0
votes
0answers
54 views

Fresh install of TokuDB using MariaDB

After a recent server crash, I am unable to restart the mysql server daemon with the following errors: 2016-01-07 12:02:52 3263 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' ...
0
votes
1answer
37 views

howto choose the right character set in MariaDB

if there are multiple character sets that can properly encode my data, how to choose one? Is there any difference in disk or memory usage? When joining tables do they need the same char set? Other ...
0
votes
0answers
405 views

MySQL / MariaDB pid ended (cannot start mysql) in CentOS

I have had a system with MySQL up and running for years. I recently accidentally moved all the directories in /var/lib/mysql to /var/lib/mysql/mysql2 and then fixed it and moved them back... or so I ...
0
votes
0answers
33 views

Problems with MariaDB - won't resync nodes - Can we build a good diagnostic set of instructions?

I have a 3 node ubuntu server MariaDB cluster using rsync, which keeps coming un-synced. When it happens I try to add it back in, reboot, and try again, try again with bootstrap... Recently I've found ...
0
votes
0answers
297 views

MySQL Tuner script to optimise MariaDB 10.1 install on 512MB VPS - MySQL's maximum memory usage is dangerously high

I have installed MariaDB 10.1 onto a 512MB CentOS 7 x64 VPS & enabled InnoDB. On this machine, I am also running NginX (1 worker process) & PHP-FPM (2 child, 2 spare) with php.ini memory limit ...
3
votes
2answers
56 views

What's the best way to diagram this “relation” looking for performance and|or disk space savings

I am working in a DB diagram and I have a table called cm_identifier_type. Each record of this table can have or not a downloadable file (saved a file path). I have identified two possibles ways to ...
0
votes
0answers
87 views

mysql optimize table and mysqldump

I have a dbserver with about 1.000 databases. This year (2015) we didn't do anything about table optimizing at all. Also our had an uptime for almost a year (338 days). Our backup script with ...
0
votes
1answer
117 views

What's the best setup for a MySQL multi master replication for a POS in a restaurant?

We're in the process of implementing a point of sale (POS) solution where we have heavily modified an existing open source POS. The original POS was never created with replication/synchronization ...
1
vote
1answer
65 views

Can't search for non-ascii characters

I have a database with Turkish names and surnames. Here is some information about my table: CREATE TABLE `sorted_tc` ( `TCKIMLIKNO` double NOT NULL, `ADI` varchar(40) COLLATE utf8_unicode_ci NOT ...
1
vote
0answers
30 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 ...
0
votes
1answer
63 views

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_turkish_ci,IMPLICIT) for operation '=' and why?

Hello I got error in mariadb. In my command two columns have different collate. one is utf8_unicode_ci (a) other is utf8_turkish_ci (b). Why I got error when I compare these columns ( where a = b ) ...
5
votes
2answers
953 views

Datatype for phone number: VARCHAR, INT or BIGINT?

So this will be the dummy question of the year but I need to ask since is not the first time I pass through this. Take a look to the following table definition: Take a look at the column ...
0
votes
0answers
45 views

MySQL/MariaDB: Can I drop KEY declatations in sql dump for CREATE TABLE for foreign keys?

I prepare Liquibase schema creation changelog for legacy DB. I started with SQL dump and refined it by little sed processing so I have only CREATE TABLE statements. It looks like: CREATE TABLE ...
0
votes
0answers
57 views

mariadb error transaction deadlock

I use galera cluster with 4 nodes, mariadb, we insert nearly 12million data. Insert task was finished. However we have lost 11000 data. I don't know where they go. In error log it writes; 151220 ...
1
vote
1answer
147 views

Why do innodb tables get corrupted so easily?

I'm upgrading a legacy system running MySQL 5.1 all the way to MariaDB 10. We're on a brand new Windows server, running XAMPP. I've done plenty of DB migrations in my time but this one has just been ...
0
votes
2answers
107 views

Connect MariaDB and Oracle XE

I got an existing MariaDB running on a CentOS 7, I want to add a reporting layer on top of it, I therefore installed an Oracle 11g XE with APEX 5. My goal is to link those two databases in order for ...
0
votes
1answer
107 views

Package mariadb-server-5.5 is not configured yet [closed]

I am having issues trying to upgrade my mariadb..... when i do apt-get update && apt-get upgrade i get the following error Setting up mariadb-server-5.5 (5.5.47+maria-1~trusty) ... * ...
1
vote
0answers
64 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 ...
0
votes
1answer
57 views

MySQL (mariaDB) trigger syntax always wrong

Im making a small game and i need to have a trigger on my members table, which will check the experience column, and anytime it gets bigger than certain values, the 'level' will become level+1. This ...
1
vote
1answer
176 views

How to set slow query log in MariaDB my.cnf?

It should be easy, but when I put these lines: log_slow_queries = 1 long_query_time = 1 log-slow-queries = /var/log/mysql/slow_query.log log_queries_not_using_indexes in [mysqld], MariaDB fails to ...
1
vote
2answers
140 views

Scaling for MariaDB / Percona / Galera Scaling

I ventured into the world of NoSQL database and as great as they are the lack of true ACID compliance has been a nightmare resulting in a lot of bad data so I am looking into relational databases. I ...
1
vote
0answers
104 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
2answers
114 views

Which service to use for unoptimized, slow mysql database ?

This will sound strange, but long story short. I have client running two CS Cart web shops one one dedicated server. Cs Cart is version 3.0.2 and each shop has around 2000 products. Website opens ...
0
votes
0answers
26 views

Can a Galera cluster be configured to allow reads-only while in a non-primary state?

If a node is unable to obtain a quorum, it goes into a non-primary state, where it will not accept any queries until it rejoins other nodes in primary state. There are config options to either ...
1
vote
1answer
211 views

Replicate only some tables of MariaDB database

I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. However I now have the need to create a new similar structure but with one ...
2
votes
1answer
34 views

Which Table Will Get Locked With This Query

INSERT INTO stats.cps (time_stamp,entries,cust_id) select start_time, count(*) , c_id from gb.str where start_time between '$DATE10' and '$DATE' group by start_time, src_id order by start_time ASC ...
0
votes
0answers
32 views

Galera 3 node cluster - force an online state transfer without downtime on existing node

We have 3 node Galera cluster. On node 3 I wish to force a state transfer. We have out of sync issues, because table was MyISAM. Now InnoDB. Howto do that? Delete data files and restart? The cluster ...
0
votes
0answers
15 views

user privilege and connection with mysql client

Why this user cannot connect to mysql using the client CLI: show grants for 'user'@'localhost'; ...
1
vote
1answer
36 views

Corruption in mariadb binlog

I have an installation with mariadb version 10.0.21. I need to backup the binlog file every 5 minutes to TSM, but as the binlog is being written every second, i am afraid of the file getting ...
0
votes
1answer
68 views

MariaDB is Forgetting Previous Auto Increment IDs

I'm using MariaDB 5.5.39, and it seems like it is forgetting the max id of the auto-incremented primary key if I delete all rows from the table and then too much time passes before another row gets ...
2
votes
1answer
153 views

Corrupt InnoDB: Start mysqld only innodb_force_recovery=6

I am working with version 10.0.19-MariaDB-1~trusty-log and I'm only able to restart mysqld with innodb_force_recovery=6 and I don't know why. The output of the /usr/sbin/mysqld is the following: ...
0
votes
1answer
77 views

SET or VARCHAR for list of tags in a MySQL photos table?

I just discovered the SET column type for MySQL tables. I have a photos table with ARIA engine where I want to store tags/keywords for each photo. Now I use a VARCHAR type and then find the photos ...