Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mariadb-10.4]

51 questions
5
votes
1 answer

MariaDB 10.4. No traffic yet high CPU usage

I have a problem with which i fail to win. Have new server set up with Debian 10 (64) and MariaDB 10.4. There's no traffic on this server yet. So no slow queries or queries in total however, MariaDB takes 300% CPU already. No matter what I do and…
ensim
  • 81
  • 5
4
votes
1 answer

MariaDB Aborted connection events

A windows server (2022) has MariaDB 10.4 running on it. In the Event Viewer for Windows logs > Application there are two events that happen every minute: Aborted connection ### to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This…
td48260
  • 65
  • 2
  • 7
3
votes
1 answer

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 changelogs from 10.0 to 10.4. I don't really have the time…
Kevin Nathan
  • 33
  • 1
  • 4
2
votes
1 answer

MySql suddenly started to choose different index for query, which causes it to be slow

Database is from Magento 2's site. Issue suddenly started to occur on our live site, dev site has the same database, but just with older data and same query is running completely fine there. I've also tried dumping those three tables from dev and…
V.V
  • 21
  • 2
2
votes
1 answer

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 you. MariaDB 10.4 Single Instance engine: InnoDB…
Bohyun
  • 55
  • 1
  • 5
2
votes
3 answers

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). First thing the installer does is attempt to create…
Tsaukpaetra
  • 207
  • 1
  • 4
  • 10
2
votes
2 answers

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 -u root -e "GRANT ALL PRIVILEGES ON *.* TO…
Freedo
  • 206
  • 2
  • 10
1
vote
0 answers

Mariadb large live database dump/restore fails when using recommended options

I have a 58Gb database that is live, using InnoDB engine and I want to dump restore it to a development machine for test purposes. I'm using mariadb 10.4 client and servers on Debian 11 Buster. I've read in the mysql and mariadb manuals that I…
Eamonn Kenny
  • 111
  • 4
1
vote
0 answers

MySQL Checksum differs but cannot find difference in table

I have two tables which are expected to be the same CHECKSUM TABLE robot, tbd_robot #Doesn't match All the column types (storage format) are the same, the engine and collation are also the same. The table DDLs are identical. I tried running the…
Wistar
  • 111
  • 5
1
vote
2 answers

MariaDB replication lagging up to a dozen times a day for no obvious reasons

We first set up MariaDB replication using less powerful servers but considering our increased database load we had to rent more powerful servers and that's when the troubles began. Right now the replication between the master and slave occasionally…
Artem S. Tashkinov
  • 111
  • 1
  • 5
1
vote
1 answer

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 `news_from_date`, IF(at_news_to_date.value_id > 0,…
gabtzi
  • 181
  • 7
1
vote
1 answer

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.cantidad), lx02.material, …
cesgdav
  • 13
  • 3
1
vote
1 answer

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, therefore, 1:n (n >= 1). Now, I want to build a…
F. Müller
  • 115
  • 7
1
vote
0 answers

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 but also get Table 'my_table' doesn't exist in…
harp1814
  • 111
  • 1
  • 3
1
vote
2 answers

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 is this: upgrade slave S1 (this is used mainly…
michnovka
  • 145
  • 8
1
2 3 4