Questions tagged [mariadb-10.4]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...