[mythtv-users] Slow scheduling response
David Engel
david at istwok.net
Mon Nov 16 15:51:14 UTC 2009
On Sun, Nov 15, 2009 at 11:28:57AM -0600, Lane Roberts wrote:
> I've got a fresh install of ubuntu 9.10 Server, running myth .22-fixes
> r22824. Performance when adding or changing a recording schedule seems
> extremely slow. In both mythweb and the program guide, saving a change
> results in a 25-30 second wait, where mysqld spikes cpu usage to
> ~100%.
>
> When I installed, I did migrate recording history and schedules. Am I
> missing an Index on one of the tables? Does anyone else see the same
> thing or have any ideas?
25-30 second reschedules is not normal. A missing or corrupted index
could be the cause. Backup your database and restore it. If the
problem persists, what does the output look like when you add "-v
schedule" to your mythbackend command line?
David
--
David Engel
david at istwok.net
More information about the mythtv-users
mailing list