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

[Dan Wilga]

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:

http://forevermore.net/files/mythtv_misc/optimize_mythdb.pl.txt

-- 
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?"