[NBLUG/talk] Hung MySQL process does not timeout.

[Augie Schwer]

I have a client query that when executed locally continues to run (and
keep locks on tables) even without a controlling terminal. I tried
setting "interactive_timeout" to something low like 60 seconds, but as
I watch the 'processlist' I see the query roll right past that timeout
even after I have killed the shell that initially started the query.

So my question is; is there some other timeout or MySQL system
variable I am missing that would timeout a local MySQL client (cli)
session that executed a long query and then was terminated poorly?
'long_query_time' is already set to 10 seconds, so that doesn't seem
to do it.

Any help or suggestions welcome.


-- 
Augie Schwer    -    Augie at Schwer.us    -    http://schwer.us
Key fingerprint = 9815 AE19 AFD1 1FE7 5DEE 2AC3 CB99 2784 27B0 C072