[mythtv-users] sanity check of recorded seek?

[Raymond Wagner]

On Thu, 07 Jul 2011 17:55:13 -0400, "Brian J. Murrell"
<brian at interlinx.bc.ca> wrote:
> My recordedseek table has 4,975,518 rows in it.  I understand that a
> single recording can produce many rows in this table but still, 5M rows
> seems like much.
> 
> Does anyone have a quickie little mysql statement to test that every one
> of those 5M rows is for a currently recorded/stored program?

There is a bit of code that runs in the housekeeper on the master backend
that will clear out any refuse from the half dozen tables used to store
recording data.  It removes any information that does not have a matching
entry in the recorded table.