Question : Here is the definition of the relevant table: CREATE TABLE IF NOT EXISTS pricehistory ( id INTEGER(6) UNSIGNED […]
Tag: mariadb-10.1
How can I use user defined variables and `USE`?
Question : I have some schemas, all with the same format. The format is: schema name, underscore, single digit (example: […]
Hex and Binary Literals in MySQL / MariaDB?
Question : Another question I have pertains to just the & over string types. This question is over the binary-string […]
Using “OR” against two indexed columns doesn’t use indexes
Question : In the query below, from and tid are indexes of the replies table. SELECT * FROM `replies` WHERE […]
Max Connections Maria DB
Question : Every time I reboot Mariadb places me the max_connections in 151 and in the my.cnf I have it […]
MySQL Master-Slave replication foreign key constraint error
Question : This is the cluster setup: —— —— | m1 | — | m2 | —— —— || || […]
Connection aborts is happening in MariaDB 10.2 but not in 10.1 even with log_warnings level set to 2
Question : I am noticing different behavior in mariadb 10.1 & 10.2 reg.connection aborts. I noticed connection getting aborted after […]
Cannot login as new user on MariaDB
Question : When I create a new user in MariaDB, I cannot login as that user. First I login to […]
mysqld_safe not run on RHEL7, while it runs on RHEL6 when starting mariadb
Question : I see this strange behavior when Mariadb is run on RHEL7 and RHEL6. When I start the mariadb […]
Deadlocks appeared after moving to MariaDB10.2 from MySQL5.5
Question : After moving to mariadb-server-10.2 from mysql5.5 I am facing deadlock issues. Please see the output of ‘show full […]