<html>
<body>
<font size=3>At 11:21 AM 2/25/2010, Johnny Walker wrote:<br>
<blockquote type=cite class=cite cite="">On Thu, Feb 25, 2010 at 9:41 AM,
Mache Creeger <mache@creeger.com> wrote:<br>
> I checked all the logs and there was nothing in them that suggested
a<br>
> problem.<br>
><br>
> -- Mache<br>
><br>
> At 07:12 AM 2/25/2010, Mike Holden wrote:<br>
><br>
>> Mache Creeger wrote:<br>
>>Sorry for the double posting but this was a new topic and I
wanted<br>
>>to make sure folks could see it.<br>
>><br>
>>Mythweb still takes around 5 minutes to render the Program
Detail<br>
>>page for a specific recording selected from the Recorded
Programs<br>
>>page. Is there anyway to speed things up? Looking at top during
the<br>
>>rendering time shows that the CPU is 85% idle and mysqld and
httpd<br>
>>are not running. Is it waiting for something to time out?<br>
>><br>
>>I have around 600 recordings but the Recorded Programs page comes
up<br>
>>right away. I run the database optimize script nightly.<br>
><br>
> Have you checked your apache logs to see if anything weird is going
on or<br>
> producing<br>
> errors?<br>
> --<br><br>
If nothing else you can turn on debug logging in mysql to see what<br>
queries are possibly slow moving.<br><br>
I think a better 1st step is to run 'tail -f<br>
/var/log/mythtv/mythbackend.log' while you request that page which
is<br>
slow loading to see what step it appears to hang on during that
load.<br><br>
What does the system's free memory look like while you're doing
this?<br><br>
-Johnny</font></blockquote><br>
I will turn on mysql debug logging to see if that shows anything. I have
not tried that. <br><br>
I have looked that the stock mysql logs and they have not shown anything.
I have looked at all the stock logs in /var/log and have not found
anything obvious. <br><br>
The system is basically at 90% idle all the time. I have looked a the
mythbackend.log and there is nothing there that would suggest a problem.
The system has 1GB of memory and 4GB of swap and there is nothing in top
to show that memory is a problem anywhere. <br><br>
-- Mache</body>
</html>