> 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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
