Questions tagged [mariadb-10.3]
MariaDB 10.3 was released as stable (GA) with version 10.3.7 on 25 May 2018. Please also tag with mariadb for search purposes.
0
votes
1answer
30 views
Do the type-specific WKT- constructors function differently from ST_GeomFromText?
From the docs on MariaDB, for ST_LineStringFromText
Constructs a LINESTRING value using its WKT representation and SRID.
ST_LineFromText(), ST_LineStringFromText(), ST_LineFromText() and ...
1
vote
1answer
18 views
Subset of Unordered Pairs of Distinct Primary Keys With Normalization
I am currently in the process of designing a database. I have one table as follows:
CREATE TABLE Set (
id INT PRIMARY KEY AUTO_INCREMENT,
-- other values
);
Now I wish to create another ...
0
votes
1answer
26 views
Can you update invisible columns
I'm trying to update the row_start column on a table with Versioning set. The row_start column is invisible.
UPDATE pgwebp.t_prov a
INNER JOIN pgwebp.t_prov b ON a.prov_id_a = b.prov_id
SET a....
0
votes
1answer
22 views
How can I add another .ibd file to my existing table when the memory space is full?
I am working on an enterprise solution on MariaDB. The biggest challenge we are facing is to find a solution if our tablespace is full (.ibd file) and how can we add another .ibd file which will work ...
0
votes
1answer
19 views
Unable to create an user using mysql_embedded
I am creating a docker mariadb image and wanted to create a database and user name before bootstrapping mysqld daemon. So as per the documentation I tried below queries.
mysql_embedded -e "CREATE ...
0
votes
1answer
26 views
How to use mysql_plugin utility?
I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that
Cannot read plugin config file unix_socket. Bad format in plugin
...
0
votes
0answers
19 views
How to execute multiple concatenated queries?
I wanted to grant privileges on some selected tables only. So far I could only gather the necessary queries but unable to execute those.
SELECT
CONCAT('GRANT SELECT ON drupal.', TABLE_NAME, ' to ...
0
votes
1answer
14 views
How to lock all tables except some specific table?
I am trying to set a stage server which replicate some tables like articles, user etc from master. If I start the slave server as read_only I am not able to my stage site up because there are some ...
0
votes
1answer
26 views
MariaDB replication from master to slave
After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them.
I am ...
0
votes
1answer
29 views
MySQL vs. MariaDB Binary Logging Difference
I've been doing some testing with both MySQL and MariaDB and I've noticed a big difference with regards to the growth of binary logs - I can't find out much about this online.
I have a test database, ...
0
votes
1answer
52 views
ERROR 1130 (HY000) not allowed to connect to this MariaDB server facing issue in granting permission
I am trying to connect to mariadb running different container.Getting below error
$ mysql -u root -h test-mysql --port 3306
ERROR 1130 (HY000): Host 'test_1_73f6dacd1d23.test_bluenet' is not allowed ...
1
vote
1answer
36 views
MariaDB uses “wrong”/irrelevant Keys on large table
We have migrated our database from a local hosting company to AWS.
Now when we run a particular query on AWS it finishes in about a minute (processlist says "sending data") where on the old server the ...
0
votes
0answers
27 views
Resolving “there is unknown charset/collation names” warnings on views
I recently moved our MySQL 5.6 server over to MariaDB 10.3.10 and, for the most part, have not had any problems. We have a couple of databases that have close to 1000 views which are now filling the ...
0
votes
2answers
50 views
Log full of [Note] InnoDB: ft_end() after upgrade to MariaDB 10.3.10
My upgrade path was MariaDB 10.2.18 to MariaDB 10.3.10.
There are no bugs reported on mariadb or mysql bug tracker (at least that I could find).
...
Oct 24 17:45:33 host1 mysqld[12196]: 2018-10-24 ...
1
vote
0answers
90 views
MariaDB 10.3 slave fails to replicate from a MariaDB 10.2 master
We have a 10.2.18 master and 4 slaves with 10.2.18. Because of this bug that I've reported last week (https://jira.mariadb.org/browse/MDEV-17420) we tried to upgrade one of the replicas to 10.3.10 to ...
-1
votes
0answers
18 views
mariadb service won't shutdown when running and the OS time update backwards
When I update the OS datetime backwards while mariadb is running, it causes mariadb to hang when I command it's service to stop.
I've also noticed that this doesn't occur when I set the new OS ...
1
vote
1answer
14 views
How to update MariaDB if the current version is not in default directory?
I will try to update my MariaDB from 5.5.56-MariaDB to 10.3.9-MariaDB. However my current version was configured or located into another directory. How should i do it?
0
votes
1answer
28 views
MariaDB - how to drop partition on master but not on slave
I've read about filtering replication and I only run into information I know already, like you can select only a database or a table to do replication on.
My use case is that I want to have a slim ...
2
votes
1answer
232 views
MySQL Workbench Visual Explain not working with MariaDB 10.3.9
I recently installed MySQL Workbench 8.0.12 and MariaDB 10.3.9. I created my database and want to start fine tuning indexes and views. I can run a query with the EXPLAIN button and get the results in ...
4
votes
2answers
120 views
What are “Invisible Columns” and how are they used?
I saw a new feature Invisible Columns in MariaDB 10.3.x. What are practical use cases for DBA and web developer? When to use this feature?
Columns can be given an INVISIBLE attribute in a CREATE ...
0
votes
0answers
68 views
MariaDB galera cluster with Mroonga in wrapper mode doesn't synch
MariaDB Galera Cluster states that the storage engine needs to be InnoDB.
I am using Mroonga on some tables in wrapper mode {which uses InnoDB under the hood as storage engine}.
The problem I am ...
1
vote
1answer
200 views
MariaDB doesn't set authentication_string during installation
I'm setting up a new server using MariaDB (current stable version of 10.3) and I notice that all of my users - mainly root and debian-sys-maint - do not have an authentication_string after the ...
0
votes
1answer
1k views
Can upgrade from MariaDB 5.5 to MariaDB 10.3 directly?
We have a database running in MariaDB 5.5.60 and we want to upgrade it to the last 10.3.7 version.
However I'm looking at MariaDB knowledge base ( https://mariadb.com/kb/en/library/upgrading/ ) and I'...
0
votes
2answers
155 views
How to filter for consecuting timeline events in pure SQL?
I run a LPR system on a parking lot, and I record every plate along with the camera that recorded it.
I have 2 cameras, camera 1 is on the entry and camera 2 on the exit. So for every reading I ...
1
vote
1answer
378 views
Does MariaDB or MySQL implement the VALUES (expression) table value constructor?
I am just wondering if MariaDB or MySQL implements the <table value constructor> in the SQL Spec. In SQL Server and PostgreSQL this is done with standardized VALUES (expression)?
SELECT *
FROM (...
