From owner-freebsd-questions@FreeBSD.ORG Wed Feb 28 16:00:17 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 59BE216A400 for ; Wed, 28 Feb 2007 16:00:17 +0000 (UTC) (envelope-from david.robillard@gmail.com) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228]) by mx1.freebsd.org (Postfix) with ESMTP id 1B97913C428 for ; Wed, 28 Feb 2007 16:00:17 +0000 (UTC) (envelope-from david.robillard@gmail.com) Received: by nz-out-0506.google.com with SMTP id r28so191521nza for ; Wed, 28 Feb 2007 08:00:16 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition; b=kcmtXEocbzWx8ymBaItjuLMrRrqCLrrxjVuTi/jkKiN2SJ1/I1urBUSDpFghvPkUnoKwHq957xZFWOaWehRI7ghDl6WU+zH+jGcfj3OnINScCKJJt9rF2XP2/zuhFGrvJ2QEq/fb1qRGW/1zj9aC6lC3F3SOroasfrM21oJPsnE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition; b=dZeO34jBLJe8xnk1m4F9ISr3scDdqif9Y4h+cGqXmTvYsl/lmDu7a1pKbAIezdlIAimb4O9iAxz8+wdDFFduybGsKv7capfRb+u5epZa8iFcAifHh09hkXHyePEgW3jtmuJNDDqqjDek1WUUvKniJyMFbjpQMivpj8/hzTSj+sc= Received: by 10.64.150.18 with SMTP id x18mr1184812qbd.1172678415847; Wed, 28 Feb 2007 08:00:15 -0800 (PST) Received: by 10.64.210.7 with HTTP; Wed, 28 Feb 2007 08:00:15 -0800 (PST) Message-ID: <226ae0c60702280800s2972ed82q1c540e6d8daf57a5@mail.gmail.com> Date: Wed, 28 Feb 2007 11:00:15 -0500 From: "David Robillard" To: "FreeBSD Questions" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: patrick Subject: Re: mysql50-server on FreeBSD 6.2 w/ LINUX_THREADS? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Feb 2007 16:00:17 -0000 > Is it still advisable to build the mysql50-server on FreeBSD 6.2 using > the LINUX_THREADS option? I'm using the SMP kernel on an older dual > 1.0GHz Pentium III. This page > suggests that the libthr library in FreeBSD 6.x is optimized for MySQL > and perhaps better than using linuxthreads. > > Any thoughts? Hi Patrick, We're running several MySQL databases on FreeBSD 6.1 and 6.2 RELEASE and we don't use LINUX_THREADS. So far so good as they say. Concerning MySQL performance on FreeBSD, I recently saw this article which could be of interest to you: Linux vs FreeBSD using mysql and sysbench http://jeffr-tech.livejournal.com/5705.html Aside from a potential holy flame war from FreeBSD vs Linux, this article does present you with an interesting my.cnf configuration file. Maybe that could interest you? Have fun, David -- David Robillard UNIX systems administrator & Oracle DBA CISSP, RHCE & Sun Certified Security Administrator Montreal: +1 514 966 0122