Hello Dan On 2006-11-06 Dan Jacobson wrote: > On notices when one starts some wild looping query, and then C-c's the > client (/usr/bin/mysql), there is no detecting "forget it, he hung up" > at the server, which just loops and needs /etc/init.d/mysql restart > done. > > Compare e.g., WWWOFFLE which knows if the browser hung up.
I'm not sure if I understand what you mean? Are you talking about using /usr/bin/mysql to enter a query which runs "endlessly" so that you are trying to kill the query with control-c? I this case you don't have to restart the server but can use "SHOW PROCESSLIST" and "KILL 10" etc to kill the offending query. What you ask is that this should be done automatically by the server? bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
