Questions tagged [magento]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

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 ...
0
votes
0answers
60 views

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 ...
0
votes
1answer
49 views

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 ...
2
votes
0answers
42 views

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)...
0
votes
1answer
587 views

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. ...
0
votes
1answer
23 views

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 ...
0
votes
1answer
823 views

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: Ã. ...
0
votes
1answer
3k views

How many tables will be there in Magento 1.8 [closed]

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 ...