Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [magento]

16 questions
2
votes
0 answers

Why would my MySQL replica server experience an sql integrity constraint error after losing connection and attempting to start again?

I have a master-master replication setup between two different servers using MariaDB. One is the primary server (server A) that is connected to my web applications, and the other is a replica that would be used for disaster recovery if the primary…
Timothy Fisher
  • 177
  • 1
  • 7
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
0 answers

MySQL Queries Truncate Causing Connection Spikes

We have a MySQL Master Instance & Read (failover only) on AWS. MySQL 5.6 Aurora running Magento. Performance is great, and better than standard MySQL (we have high traffic site so see the benefits). We suffer some issues with when Magento Indexing…
Mark
  • 21
  • 1
0
votes
1 answer

How many tables will be there in Magento 1.8

I just started using Magento with 1500 products and I saw the DB size is about 150MB and when I looked at the tables, the count is 250 tables. Is it normal? Should I worry about anything? I host this on EC2 micro instance.
Dave
  • 1
  • 1
  • 1
0
votes
1 answer

Need help on SQL Server data compression, hope to compress more on a large table

We have made good progress following our previous question about SQL Server data compression. For one of the tables, we compressed it from 20 GB to 2 GB, so this proves that the best compression ratio can get up to 10 times. Another table's size,…
James
  • 149
  • 1
  • 6
0
votes
1 answer

How to compress data in SQL Server? The data warehouse raw data is times bigger than the MySQL OLTP database for the same tables

For reporting purposes, we have a DWH (data warehouse) doing ETLs (extract-transform-load) to retrieve data from selected tables in a production OLTP (on-line transaction processing) database. The ETL extracts data with incremental manner, so it…
James
  • 149
  • 1
  • 6
0
votes
0 answers

CPU mysql hight value consumed

Sometimes I get issue with connetion to database. I checked and when I open product then mysql CPU is 180 - 330% CPU. Does anyone know why this is happening and what it might be? Magento 2 platform
Sylvester
  • 101
0
votes
2 answers

MySQL high CPU usage under medium load

I'm managing a Magento server with MySQL installed in it. 16GB RAM 8 core vCPU (Digitalocean). We're having a problem with the site becoming a bit sluggish when under medium to heavy load. Under low to none, MySQL uses around 25% to 60% of CPU…
Odin
  • 11
  • 3
0
votes
1 answer

MySQL DB Causing Spike-up on Windows Server CPU

This is a Magento application connected to MySQL Db. When I ran show engine innodb status\GI get a list of TRANSACTIONSand it looks like some of them are pending and others are in a DEADLOCKand it doesn't matter if I kill them, they keep coming…
Jacman
  • 101
  • 2
0
votes
0 answers

Implication in Increasing MySQL maximum keys allowed per table

We have a situation where we encounter a MySQL error ERROR 1069: Too many keys specified. Max 64 keys allowed In our database (using Magento E-commerce) we need to add 76 indexed key columns but we are not allowed to add more than 64 keys, which…
Haijerome
  • 111
  • 5
0
votes
1 answer

why Threads_connected falls down automatically in some cases

How can I monitoring, when Threads_connected increase from which place(files) or when it decrease, because some of cases it dose not fall down automatically in our production server and we are getting to max connection error there, So i need to…
Darshan TecStub
  • 1
  • 1
0
votes
1 answer

Best configuration of my.cnf for make fast Magento navigation

I have a Magento 1.7 version site with 7000 configurable products. Site navigation is slow. From the moment I click on a site link to when the address in the url bar changes several seconds pass. Configuring the file my.cnf I have had improvements.…
Aldo Valente
  • 1
0
votes
1 answer

MySql version and MySql Library version

Does the version of MySql Library have the same impact as the version of MySql server when it comes to other software requirements? Example: I run Magento 1.9.3, which specifies MySQL 5.6 as a minimum requirement. If my web server installation is…
robgt
  • 101
  • 1
0
votes
1 answer

Database convert character_set_server latin1 to utf8

I am writing about a problem on the character encoding that i have on my site with Magento. In practice, the special characters do not take utf8 and gives me the classic non-coded characters: Ã. These are the codes in my…
Gabriel91
  • 101
  • 2
-1
votes
2 answers

1052 Column 'product_id' in order clause is ambiguous,

I am trying to run query in Magento 2 Db and getting the error: Column 'product_id' in order clause is ambiguous, The query is: SELECT `main_table`.* FROM `wishlist_item` AS `main_table` INNER JOIN `cataloginventory_stock_status` AS `stockItem` …
Anees ahmad
  • 1
  • 1
  • 1
1
2