DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools to remove problematic MySQL processes. I will highlight all of the tools via some examples in this post.
pt-kill:
There have been some good posts on this blog about the pt-kill
tool, like this one by Arunjith Aravindan titled “How a set of queries can be killed in MySQL using
Percona Toolkit’s pt-kill.” Let’s dive into pt-kill a bit further with a few more …