RE: Aborting a greedy querry from the command line

2006-06-20 Thread cknipe
Quoting Ciprian Vizitiu <[EMAIL PROTECTED]>: > > 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 cli

Re: Aborting a greedy querry from the command line

2006-06-20 Thread 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

RE: Aborting a greedy querry from the command line

2006-06-20 Thread Ciprian Vizitiu
> 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 a

Re: Aborting a greedy querry from the command line

2006-06-19 Thread Dan Nelson
In the last episode (Jun 19), Chris White said: > On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: > > 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,

Re: Aborting a greedy querry from the command line

2006-06-19 Thread Chris White
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 entirel

RE: Aborting a greedy querry from the command line

2006-06-19 Thread Logan, David (SST - Adelaide)
nt --- -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 June 2006 8:37 AM To: mysql@lists.mysql.com Subject: Re: Aborting a greedy querry from the command line On Monday 19 June 2006 04:02 pm, Scott Haneda wrote: > Sometimes I will issue something, slip of the

Re: Aborting a greedy querry from the command line

2006-06-19 Thread Chris White
On Monday 19 June 2006 04:02 pm, Scott Haneda wrote: > Sometimes I will issue something, slip of the fingers, and mysql will chew > on it for hours, the best I can do is control-z to get out of it and log > back in. But, I just learned these processes are still running, and I have > to go in and k

RE: Aborting a greedy querry from the command line

2006-06-19 Thread Logan, David (SST - Adelaide)
Hi Scott, mysqladmin can issue a kill from the command line. You will have to issue a mysqladmin -u etc. etc. processlist to get the process id from mysql and then you can issue a mysqladmin -u etc. etc. kill Regards --- ** _/