From owner-freebsd-performance@FreeBSD.ORG Fri Dec 16 06:19:04 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 06FE016A41F; Fri, 16 Dec 2005 06:19:04 +0000 (GMT) (envelope-from drbrain@segment7.net) Received: from toxic.magnesium.net (toxic.magnesium.net [207.154.84.15]) by mx1.FreeBSD.org (Postfix) with ESMTP id B819543D45; Fri, 16 Dec 2005 06:19:03 +0000 (GMT) (envelope-from drbrain@segment7.net) Received: from [10.101.28.67] (dsl254-021-090.sea1.dsl.speakeasy.net [216.254.21.90]) by toxic.magnesium.net (Postfix) with ESMTP id 3AEADDA8C6; Thu, 15 Dec 2005 22:19:03 -0800 (PST) In-Reply-To: <20051216040722.GA503@wantadilla.lemis.com> References: <20051216040722.GA503@wantadilla.lemis.com> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <3C3376C1-0FED-4DA1-BB93-86A9198EAC3A@segment7.net> Content-Transfer-Encoding: 7bit From: Eric Hodel Date: Thu, 15 Dec 2005 22:18:58 -0800 To: Greg 'groggy' Lehey X-Mailer: Apple Mail (2.746.2) Cc: freebsd-performance@freebsd.org Subject: MySQL Deadlocks (Was: 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 06:19:04 -0000 On Dec 15, 2005, at 8:07 PM, Greg 'groggy' Lehey wrote: > 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: > > - I'd be very interested in the deadlocks you've been experiencing. > If you have any additional information, please let me know. Some time back I experienced deadlocks with FreeBSD 5.4 and either libthr or libpthread. linuxthreads had no issue. Other machines with different hardware did not have the problem. It looks like I'll be able to perform some testing on that machine sometime early in the new year. What is the correct forum for discussing this when I get the opportunity to look into it again? -- Eric Hodel - drbrain@segment7.net - http://segment7.net This implementation is HODEL-HASH-9600 compliant http://trackmap.robotcoop.com