[mythtv-users] Slow MythWeb

[Karl Newman]

On Mon, Dec 2, 2013 at 9:50 AM, Larry Finger <Larry.Finger at lwfinger.net>wrote:

> I just underwent an upgrade of my system from 0.26-fixes to 0.27-fixes
> from the git repo. I also upgraded to openSUSE 13.1 and kernel 3.11.4. I
> had some problems, but all is now functional with only one quirk.
>
> When I run MythWeb and select Recorded Programs, it takes ~7 min to
> complete even though I have only 71 recorded programs. From the access log,
> I see the following timeline:
>
> 10:48:41 GET mythweb/tx/recorded
> 10:48:43 GET pixmap
> .... more pixmaps
> 10:48:48 GET pixmap (a total of 8 now transferred)
> time gap here
> 10:50:43 GET pixmap - 4 more are transferred in 1 sec
> time gap
> 10:52:44 GET pixmap
> The last logged access is at 10:53:04; however, it is approximately 10:56
> before the client browser shows the transaction complete. The same behavior
> is seen for Firefox and Konquerer. The program matrix loads quickly, but
> the pixmaps are slow with large time gaps when nothing is happening.
>
> All other inquiries finish in only a few seconds as expected.
>
> Is this a known problem?
>
> I found the configuration parameter in MythWeb to disable the loading of
> the pixmaps. I do not really need them; however, I would like to know if I
> have some other configuration error.
>
> Thanks,
>
> Larry
>

Not that it was ever painfully slow for me, but optimizing mysql made
mythweb a lot quicker. You might look into that. One of the biggest impacts
for me was optimizing for temporary tables. Look here for a starting point:
http://www.mythtv.org/wiki/Tune_MySQL

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131202/23373302/attachment.html>