Showing results for 
Search instead for 
Did you mean: 

Magento 2.2 are very slow

Magento 2.2 are very slow

Hi everybody. Please help me with issue.
My main problem is that mysql are very slow. When i try create products in my CMS, it take mutch time. Example - create product take 4 min, delete product - 12 min.

I use CMS Magento 2.2 CE (community edition). Also there is 145 000 of products. Before we add products all was fine. Create product take about 5 sec, delete product about 5-10 sec.

Here is my system
Ubuntu 14 x64, Linux kernel 3.13, 16 cpu, SSD, 48 GB RAM
Percona MySQL - 5.6 - here is config -
Varnish server 4.1
PHP 7.0.22
Nginx 1.12
Redis Server 4.0.2

I try run some profiling tests of magento and mysql
Here is slow log results -
Here is example of mysql request that are very slow -

When i run it show me that everything is OK.
Also if there is 60 real users on my site i see mysql process takes very highload cpu. As example i have site on same CMS with 100 products and lower server< and it take about 500 users and feels ok.

So help me please with this issue. Thank you.


Tags (1)

Re: Magento 2.2 are very slow



could you try EXPLAINing the SQL query you put here ?


Do this test: what happens if you install a fresh copy of M2+sample data on the same server? Is it fast or slow? If it is as slow as your current site than something is wrong with MySQL or the server configuration. If it is fast than something is wrong with your current shop.



Re: Magento 2.2 are very slow

before we add a products. everything was fine.


here is explain -

Re: Magento 2.2 are very slow

Did you try memcached Robot Happy ?

Re: Magento 2.2 are very slow

Check if any of custom modules / community modules are having observers for " Product Save After " which are doing some operations / foreach loop on product collection, that might make it sluggish.

If my answer helped you, please give me "Kudos" Smiley Happy