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
32 views

Mariadb Prepared Statements stopped working, they were OK last week, I need help locating the issue

I have a number of stored procedures that were working perfectly well last week, but this week are causing me problems. The first problem is I seem to be getting the following: Mariadb SQL ...
2
votes
1answer
22 views

MySQL is too slow

I have a project with PHP/Laravel/MariaDB, the DB is getting bigger every day now some tables has 4kk+ records already Server is 4GB RAM + Ubuntu 14.04 + Apache (DigitalOcean) when I only start the ...
1
vote
1answer
85 views

MySQL cluster write performance with Galera (MariaDB)

I am currently evaluating the migration from our current database server to a three node cluster. Our current server is a VM running MariaDB 10.1 with asynchronous replication to another server in ...
0
votes
2answers
43 views

at the moment mysqldump (22 minutes exec time, 5 GB Dump), when to use xtrabackup?

We use the Puppet code for deploying MariaDB. Those are the backup options. mysql::backup::mysqldump: Implements mysqldump backups. mysql::backup::mysqlbackup: Implements backups with Oracle MySQL ...
0
votes
0answers
52 views
0
votes
0answers
36 views

Query result different between MySQL(4.1.22) and Maria(10.1.X)

Im trying to change DB of an application from MySQL(4.1) to MariaDb(10.1.X). During my testing, I came across a strange issue. Return value of a certain query is different between mysql (4.1.22) and ...
0
votes
0answers
74 views

MariaDB: Can't connect to MySQL server on '127.0.0.1' (107)

What does it mean the error 107? Can't connect to MySQL server on '127.0.0.1' (107) I haven't found this error in any documentation: https://mariadb.com/kb/en/mariadb/mariadb-error-codes/ ...
0
votes
0answers
28 views

Unexplained MariaDB/MySQL memory jump

All of a sudden the memory usage of my MariaDB instance has jumped from around 1.5GB to 6GB. A restart briefly solves the issue, but slowly creeps back to the peak value. Stopping all processes that ...
1
vote
0answers
42 views

MaxScale vs Fabric [closed]

I am looking to expand my single MySQL database into multiple instances to provide High Availability. As well, I am looking to be able to have read replicas and to shard in the future. I have looked ...
1
vote
1answer
35 views

Galera cluster: change the size of InnoDB Redo log files online?

We have a 3 node Galera cluster. I need to change the mysqld innodb_log_file_size parameter (see Changing the Number or Size of InnoDB Redo Log Files). I do this by stopping all 3 nodes and ...
0
votes
1answer
53 views

How does InnoDB represent composite integer keys?

Let's say I have the following table: Create Table Orders(server : tiny int, ticket : integer, primary key (server, ticket)); How is the composite primary key representation when stored on disk? ...
0
votes
0answers
35 views

SQL Joining across multiple tables

I'm trying to query across multiple queries at once, it is fairly easy to run queries one after the other but that is not what I should be doing in this case. I have one free variable and the rest of ...
4
votes
1answer
90 views

MariaDB database access using roles

I run MariaDB 10.0.23, and I use roles to grant privileges to users. I have a user john: +-------------------------------------------------------------------+ | Grants for john@% ...
1
vote
0answers
11 views

Need advice on storing pincode system (Zip code) and Shipping company Service Details

I am in the process of creating a system that could identify shipping companies (Fedex, UPS, etc.) from a given pincode (zip code) for a e-commerce platform. The shipping companies will provide a ...
0
votes
0answers
56 views

How can I avoid this deadlock in MariaDB?

I saw that I got a deadlock in a MariaDB cluster. I have 3 cluster database. What should I do to avoid that? 160211 16:29:02 *** (1) TRANSACTION: TRANSACTION 75AB6B17, ACTIVE 0 sec starting index ...
0
votes
0answers
42 views

MariaDB: inner join searching for 1 in TINYINT column not working

Since yesterday I've been trying to make a query work. I have two tables: image where I store information about images and imagehit where I store information about how many times those images are ...
0
votes
0answers
31 views

simple math with SELECT - no resulting row

Simple math with SQL don't give a result. There is written 1 row in set, but I don't see the result/row. MariaDB [(none)]> select 5242880 / 1024 / 1024 as current; 1 row in set (0.01 sec) ...
1
vote
1answer
40 views

Changing IP address from existing Mariadb10.1 Galera Cluster

I have a multimaster cluster with MariaDB Galera working properly, it is set to perform the replica through its WAN interface. This configuration was a result of a previous migration from another ...
0
votes
0answers
43 views

Is there any reason to use Innodb over Aria for wordpress?

Is there any reason to use Innodb over Aria for Wordpress? I currently have an nginx php-fpm wordpress Mariadb stack. Aria seems like a natural fit, given my workload is 98% select statements, and ...
0
votes
2answers
30 views

How do I do a join and exclude certain records?

Table STUDENT has columns ID, LASTNAME, FIRSTNAME Table TEACHER has columns ID, TEACHER_ID, STUDENT_ID Students can have many teachers. Teachers can add students to their class. I want to be able ...
1
vote
1answer
68 views

How do Locks Work in MySQL or MariaDB

There is a case which makes me a bit confused. As far as I understand deadlocks should appear if there are two query statements (including subqueries) in request (each transaction). So the ordering of ...
0
votes
2answers
88 views

MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash

We have tables with MyISAM. The are out of sync, the number of records is different on each cluster node > select table_schema, table_name from tables where ENGINE = 'MyISAM' and table_schema != ...
0
votes
1answer
45 views

Retrieving most recent X rows for each given user from a table

We've got a seemingly simple query that's running extremely slowly, but I can't quite figure out the best solution to the problem. The scenario is as follows. We have an inbox table, which has the ...
1
vote
0answers
40 views

Expanding MariaDB cluster (sharding)

I have an expanding MariaDB 3 node cluster and need to expand the available storage. Each node has (to make the maths slightly easier) 120Gb of database storage. As this is replicated, the total DB ...
1
vote
0answers
50 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
30 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
50 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
42 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
24 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
41 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
36 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
50 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
52 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
78 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
29 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
23 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
37 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
48 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
28 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
46 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
33 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
320 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
29 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
225 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
79 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
104 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 ...