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

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: Scott Haneda [mailto:lists@stripped] 
Sent: Tuesday, 20 June 2006 8:32 AM
To: mysql@stripped
Subject: Aborting a greedy querry from the command line

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.

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.



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