you can do it by a simple shell script by doing a grep of id's and passing it to mysql.
On Wed, Sep 29, 2010 at 8:31 PM, Willy Mularto <[email protected]> wrote: > AFAIK mysqladmin just kill a proccess and can not do kill all instances. > > > > sangprabv > [email protected] > http://www.petitiononline.com/froyo/ > > > On Sep 29, 2010, at 9:09 PM, Евгений Килимчук wrote: > > > mysqladmin kill id,id,... > > > > 2010/9/29 Willy Mularto <[email protected]> > > Hi, > > I see so many locked tables and can not be unlocked. Is there any single > command or tools to kill all processes? > > > > > > > > > > sangprabv > > [email protected] > > http://www.petitiononline.com/froyo/ > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[email protected] > > > > > > > > > > -- > > Best regards, > > > > Eugene Kilimchuk <[email protected]> > > -- Thanks Suresh Kuna MySQL DBA
