0.19 Program Guide slowness...
- From: Dan Wilga <dwilga (at) mtholyoke.edu>
- Date: Thu, 23 Feb 2006 10:34:44 -0500
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?"
_______________________________________________
mythtv-users mailing list
mythtv-users (at) mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users