Questions tagged [mariadb-10.4]
The mariadb-10.4 tag has no usage guidance.
38
questions
1
vote
1answer
27 views
Can I improve this query by adding indexes or tuning mariadb config?
We're having a problem with a query that keeps executing very very slowly
SELECT `e`.*,
IF(at_news_from_date.value_id > 0, at_news_from_date.value, at_news_from_date_default.value) AS `...
0
votes
1answer
29 views
Suddenly, started getting "ERROR 2026 (HY000): Unknown SSL error"
MariaDB instance has been running well for ages, and suddenly, starting about 30 minutes ago, my apps get this error trying to connect:
# mysql
ERROR 2026 (HY000): Unknown SSL error
My certs have ...
0
votes
1answer
26 views
Identify duplicates data in combined columns
In a table there is Lang1 (First Language ID) and Lang2 (Second Language ID) that is repeating logically and I would like to keep one record and delete the other. I have encircled the entries in ...
0
votes
0answers
25 views
select which algorithm a view is using
I have a view in a MariaDB 10.4.13 database that feeds into a database documentation process and gathers data on tables and views used in the database.
Amongst other fields it selects which algorithm ...
0
votes
0answers
12 views
Correct way to setup wsrep_notify in MariaDB
I have been running 5 cluster nodes in MariaDB 10.4/galera setup for quite sometime without any wsrep_notify_cmd configuration.
To test basic functionality, I added the notify script script and ...
1
vote
1answer
25 views
query left join error
I have two queries that get me a correct result, but when I try to join they give me an incorrect result.
I want to make something like:
SELECT directoscount.parte,
SUM(directoscount....
0
votes
0answers
44 views
MariaDb 10.4 not starting in a freebsd jail after update
ran a pkg update and mariadb seems to be broken.
Cant find out what the reason might be after 2h our googling and digging.
Help to figure out would be highly appreciated. Thanks in advance.
The ...
0
votes
1answer
16 views
List sorted Posts on Group and children Groups efficiently
Say I have a system that has Groups and Posts on those Groups.
A Group can have multiple "child Groups"
Group 1 > Group 2 > Group 3
Group 1 > Group 2 > Group 4
Group 1 > ...
0
votes
0answers
14 views
Checksum difference between table in MariaDb 10.4 and Mysql 8
We have a script that transfers databases between clusters. To make sure the data is still valid, we run a checksum on some of the tables. If those are ok, we mark transfer succesful.
The problem is ...
0
votes
1answer
27 views
Select data from a table to insert/update another similar table
I have two tables (in two databases):
create table catalog_product_entity_text
(
value_id int auto_increment comment 'Value ID'
primary key,
attribute_id smallint unsigned default 0 ...
0
votes
1answer
459 views
an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
I am restore a MariaDB 10.4.17 Database to Amazon aurora MySQL 5.6
while creating a table it is showing me this error
ERROR 1064 (42000) at line 25 in file: 'name.sql': You have an error in your SQL ...
0
votes
1answer
56 views
mysql.gtid_executed table is empty
I want to keep track of GTIDs and the corresponding mysqlbin log somewhere. I see this mysql.gtid_executed table, however on my mariadb DB, there are no rows in this table. Any idea how this gets ...
0
votes
1answer
212 views
JSON in MySQL : get data from an object within a range of keys
What I have:
A mysql table, say table1
table1 contains two columns viz. id and data
id is int but the twist is data is JSON type and its keys are comparable
the table1 contains only one row (for the ...
2
votes
1answer
40 views
what happens If I remove mysql-bin.index file?
Because of the file storage full, we are removing mysql bin log files.
Accidentally, we removed mysql-bin.index file.
What happens if I remove mysql-bin.index file?
These below are my DBMS info. Thank ...
1
vote
1answer
267 views
How to model dependent categories (parent-child-relation)?
Idea / Goal
I have two tables: Article (represents a Product) and Category. The relation is like this: An Article can be assigned to only one Category but a Category may have at least one Articles, ...
0
votes
2answers
64 views
How should I model my database - cannot decide on multiple options
I apologize if this might be a rather beginner-level-question.
For my database design, I have worked out multiple options but cannot decide on which one I should implement. I am using 10.4.17-MariaDB.
...
0
votes
1answer
306 views
mariadb: replication master and slave have equal MySQL server ids
I'm a novice mariadb user trying to set up a master with multiple slaves using mariadb-10.4.17 on fedora33.
I believe at one point I inadvertently ran the "change master" command on the ...
1
vote
0answers
118 views
Table 'my_table' doesn't exist in engine
If I try
select * from my_table
I get:
"Table 'my_table' doesn't exist in engine"
but
show tables
contains this table in the list.
I tried:
mysqlcheck -u root -p --check --all-databases
...
0
votes
1answer
64 views
MariaDB (RDS) going temporarily offline (with memory drop)
We have an issue with a database of ours on RDS running MariaDB 10.4.8 on a t3-large instance type.
For the past week or so, it's been sporadically inaccessible with no errors I can find. During the ...
1
vote
1answer
200 views
Can I upgrade MariaDB replication infrastructure gradually?
I have 2 masters and 1 slave (replicating form both masters).
M1- MariaDB 10.4.11
M2- MariaDB 10.4.16
S1- MariaDB 10.4.12
I want to upgrade this LIVE system to 10.5 with possibly 0 downtime. The idea ...
0
votes
1answer
34 views
Covering Index Not Being Used Effectively
I have a unique composite index on three fields (hash, is_customer, user_id) in a table a.
And queries that go like this:
select `a`.`id`, `hash`, `is_customer`, `user_id`
from `a`
where `hash` = ...
1
vote
0answers
229 views
Bad write log efficiency, strange broken relationships
I recently switched galera synchronization method from rsync to mariabackup which greatly reduced CPU usage on our DB servers and also increased the innodb_log_file_size to 2G from about 600M or so. ...
1
vote
0answers
88 views
Unable to grant privileges with admin account
I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users.
Creating the databases and users works ...
1
vote
2answers
27 views
Problem with complex queries after migrating from MySQL 5.1 to MariaDB 10.4
I completed a migration from MySQL 5.1 master-slave system to a MariaDB 10.4 Galera Cluster. All the databases where copied over since they were on InnoDB per-file and they are working fine. However ...
0
votes
1answer
80 views
MariaDB Out-of-Order Parallel Replication and OPTIMIZE TABLE
I am using MariaDB 10.4 and have question about Out-of-Order parallel replication.
I am optimizing databases(about 400GB of data) on Master every week. As optimizing DB on master do not have any ...
0
votes
1answer
227 views
Mariadb always writes tmp disk to a file
I'm trying to understand why Mariadb (v10.4.12) is writing most of the temp tables to disk.
Created_tmp_disk_tables 196,8k
Created_tmp_tables 367.8k
There's 188G of RAM in the system with ~50% of it ...
0
votes
1answer
257 views
UTF8mb4 MariaDB 10.4 - Max key length is 767 bytes error
I am running MariaDB 10.4.
I am trying to setup symmetricDS for database syncing. Some of the tables it creates have fields that are are VARCHAR(255). I know UTF8mb4 can only support up to VARCHAR(...
0
votes
1answer
271 views
Why doesn't MariaDB server recognise Server Audit settings in config file?
I'm trying to implement the Server Audit plugin that is built-in with MariaDB 10.4. I've added the settings to the my.ini config file, running on Windows 10.
[server]
...
#Audit Settings
...
0
votes
3answers
51 views
Join without indexing the entire table
I have a query that pulls the 3 most recently commented posts on our forum. The issue is is that COUNT(forum_posts.id) as posts, is indexing the entire database of 600,000 posts and the query takes ...
0
votes
2answers
26 views
slow UPDATE of rows by COUNTing from another table
I try to update a table by counting rows from another table as
UPDATE t1 SET c1 = (
SELECT COUNT(*) FROM t2 WHERE t2.id=t1.id GROUP BY id
)
strangely, this query stuck at Sending data state ...
0
votes
1answer
43 views
How to add/update data from slave server to master server in MariaDB?
I am experimenting on whether I can tweak the functionality of master-slave replication. I can write data in my master server which gets updated in the slave server but it cannot happen the other way. ...
1
vote
1answer
1k views
SQL query with "INTO OUTFILE" does not work on MariaDB 10.4 but does on 10.0
I have an SQL query that executes perfectly on MariaDB 10.0.35 but fails with a syntax error on MariaDB 10.4.12. I attempted to contact them, but they told me to check forums and compare the ...
0
votes
1answer
26 views
SQL 2 Columns of Different Types in Same Table - Working With 'Uknown' Amount
I'm very new to SQL and I've been searching for an answer for a while now, can't seem to find it.
I have 1 table of CustOrders which has 3 columns.
Table CustOrders
Name (varchar)
Number_Orders (...
1
vote
1answer
567 views
MariaDB Optimization with Mysql Tuner
I've read so many articles regarding MariaDB optimization for low memory servers. There are a lot of guides about that but people are always sharing their own configuration. That makes it difficult to ...
0
votes
3answers
8k views
Unable to create tables with ROW_FORMAT=COMPRESSED [closed]
I'm attempting to install Nextcloud on MariaDB 10.4.11-MariaDB-1:10.4.11+maria~bionic in a docker container (mariadb:latest sha256:2f11cf2ec18988aec8346a5cf528d69ac3f0f4fc02af79ba28f4fd47b7778d6f).
...
0
votes
0answers
769 views
mariaDB Incorrect string value
I'm a newbie. I have stumbled upon this warning (code 1366) when trying to insert a string with an accent like é in my tables.
For instance if I type this in the prompt:
create database db character ...
1
vote
2answers
3k views
10.4.10-MariaDB Column 'authentication_string' is not updatable
So I just installed mariadb in a new server as always, but it seems none of my commands I used to set root password and allow remote root logins work anymore and googling isn't helping me much.
mysql ...
-1
votes
1answer
41 views
How to get all previous week record by using creating a imaginary column
I have problem an now this is more than 2days and I can't find any answer. can you help me out guys. to solve my problem.
I use Server version: 10.4.6-MariaDB
Question: How to get the all records ...
