From owner-freebsd-ports@FreeBSD.ORG Wed Jul 14 12:02:18 2004 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 88EA816A4CE for ; Wed, 14 Jul 2004 12:02:18 +0000 (GMT) Received: from bsd.naebunny.net (adsl-67-38-156-22.dsl.dytnoh.ameritech.net [67.38.156.22]) by mx1.FreeBSD.org (Postfix) with ESMTP id 45F5243D45 for ; Wed, 14 Jul 2004 12:02:18 +0000 (GMT) (envelope-from derwood@naebunny.net) Received: from [192.168.0.246] (unknown [192.168.0.246]) with ESMTP id 8AA5E2AD09 for ; Wed, 14 Jul 2004 08:02:16 -0400 (EDT) Message-ID: <40F520CC.4030703@naebunny.net> Date: Wed, 14 Jul 2004 08:02:20 -0400 From: Darin User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: ports@FreeBSD.org References: <71A4E938-D562-11D8-83F0-000A958EC5D6@chello.at> In-Reply-To: <71A4E938-D562-11D8-83F0-000A958EC5D6@chello.at> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: FreeBSD Port: mysql-server-4.0.20 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Jul 2004 12:02:18 -0000 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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-ports > To unsubscribe, send any mail to "freebsd-ports-unsubscribe@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 reinstall things. Darin -