[mythtv-users] Slow scheduling response

[David Engel]

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