Re: How to kill a mysql CLI session

["Jeremy D. Zawodny" <jzawodn@xxxxxxxxxxxxx>]

On Tue, Jan 02, 2001 at 01:24:34AM +0100, Jørn-Morten Innselset wrote:

> Is there a way to gracefully kill a lenghty query in the mysql
> client without shutting down the client? Now I do a Ctrl-C (thus
> being dropped into the shell), and have to kill the query with
> mysqladmin. In the Oracle sqlplus client (as horribly as it may be)
> a Ctrl-C just kills the job and returns to the sqlplus prompt.

Right now that functionality isn't built into the mysql client. You
either need to use another mysql client session, mysqladmin, or some
other tool.

I use mytop to watch servers and kill off run-away queries when I need
to. Of course, I'm a little biased, since I wrote it. :-)

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@xxxxxxxxxxxxx>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60340@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php