H
H
hoodie2018-10-01 15:54:49
MySQL
hoodie, 2018-10-01 15:54:49

MYSQL Monitoring: Why does DatabaseConnections grow while Queries stay the same?

There is a site on nginx + php-fpm + mysql
During the day, when users are most active on the site, the site starts to work slowly.
These are the mysql metrics - the number of Queries (in red) and the number of DatabaseConnections (in blue). It can be seen that at the time of loading, the number of connections increases. It is logical to assume that the number of requests should also increase. Or not? What could be the reason that the number of connections is growing while the number of requests remains the same? Or is this normal and how it should be?
kBB2R8P.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Shatokhin, 2018-10-01
@Sovigod

The response time also grows apparently. The number of requests does not change, but more of them are executed in parallel. run longer. Look at slowlogs and memory-perc-disk during these spikes.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question