cancel
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 - https://pastebin.com/TVu1Ed7c
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 - https://pastebin.com/kbFw0F28
Here is example of mysql request that are very slow - https://pastebin.com/mi656h2h

When i run mysqltuner.pl 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.

 

4 REPLIES 4

Re: Magento 2.2 are very slow

Hi,

 

could you try EXPLAINing the SQL query you put here https://pastebin.com/mi656h2h ?

 

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 - https://pastebin.com/8jbmbb5j

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