[mythtv-users] 0.19 Program Guide slowness...

[Todd Hutchinson]

I too notice a slow response when I click "Listings"
on the web page.  If I click "listings" and view top
at the same time, mysqld uses a large amount of CPU
(70-98%) for about 12 seconds, then, httpd uses a
large amount of CPU (~99%) for a couple seconds
followed by galeon (my web browser) using a large
amount of CPU (~99%) for about 1-2 seconds.  I really
don't know why displaying the listings should take so
much CPU usage, especially with mysqld--the search
should be simple, right?

Anyway, I have an Intel Celeron 2.4GHz
processor--should be plenty for mysqld and httpd, I
would think.  

Also, after about two years, my nightly mysql dump
(mysqldump -u mythtv -pmythtv mythconverg) text output
is about 389 MB.  

Any ideas out there of what might be wrong?  



--- Paul Harvey <paul.l.harvey at gmail.com> wrote:

> Thanks!!!... That did fix the frontend problems.
> 
> Now I would like to figure out how to speed up the
> MythWeb part....
> 
> On 2/20/06, Paul Harvey <paul.l.harvey at gmail.com>
> wrote:
> > It may be that my logging level isn't including
> the errors...  I did
> > do an Icon grab with root as well, so that may be
> my problem.
> >
> > Looking in the Channels table, it shows
> /root/.mythtv in the path for
> > all the icons, so that is at least contributing to
> the problem....
> > I'll fix them and see if the program guide is
> faster.
> >
> > Thanks!
> >
> > On 2/20/06, Stuart Larson <halcyon at obfus.com>
> wrote:
> > > I had some problems after updating, and tracked
> it down to the channel
> > > icons.  I ran the initial icon-grab with root,
> so it was looking for the
> > > icons in root's home dir, which it didn't have
> access to... once I fixed
> > > that the program guide worked just like 0.18.1 -
> I did have errors in the
> > > log to help, though, so maybe this isn't what
> you're seeing.
> > >
> > > > After working out all the little changes
> between 0.18.1 and 0.19,
> > > > everything is working great except for the
> speed when trying to view
> > > > the Program Guide.  When I select it from the
> Mythfrontend, it takes
> > > > at least 30 seconds to display the content.
> > > >
> > > > I do see some slowness from the Mythweb
> interface too, but it is much
> > > > faster than the frontend.  The two most
> obvious slow places are when
> > > > viewing the Recorded Programs list, and when
> viewing the Program
> > > > Guide.
> > > >
> > > > I don't see any errors in the logs about
> problems, but it may be I'm
> > > > overlooking them too.
> > > >
> > > > Any ideas what to look at, and what might need
> to be tweaked to
> > > > improve performance?
> > > >
> > > > My system is a split BE/FE system, both
> running Gentoo, and MythTV is
> > > > installed using the mythtv-0.19 ebuild.  The
> BE is running the
> > > > 2.6.14-gentoo-r5 kernel, the FE is running 
> 2.6.11-gentoo-r11, both
> > > > have MySQL 4.0.25-r2 installed
> > > >
> > > > TIA!
> > > >
> > > > --
> > > > I have Gmail invites... Email me if you want
> one!
> > > >
> _______________________________________________
> > > > mythtv-users mailing list
> > > > mythtv-users at mythtv.org
> > > >
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > > >
> > >
> > >
> > > _______________________________________________
> > > mythtv-users mailing list
> > > mythtv-users at mythtv.org
> > >
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > >
> >
> >
> > --
> > I have Gmail invites... Email me if you want one!
> >
> 
> 
> --
> I have Gmail invites... Email me if you want one!
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com