[mythtv-users] Horrible performance fastforwarding HDTV - FIXED

[Billy Macdonald]

Hi,
     I was having difficulty fast-forwarding HDTV shows.  It would
take take longer than 5 seconds to skip 5 seconds.  The frontend logs
showed the following errors when I would try to skip.


2007-07-24 21:16:17.286
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 1.0
seconds for data to become available...
2007-07-24 21:16:18.294
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 2.0
seconds for data to become available...
2007-07-24 21:16:19.701
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..
2007-07-24 21:16:20.703
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..
2007-07-24 21:16:22.304
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 1.0
seconds for data to become available...
2007-07-24 21:16:23.315
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Waited 2.0
seconds for data to become available...
2007-07-24 21:16:24.706
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..
2007-07-24 21:16:25.708
RingBuf(/var/storage/mythtv/3467_20070724203000.mpg): Taking too long
to be allowed to read..

I finally found the following problem in the database when I tried to
manually access the recordedseek table.

Table './mythconverg/recordedseek' is marked as crashed and should be repaired

And used the following command to fix it.  I used the same command
without --auto-repair to make sure that no other tables weren't
corrupted.  This happened after a power failure.  It was odd that I
didn't see any errors in the backend log even though it couldn't write
to this table.

mysqlcheck --auto-repair -u root -p mythconverg

This was my first experience with a data problem on mysql that I've
always heard of as a negative for mysql.  The recordings that happened
when it was broke are still laggy fast-forwarding, but a new
recordings work well.

Just thought I would post this to the list for documentation in case
someone else has similar issues down the road.

Billy