[mythtv-users] database size

[Frank Lynch]

On Wed, Apr 2, 2008 at 8:25 PM, Michael T. Dean <mtdean at thirdcontact.com>
wrote:

> On 04/02/2008 12:31 AM, Frank Lynch wrote:
> > I've got a reasonable amount of tv/video but not that much. When I view
> the
> > db using your method its:
> > -rw-rw---- 1 mysql mysql  24M 2008-04-01 23:56 recordedseek.MYI
> > -rw-rw---- 1 mysql mysql  21M 2008-04-01 23:30 recordedseek.MYD
> > -rw-rw---- 1 mysql mysql 4.2M 2008-04-01 22:55 music_songs.MYD
> > -rw-rw---- 1 mysql mysql 2.7M 2008-04-01 22:55 music_songs.MYI
> > -rw-rw---- 1 mysql mysql 220K 2008-04-01 17:21 music_albums.MYD
> > -rw-rw---- 1 mysql mysql 163K 2008-04-01 22:53 music_directories.MYD
> > -rw-rw---- 1 mysql mysql 144K 2008-04-01 17:21 music_albums.MYI
> > -rw-rw---- 1 mysql mysql 108K 2008-04-01 17:21 music_playlists.MYD
> > -rw-rw---- 1 mysql mysql 100K 2008-04-01 17:21 music_artists.MYI
> > -rw-rw---- 1 mysql mysql  76K 2008-04-01 17:21 music_artists.MYD
> > -rw-rw---- 1 mysql mysql  35K 2008-04-01 23:56 music_directories.MYI
> > -rw-rw---- 1 mysql mysql  35K 2008-04-01 21:39 nestitle.MYD
> > -rw-rw---- 1 mysql mysql  21K 2008-04-01 21:39 nestitle.MYI
> > -rw-rw---- 1 mysql mysql  15K 2008-04-01 23:56 displayprofiles.MYI
> > -rw-rw---- 1 mysql mysql  11K 2008-04-02 00:03 record.frm
> > -rw-rw---- 1 mysql mysql  10K 2008-04-02 00:03 record_tmp.frm
> >
>
> Yep.  That's actually a pretty small DB, so you shouldn't have any
> issues.  You'll probably find your DB backups are <200MB uncompressed
> and <35MB compressed with gzip (I'd guess ~150MB and 25MB).
>
> Also, as it seems that Myth has just deleted a large amount of data,
> your indices are unbalanced (the MYI shouldn't be larger than the MYD,
> so that's a good indication that the indices need redone).  You may want
> to consider running optimize_mythdb.pl (though, IIRC, I think
> MythBuntu--I'm guessing that's what Ubuntu you're running--has it set up
> to run automatically, so it may have already run today since you posted
> this).


Thanks again Mike,
 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.
cheers,
--Frank
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080402/fa310514/attachment.htm