[mythtv-users] Performance [was :huge recorded seek table?]

[ross camm]

converting my recordedseek table from MyISAM  to InnoDB resulted in a
huge performance gain for me.

It fixed slow menu navigation in recordings, deletes are now fast, and I
dont get timeouts trying to load programs that are greater than 2 hours
in length.

/usr/bin/mysql_convert_table_format --user=root --password=XXX
--type=innodb mythconverg recordedseek

Hope this helps.

On Mon, 2007-10-01 at 11:35 -0400, Rich West wrote:
> Anduin Withers wrote:
> >> I'm leaning towards upgrading the backend system to help improve
> >> performance.  I was looking at the DB because it was taking several
> >> seconds to bring up the recordings page, and, in some cases, it would
> >> take 15 seconds (or more) to navigate through the recordings.
> >>     
> >
> > If you can live without video/picture preview that should speed navigation.
> > Presumably, there is some point when all recorders are idle and you have
> > commflagged everything, is it significantly faster then?
> 
> 
> When things are idle, yes, it the frontend systems work smoother.  I
> haven't tried disabling the preview yet.. the other half immediatly shot
> down my attempt to turn it off since one of our DirecTV boxes randomly
> decides to lose signal until it gets a hard reset and she uses the
> preview to see if it is recording just a black screen.
> 
> I usually notice it when bringing up the kids recordings list (350 shows
> and growing.. I have to do something about that).
> 
> I'm wondering if it is time to upgrade the system with a dual-core
> processor (benefits there would be the ability to record multiple shows
> and one commflag with ease) and upgrade the recordings filesystem to
> SATA (currently have it striped across two PATA drives).
> 
> -Rich
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users