[mythtv-users] database size

[Michael T. Dean]

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).

Mike