From owner-freebsd-questions@FreeBSD.ORG Sun Mar 7 02:05:18 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EBCF516A4CE for ; Sun, 7 Mar 2004 02:05:18 -0800 (PST) Received: from mail.ngdc.net (mail.ngdc.net [195.190.153.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id B878F43D1F for ; Sun, 7 Mar 2004 02:05:18 -0800 (PST) (envelope-from laursen@netgroup.dk) Received: from animal (cpe.atm2-0-105244.0x3ef2379f.odnxx3.customer.tele.dk [62.242.55.159]) (AUTH: LOGIN laursen@solidcore.dk) by bunsen.solidcore.dk with esmtp; Sun, 07 Mar 2004 11:05:16 +0100 Message-ID: <012601c4042b$add94a20$0a01a8c0@animal> From: "Lasse Laursen" To: mysql@lists.mysql.com, freebsd-questions@freebsd.org Date: Sun, 7 Mar 2004 11:05:10 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Subject: MySQL and FreeBSD 5.x - Using LinuxThreads or not? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 07 Mar 2004 10:05:19 -0000 Hi all, We are about to upgrade one of our database servers to a Dual Xeon machine with HT. We have been testing FreeBSD 5.x for 6-7 months on a Uniprocessor box and we haven't had any problems with the platform. We would like to use FreeBSD 5 on our new database server since the SMP support is superior in the new release compared to the 4.x branch. I did some reading on the topic at Jeremy Zawodny's website: http://jeremy.zawodny.com/blog/archives/000697.html and he suggests that the best solution is to use LinuxThreads when compiling MySQL under FreeBSD. His initial article covered FreeBSD 4.x - http://jeremy.zawodny.com/blog/archives/000203.html Have any of you had any experience with stability/performance under FreeBSD 5.x and MySQL 4.0.x? Should the LinuxThread library still be used when compiling for maximum performance or has the problems been solved in Regards -- Lasse Laursen · VP, Hosting Technology · NetGroup A/S St. Kongensgade 40H · DK-1264 Copenhagen K, Denmark Phone: +45 3370 1526 · Fax: +45 3313 0066 - Don't be fooled by cheap finnish imitations - BSD is the One True Code