Skip to main content

Questions tagged [mariadb]

MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.

Filter by
Sorted by
Tagged with
0 votes
0 answers
11 views

Magento 2 - Configuring db in Docker context

Looking for build a magento docker container. Is using mariadb:10.6 image for the database, but maybe lacking some property. Follows the service frm docker-compose.yaml created with ece-tools: db: ...
zanoth's user avatar
  • 1
0 votes
0 answers
38 views

My magento 2 store is running this process make cpu is very high

I have and issuse with my magento 2 store the server has running this query and make the cpu to high,about 5-800% cpu ,
Bbaodenx3's user avatar
0 votes
1 answer
197 views

Is Magento 2.4.5-p5 compatible with MariaDB 10.6.16?

Is Magento 2.4.5-p5 compatible with MariaDB 10.6.16? I am runing Magento 2.4.5-p5 on a Centos 7 Server running MariaDB 10.4. We are preparing for a move to AlmaLinux OS 8. I am trying to upgrade some ...
richardwendrock's user avatar
0 votes
1 answer
290 views

How to optimize MariaDB for best Magento 2 performance and Increase indexing speed?

I working on Magento2.4.6 with 7 stores and more than 90 000 products. We used MariaDB as Database with 32GB of RAM. What is the best DB configurations (parameters) recommanded to increase the ...
maldini3's user avatar
0 votes
1 answer
514 views

Magento CE breaks with MariaDB 10.6.13 galera cluster

I run a Magento CE store with 3 DB servers (galera cluster). When upgrading Magento from 2.3.4 to Magento 2.4.6, also upgraded MariaDB from 10.4 to 10.6, and PHP from 7.4 to 8.1, to match Magento ...
MAX's user avatar
  • 1
0 votes
1 answer
843 views

Slow saving products after upgrade to MariaDB 10.4 (Magento 2.4.5-P1 and PHP 8.1)

Since we upgraded Magento to 2.4.5-P1 and moved to MariaDB 10.4 (now 10.4.28) and PHP 8.1, we are facing really slow saving of products in admin. Everything else is fast, like the frontend, and ...
Aknot's user avatar
  • 288
2 votes
4 answers
1k views

Performance issues after upgrade to Adobe Commerce 2.4.6

My Adobe Commerce was running fine, but after the upgrade, I can see via New Relic that it takes more time to process queries. I tried to upgrade my MariaDB to versions 10.4 and 10.6. Is there any ...
Rafael Corrêa Gomes's user avatar
0 votes
1 answer
587 views

M2 | CREAT USER statement giver syntax error when "WITH mysql_native_password" is used it it

I am installing fresh Magento, after installing MariaDB serve, I am creating database user as: mysql> CREATE USER 'magento'@'localhost' IDENTIFIED WITH mysql_native_password BY 'm0d1fyth15'; The ...
Ajwad Syed's user avatar
  • 1,591
1 vote
1 answer
704 views

Product query is suddenly really slow, because wrong index is being selected in MySql

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 ...
V.V's user avatar
  • 11
0 votes
1 answer
106 views

Database loading Product Collection slow (Minutes)

I've got some third party code here that loads a larger product collection. It takes around 9 minutes to load on decent hardware. We have some 150000 SKU in the database. Collection: SQL is: SELECT ...
Alexander Gran's user avatar
1 vote
1 answer
2k views

Magento 2: What is causing slow reindexing of catalogsearch_fulltext with large catalog?

We have 400k line items, so I expect things to take a little while, but reindexing has started taking days, and often errors out in the middle. Checking in the database processlist, it looks to be ...
Art Siv's user avatar
  • 89
0 votes
2 answers
457 views

elasticsearch and mariadb services stop sometimes. They get up automatically in a few minutes or I do it manually but I need a permanent solution

I don't know if it's a problem with my magento(magento 2.4.1) or with my server I found this errors in log file: 1-main.CRITICAL: Lo sentimos, algo salió mal. Encontrarás más información en el ...
Paty Gallardo's user avatar
0 votes
0 answers
304 views

MariaDB crashing every few days

I'm using Magento2 with MariaDB 10.3.27 on Debian 10.8 and i'm experiencing MariaDB crash every few days. I have no idea what can cause those unexpected crashes. I'm sending my config and crash logs. ...
Dariusz Bilewicz's user avatar
0 votes
0 answers
160 views

Connecting Maria db 10.2 to magento 2.3.5

I have website to connected database I am using RDS MARIAB 10.2 while running upgrade command faced : SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is ...
anonymous's user avatar
0 votes
1 answer
1k views

MariaDB or MySQL Magento 2.4 "magento community edition open source"

We are in the process of planning for an eCommerce project with Magento 2.4 "magento community edition open source" for building up the e-commerce project. But we are really confused with ...
Noury Micron's user avatar
1 vote
1 answer
1k views

Magento 2.4.0 Issues using docker with MariaDB

Has anyone else encountered this error? I am using docker-compose.yml file with mariadb:10 image. Schema creation/updates: Current version of RDBMS is not supported. Used Version: 10.5.5-MariaDB-1:10....
user59268's user avatar
  • 103
5 votes
5 answers
11k views

Compatible MariDB version for Magento 2.4

We are upgrading from magento 2.3 to 2.4. Would like to know the compatible MariaDB version to be used for the upgraded magento version. As per official magento site, it mentions MySQL8.0 for on ...
NKumar's user avatar
  • 151
1 vote
3 answers
1k views

Magento 2.3.x Admin Panel keeps loading

I have installed Magento 2.3.5-p1 and also tried 2.3.4-p2 on Centos 7, with Nginx & PHP-FPM, maria DB with following commands. 1. /var/www/magento < owner by MAGENTO:NGINX user (I have created ...
nix's user avatar
  • 127
1 vote
3 answers
266 views

Installation Problem Magento 2.3.5p1 on Centos 7

I have been trying to install Magento on Centos 7 with Nginx and Maria Db for the past 2-3 days now but each time I got errors. I have tried several ways and changed Nginx configuration file and tried ...
nix's user avatar
  • 127
1 vote
1 answer
152 views

What is the most popular database choice for Magento 2?

this question sounds more like a poll because I'm just curious as to what database is the most commonly used for Magento2. I currently use MariaDB 10 from following an installation tutorial online, ...
VWijaya23's user avatar
0 votes
1 answer
50 views

Error when adding a user

When I try to create a user, I get this error: "Rolled back transaction has not been completed correctly." In system log I get: main.INFO: Broken reference: the 'notification.messages' tries to ...
Alain Picard's user avatar
1 vote
1 answer
900 views

how to switch between mariadb and mysql

my magento2 is reading mariadb server and database is connected to that, I am trying o use mysql instead but I had no luck, it does not recognize the database at all although I have added the ...
Nickool's user avatar
  • 1,069
1 vote
0 answers
844 views

my.cnf MySQL optimize for 2G RAM Magento 1.9

I'm find my.cnf optimized for 2G RAM. It's good configuration for 2G RAM and magento 1.9 and 5.5.56-MariaDB? Server VPS CentOS 7.5 on SSD. In this case i have about 30 domains in 1 multidomain ...
Boulatov's user avatar
1 vote
0 answers
136 views

Are high AUTO_INCREMENT values in cron_schedule values are problem?

I am debugging a checkout problem, where the shipping address is not saved. This can be reproduced only some times and on production, under unclear circumstances. Checking the logs I found ...
Alex's user avatar
  • 13.9k
1 vote
0 answers
42 views

import csv in mariadb

We import csv files in mariadb, 1 csv takes about 30 minutes. For daily sync of csv files thats about 3-4 hours and judge that as too much. Magento 2.3, Update on save is activated + Mysql tuner ...
Kurtz's user avatar
  • 41
1 vote
0 answers
185 views

Magento upgrade from 2.2.3 to 2.3.0 just blew Cheeze balls .. help

just finshed updating composer update, bin/magento setup:upgrade Cache cleared successfully File system cleanup: /home/pricesplitters/public_html/generated/code/Composer /home/pricesplitters/...
william Jensen's user avatar
2 votes
0 answers
212 views

NGINX 404 error despite Magento Installation complete on CentOS 7 terminal

I am trying to load the /admin part of my development build of the website. I am unsure what could be the cause of this. Using this command: (Some of these details are intentionally not in line with ...
Joseph Candava's user avatar
1 vote
1 answer
891 views

<magento_instance>/graphql not working on windows but works on linux machine

Officially Magento2.3 supports only these operating systems Linux distributions, such as RedHat Enterprise Linux (RHEL), CentOS, Ubuntu, Debian, and similar. This is my configuration Installed ...
Syed Saleem's user avatar