ports/69399: mysql-server ports use ridiculous layout

[Dan Mahoney]

>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 at 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: