MySQL Deadlocks (Was: Re: Benchmark MySQL Performance On FreeBSD And Linux)

To: Greg 'groggy' Lehey <grog@xxxxxxxxxxx>
Subject: MySQL Deadlocks (Was: Re: Benchmark MySQL Performance On FreeBSD And Linux)
From: Eric Hodel <drbrain@xxxxxxxxxxxx>
Date: Thu, 15 Dec 2005 22:18:58 -0800
Cc: freebsd-performance@xxxxxxxxxxx
Delivered-to: freebsd-performance@xxxxxxxxxxx
In-reply-to: <20051216040722.GA503@xxxxxxxxxxxxxxxxxxxx>
List-archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-id: Performance/tuning <freebsd-performance.freebsd.org>
List-post: <mailto:freebsd-performance@freebsd.org>
List-subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>, <mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
List-unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>, <mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
References: <a0cd7c070512151920s67ca6cd6h@xxxxxxxxxxxxxx> <20051216040722.GA503@xxxxxxxxxxxxxxxxxxxx>

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. Theresult 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 eitherlibthr or libpthread. linuxthreads had no issue. Other machineswith different hardware did not have the problem.

It looks like I'll be able to perform some testing on that machinesometime early in the new year. What is the correct forum fordiscussing this when I get the opportunity to look into it again?


--
Eric Hodel - drbrain@xxxxxxxxxxxx - http://segment7.net
This implementation is HODEL-HASH-9600 compliant

http://trackmap.robotcoop.com

Follow-Ups:
- Re: MySQL Deadlocks (Was: Re: Benchmark MySQL Performance On FreeBSD And Linux)
  - From: Greg 'groggy' Lehey

References:
- Benchmark MySQL Performance On FreeBSD And Linux
  - From: huang leo
- Re: Benchmark MySQL Performance On FreeBSD And Linux
  - From: Greg 'groggy' Lehey

Prev by Date: Re: Benchmark MySQL Performance On FreeBSD And Linux
Next by Date: Re: Benchmark MySQL Performance On FreeBSD And Linux
Previous by thread: Re: Benchmark MySQL Performance On FreeBSD And Linux
Next by thread: Re: MySQL Deadlocks (Was: Re: Benchmark MySQL Performance On FreeBSD And Linux)
Index(es):
- Date
- Thread