Kill All Proccesses

2010-09-29 Thread Willy Mularto
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:

Re: Kill All Proccesses

2010-09-29 Thread Евгений Килимчук
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

Re: Kill All Proccesses

2010-09-29 Thread Willy Mularto
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

Re: Kill All Proccesses

2010-09-29 Thread Suresh Kuna
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