17 Aug
2013
17 Aug
'13
8:56 p.m.
well this may work, and may not work, you don't set a lock between information_schema.PROCESS_LIST and KILL command, the query can change between the time of process_list return and the kill command, and yes, i have a very high lucky and i killed a query that was not the right query because i used the thread id, instead of the query id i think the solution is a new parameter to KILL command, the query_id information...
Of course this MAY happen even using that procedure, but you should be very very very unlucky :) Federico