[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