01 Sep

Hunting for "Locked" queries with pt-stalk utility

Recently we faced an issue when Nagios reported significant amount of "Locked" queries. To investigate and debug the issue we needed to get more insight about the state of MySQL and the OS at the time the locks occurred. This is how we got the much needed information.

Read More