From owner-freebsd-current@FreeBSD.ORG Thu Oct 27 13:57:14 2005 Return-Path: X-Original-To: current@freebsd.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 082B616A41F for ; Thu, 27 Oct 2005 13:57:14 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id B032343D45 for ; Thu, 27 Oct 2005 13:57:13 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [209.31.154.41]) by cyrus.watson.org (Postfix) with ESMTP id B26AB46B42; Thu, 27 Oct 2005 09:57:10 -0400 (EDT) Date: Thu, 27 Oct 2005 14:57:10 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: Greg 'groggy' Lehey In-Reply-To: <20051027074229.GA825@eucla.lemis.com> Message-ID: <20051027145435.H32255@fledge.watson.org> References: <435F48DA.6060009@kernel32.de> <20051026105411.L32255@fledge.watson.org> <20051027074229.GA825@eucla.lemis.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: current@freebsd.org, Marian Hettwer Subject: Re: MySQL Performance 6.0rc1 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 27 Oct 2005 13:57:14 -0000 On Thu, 27 Oct 2005, Greg 'groggy' Lehey wrote: > This would be interesting to know, doubtless, but please note that MySQL > 4.0 is either no longer supported or will reach that status in the > immediate future. It would be more interesting to see what the > performance difference is between Linux and FreeBSD with MySQL 5.0, > which has just been released. > > If you find reasons to believe that any problems you're seeing are a > MySQL problem, please let me know. I'm not certain it's a "MySQL Problem" so much as a set of changes that happen to be less optimal on FreeBSD than Linux. It could even be a bugfix that makes MySQL more correct :-). However, the differential change is interesting, and it would be useful (if nothing else) to compare system call activity between the two versions for the same load and see if there's anything obvious (like lots more calls to sync data, or changing select model, or...) As I said, I haven't had time to investigate much lately, but hope to get back to MySQL investigation in the next few weeks or month. It would be quite useful to know more about the changes between 4.0 and 4.1, and I don't doubt there's a release page somewhere that would tell me. Robert N M Watson