Steve Ruby wrote:
>
> If I have a connection that executes a bad query shouldn't I
> ALWAYS be able to kill it with "kill <connect num>"?
>
> I have a query that keeps getting stuck, (who knows what
> it is doing) but that State is "statistics"
>
> I can't ever kill it without taking down the server..
>
PS.. this is using 3.23.33 on Linux.. I find that the query is very
slow but will eventually complete, still, can I not kill a query
that will lock tables for hours?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
