B
B
BoneFletcher2015-11-17 14:58:37
MySQL
BoneFletcher, 2015-11-17 14:58:37

What can cause INSERT and UPDATE queries to hang in MySql on VPS hosting?

Hosting digitalocean.com
Tariff 2 Core/SSD
Virtualization KVM
Ubuntu 14.04
MySql 5.5.46
There is practically no load on the base, disk and CPU on the server. Normal requests are completed in about 5ms. But from time to time INSERT and UPDATE queries hang up to 5 seconds. Queries are very simple, the problem is observed on all tables. They hang for periods, for example, from 8:00 to 8:20 they hang periodically, then everything is fine again.
With what it can be connected? If with hosting, then what are the parameters to look for VPS hosting in order to avoid these problems? Because query execution speed is very critical.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Rikcon, 2015-11-17
@Rikcon

You monitor the load of RAM.
It looks like something is falling into the swap.

V
Vlad Zhivotnev, 2015-11-17
@inkvizitor68sl

We can't guess by tea leaves.
See show processlist at the time of requests, do explain on requests.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question