On Wed, Apr 2, 2008 at 8:25 PM, Michael T. Dean <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On 04/02/2008 12:31 AM, Frank Lynch wrote:<br>
> I've got a reasonable amount of tv/video but not that much. When I view the<br>
> db using your method its:<br>
> -rw-rw---- 1 mysql mysql 24M 2008-04-01 23:56 recordedseek.MYI<br>
> -rw-rw---- 1 mysql mysql 21M 2008-04-01 23:30 recordedseek.MYD<br>
> -rw-rw---- 1 mysql mysql 4.2M 2008-04-01 22:55 music_songs.MYD<br>
> -rw-rw---- 1 mysql mysql 2.7M 2008-04-01 22:55 music_songs.MYI<br>
> -rw-rw---- 1 mysql mysql 220K 2008-04-01 17:21 music_albums.MYD<br>
> -rw-rw---- 1 mysql mysql 163K 2008-04-01 22:53 music_directories.MYD<br>
> -rw-rw---- 1 mysql mysql 144K 2008-04-01 17:21 music_albums.MYI<br>
> -rw-rw---- 1 mysql mysql 108K 2008-04-01 17:21 music_playlists.MYD<br>
> -rw-rw---- 1 mysql mysql 100K 2008-04-01 17:21 music_artists.MYI<br>
> -rw-rw---- 1 mysql mysql 76K 2008-04-01 17:21 music_artists.MYD<br>
> -rw-rw---- 1 mysql mysql 35K 2008-04-01 23:56 music_directories.MYI<br>
> -rw-rw---- 1 mysql mysql 35K 2008-04-01 21:39 nestitle.MYD<br>
> -rw-rw---- 1 mysql mysql 21K 2008-04-01 21:39 nestitle.MYI<br>
> -rw-rw---- 1 mysql mysql 15K 2008-04-01 23:56 displayprofiles.MYI<br>
> -rw-rw---- 1 mysql mysql 11K 2008-04-02 00:03 record.frm<br>
> -rw-rw---- 1 mysql mysql 10K 2008-04-02 00:03 record_tmp.frm<br>
><br>
<br>
</div>Yep. That's actually a pretty small DB, so you shouldn't have any<br>
issues. You'll probably find your DB backups are <200MB uncompressed<br>
and <35MB compressed with gzip (I'd guess ~150MB and 25MB).<br>
<br>
Also, as it seems that Myth has just deleted a large amount of data,<br>
your indices are unbalanced (the MYI shouldn't be larger than the MYD,<br>
so that's a good indication that the indices need redone). You may want<br>
to consider running optimize_mythdb.pl (though, IIRC, I think<br>
MythBuntu--I'm guessing that's what Ubuntu you're running--has it set up<br>
to run automatically, so it may have already run today since you posted<br>
this).</blockquote><div><br>Thanks again Mike,<br> I'm actually running vanilla gutsy here, rather than mythbuntu. So I'll be sure to add the optimize script as a nightly cron job.<br>cheers,<br>--Frank<br></div>
</div>