From owner-freebsd-questions@FreeBSD.ORG Sat Jan 28 18:49:10 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org 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 3A4EE16A420 for ; Sat, 28 Jan 2006 18:49:10 +0000 (GMT) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5F34B43D6A for ; Sat, 28 Jan 2006 18:49:04 +0000 (GMT) (envelope-from kris@obsecurity.org) Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id 406CA1A3C2B; Sat, 28 Jan 2006 10:49:04 -0800 (PST) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 3E17D51DA0; Sat, 28 Jan 2006 13:49:01 -0500 (EST) Date: Sat, 28 Jan 2006 13:49:01 -0500 From: Kris Kennaway To: Chris Message-ID: <20060128184900.GA25785@xor.obsecurity.org> References: <20060127202202.GA65737@xor.obsecurity.org> <3aaaa3a0601280503t2dc3e92ej@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="OgqxwSJOaUobr8KG" Content-Disposition: inline In-Reply-To: <3aaaa3a0601280503t2dc3e92ej@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Cc: Romeo Theriault , freebsd-questions@freebsd.org, Kris Kennaway Subject: Re: mysql - linuxthreads 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: Sat, 28 Jan 2006 18:49:10 -0000 --OgqxwSJOaUobr8KG Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Jan 28, 2006 at 01:03:31PM +0000, Chris wrote: > On 27/01/06, Kris Kennaway wrote: > > > > On Fri, Jan 27, 2006 at 03:15:05PM -0500, Romeo Theriault wrote: > > > A week or so ago I wrote to the this list asking about Freebsd and > > > Mysql, wondering if you still needed to compile Mysql with > > > linuxthreads to get better performance under Freebsd 6. I didn't get > > > much of a response so I looked around for the answer. I thought I'd > > > write back to the mailing list to tell anyone interested what I found. > > > > Thanks, this is always useful! > > > > > In the Freebsd 6.0 is seems that to get the best MySQL performance > > > you need to do a few things. > > > #compile your kernel with the ULE scheduler > > > > I'd be inclined to doubt this..all my measurements show ULE is slower > > than 4BSD except at negligible load. How did you measure it? > > > > > #use the TSC timecounter > > > #use the libthr threading library with mysql > > > > You definitely want libthr. > > > > Kris > > > > > > > is there large differences between libthr on 6.x and 5.x, I mean is libthr > the best option for 5.x also? I don't know, sorry. You should try it and see - it's easy to switch in using libmap.conf. Kris --OgqxwSJOaUobr8KG Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQFD27ycWry0BWjoQKURApWaAJwJAaNl74jiYbQzLEsiBXjRCFaIIACeKemO cBNJq9ZDvjIdaP7gLYbVPCM= =/FEA -----END PGP SIGNATURE----- --OgqxwSJOaUobr8KG--