Why long answer from Mysql?

Question

MySQL

What's the matter? Too long response from base. And it would be okay if it was always long, the problem is temporary - which makes it even more difficult to diagnose.
In general, there is a game server, with a connection to the Mysql database through a plugin (we will not go into this plugin and so on, since this is most likely not the case). So, when not many people play on the server (although the problem may not be related to the number of players at all), then everything is fine. But there are times when you wait 30 seconds for answers! Both the game server and mysql are on the same machine (VPS). But I have something to build on - after "service mysqld restart" everything works instantly. And then, after a while, again, the request delay is 30-60 seconds.

Answer 1

Enable the slow query log and analyze the plan of these queries

Answer 2

Perhaps you have to wait for a long response from the server at those moments when the VPS container is being backed up?

Answer 3

1. Check the number of connections. Type of connection (permanent or not)
2. What are the actions with the base? Writes mostly or reads?
3. Check the hard disk with utilities when there is a long answer. Maybe mysql ran into disk speed