[mythtv-users] RecordedSeek Table Size

[Nick Morrott]

On 24/07/07, Chris Tepe <cstepe at ctdataservices.com> wrote:
> I recently had an issue with the database  where I had to repair the
> recordedseek table.   My table is >40 megs and has more than a million
> records in it.  Is this normal and should I be concerned.  I'm running
> myth .20 on FC4.

If you have a number of recordings that is entirely possible. I
currently have 92 recordings listed in my `recorded` table (majority
recorded from ivtv cards) with >400,000 records in `recordedseek`. You
should notice that as your net number of stored recordings reduces so
does the number of records in `recordedseek`. This table provides seek
information for the recorded video streams.

You may also have some orhpaned records in the `recordedseek` table -
I'm not sure if this scenario is catered for by the database
maintenance script. You can always run a SQL script comparing the
records in `recorded` against the seek information in `recordedseek`.

-- 
Nick

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin