From owner-freebsd-threads@FreeBSD.ORG Fri Jan 19 20:04:05 2007 Return-Path: X-Original-To: threads@freebsd.org Delivered-To: freebsd-threads@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 60E3116A402 for ; Fri, 19 Jan 2007 20:04:05 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from bay0-omc1-s16.bay0.hotmail.com (bay0-omc1-s16.bay0.hotmail.com [65.54.246.88]) by mx1.freebsd.org (Postfix) with ESMTP id 4EC4913C442 for ; Fri, 19 Jan 2007 20:04:05 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from hotmail.com ([65.55.138.83]) by bay0-omc1-s16.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 19 Jan 2007 11:52:05 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 19 Jan 2007 11:52:05 -0800 Message-ID: Received: from 65.55.138.123 by by133fd.bay133.hotmail.msn.com with HTTP; Fri, 19 Jan 2007 19:52:00 GMT X-Originating-IP: [68.192.174.20] X-Originating-Email: [gordon_s_smith@hotmail.com] X-Sender: gordon_s_smith@hotmail.com From: "Gordon Smith" To: threads@freebsd.org Date: Fri, 19 Jan 2007 14:52:00 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 19 Jan 2007 19:52:05.0288 (UTC) FILETIME=[4B845280:01C73C03] X-Mailman-Approved-At: Mon, 22 Jan 2007 05:05:31 +0000 Cc: Subject: Recommended MySQL 4.1 Installation X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Jan 2007 20:04:05 -0000 Now that FreeBSD 6.2 is out, can anyone recommend specific configurations for FBSD and MySQL V.4.1 that deliver a really stable and fast (emphasizing stable) DB platform on 6.2? In the absence of such, info about 6.1 would also be greatly appreciated. Would I need to compile a specific threading library into FreeBSD to avoid panics or other problems that may occur under high load? I'm happy to RTFM on this. The last really good info I remember seeing about this (specifically about FBSD and MySQL) was from: - Jeremy Zawodny's blog entry http://jeremy.zawodny.com/blog/archives/000697.html - the mysql.com doc page http://dev.mysql.com/doc/refman/4.1/en/freebsd.html I would be willing to sacrifice some reasonable degree of performance for stability (if needed), so I want to be careful here. Running the Linux compatability layer is an option, if needed - I'm not sure if the Linux compatability layer is needed to support Linux threads (if Linux threads are the best choice of threading library to use with MySQL). Has anyone done recent benchmarks to compare threading libraries? Anyone have any contacts in MySQL AG that might be able provide suggestions? If I've missed some obvious documentation, I apologize in advance. Thank you. Gordon Smith