Xmodulo posted How to find and kill misbehaving MySQL queries
A quote from the article:
Sometimes the complexity of a relational database system can be overwhelming. Fortunately, sometimes that complexity is an advantage, as with MySQL's tools for managing queries.How to find and kill misbehaving MySQL queries @ Xmodulo