From: Robert Citek [mailto:[EMAIL PROTECTED]
How does one stop or abort a query?
I was doing some experimenting with MySQL and created a table with
100,000 records. I then did a join like so:
create table foo select foo.name, foo.val from foo, foo x,
foo y, foo
z ;
This took a long time. So, I aborted with Ctrl-C (^C) which
bumped me
out of the mysql client. I then reconnected, issued 'show
processlist;', and issued a 'kill ###;' for the process. Is this the
way to abort a query? Or is there a more graceful method that aborts
the query but keeps me in the mysql client?
Have googled and searched the mailing list archives and faq, but
nothing so far. Hints for search terms and pointers to a URL are
greatly appreciated.
When I need to kill a query, I skip the Ctrl-C step and just open another session on
the client and kill it from there. The previous window will say something about the
MySQL server going away, but can generally reconnect on its own if you give it a line
feed.
However, I've found that when I kill a query, more often than not it just hangs in the
processlist. In fact, we've had queries that hang and prevent other queries from
getting to the table for so long that we end up restarting the server to free it up.
Ugh.
I haven't researched it much, but has anyone else seen this hanging query problem
before? It was probably 3.23 at that point (we recently upgraded to 4, but haven't
done much to warrant the situation since). The status for the process usually says
'killed' if that helps.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]