Questions tagged [performance]

Denotes questions related to performance on Magento

128 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
12 votes
3 answers
2k views

SQL query kills entire server

I caught the following query via mysql's SHOW FULL PROCESSLIST; which was eating the whole CPU / RAM on my server (32GB Ram, i7 hexacore CPU) rendering the entire server unusable for more than 3 hours....
koseduhemak's user avatar
12 votes
1 answer
2k views

Product List Attribute Filter Query

I have added one filter in Method _getProductCollection() of the class Mage_Catalog_Block_Product_List as follows. protected function _getProductCollection() { ... $this->...
Magento Learner's user avatar
5 votes
0 answers
310 views

Add to cart not working in Magento 2.2.5 performance testing script "benchmark_2015.jmx" for customer account

In Magento2 - I am using Magento benchmark script "benchmark_2015.jmx" for a default Magento(v2.2.5) installation. In Customer Checkout thread group >> "Add to cart" request(http://prntscr.com/mty00o)...
Mukesh Suthar's user avatar
4 votes
1 answer
135 views

How to choose right caching technique for Magento2 and how to configure them properly

We are working on a new store and want the site to have cached. I think there are a lot of caching techniques but I would like to which are to be chosen. Ex: Varnish, OPcache, Memcache, Redis. ...
Bharath's user avatar
  • 498
4 votes
0 answers
529 views

Magento 2 - Page Speed Insights / Lighthouse Audits Low Scores

I noticed recently the Google page speed insights has improved somewhat, shows a lot more information however is harsh especially it seems for Magento 2 (I can get 98 so far from other non Magento 2 ...
harri's user avatar
  • 5,465
4 votes
1 answer
867 views

slow INSERT query in sales_flat_order_grid

We see in newrelic some peaks if orders are inserted into sales_flat_order_grid. I tried to figure out why, but couldn't find the reason. This peaks appear ~ 1 of 100 orders. First of all I thought ...
Pawel's user avatar
  • 1,096
3 votes
2 answers
2k views

Why is the loading of scripts via RequireJS incredibly slow when they are not cached?

First of all, this is not a question about general Magento 2 performance. I'm already aware of how to speed up Magento 2, in general. My question is specifically about RequireJS and the assets served ...
WackGet's user avatar
  • 1,188
3 votes
0 answers
86 views

EAV Model Product - Loading too heavy

Our website's using Magento 2 platform. Number of product and number of product's attributes keep growing faster.It leads to heavy loading when getting product's information(using EAV Model).In ...
moonlightkg92's user avatar
3 votes
0 answers
219 views

Why Mage_CatalogIndex_Model_Aggregation is not caching layered navigation filters?

A question for an expert. Make sure you read the preamble - the question is at the bottom. In app/code/core/Mage/Catalog/Model/Layer/Filter/Attribute.php I noticed a functionality to cache ...
Konstantin Gerasimov's user avatar
3 votes
1 answer
892 views

RequireJS components sometimes not loading

We are launching a Magento 2.1.3 site, and finding that the site will sometimes load all of its Javascript components and dependencies properly, but sometimes fails to load, in which case a slider is ...
Gordon Krauthamer's user avatar
3 votes
0 answers
704 views

Magento 2: Setting cron job for changing order status, can affect on performance?

I want to set cron job for order confirm. Below controller code Confirm.php used for confirm order from my fronted custom module. This will Set order status confirm. This is working fine. <?php ...
Dev's user avatar
  • 369
3 votes
0 answers
458 views

Magento2 performance testing error

When I run the first time: magento setup:perf:generate-fixtures /var/www/setup/performance-toolkit/profiles/ce/small.xml I got this error: Generating simple products... Error in data structure: ...
Claudiu Creanga's user avatar
2 votes
2 answers
50 views

magento 2 : is it impact on isting page performance for $_product->getResource()->getAttribute('custom_attribute_code')?

I have a custom attribute which has 15 text values. I am using $_product->getResource()->getAttribute($attributecode)->getFrontend()->getValue($_product); . In catalog page I have used ...
Niraj Patel's user avatar
2 votes
1 answer
215 views

Filter by attribute is slow for customer collection using addAttributeToFilter() function

I have created a custom attribute called username for Customer which is searchable in admin grid. But whenever I search by username for SSO it takes much time (2-3 sec). Below are the code: $...
Vaibhav V. Joshi's user avatar
2 votes
0 answers
251 views

\StoreResolverInterface->getCurrentStoreId() taking huge amount of time to resolve current store ID in StoreManager.php

Running Magento 2.3.4 and encountering an issue with Magento core code. For the past couple of days I've been battling terrible performance on my site, especially when serving uncached content via ...
WackGet's user avatar
  • 1,188
2 votes
1 answer
214 views

Page loads take around 10 minutes due to requirejs

I have a local site running Magento 2 Enterprise set up on a Hyper-V virtual machine running Ubuntu 18.04 and Nginx. I've got 4 CPUs and plenty of RAM assigned to the virtual machine. This same site ...
Ben Rubin's user avatar
  • 549
2 votes
1 answer
5k views

How do i remove unused css from magento 2 homepage?

I am not getting good performance when i audit my website with chroome lighthouse. I am getting few errors like - Remove unused CSS - Ensure Text Remain Visible during web front load - Minimize main ...
Ashar Riaz's user avatar
  • 1,035
2 votes
0 answers
342 views

Magneto 2: How to configure a rest api only server for best performance?

I know magento have some recommendations for the best performance. And I found several articles related. But nothing specific for servers that provide access only by the Rest API. Because everyone ...
Douglas Ianitsky's user avatar
2 votes
2 answers
81 views

Magento performance went dow by 50% after upgrading from 2.1 to 2.2

I've upgraded Magento 2.1.11 to Magento 2.2.6 and after the upgrade the CPU utilization and CPU load duplicated. Is was a simple and straight forward upgrade. No server changes were made regarding ...
Filipe Sá's user avatar
2 votes
1 answer
249 views

SQLSTATE[HY000] [2006] MySQL server has gone away - hosting company says to OPTIMIZE Magento :-(

Magento 1.9.1 Porto theme VPS server: RAM: 6 GB RAM Storage: 150 GB SSD Bandwidth: 6TB 8 cores Our Hosting company is Hostforweb.com They did this migration from a datacenter in Chicago to New York ...
Allysin's user avatar
  • 250
2 votes
0 answers
30 views

Advice on most performant approach to get variables once per session

I need to pass deviceType and userState(IL, IN, IA, KS, etc) variables to GTM for marketing purporses and wondering what’s the best way to do it. To calculate deviceType I will use mobiledetect php ...
MployBy's user avatar
  • 125
2 votes
3 answers
4k views

Why Magento is using high CPU in AWS?

I'm having a problem that is occurring after the volume of concurrent users on my site has increased. I'm currently with almost 600 concurrent users and the server is using 100% CPU. To alleviate ...
Junior Maia's user avatar
2 votes
1 answer
848 views

Magento 2 - 11k Products on 1 configurable product too much?

A few specs: Using magento 2.1 PHP 7.0.9 VPS has 48GB RAM 8x Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz I am setting up an online print shop, and have created a CSV of all of our 100k+ variations we ...
user42020's user avatar
2 votes
0 answers
942 views

Magento 2.1 and PHP 7.0.8 work extremely slow

I had Magento 2.0.4 instance running on vagrant machine: CentOS 6.5 PHP 7.0.1 MySQL 5.6.31 I've upgraded to 2.1 with composer but then when I tried to run php bin/magento setup:upgrade I get ...
Miroslav Petroff's user avatar
2 votes
0 answers
636 views

Product brand (attribute, category or both)?

I am fairly new to Magento module development, and I am dealing with catalog/product pages at the moment. I have seen our clients using different approaches when dealing with storing product brands. ...
Emke's user avatar
  • 133
2 votes
0 answers
367 views

Redis default configuration and utilization

We did install Redis server 3.0.7 which has made our Magento store 1.9.x a bit better than before, but I just need to ask that all settings which comes out of the box in Redis is fine? or do I need to ...
T_Flows's user avatar
  • 137
2 votes
0 answers
355 views

Slow performance of: Mage_Eav_Model_Entity_Abstract::getSortedAttributes

Hi we are seeing some slow performance in "Mage_Eav_Model_Entity_Abstract::getSortedAttributes" I was reading this (from 2 years ago and Mage 1.6). Would this still apply? http://blog.nexcess.net/...
snh_nl's user avatar
  • 5,442
1 vote
0 answers
27 views

Magento2 Products List Page taking much time too load products

I have setup Magento 2.4.6-p2 Version in my local system I enabled the profiler to see the loading time of the site and I found the below file is taking too much time if I visit the list page the ...
Sanjay Shiyal's user avatar
1 vote
2 answers
262 views

how can we increase performance of bulk product save in magento 2 api

when we test performance of bulk product create api request using Apache 2 Benchmark, it takes to much time for return response of request. I tested bulk api requests with 200 total number of requests ...
Harsh Patel's user avatar
1 vote
3 answers
531 views

Adobe Magento Cloud how to add robots.txt

What are the best ways to add the robots.txt file to adobe magento cloud environment
Mohamed Abbas's user avatar
1 vote
0 answers
84 views

Is there a proper way in magento to use stored procedure?

Is it possible for replacing the default product collection from model/resourcemodel with some stored procedure having some dynamic query which use different product ids as parameter based on current ...
Vishal Rathod's user avatar
1 vote
1 answer
367 views

CPU 100% most of the time - maybe a cron problem?

e are running shop on Magento 2.4.3-p1 with 50 000 SKUS, about 800 categories and 5 language mutations. About 65000 users and 80 000 sessions monthly. We are using cloudways server: 32GB RAM 8 core ...
Milan Ďaďo's user avatar
1 vote
1 answer
246 views

Magento 2: performance issue with Magento\Framework\View\TemplateEngine\Php::render

I have enabled the new relic log to check the performance of the Magento 2 website. On home page I am rendering 5 blocks with 5 template files. In new relic logs, it shows homepage takes time to ...
Niraj Patel's user avatar
1 vote
2 answers
263 views

Pagespeed performance in Magento 2.3.6

I am trying to improve the performance of magento complying with the requirements of google page speed and I have come across this, I don't know if it is a bug, if I am missing something or what it is ...
Tomás Hurtado's user avatar
1 vote
0 answers
64 views

Magento 2 Admin Console - Performance Issues

For one of our big projects, our client is using the Magento backend Admin Console for their Project Managers to create orders/customers etc. Our Customer has time and again reported that the ...
Seema Nair's user avatar
1 vote
0 answers
248 views

How to load category products in batches? Enable "Allow All Products per Page" without compromising performance

TLTR: How to load category products in batches? I want to show ALL products for a category and remove the pagination. However, that poses a huge performance concern that I need to address. Let's ...
Greg's user avatar
  • 2,929
1 vote
0 answers
8 views

Magento 1: change setting Display out of stock products to NO & effect on performance of indexers and db

Question: how much effect does disabling the setting Display out of stock products to NO in Stock options have? Does it improve indexer speed? Does it improve layered navigation building? Does it ...
snh_nl's user avatar
  • 5,442
1 vote
0 answers
84 views

Overriding core user data files for Magepack

We are working on getting Magepack installed on our dev environment. One of the shims we had to fix was in the "customer-data.js". It works when we edit the core file(vendor/magento/module-...
Stech's user avatar
  • 89
1 vote
0 answers
438 views

SearchCriteria vs Collection - Query Performance Difference

I am trying to refactor get category data method. Initially, it was written with Collection filter. Later I refactored with the search builder interface. When I tried to compare the querying time, I ...
blakcaps's user avatar
  • 1,965
1 vote
0 answers
85 views

Load times for files in pub/static/ are extremely variable and often painfully slow

On Magento 2.3.3 I'm seeing extremely variable load times for files served from Magento's pub/static directory. This happens in both developer and production modes, and I can't understand what's ...
WackGet's user avatar
  • 1,188
1 vote
0 answers
63 views

How can we redirect Admin Catalog Search to use Elasticsearch?

We have over 2M products in our catalog and growing. This has made the Admin Catalog Search completely non-functional (it spins until it times out). How can we update this to also use elasticsearch? ...
user2886718's user avatar
1 vote
0 answers
61 views

Magento2.3: How to put a loader?

My website is taking too much time to load. When the site is loading, there are chances that the customer to click on the things which is not active yet. So I want to put a loader before the site is ...
Mohammad's user avatar
1 vote
1 answer
191 views

getIdentities spends a lot of time

We have very slow product detail pages. In a blackfire trace I see, that a lot of time is spent in getIdentities. Did anybody see this before? If I return []; in \Magento\Catalog\Block\Product\...
Alex's user avatar
  • 13.8k
1 vote
0 answers
250 views

Magento Commerce Cloud : Tool for real time monitoring of sql queries and processes

I need to monitor the number of SQL queries and processes and their corresponding CPU and swap usages in real-time just like the monitoring tool provided with PHPMyAdmin. I need something similar for ...
Vivek Kumar's user avatar
  • 5,105
1 vote
0 answers
340 views

htaccess for brotli does not work

I want to add the following code to my htaccess but it does not work. # ---------------------------------------------------------------------- # | Brotli pre-compressed content ...
user avatar
1 vote
1 answer
112 views

Magento 2 optimisation : SQL Seem's ok but its slow

I have a performance issue with my magento 2 store. I am using varnish, wish I believe works fine. Each not cached page take ~~ 3.5 sec up to 5 sec. (category page, home, product) Here is my ...
David's user avatar
  • 90
1 vote
0 answers
98 views

Magento 2 - CMS Specific page_layout XML and Dedicated page_layouts in general?

I'm looking for some BEST PRACTICES insight into using page_layout.xml. Is it a good idea to try and decouple the non-shared resources on Product Pages, Category Pages and CMS Pages? If so, what's the ...
JustinP's user avatar
  • 579
1 vote
0 answers
172 views

Magento 2.2 - Want to implement blackfire for community edition

I have heard about blackfire php profiler and automated performance tool that can be used in three environments. If i wanted to implement in Magento 2.2 based website using nginx server then is it ...
Softec's user avatar
  • 2,065
1 vote
0 answers
63 views

Redirection Error

We built a website with Magento 2x version. We are monitoring our web server performance using Pingdom. Today, we got an alert message from Pingdom and it says the server is down for around 20 minutes....
Siva's user avatar
  • 1,120
1 vote
0 answers
16 views

How to check if an external process may be causing slowness while going through placing an order?

Magento 1.9.1 Porto theme We had perfomance problems with the hosting company. They migrated us to their best VPS machine/node and now things seem to run rather fast except for when going through the ...
Allysin's user avatar
  • 250