Jeremy D. Zawodny wrote:
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.
Ctrl-C aborts for me.
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
-- Daniel Bohling NewsFactor Network -- --------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php"; before posting. To request this thread, e-mail mysql-thread60409@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