From owner-freebsd-performance@FreeBSD.ORG Sat Feb 19 16:53:14 2005 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A649E16A4CE for ; Sat, 19 Feb 2005 16:53:14 +0000 (GMT) Received: from cyrus.watson.org (cyrus.watson.org [204.156.12.53]) by mx1.FreeBSD.org (Postfix) with ESMTP id 463DB43D48 for ; Sat, 19 Feb 2005 16:53:14 +0000 (GMT) (envelope-from robert@fledge.watson.org) Received: from fledge.watson.org (fledge.watson.org [204.156.12.50]) by cyrus.watson.org (Postfix) with SMTP id A186546B23; Sat, 19 Feb 2005 11:53:13 -0500 (EST) Date: Sat, 19 Feb 2005 16:51:43 +0000 (GMT) From: Robert Watson X-Sender: robert@fledge.watson.org To: Bosko Milekic In-Reply-To: <20050219162944.GA96337@technokratis.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: performance@freebsd.org Subject: Re: libpthread vs libthread, simply mysql benchmark X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 19 Feb 2005 16:53:14 -0000 On Sat, 19 Feb 2005, Bosko Milekic wrote: > > As of today, I get about 8400tps with HTT turned on, probably a bit > > betterwith it turned off. By combining various factors we've introduced > > in the last couple of years, such as MPSAFE network stack, scheduling > > improvements, threading improvements, mutex changes, etc, we've improved > > performance on mysql by over 100% on SMP, going from quite sub-par > > performance in the depths of 5.x development (when all the infrastructure > > changes were going in but no optimizations) to quite healthy in 6.x, > > especially with the new threading library. > > For reference, do you have numbers from RELENG_4? Unfortunately, not for this box. I hope to get a chance to run the tests against a handy dual PIII with 4.x, 5.x, and 6.x in the next couple of days. Just as an FYI to those wanting to give this a spin -- to test with libthread on 6.x, you'll need a copy of MySQL linked against libc.so.6 so it can get to the _umtx_op symbol, which is not currently present in a 5.x libc. This basically translates to meaning: you'll need a package/port of MySQL built against 6.x to test with libthread. The package on ftp.FreeBSD.org worked fine for me. Robert N M Watson