[mythtv-users] RecordedSeek Table Size

[Tom Dexter]

>From: Jimbo
>
>Chris Tepe 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.
> >
> > Chris
> >
>Seems right to me:
>
>mysql> select count(*) from recordedseek;
>+----------+
>| count(*) |
>+----------+
>|  1598843 |
>+----------+
>
>The table is 38.12 MB on my system.

Although mine isn't that big (yet anyway) I was was curious why it had as 
many rows as it did.  It's just the nature of that table...it has quite a 
few rows for each recording...probably even more so when you use commercial 
skipping I'd guess.  This query on mine indicated that everything in there 
is in fact for an existing recording and that there were no orphanned rows 
or anything like that:

mysql> select count(*) from recordedseek where not exists (select * from 
recorded where chanid=recordedseek.chanid and 
starttime=recordedseek.starttime);
+----------+
| count(*) |
+----------+
|             0 |
+----------+

Tom

_________________________________________________________________
http://newlivehotmail.com