[mythtv-users] MySQL server has gone away
Michael T. Dean
mtdean at thirdcontact.com
Fri Nov 6 16:33:04 UTC 2009
On 11/06/2009 09:59 AM, Duncan Brown wrote:
> 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
Wait timeout defaults to 28800 (seconds--which is 8hrs) in MySQL (though
your distro may have changed your system configuration such that it uses
something lower). Bumping from 28800 to 600 won't help. :)
More information about the mythtv-users