From owner-freebsd-performance@FreeBSD.ORG Mon Jun 20 15:05:59 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 564AF16A41C for ; Mon, 20 Jun 2005 15:05:59 +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 26F1C43D1F for ; Mon, 20 Jun 2005 15:05:59 +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 AD70046B1E; Mon, 20 Jun 2005 11:05:58 -0400 (EDT) Date: Mon, 20 Jun 2005 16:08:45 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: David Sze In-Reply-To: <6.2.1.2.2.20050620102441.06372a70@mail.distrust.net> Message-ID: <20050620160522.C26664@fledge.watson.org> References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> <20050611085604.J75625@fledge.watson.org> <20050616161506.GB28794@bibipentium.lonres.com> <6.2.1.2.2.20050617091736.05949298@mail.distrust.net> <20050619165349.U6413@fledge.watson.org> <6.2.1.2.2.20050620102441.06372a70@mail.distrust.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: 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: Mon, 20 Jun 2005 15:05:59 -0000 On Mon, 20 Jun 2005, David Sze wrote: > I'll be re-running super-smack against an InnoDB table. Any additional > requests for configurations to test, or other tweaking suggestions? > > This is what I'll be trying: > > FreeBSD/amd64 4.11-RELEASE, linuxthreads > FreeBSD/amd64 5.4-RELEASE, libpthread > FreeBSD/amd64 5.4-RELEASE, libpthread, process scope > FreeBSD/amd64 6.0-CURRENT, libpthread > FreeBSD/amd64 6.0-CURRENT, libpthread, process scope > FreeBSD/amd64 6.0-CURRENT, libthr, system scope > FreeBSD/amd64 6.0-CURRENT, libthr, process scope > CentOS/amd64 4.0 > > The different threading libraries are more for completeness. In my last > test I saw <10% difference between them on amd64. I realize every additional variation increases the testing load, but I'd be interested in seeing linuxthreads performance on 5.x/6.x also. While we've worked hard to improve native threading, linuxthreading remains fully functional, and given that MySQL may well be being optimized based on assumptions regarding the Linux threading model, it could well be linuxthreads comes in ahead on recent versions. You probably did this in a prior e-mail but I may have missed it -- could you forward me a copy of the 6.x kernel dmesg via private e-mail? Thanks, Robert N M Watson