Kill All Proccesses

Kill All Proccesses

am 29.09.2010 11:28:54 von uYe

Hi,
I see so many locked tables and can not be unlocked. Is there any single =
command or tools to kill all processes?




sangprabv
sangprabv@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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Kill All Proccesses

am 29.09.2010 16:09:50 von ekilimchuk

--0016363b9164c8dc4e04916683ce
Content-Type: text/plain; charset=ISO-8859-1

mysqladmin kill id,id,...

2010/9/29 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
> sangprabv@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=ekilimchuk@gmail.com
>
>


--
Best regards,

Eugene Kilimchuk

--0016363b9164c8dc4e04916683ce--

Re: Kill All Proccesses

am 30.09.2010 02:31:56 von uYe

--Apple-Mail-2-409354532
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=utf-8

AFAIK mysqladmin just kill a proccess and can not do kill all instances.



sangprabv
sangprabv@gmail.com
http://www.petitiononline.com/froyo/


On Sep 29, 2010, at 9:09 PM, Евгений =
Килимчук wrote:

> mysqladmin kill id,id,...
>=20
> 2010/9/29 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?
>=20
>=20
>=20
>=20
> sangprabv
> sangprabv@gmail.com
> http://www.petitiononline.com/froyo/
>=20
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dekilimchuk@gmail.com
>=20
>=20
>=20
>=20
> --=20
> Best regards,
>=20
> Eugene Kilimchuk


--Apple-Mail-2-409354532--

Re: Kill All Proccesses

am 30.09.2010 02:52:28 von sureshkumarilu

--00221572690a04a20e04916f7ea4
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 wrote:

> AFAIK mysqladmin just kill a proccess and can not do kill all instances.
>
>
>
> sangprabv
> sangprabv@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
> > Hi,
> > I see so many locked tables and can not be unlocked. Is there any singl=
e
> command or tools to kill all processes?
> >
> >
> >
> >
> > sangprabv
> > sangprabv@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=3Dekilimchuk@gmail.com
> >
> >
> >
> >
> > --
> > Best regards,
> >
> > Eugene Kilimchuk
>
>


--=20
Thanks
Suresh Kuna
MySQL DBA

--00221572690a04a20e04916f7ea4--