[mythtv-users] table recordedmarkup is very big

Michael T. Dean mtdean at thirdcontact.com
Sun Sep 17 11:57:35 UTC 2006


On 09/17/2006 04:58 AM, Kim Bisgaard wrote:

>Is it normal that the table recordedmarkup is very big?
>
Only if you're using MPEG-2 recordings.

> Have I set a setting wrong?
>  
>
Nope.

>Mine has 500,000 records and fills 25M (+ another 23M index).
>
>If I query the table with:
>select chanid,starttime,count(*) from recordedmarkup group by 
>chanid,starttime order by starttime;
>
No problem.  That's what allows you to seek instantaneously in MPEG-2 
recordings.

If you want to reduce the table's size, you can:
    a) delete your MPEG-2 recordings.
    b) transcode your MPEG-2 recordings to MPEG-4 recordings.
    c) not worry about it and enjoy all the benefits the table provides.  :)
    d) upgrade to 0.20, where the seektable data in recordedmarkkup gets 
moved to recordedseek (so then you'll have a huge recordedseek table and 
a small recordedmarkup table).  ;)

Mike


More information about the mythtv-users mailing list