In this blog, I will demonstrate how to use Percona Monitoring and Management (PMM) to
find out the reason why the MySQL server is stalling. I will use
only one typical situation for the MySQL server stall in this
example, but the same dashboards, graphs, and principles will
help you in all other cases.
Nobody wants it but database servers may stop handling
connections at some point. As a result, the application will slow
down and then will stop responding.
It is always better to know about the stall from a monitoring
instrument rather than from your own customers.
PMM is a great help in this case. If you look at its graphs and
notice that many of them started showing unusual behavior, you
need to react. In the case of stalls, you will see that either
some activity went to 0 or, otherwise, it increased to high …
[Read more]