[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.
Regards
Sid.
--
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