Questions tagged [mariadb-10.4]
The mariadb-10.4 tag has no usage guidance.
25
questions
2
votes
1answer
12 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
82 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
61 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
55 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 ...
0
votes
0answers
47 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
56 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
53 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
27 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
117 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. ...
0
votes
0answers
39 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
23 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
34 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
98 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
122 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
111 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
49 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
24 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
658 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
384 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
2answers
308 views
Unable to create tables with ROW_FORMAT=COMPRESSED
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
496 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
2k 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
39 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 ...