From owner-freebsd-performance@FreeBSD.ORG Wed Jun 29 12:29:51 2005 Return-Path: X-Original-To: performance@FreeBSD.org 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 E216716A41C for ; Wed, 29 Jun 2005 12:29:51 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [204.156.12.53]) by mx1.FreeBSD.org (Postfix) with ESMTP id B688843D48 for ; Wed, 29 Jun 2005 12:29:51 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [204.156.12.50]) by cyrus.watson.org (Postfix) with ESMTP id 42B2546B14; Wed, 29 Jun 2005 08:29:51 -0400 (EDT) Date: Wed, 29 Jun 2005 13:33:56 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: Steve Roome In-Reply-To: <20050623144611.GA64879@bibipentium.lonres.com> Message-ID: <20050629133209.Q74117@fledge.watson.org> References: <6.2.1.2.2.20050620105116.06376688@wheresmymailserver.com> <20050623144611.GA64879@bibipentium.lonres.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: David Sze , performance@FreeBSD.org Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 29 Jun 2005 12:29:52 -0000 On Thu, 23 Jun 2005, Steve Roome wrote: >> The different threading libraries are more for completeness. In my >> last test I saw <10% difference between them on amd64. > > Well, I finally got some tests out for FreeBSD/i386 with -current, Here > we go with a bunch of results of FreeBSD 6 with mysql and different > threading libraries, as for you, there's sadly not enough in it so far. > Maybe I need to tune a whole bunch of stuff I've missed ? What version of MySQL are you using? I saw much better FreeBSD MySQL performance with 4.0.x than 4.1.x in terms of transactions per second, and am wondering what changed in MySQL -- did it start using different IPC primitives, threading primitives, etc? I realize it complicates testing, but if you have a chance to compare 4.0.x and 4.1.x across linux and freebsd, that would be quite helpful, so we can see if there's a change in relative performance. Most of my work to optimize MySQL performance with SMP has been using 4.0.x, FYI, so 4.1.x might require different optimization strategies. Robert N M Watson