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]