Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mariadb-10.1]

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

Among the main new features are Galera as a standard part of the distribution, encryption of tables, tablespaces, and logs, page compression, improvements to replication features, support for Spatial Reference systems for the GIS data and more geo-spatial functions.

For more details, see Changes & Improvements in MariaDB 10.1.

116 questions
14
votes
2 answers

Cannot drop column : needed in a foreign key constraint

I have a table with two foreign key constraints as below: mysql> SHOW CREATE TABLE `user`; CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `region_id` int(11) unsigned DEFAULT NULL, `town_id` int(11) unsigned DEFAULT…
Sithu
  • 367
  • 3
  • 4
  • 10
8
votes
2 answers

How to recover MariaDB Galera Cluster after full crash?

I crashed all my 3 nodes. After all nodes have been started I noticed that mariadb is dead. An I couldn't run it again. I am using CentOS 7 on all servers I tried to start first node and then others but without success. First of all I tried to find…
Oleksandr
  • 403
  • 2
  • 6
  • 14
7
votes
4 answers

Why the query optimizer choose this bad execution plan?

We have a MariaDB table (stories) with more than 1TB of data, periodically running a query that fetches recently added rows for indexing somewhere else. innodb_version: 5.6.36-82.1 version : 10.1.26-MariaDB-0+deb9u1 The query works just fine…
snebel29
  • 73
  • 4
7
votes
2 answers

Hex and Binary Literals in MySQL / MariaDB?

Another question I have pertains to just the & over string types. This question is over the binary-string literals as constructed with B'' or X''. MariaDB supports binary and hex literals, SELECT X'01', B'00000001', X'01' = B'00000001'; | X'01' |…
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
6
votes
1 answer

MariaDB - "ERROR 1205 ... Lock wait timeout exceeded; ..." when doing multiple parallel UPDATEs affecting different rows

We are using MariaDB 10.1.19 hosting a legacy database. We have an lpr table (on InnoDB) where we want to move from a text column gate to a normalized foreign key gate_id. Our code is doing the UPDATE in parallel, like this: UPDATE lpr SET gate_id=1…
Marco Pantaleoni
  • 163
  • 1
  • 1
  • 4
5
votes
3 answers

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 node: set global…
Oleksandr
  • 403
  • 2
  • 6
  • 14
4
votes
2 answers

Max Connections Maria DB

Every time I reboot Mariadb places me the max_connections in 151 and in the my.cnf I have it with 300. Why does this happen?
Jonathan J. Mangarret P.
  • 41
  • 1
  • 1
  • 3
4
votes
2 answers

Unexpected RAM usage on MySQL

We have a server which hosts about 10 customers in a multi-tenant web application, each customer has its own database which is cloned from a template, and each database is a little less than 3000 tables. The server currently has 8 GB of RAM with the…
Matteo Tassinari
  • 187
  • 2
  • 16
4
votes
2 answers

Select only the last record for multiple values

I have a table called "sessions" with say 4 columns like below id name s_time f_time 01 abc 10.15 10.45 02 abc 11.05 11.55 03 abc 12.18 13.46 04 abc 15.12 16.53 05 def 10.01 12.58 06 def 14.06 16.51 07 def 17.43 18.54 08 xyz …
R2xDV7
  • 43
  • 1
  • 1
  • 5
4
votes
1 answer

how to get 'Queries per second avg' using SQL (not 'mysqladmin status')

When I start mysqladmin, it prints out several statistics, including "Queries per second avg": # mysqladmin --defaults-file=../mylogin.cnf status Uptime: 4568115 Threads: 859 Questions: 3703806462 Slow queries: 19415 Opens: 10300505 Flush…
Sybil
  • 2,578
  • 6
  • 34
  • 61
4
votes
3 answers

Can MariaDB or MySQL cast as bigint, getting an error: ... right syntax to use near 'bigint)'?

If I want to take a string and create a table (this fails in strict mode), CREATE TABLE g AS SELECT CAST('2147483699' AS int); How do I tell it that I want a bigint type? I'll also get an int(10) type. SELECTing from it is humorous…
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
4
votes
2 answers

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 “No such file or directory”) when configuring cluster

I have 3 MariaDB nodes. Want to configure cluster. Specified in gcomm:// in my.cnf ips of all members in cluster according to this. And added ?pc.wait_prim=no at then of gcomm://ip1,ip2,ip3 Then mysqld process starts on each VM, but when i try to…
rokpoto.com
  • 183
  • 1
  • 4
  • 14
4
votes
2 answers

MySQL fails to start on arch Linux. Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

MySQL fails to start on arch Linux. mysqld[3440]: [Note] /usr/bin/mysqld (mysqld 10.1.22-MariaDB) starting as process 3440 ... mysqld[3440]: [Note] InnoDB: Using mutexes to ref count buffer pool pages mysqld[3440]: [Note] InnoDB: The InnoDB memory…
nelaaro
  • 767
  • 3
  • 10
  • 22
3
votes
2 answers

MariaDB freezes with no visible reason

MariaDB server experiences some sort of freezes happening sporadically with no visible reason or connection to outside factors (load, etc). After a thorough investigation the common picture for those freezes is the following: There are many…
user1065145
  • 141
  • 2
  • 6
3
votes
2 answers

Unable to run mariadb in safe mode

When I run following command mysqld_safe --skip-grant-tables & I get message myuser@myvm:~$ 200523 08:24:41 mysqld_safe Logging to syslog. 200523 08:24:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql After that when I type…
Frank Martin
  • 451
  • 1
  • 5
  • 18
1
2 3 4 5 6 7 8