[mythtv] MySQL database location

Sid Boyce sboyce at blueyonder.co.uk
Thu Oct 18 20:35:24 UTC 2007

Mitch Gore wrote:
> Hi,
> 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?
"rpm -ql mysql" should show you the files and locations for mysql. On 
openSUSE here, the mythtv database is /var/lib/mysql/mythconverg. I 
haven't got mysql installed in Fedora currently.

> 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.
> Thanks,
> Mitchell
More like running out of disk space rather than losing performance. It 
depends on how much you intend to store and to keep, 23G would be enough 
for me.

Sid Boyce ... Hamradio License G3VBV, Licensed Private Pilot
Emeritus IBM/Amdahl Mainframes and Sun/Fujitsu Servers Tech Support 
Specialist, Cricket Coach
Microsoft Windows Free Zone - Linux used for all Computing Tasks

More information about the mythtv-dev mailing list