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

[Michael T. Dean]

On 11/04/2008 10:22 PM, OCG Technical Support wrote:
> From: Brian Wood
>> 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.
> Could you reply with how to optimize the DB?
>   

Run the script optimize_mythdb.pl from the contrib directory of the
source distribution (probably installed somewhere on your system by your
packages).

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

It's quite possible that it's not a timeout, but is a problem with PHP
running out of memory.  Try increasing the PHP memory limit (search the
list for how, as I don't remember and don't feel like fighting the hotel
Internet to find it myself).

Mike