[mythtv-users] MySQL server has gone away

Duncan Brown mythtv at duncb.co.uk
Fri Nov 6 14:59:05 UTC 2009


On 06/11/2009 14:27, Dan Wilga wrote:
> What is the value for wait_timeout in your my.cnf? It's been my 
> experience that this variable is more important, since it controls the 
> length of time that a connection is allowed to remain idle before the 
> server disconnects. It has to be longer than the execution time of the 
> longest query.
>
> 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.
At the moment it is whatever the default is. I'll try bumping it up to 
600 and see how it goes.

Thanks for the suggestion

Dunc


More information about the mythtv-users mailing list