From owner-freebsd-database@FreeBSD.ORG  Sat Jul  1 11:44:29 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 58EEA16A403
	for <freebsd-database@freebsd.org>;
	Sat,  1 Jul 2006 11:44:29 +0000 (UTC)
	(envelope-from maikel.lambregts@yahoo.com)
Received: from web52205.mail.yahoo.com (web52205.mail.yahoo.com
	[206.190.48.128])
	by mx1.FreeBSD.org (Postfix) with SMTP id D277A43D7B
	for <freebsd-database@freebsd.org>;
	Sat,  1 Jul 2006 11:44:28 +0000 (GMT)
	(envelope-from maikel.lambregts@yahoo.com)
Received: (qmail 51389 invoked by uid 60001); 1 Jul 2006 11:44:28 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=K1o66PVGK8Ipgqea+FaoR88j3QrCITH+hCD6d+QME5/phwlciCCE6su3Lyu+xv91t6SkFCi3JPUPHhb4DjmWbnEelwKv9tbna/pN5kDVs+BsTCIWK9He0mGh54ghtzX1UJXOVNkOWsAQe0/9gdzftn4abfTt0oo36RL3OOqRfqY=
	; 
Message-ID: <20060701114428.51387.qmail@web52205.mail.yahoo.com>
Received: from [84.24.236.21] by web52205.mail.yahoo.com via HTTP;
	Sat, 01 Jul 2006 04:44:28 PDT
Date: Sat, 1 Jul 2006 04:44:28 -0700 (PDT)
From: Maikel Lambregts <maikel.lambregts@yahoo.com>
To: freebsd-database@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: MySQL and FreeBSD
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 01 Jul 2006 11:44:29 -0000

Hi,
   
  I saw your information on http://lists.freebsd.org/pipermail/freebsd-database/2006-January/000386.html

Atm we still have and olf MySQL server with FreeBSD 4.8 and MySQL 4.0 running with Linuxthreads. We now bought a new Dell server (Dual Xeon 2.8, 4GB ram, 15.000 SCSI RAID 1) and I'm wondering what would be the best to install MySQL.

I was thinking of FreeBSD 6.1 in combination with MySQL 5.0. I was thinking of using your advice by using native threads instead of Linuxthreads and furthermore I just would copy your build options -->

'WITH_CHARSET=utf8',
'WITH_XCHARSET=all',
'WITH_COLLATION=utf8_general_ci',
'WITH_PROC_SCOPE_PTH=yes',
'BUILD_OPTIMIZED=yes',
'BUILD_STATIC=yes',

Is this still the best configuration according to you?
Do you have exact copy of my.cnf file for me that you use?

Regards,
   
  Mike