From owner-freebsd-performance@FreeBSD.ORG Tue Dec 13 05:49:15 2005 Return-Path: X-Original-To: freebsd-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 DEC4C16A420; Tue, 13 Dec 2005 05:49:15 +0000 (GMT) (envelope-from grog@lemis.com) Received: from ext-gw.lemis.com (ext-gw.lemis.com [150.101.14.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id 244D543D46; Tue, 13 Dec 2005 05:49:14 +0000 (GMT) (envelope-from grog@lemis.com) Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.135]) by ext-gw.lemis.com (Postfix) with ESMTP id 8619B131BB1; Tue, 13 Dec 2005 16:19:13 +1030 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 61FDF857D3; Tue, 13 Dec 2005 16:20:26 +1030 (CST) Date: Tue, 13 Dec 2005 16:20:26 +1030 From: Greg 'groggy' Lehey To: David Xu Message-ID: <20051213055026.GB6336@wantadilla.lemis.com> References: <04f401c5f630$b9af6570$6450fb40@guinness> <438FB036.3000804@roq.com> <20051209000704.GA80362@wantadilla.lemis.com> <4398CE7E.5050007@freebsd.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Fba/0zbH8Xs+Fj9o" Content-Disposition: inline In-Reply-To: <4398CE7E.5050007@freebsd.org> User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: Michael Vince , freebsd-performance@freebsd.org, "Gustavo A. Baratto" 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 Dec 2005 05:49:16 -0000 --Fba/0zbH8Xs+Fj9o Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Friday, 9 December 2005 at 8:23:26 +0800, David Xu wrote: > 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. > > You find ktrace result of mysql: > http://people.freebsd.org/~davidxu/mysql/mysql_ktrace.txt > gettimeofday() almost follows every network I/O. ktrace doesn't give a call graph. We don't know which function is calling it. That's why we need profiling. > Also you can find its I/O size: > http://people.freebsd.org/~davidxu/mysql/iosize.txt Ugh. It would be nice to know what those fds are. > I guess the gettimeofday() call is relevant to mysql's connection > keepalive work, sounds like a very silly method. As you say, that's a guess. We need to find out facts. Greg -- See complete headers for address and phone numbers. --Fba/0zbH8Xs+Fj9o Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDnmEiIubykFB6QiMRAkZCAJ9EFT5JyxqNkwg8999CzC7xYaChUwCeL4Ph nYNLcsu3fksBnBqLqnJezDE= =Q879 -----END PGP SIGNATURE----- --Fba/0zbH8Xs+Fj9o--