From owner-freebsd-performance@FreeBSD.ORG Fri Dec 16 04:07:24 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 D8D6816A41F for ; Fri, 16 Dec 2005 04:07:24 +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 3295A43D58 for ; Fri, 16 Dec 2005 04:07:23 +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 44E26131D83; Fri, 16 Dec 2005 14:37:22 +1030 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 1DC14857EC; Fri, 16 Dec 2005 14:37:22 +1030 (CST) Date: Fri, 16 Dec 2005 14:37:22 +1030 From: Greg 'groggy' Lehey To: huang leo Message-ID: <20051216040722.GA503@wantadilla.lemis.com> References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="oyUTqETQ0mS9luUI" Content-Disposition: inline In-Reply-To: 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 Subject: Re: Benchmark MySQL Performance On FreeBSD And 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, 16 Dec 2005 04:07:25 -0000 --oyUTqETQ0mS9luUI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Friday, 16 December 2005 at 11:20:12 +0800, huang leo wrote: > > We had evaluated MySQL performance on FreeBSD and Linux. The result is > attached. Thank you! This is some of the most plausible information I've seen in a while. I'm forwarding it to a MySQL internal list, and I expect we'll discuss it in much detail. A few comments: - You refer to bug http://bugs.mysql.com/bug.php?12251. Did you experience these crashes yourself? If you look through that bug report, you'll find that we (MySQL) have had great difficulty reproducing the problem. Many people have reported that they have no trouble under the same conditions, and we were half thinking it might be related to (but not the fault of) the hardware in question. Your hardware is very different, so it would help us a lot if you're also able to reproduce it. - There's been a lot of discussion on the FreeBSD lists recently suggesting that the performance problems are related to the choice of timer. I've never been convinced, and your results suggest to me that this isn't the real problem. Still, it would be nice to compare the results using various timer options. If you haven't been following the discussion, it's in the archives for the FreeBSD-current mailing list. Let me know (in private mail) if you'd like me to forward them to you. - I'd be very interested in the deadlocks you've been experiencing. If you have any additional information, please let me know. Do you have scripts for these tests? I appreciate that the information is mainly there, but it would be easier for us if the scripts are available. Thanks again for the report Greg -- See complete headers for address and phone numbers. --oyUTqETQ0mS9luUI Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDoj16IubykFB6QiMRAo+4AKCTe8j9jTkxBG4IzkkovWWmGqUwWQCdHgNu R3fSoeS76/nH4lDIi14u4LQ= =02Md -----END PGP SIGNATURE----- --oyUTqETQ0mS9luUI--