# Mysql server are very slow

**URL:** https://forums.percona.com/t/mysql-server-are-very-slow/6099
**Category:** Other MySQL® Questions
**Created:** [January 3, 2018, 8:44am UTC](https://forums.percona.com/t/mysql-server-are-very-slow/6099 "2018-01-03T08:44:47Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![parrabol](https://avatars.discourse-cdn.com/v4/letter/p/8baadc/32.png) [@parrabol](https://forums.percona.com/u/parrabol)
#### Post date: [January 3, 2018, 8:44am UTC](https://forums.percona.com/t/mysql-server-are-very-slow/6099/1 "2018-01-03T08:44:47Z")

</div>

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 - [URL][https://pastebin.com/TVu1Ed7c[/URL]](https://pastebin.com/TVu1Ed7c%5B/URL%5D)  
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 - [URL][https://pastebin.com/kbFw0F28[/URL]](https://pastebin.com/kbFw0F28%5B/URL%5D)  
Here is example of mysql request that are very slow - [URL][https://pastebin.com/mi656h2h[/URL]](https://pastebin.com/mi656h2h%5B/URL%5D)

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.