[mythtv-users] MySQL server has gone away

Dan Wilga mythtv-users2 at dwilga-linux1.amherst.edu
Fri Nov 6 14:27:51 UTC 2009


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.
-- 
Dan Wilga                                                        "Ook."


More information about the mythtv-users mailing list