<br><br><div><span class="gmail_quote">On 6/11/07, <b class="gmail_sendername">Craig Fry</b> <<a href="mailto:craigfry@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">craigfry@gmail.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I run mythfilldatabase a few times a week.<br><br>I have records from old recordings all the way back to 2004-04-17. I want to remove all the old data. I can handle seeing the same episode yearly. I can't even remember what I watched yesterday, let alone 2004.
<br><br>My sql dump is 139 megs. <div><span><br><div><span class="gmail_quote">On 6/11/07, <b class="gmail_sendername">Michael T. Dean</b> <<a href="mailto:mtdean@thirdcontact.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mtdean@thirdcontact.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 06/11/2007 02:40 PM, Craig Fry wrote:<br>> I'd like to clean up my mythconverg database. I've been running this<br>> thing for years upon years and it's getting huge. I'd like to clean<br>> out all the records more then a year old. Does anyone have a script
<br>> or solution? Thanks<br><br>A huge database is not due to having done too many recordings or having<br>downloaded too many listings. It's due to not running the mythtv tools<br>that perform automatic database cleanup.
<br><br>In other words, I'm guessing you're using EIT for your guide data and<br>that you never run mythfilldatabase. Running mythfilldatabase<br>"periodically" is mandatory for 0.20-fixes and below (in SVN the cleanup
<br>functionality has been moved to the backend).<br><br>So, my recommendation is to run:<br><br>mythfilldatabase --no-delete<br><br>and it will do all the appropriate cleanup for you. If your database is<br>still "huge", you need to adjust your definition of the word huge.
<br><br>My entire mysql data directory is 190MB, and the mythconverg directory<br>under it is 170MB, and I have 384 programs using 1.4TB of storage. I've<br>been running MythTV for over 3 years and have recorded 5842 programs.
<br>Of the space in use, 120MB is consumed by recordedseek (since 382 of 384<br>recordings are MPEG-2) and 28MB is consumed by romdb.<br><br>You'll likely see similar sizes (scaled for the number of MPEG-2<br>recordings you have) once you run mythfilldatabase. See
<br><a href="http://www.gossamer-threads.com/lists/mythtv/users/269833#269833" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.gossamer-threads.com/lists/mythtv/users/269833#269833</a> (and
<br>the rest of the thread) for more info.<br><br>Mike<br>_______________________________________________
<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
</a><br></blockquote></div><br>
</span></div><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mythtv-users@mythtv.org
</a>
<br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br><br></blockquote>
</div>Craig,<br>I've had myth running since October 2005, my oldrecorded (which appears to hold the programs have been recorded) table has about 5K entries and is using about 1.7 MiB. The total mythconverg DB is using
92.6 MiB. <br><br>Your utilization may be (probably is?) different from mine. But based on the numbers I'm seeing, reducing the number of records in your oldrecorded table probably isn't going to reduce the overall size of the DB by much.
<br><br>If the DB size is _really_ a concern, you may want to install phpmyadmin so you can identify which tables are using all of the space. <br><br><br>Rob<br>