FreeBSD Port: mysql-server-4.0.20
derwood at naebunny.net
Wed Jul 14 05:02:18 PDT 2004
Christoph Bodner wrote:
> Dear package-maintainers of the MySQL-server!
> I would like to inform you of a potential problem when using
> "/var/db/mysql" as the data folder. Usually in a standard
> installation, during slicing and partitioning the disk layout, "/var"
> belongs to partition "e", which is, e.g., only 256 MB large as
> opposed to partition "g" which can hold many GigaBytes. The
> folllowing listing is a "df" output of my server:
> Filesystem 1K-blocks Used Avail Capacity Mounted on
> /dev/ar0s1a 128990 47748 70924 40% /
> /dev/ar0s1f 257998 8 237352 0% /tmp
> /dev/ar0s1g 77123102 27117646 43835608 38% /usr
> /dev/ar0s1e 257998 1034 236326 0% /var
> procfs 4 4 0 100% /proc
> Therefore, I am forced to reconfigure this for a real-world-mission
> where MySQL tables require much more space than reservered for
> partition "e". Maybe, "/usr/home/mysql" or "/usr/local/mysql" would be
> a better location for the data dictionary of MySQL.
> Kind regards,
> Christoph Bodner
> Innsbruck (Austria)
> freebsd-ports at freebsd.org mailing list
> To unsubscribe, send any mail to "freebsd-ports-unsubscribe at freebsd.org"
Why reconfigure anything? Since you have all that free space in /usr
that will never be used, make a "/usr/home/mysql" or "/usr/local/mysql"
as you mention above and then make a symbolic link to one of those from
/var/db/mysql That will keep you from having to re-partition and
More information about the freebsd-ports