It”s not the most common task in the world, but you might want to view processes from a particular user and once in a while you might even need to kill processes from a single user, be it during an attack or because you simply got a bug in an application bombarding your db server with connections!
Here is a small stored procedure which does exactly that!
– shows all processes owned by username@hostname
– kills all processes owned by username@hostname
The code for this stored procedure can be …[Read more...]