List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:June 19 2006 11:08pm
Subject:RE: Aborting a greedy querry from the command line
View as plain text  
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.

Regards

---------------------------------------------------------------
********** _/     **********  David Logan 
*******   _/         *******  ITO Delivery Specialist - Database
*****    _/            *****  Hewlett-Packard Australia Ltd
****    _/_/_/  _/_/_/  ****  E-Mail: david.logan@stripped
****   _/  _/  _/  _/   ****  Desk:   +618 8408 4273
****  _/  _/  _/_/_/    ****  Mobile: 0417 268 665
*****        _/       ******    
******      _/      ********  Postal: 148 Frome Street,
********   _/     **********          Adelaide SA 5001
                                      Australia 
i    n    v    e    n    t                                   
---------------------------------------------------------------

-----Original Message-----
From: Chris White [mailto:chriswhite@stripped] 
Sent: Tuesday, 20 June 2006 8:37 AM
To: mysql@stripped
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 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 kill them by hand.

CTRL+Z simply puts a process in sleep mode so it can be woken up later
on.  
CTRL+C will kill the MySQL process (thus killing the query).  While I
don't 
like that method, it's the only one I've found so far.

> Is there any easy way to abort from the command line and have it
really
> stop that query?
> --
> -------------------------------------------------------------
> Scott Haneda                                Tel: 415.898.2602
> <http://www.newgeo.com>                     Novato, CA U.S.A.

-- 
Chris White
PHP Programmer/DB Overclocker
Interfuel

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Aborting a greedy querry from the command lineScott Haneda20 Jun
  • RE: Aborting a greedy querry from the command lineSST - Adelaide)20 Jun
  • Re: Aborting a greedy querry from the command lineChris White20 Jun
    • RE: Aborting a greedy querry from the command lineSST - Adelaide)20 Jun
      • Re: Aborting a greedy querry from the command lineChris White20 Jun
        • Re: Aborting a greedy querry from the command lineDan Nelson20 Jun
        • RE: Aborting a greedy querry from the command lineCiprian Vizitiu20 Jun
          • Re: Aborting a greedy querry from the command lineDuncan Hill20 Jun
          • RE: Aborting a greedy querry from the command linecknipe20 Jun