Date: Wed, 21 Jul 2004 20:10:03 -0400 (EDT) From: Dan Mahoney <danm@prime.gushi.org> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/69399: mysql-server ports use ridiculous layout Message-ID: <200407220010.i6M0A3sv028447@prime.gushi.org> Resent-Message-ID: <200407220000.i6M00fsp019581@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 69399 >Category: ports >Synopsis: mysql-server ports use ridiculous layout >Confidential: no >Severity: serious >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Thu Jul 22 00:00:41 GMT 2004 >Closed-Date: >Last-Modified: >Originator: Dan Mahoney >Release: FreeBSD 4.9-RELEASE-p4 i386 >Organization: Gushi Systems >Environment: System: FreeBSD prime.gushi.org 4.9-RELEASE-p4 FreeBSD 4.9-RELEASE-p4 #0: Thu Mar 18 21:12:47 EST 2004 danm@prime.gushi.org:/usr/obj/usr/src/sys/PRIME49 i386 Any base install of FreeBSD with ports. >Description: FreeBSD by default installs a very small /var partition for the user. This small partition is used not only for mail, and logs (both of which can grow on occasion without warning), but the mysql-server port uses this location as the default location for all databases. Additionally, the /var/tmp directory is used >How-To-Repeat: cd /usr/ports/mysql40-server make install let logs and/or mail run for a while (especially easy if you've also installed apache from ports), as the apache logs are written to /var/log with no rotation. Watch your tables corrupt themselves and mysql die with error 28 from the table handler. >Fix: The "fix" is something like: mkdir /usr/var cd /var cp db /usr/var ln -s /usr/var/db cp tmp /usr/var ln -s /usr/var/tmp However, it's generally my opinion that at least a WARNING or something should be printed, as the default table types (especially InnoDB) tend to grow by fairly large increments. Either an alternate location needs to be found for "big" semi-permanent files (/var is for mainly transient files -- it's not supposed to be a huge earth-shattering disaster if you lose /var), or that partition needs to be defaulted to something a lot bigger. >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200407220010.i6M0A3sv028447>