Questions tagged [performance]
Denotes questions related to performance on Magento
128
questions with no upvoted or accepted answers
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....
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->...
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)...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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: ...
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 ...
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:
$...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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/...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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-...
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 ...
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 ...
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? ...
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 ...
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\...
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 ...
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 ...
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 ...
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 ...
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 ...
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....
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 ...