[mythtv-users] mythfilldatabase with EIT data

Richard Morton richard.e.morton at gmail.com
Sat Jul 25 19:22:55 UTC 2009

ok, after seeing the issue reappear today and missing the recording of the
formula1 qualy. I thought Id ask if there is a way to prevent timeout of the
MySQL connections.



Thanks And Regards,

Richard Morton
07899 750400
GoogleTalk: richard.e.morton at gmail.com
MS Messenger: richard.e.morton at gmail.com

www.pidgin.im - MSN & Yahoo Messenger and many great features but without
www.ubuntu.com - a free operating system thats pretty damn good.

to mess up a Linux box, you need to work at it;
to mess up your Windows box, you just need to work on it.
     - Scott Granneman, Security Focus

OpenOffice a fully featured office suite that is free, it's so good
Microsoft are adding support for it to their office applications.

"I would change the world if I could, but they wont give me the source
code." --Unknown

2009/7/21 Michael T. Dean <mtdean at thirdcontact.com>

> On 07/20/2009 06:58 PM, Richard Morton wrote:
>> On Jul 20, 2009 11:28 PM, "Michael T. Dean" wrote:
>>  That sounds a lot like your backend lost its connections to the MySQL
>>> server.  When you restarted the backend, it got new connections, so it was
>>> working fine.
>>> If it happens every day (or every 8 hours), it probably means that your
>>> backend is unable to detect dead connections or unable to reconnect.  You
>>> can set MySQL's wait_timeout and interactive_timeout in /etc/mysql/mysql.ini
>>> (or wherever your distro puts it) to small values (like 120 --2mins) to test
>>> if the backend recovers.  They default to 8hrs worth of seconds (though your
>>> distro may have modified the defaults).
>>> I've heard reports that some versions of MySQL/MySQL libs/Qt-MySQL
>>> drivers/something cause huge delays when Myth needs to reconnect--possibly
>>> long enough that Myth gives up.
>> I thought that but the epg is populated. Isn't that also fetched by
>> mythweb etc from the db?
> The Scheduler uses its own distinct MySQL connections (which aren't
> commingled with the others).  And, Myth uses a bunch of different
> connections in a pool, so it's possible that some were timed out and others
> weren't.
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090725/76925c06/attachment.htm>

More information about the mythtv-users mailing list