Answer the question
In order to leave comments, you need to log in
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
You monitor the load of RAM.
It looks like something is falling into the swap.
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 questionAsk a Question
731 491 924 answers to any question