Questions tagged [mariadb-10.1]

MariaDB 10.1 was released as stable (GA) with version 10.1.8 on 17 Oct 2015.

Filter by
Sorted by
Tagged with
1
vote
1answer
181 views

Using “OR” against two indexed columns doesn't use indexes

In the query below, from and tid are indexes of the replies table. SELECT * FROM `replies` WHERE `from`="<userId>" OR `tid` IN (SELECT `tid` FROM `posts` WHERE `from`="<userId>") By ...
1
vote
2answers
3k views

MySQL Instance Crashing on Selecting From a DB

I have a MySQL database table which crashes whenever I select from the table or perform any operation no matter how little it is. It crashes the whole MySQL instance. The table is of the following ...
4
votes
1answer
23k views

How to restart MariaDB Galera cluster?

How to restart MariaDB Galera cluster? After all node have been crashed I try to recover the cluster but without success. I have only 2 nodes. As documentation says I set a parameter on one of the ...
0
votes
1answer
1k views

Can't grant privileges to “root” when it has no password in MariaDB

I am setting up a small development local server (is a VM running CentOS 7) and because of that I didn't add any password to MySQL after run the command: mysql_secure_installation. Now I need to ...
0
votes
0answers
125 views

MariaDB 10.1.18 - Resetting Auto Increment Column After Reboot [duplicate]

I have 2 live MySQL servers, one running on Linux and another running on Windows. I have recently setup another MySQL environment on Windows however I am getting this error when inserting data into ...
1
vote
1answer
1k views

MySQL/MariaDB connection in asp code encodes wrongly charset utf8 at insert or update in data base

I can't get a simple update or insert to save special äöü characters. Instead they are being stored as äöü. The website displays äöü characters correctly if they are already stored as äöü in the ...
0
votes
1answer
93 views

Why does MariaDB 10.1.16 vanilla installation comes with an almost empty config file?

Why does MariaDB 10.1.16 vanilla installation comes with an almost empty config file (/etc/my.cnf) ? Whereas it is not the case for MySQL. The config file for MySQL is usually not empty.
1
vote
1answer
613 views

Issues using pt-kill to kill log queries

I'm trying to get pt-kill to work to kill queries running longer than n. The command as I'm running now is; pt-kill --busy-time 15 --print -u root -p `cat mysqlpw` --victims all --log /var/log/pt-...
0
votes
1answer
2k views

mysqld_safe not run on RHEL7, while it runs on RHEL6 when starting mariadb

I see this strange behavior when Mariadb is run on RHEL7 and RHEL6. When I start the mariadb server on RHEL6 via service mysql start, I see mysqld_safe starts along with mysqld. [user@divinedragon]# ...
0
votes
1answer
425 views

Incorrect information in file

[ERROR] mysqld: Incorrect information in file: '/mysql/#sql50f_eb5128_1.frm' Received this error while restoring old snapshot. How to confirm which table which is causing this error message? I'm sure ...
2
votes
2answers
7k views

MariaDB 10.1.16 on Ubuntu fails to start: WSREP Failed to recover position

I'm using 10.1.16-MariaDB-1~xenial from the official MariaDB apt repository for 10.1 [stable], via the University of Texas mirror. I had a perfectly functioning MariaDB Galera cluster setup on 3 ...
-1
votes
2answers
6k views

How do I find mismatches in two tables?

I have a database where I'm trying to find inconsistencies across two tables. I'm new to SQL and would like some help. The other questions I've looked up are confusing and too convoluted for what I'...

1 2
3