Given an environment where a high volume web application is prone to opening many connections to backend resources, using a utility like pt-stalk is important. When performance or availability affecting events like innodb lock waits or connection saturation occur, pt-stalk helps give you information you may need in troubleshooting what was happening.
The tendency may be to create multiple pt-stalks for various conditions. This can be a poor decision when your server is dealing with both lock contention and high connections. When pt-stalk triggers, it …[Read more]