maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

> 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