From owner-freebsd-performance@FreeBSD.ORG Fri Dec 9 00:06:13 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 62C6C16A41F for ; Fri, 9 Dec 2005 00:06:13 +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 138D443D73 for ; Fri, 9 Dec 2005 00:06:05 +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 0A598131D4A; Fri, 9 Dec 2005 10:36:04 +1030 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 50FC1857BE; Fri, 9 Dec 2005 10:37:04 +1030 (CST) Date: Fri, 9 Dec 2005 10:37:04 +1030 From: Greg 'groggy' Lehey To: Michael Vince Message-ID: <20051209000704.GA80362@wantadilla.lemis.com> References: <04f401c5f630$b9af6570$6450fb40@guinness> <438FB036.3000804@roq.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="6TrnltStXW4iwmi0" Content-Disposition: inline In-Reply-To: <438FB036.3000804@roq.com> 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: 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: Fri, 09 Dec 2005 00:06:13 -0000 --6TrnltStXW4iwmi0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Friday, 2 December 2005 at 13:23:50 +1100, Michael Vince wrote: > It would be good to actually see the Linux performance on the exact same > hardware, all we ever see is how it is on FreeBSD. > > MySQL has very frequent use of queries of the system time and is > well known in FreeBSD to be slower because its more expensive to > call compared to Linux, which has less precision time. 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. --6TrnltStXW4iwmi0 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDmMqoIubykFB6QiMRAuF7AJ9E+LWKJQdU7dyKNqAiudj7423pVQCfZsh1 pHccrBQstu500DFvWAMLdTk= =vWLz -----END PGP SIGNATURE----- --6TrnltStXW4iwmi0--