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

Open source & cheap 'data at rest' encryption solutions

So I am exploring some options about database encryption. The best options are commercial (TDE). I am looking for an open-source implementation. Recent releases of MySQL and MariaDB have data-at-rest ...
1
vote
2answers
38 views

Enabling SSL in MariaDB running on Synology NAS

I am having problems with enabling SSL in MariaDB running on Synology NAS (DSM version 6.0) using self signed certificates. I have modified the my.cnf file to point to certificate files and the DB ...
1
vote
0answers
35 views

Slow MariaDB performance my.cnf

I migrated my eCommerce website database (Magento) from MySQL to MariaDB (10.0.25-MariaDB) and my site isn't performing as well as it did with MySQL. I've gone through my.cnf several times but to be ...
1
vote
1answer
18 views
+250

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...
1
vote
0answers
10 views

MariaDB / mYSQL Order BY PrimaryKey DESC vs DESC set by Default

What do you guys think about: After each query, I put "Order BY PrimaryKey DESC" VS I set "PrimaryKey Sort by DESC Default" and each query I don't need to put Order By there. Which one will be ...
0
votes
1answer
34 views

How do I get mysql to start for the first time?

I want to get mysql to start for the first time. I installed it on RHEL version 6. All of the commands posted were executed as root. As a test, I ran this: # yum install mysql This is the output:...
0
votes
1answer
35 views

MySQL MyIsam Compressing tables

Im packing big MyISAM tables with myisampack and came up with the following issue. (MariaDB 10.1.14 64bit windows) Indexes are rebuilt after packing the tablewhile running myisamchk -rq, so, it doesnt ...
0
votes
0answers
24 views

Howto defrag a Galera Cluster (5.5.41) with innodb_file_per_table = off? After TRUNCATE a huge table is defrag needed?

First question how to defragment our cluster (see Galera and MariaDB config)? I don't know how Galera replicates the new data files size? Second question, is defrag needed? We truncated a 30 GB table ...
0
votes
0answers
33 views

Howto fix replication failure with Galera - thousands of GRA_*.log files on all nodes

Galera Cluster generates a GRA log files if it fails to apply the writeset on the target node. This files exists in the MySQL data directory I use grareader to extract the SQL statement and get ...
0
votes
0answers
29 views

mysqldump: Got error: 1049: “Unknown database 'xx'” when selecting the database - because database deleted during backup? DBaaS

I receive this error during dump (runs a few hours, because 31 GB data files) mysqldump: Got error: 1049: "Unknown database 'ZETF_353D082E_422C_47C4_905F_FF961EEA29B8'" when selecting the database ...
1
vote
0answers
12 views

Howto restore Trigger filesystem copy (*.TRG and *.TRN files) in addition to mysqldump?

We use mysqldump for backup (without Trigger/Events/Routines included). mysqldump --opt --flush-logs --single-transaction --ignore-table=mysql.event --all-databases The triggers we copy with cp to ...
4
votes
3answers
74 views

Behavior of transactions on multiple connections

I have a MariaDB database with InnoDB tables. I have two connections to the same database. One connection is using a transaction around a large chunk of work. The other connection is tasked with ...
1
vote
0answers
27 views

Mysql replication, master_log_pos sync but tables not update

First, my replication config on Master: replicate-do-db = mydb binlog-do-db = mydb expire_logs_days = 2 max_binlog_size = 100M binlog_format = MIXED log-...
0
votes
0answers
14 views

Copying MySQL MariaDB databases MyISAM vs Aria

One of the main advantages that MyISAM continues to have over InnoDB is the ability to copy databases directly between servers using just tar files of the database directories. InnoDB has ...
1
vote
1answer
57 views

what's practical example / use case SELECT SLEEP() for DBA

I don't know how to use SELECT SLEEP(). It looks like a dirty hack. I found an interesting question How and when to use SLEEP() correctly in MySQL?. The answer is developer oriented: If you don't ...
1
vote
1answer
33 views

I'm seeing inconsisntecies in table data after exporting from one server and importing to another, why is this?

I'm quite new to the process of importing/exporting databases. I'm using Maria DB, and HeidiSQL to run queries, etc. I exported an entire database from our dev server, and loaded it into our live ...
1
vote
0answers
11 views

galera cluster in simple failover mode

Can mariadb-galera cluster be configured without data replication but simply in failover mode? I envision such configuration as one active master server and one backup server, both using the same ...
1
vote
0answers
25 views

1 Node crashed of 3 node mariadb galera cluster

Heading I have three nodes Galera cluster MariaDB, a node in June 4, 2016 suddenly crash, the following is log error Red Hat Enterprise Linux Server release 6.5 Server version: 5.5.39-MariaDB-wsrep-...
1
vote
2answers
33 views

guessing unused junk space in table. (innodb mysql/mariadb )

We have in every site (a dozen) one big database with lots of tables and record, using innodb as default and with innodb_file_per_table. from time to time we have space issue on some site and I am ...
2
votes
3answers
64 views

2 fast SQL queries get slow when bunched as subquery on a very large table

I'm trying to use a subquery to speed up a query on a very large table right now 30 million row it most likely going to end up close to 1 billion rows. My table lnmntr is as follow Lnmntr_ndx: ...
1
vote
1answer
57 views

Querying dates with different timezones at db and application level

There is a created_at column of datetime type in the order table. In my application I'm storing dates to the db as datetime in UTC. When I bring them back from the db I'm presenting/formating them to ...
1
vote
1answer
25 views

Contradictory reports from MySQL that a binlog file exists

Our replication recently stopped working. I submitted a question but was unsuccessful in fixing the problem (Error 1236 - "Could not find first log file name in binary log index file"). ...
1
vote
0answers
16 views

mysql/mariadb - prepared statement to create schema for users

I have the following scenario: mariaDB (mysql Ver 15.1 Distrib 5.5.49-MariaDB to be exact - I could bug the sysadmins to update if necessary) I want users to be able to create their own, distinct ...
1
vote
0answers
72 views

LEAST with 'if' condition brings timestamp instead of date

I was testing some new code in my server 1 and everything was just fine. When I sent my code to my server2 [Ver 15.1 Distrib 10.0.22-MariaDB, for Linux (x86_64)] , which is almost the same as server1 [...
0
votes
0answers
23 views

WSREP: Requesting state transfer failed: -11(Resource temporarily unavailable)

We have a 3 node Galera cluster. Only one node has "valid" data (gal-1). The other nodes need to sync from this node. I delete datadir and start MariaDB. 160527 14:28:20 [Note] WSREP: discarding ...
1
vote
1answer
31 views

MySQL trigger to update a key if record exists

I'm trying to build a trigger in MariaDB to follow this logic: 1. If the primary key val exists, increment the counter column 2. Else, insert the primary key into the table Here is my prosed ...
0
votes
0answers
34 views

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

I try to use this on my vps with mariadb: # Optimized MySQL configuration for cPanel servers by Fotis Evangelou - Updated Feb 2016 # # The settings provided below are a starting point for a 4GB-8GB ...
0
votes
3answers
67 views

Combine WHERE NOT EXISTS with ON DUPLICATE KEY UPDATE

I have 2 tables params and params_exceptions where params is supposed to be updated frequently by an external script. INSERT INTO params (extension, type, subtype, paramvalue) VALUES ('12345', 'FRNR1'...
1
vote
0answers
28 views

'mysqlcheck' hangs over a database

Sometime ago I noticed my WordPress sites wont load. I found the problem with MySQL. The server I am running on is a VPS server with: Debian 8.1 MariaDB - Ver 15.1 Distrib 10.1.14-MariaDB 2048 MB ...
0
votes
0answers
57 views

how to optimize individual insert-if-not-exist on large table with unique varchar

I am in the process of building a bunch of tables and pivot tables from a single large table containing 1.4m rows (from the OMDB project's monthly dump) The dump contains rows that include things ...
1
vote
1answer
81 views

howto read/interpret “show engine innodb mutex” output?

We use a 3 node Galera cluster with version 5.5.41-MariaDB-wsrep MariaDB [(none)]> show engine innodb mutex; +--------+---------------------------------+------------------+ | Type | Name ...
1
vote
2answers
102 views

Error 1236 - “Could not find first log file name in binary log index file”

Our setup: Master: MariaDB 10.0.21 Slave: MariaDB 10.0.17 Replication was working fine until recently at which point the slave's DBs had to be restored from a dump. I performed all of the ...
0
votes
1answer
61 views

Building MySQL InnoDB clustered indexes

Assuming that you have a table like CREATE TABLE `t1` ( `search_id` int(11) NOT NULL, `provider_id` bigint(20) unsigned NOT NULL, `status` text NOT NULL, `imported_at` int(11) NOT ...
0
votes
0answers
14 views

What is the 'auth_string' in 'GRANT' 'ON' SQL command in MySQL/MariaDB?

In the typical command to grant privileges: GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname" IDENTIFIED BY "password"; What is the "password" part? The documentation says it'...
1
vote
1answer
42 views

varchar datatype accepting integer values

below is the test table created. As data type is set to varchar it shouldn’t accept int values. desc c\G *************************** 1. row *************************** Field: t Type: int(6) ...
0
votes
1answer
65 views

Unable to change innodb_log_file_size in MariaDB Galera Cluster 10.0

I have a MariaDB Galera cluster (v. 10.0.19) with 3 nodes. I want to increase the innodb_log_file_size (i.e. the size of the InnoDB redo log files) on one of the nodes to match what it is on the other ...
1
vote
1answer
41 views

Display last date grouped by warehouse and product

I have a table called daily_stock with the following fields: +-----------+----------+------------+----------+ | warehouse | product | date | stock | +-----------+----------+------------+----...
1
vote
0answers
16 views

MariaDB strange user privileges issue

Server version: 5.5.47-MariaDB-log MariaDB Server / CentOS Linux 7 x86_64 I have two users: user@% and user@localhost with the same password but apparently different privileges (some privileges the ...
0
votes
1answer
70 views

Cant initialize MySQL. “mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended”

I am doing a fresh install of MySQL on Fedora 22. After I run mysql_install_db I try to start the daemon using mysqld_safe but it does not work. The system says: mysqld_safe Logging to '/var/log/...
0
votes
0answers
39 views

Table data is not getting dumped

This is just for test purpose. I'm taking backup (INNODB DB) with --single-transaction and from another terminal I'm running alter table on one of the table of same DB on which dump command is running....
0
votes
0answers
73 views

MySql Error : Database page corruption on disk

Recently Ive setup a xampp in my store location. on Windows 7 32 bit, 2GB RAM - Pentium PC. (XAMPP) xampp-win32-5.5.19-0-VC11 PHP application is Point of Sale. With latest mysql server and PHP 5.5. (...
0
votes
1answer
86 views

MariaDB - cannot set max_connections and wait_timeout through my.cnf

I am struggling to set max_connections and wait_timeout parameters in /etc/my.cnf but MariaDB does not seem to read the parameters from the file (it reads some of the others, I haven't checked all). ...
0
votes
0answers
26 views

Completely reset innodb logs and files

So long story short, we've been dealing with a corrupt innodb installation on a MariaDB 10.0 server after a power outage, specifically a log in the future error. Rather than try and fake the log ...
0
votes
0answers
33 views

Create a not unique FK in MySQL Workbench

I'm trying to model a database using MySQL Workbench (version 6.3.6, 64 bits, using linux mint). After syncing my model with a MariaDB (running in localhost, version 10.0.25), I discovered that the ...
2
votes
2answers
49 views

Improve query “JOIN … WHERE NOT EXISTS (SELECT 1 FROM … WHERE … )”

I'm trying to optimize a query because the plan generates a full table scan for a subquery. Data The (simplified) table structure: CREATE TABLE RECORD ( ID INTEGER PRIMARY KEY AUTO_INCREMENT ); ...
0
votes
0answers
24 views

pt-duplicate-key-checker - DBD::mysql::db selectall_arrayref failed: MySQL server has gone away

I run pt-duplicate-key-checker a few months ago successfully. Now I receive on the same database (Galera, RHEL7) those errors DBD::mysql::db do failed: MySQL server has gone away On CLI I can do use ...
0
votes
0answers
31 views

MariaDB shows crashed and PID/Program Name shows -

I have setup alpine linux 3.3 on ubuntu 16.04 as a container using lxc/lxd and setting up mariadb. I am done with the installation and all. When I check for the status of mariadb, it shows crashed ...
1
vote
1answer
62 views

import TSV file into MySQL table with SET datatype column

Is it possible to use LOAD DATA INFILE to load data into a MySQL/MariaDB table, where one column uses the SET datatype? My columns are separated by tab, my set members by comma. If so, how do I ...
4
votes
1answer
101 views

How can I optimize a query with multiple derived tables containing `IN` and `GROUP BY`?

I'm collecting nmap data every five minutes and storing it in a database. Information about each scan (e.g. start and end time) is stored in the scans table: CREATE TABLE `scans` ( `scan_id` int(10)...