[mythtv-users] Mythweb - search times out. Mysql?

[OCG Technical Support]

Could you reply with how to optimize the DB?

I tried increasing the timeout value in /etc/httpd/conf/httpd.conf to 240
seconds...still timing out!

-M-

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Brian Wood
Sent: November 4, 2008 10:18 PM
To: Myth TV Users List
Subject: Re: [mythtv-users] Mythweb - search times out. Mysql?
Importance: High

Brad DerManouelian wrote:
> On Nov 4, 2008, at 7:00 PM, OCG Technical Support wrote:
>
>> I have myth working great with EPG data for several TV sources (LOTS
>> of channels).  Whenever I try to do a mythweb search for New Release /
>> movies, mythweb times out (no page ever appears)
>
> MySQL won't time out. It will keep chugging until it gets results.
> Apache is timing out. Check your logs and see if you can set your time
> before timing out longer.

With both satellite and cable channels searches like that take a LONG
time for me.

Regularly optimizing the DB seems to help a lot.

beww
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users