[mythtv-users] MySQL server has gone away

Yeechang Lee ylee at pobox.com
Fri Nov 6 16:39:22 UTC 2009


Dan Wilga <mythtv-users2 at dwilga-linux1.amherst.edu> 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?

-- 
Frontend/backend:	P4 3.0GHz, 1.5TB software RAID 5 array
Backend:		Quad-core Xeon 1.6GHz, 6.6TB sw RAID 6
Video inputs:		Four high-definition over FireWire/OTA
Accessories:		47" 1080p LCD, 5.1 digital, and MX-600


More information about the mythtv-users mailing list