[mythtv-users] MySQL server has gone away

[Michael T. Dean]

On 11/06/2009 02:17 PM, Dan Wilga wrote:
> At 8:39 AM -0800 11/6/09, Yeechang Lee wrote:
>> Dan Wilga says:
>>>  IMHO, a value of 600 (10 minutes) should be plenty. And on a system
>>>  where you generally only have a few clients at most, that value
>>>  should not result in too many zombie connections.
>>
>> Just checked my my.cnf and it was set to 93600 (!); same with
>> interactive_timeout. Should I lower one, or both?
> Don't bother, unless you're using lots of applications which use MySQL 
> and don't disconnect properly--which is unlikely.
>
> These timeouts are there to keep clients that crash or otherwise fail 
> to close their connections from consuming MySQL's resources by keeping 
> the "slot" open. You'd probably have to make an application crash a 
> dozen times in a row during that period before you would even notice a 
> slight difference in speed.
>
> If you make this value too low, you can run into situations where the 
> client retrieves some data, takes a long time to process it, and then 
> tries to fetch the next bit of data but can't because its connection 
> has been dropped. 

For example, nuvexport can be affected by too-low timeouts.  If your 
system takes longer than 8hrs to transcode some show (which happens to 
some users--especially for long recordings), the MySQL-default of 8hrs 
will cause it to fail (/after/ at least 8hrs of processing, of course :).

Mike