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

Dan Wilga dwilga at mtholyoke.edu
Thu Feb 23 15:34:44 UTC 2006

At 7:41 PM -0800 2/21/06, Todd Hutchinson wrote:
>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

The database might be missing some indices, or may just have large 
amounts of leftover junk in it waiting to be garbage collected.

Have you tried optimizing it? Here's one script that does so:


Dan Wilga                                         dwilga at mtholyoke.edu
Web Administrator                             http://www.mtholyoke.edu
Mount Holyoke College                                Tel: 413-538-3027
South Hadley, MA  01075            "Who left the cake out in the rain?"

More information about the mythtv-users mailing list