Bug #2938 Suggestion regarding kill command
Submitted: 24 Feb 2004 10:03 Modified: 1 Dec 2005 14:10
Reporter: [ name withheld ] Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:any OS:Any (any)
Assigned to: CPU Architecture:Any

[24 Feb 2004 10:03] [ name withheld ] 
Description:
Here is a suggestion:

Add another parameter to the kill command, somehting like this:

kill thread_id where time>#

where # is a number

That way I could look at the process list and see that process 1234 has been inactive for 1000 seconds and decide to kill the process like this:

kill 1234 where time>1000

If process 1234 suddenly started being active between the time I looked at the process list and the time I issued the command then time would be less than 1000 and the thread would not be killed and I would not have messed up an active process.

How to repeat:
this is a feature request
[1 Dec 2005 14:10] Valeriy Kravchuk 
Thank you for a feature request. I agree, that additional check may be needed before executing kill command, but it is up to DBA to decide is there any reason to kill or not to kill the thread. Inactivity time is just one of them. So, I do not think that this addition is worth implementing.