Hi everyone, I have a rather obscure problem with hung login connections in mysql. I've set the wait|interactive_timeout to 120 seconds, but it has no effect.\ If I attempt to `mysqladmin kill <id>`, the process is marked 'killed', but never goes away.
Now I know the main problem is with the program I am using to create the connections and access the data, but I'm ignoring that right now because I want to deal with these stale (or hung) login processes. And find out how to remove them or time them out (without restarting mysql mind you, if at all possible). Here's some brief output from my `mysqladmin processlist`: +--------+--------------+---------------+--------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+--------------+---------------+--------------+---------+------+-------+------------------+ | 22088 | via_httplogs | localhost | | Connect | | login | | | 22877 | via_httplogs | localhost | | Connect | | login | | | 23135 | via_httplogs | localhost | | Connect | | login | | | 23226 | via_httplogs | localhost | | Connect | | login | | | 26523 | via_httplogs | localhost | | Connect | | login | | | 32105 | via_httplogs | localhost | | Connect | | login | | | 32113 | via_httplogs | localhost | | Connect | | login | | | 37098 | via_httplogs | localhost | | Connect | | login | | | 38300 | via_httplogs | localhost | | Connect | | login | | | 51212 | via_httplogs | localhost | | Connect | | login | | | 89713 | via_httplogs | localhost | | Connect | | login | | | 99008 | via_httplogs | localhost | | Connect | | login | | | 119642 | via_httplogs | localhost | via_httplogs | Sleep | 2 | | | | 119644 | via_httplogs | localhost | via_httplogs | Sleep | 29 | | | | 119645 | via_httplogs | localhost | via_httplogs | Sleep | 14 | | | | 119646 | via_httplogs | localhost | via_httplogs | Sleep | 41 | | | ... Nothing shows up in the mysql error log either. Any ideas? Thanks again. -reid --------------------------------------------------------------------- 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
