From owner-freebsd-performance@FreeBSD.ORG  Fri Dec  9 00:23:03 2005
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by hub.freebsd.org (Postfix) with ESMTP id B860416A41F;
	Fri,  9 Dec 2005 00:23:02 +0000 (GMT)
	(envelope-from davidxu@freebsd.org)
Message-ID: <4398CE7E.5050007@freebsd.org>
Date: Fri, 09 Dec 2005 08:23:26 +0800
From: David Xu <davidxu@freebsd.org>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US;
	rv:1.7.10) Gecko/20050806
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Greg 'groggy' Lehey <grog@FreeBSD.org>
References: <04f401c5f630$b9af6570$6450fb40@guinness>	<438FB036.3000804@roq.com>
	<20051209000704.GA80362@wantadilla.lemis.com>
In-Reply-To: <20051209000704.GA80362@wantadilla.lemis.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Michael Vince <mv@roq.com>, freebsd-performance@freebsd.org,
	"Gustavo A. Baratto" <gbaratto@superb.net>
Subject: Re: new benchmarks. WAS: 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 <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 09 Dec 2005 00:23:03 -0000

Greg 'groggy' Lehey wrote:

>I've heard this claim again and again, and I intend to look at it when
>I have time.  I find it difficult to believe that this alone could
>explain the sometimes horrendous performance differences (3 to 1) that
>have been reported.
>
>Can somebody tell me:
>
>1.  How many calls there are per second?
>2.  Where they're coming from?  This would involve profiling, of
>    course.
>
>Greg
>--
>See complete headers for address and phone numbers.
>  
>
You find ktrace result of mysql:
http://people.freebsd.org/~davidxu/mysql/mysql_ktrace.txt
gettimeofday() almost follows every network I/O.

Also you can find its I/O size:
http://people.freebsd.org/~davidxu/mysql/iosize.txt

I guess the gettimeofday() call is relevant to mysql's
connection keepalive work, sounds like a very silly method.

David Xu