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: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** 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:[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 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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
