[mythtv] MySQL database location

[Michael T. Dean]

On 10/17/2007 05:23 PM, Mitch Gore wrote:
> I have my partition layout as so:
>
> [myth at mythtv ~]$ df -h
> Filesystem            Size  Used Avail Use% Mounted on
> /dev/sdb1             6.7G  5.8G  538M  92% /
> tmpfs                 506M     0  506M   0% /dev/shm
> /dev/sdb3             444G  399G   23G  95% /video
> /dev/sda1             111G   92G   14G  88% /video2
>
> I am using storage groups for my recordings and they are in /video and
> /video2.
>
> Over the months of building this box i have noticed my / free space
> shrinking.  I am thinking this is because of my database.  Where is
> the DB actually stored on FC6?
>
> Also,  is there any way to show where the large files are?  Should i
> be concerded about 90% full / partition?  I have always gone by the
> rule of thumb of above 80% you start loosing performance.

The database is /very/ unlikely to be filling up your partition.  The
largest my database has ever gotten was around 400MB and that was with
almost 500 hours (= almost 21 days) of MPEG-2 recordings (almost all of
the space taken up by the DB for Myth will be dedicated to the
seektable--which grows linearly with amount (time) of recorded TV
available to watch, and will be decreased as shows are deleted).  The
rest tends to stay relatively constant in size.

My DB is currently 133MB with 232 hours and 40 minutes (9 2/3 days) of
recorded TV.

I would bet--if it's not data--that it's your log files taking up the
space--specifically, MySQL binary log files.

http://www.gossamer-threads.com/lists/engine?list=mythtv&do=search_results&search_forum=all&search_string=%22binary+log%22

Mike