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
Redis Server 4.0.2
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.
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.
before we add a products. everything was fine.
here is explain - https://pastebin.com/8jbmbb5j
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.