Re: Aborting a greedy querry from the command line

[Duncan Hill]

On Tuesday 20 June 2006 08:23, Ciprian Vizitiu wrote:
> > On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> > > Hi Chris,
> > >
> > > I've noticed that a Ctrl-C will also leave the query
> >
> > running (5.0.22 -
> >
> > > Linux) and I've had to use the kill from mysqladmin or
> >
> > mysql client to
> >
> > > get rid of it.
> >
> > Huh, that's odd, it should abort everything entirely.... even
> > with threading and what not.  Maybe a MySQL person can step
> > in here and throw in an explanation :).
>
> It might me odd but it's true; and annoying. Have to restart the daemon
> otherwise the server will continue to chew CPU and disk doing the query.

You can execute a kill from the mysql command prompt to remove the query.  No 
need to take the entire server down.
----
Scanned by mailCritical.