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 <sangpr...@gmail.com> wrote: > AFAIK mysqladmin just kill a proccess and can not do kill all instances. > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > > On Sep 29, 2010, at 9:09 PM, Евгений Килимчук wrote: > > > mysqladmin kill id,id,... > > > > 2010/9/29 Willy Mularto <sangpr...@gmail.com> > > Hi, > > I see so many locked tables and can not be unlocked. Is there any single > command or tools to kill all processes? > > > > > > > > > > sangprabv > > sangpr...@gmail.com > > http://www.petitiononline.com/froyo/ > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=ekilimc...@gmail.com > > > > > > > > > > -- > > Best regards, > > > > Eugene Kilimchuk <ekilimc...@gmail.com> > > -- Thanks Suresh Kuna MySQL DBA
