Fine-grained locking for UNIX domain sockets: patch updated

2007-02-24 Thread Robert Watson
As part of Kris and Jeff's recent work on improving MySQL scalability on FreeBSD, I've updated my fine-grained locking patch for UNIX domain sockets to a more recent 7-CURRENT: http://www.watson.org/~robert/freebsd/netperf/20070224-uds-fine-grain.diff This patch replaces the gl

Re: Fine-grained locking for UNIX domain sockets: patch updated

2007-02-24 Thread Steven Hartland
- Original Message - From: "Robert Watson" <[EMAIL PROTECTED]> As part of Kris and Jeff's recent work on improving MySQL scalability on FreeBSD Are there any results / info on what's been done that we can look at? Steve This e.mail

Re: Fine-grained locking for UNIX domain sockets: patch updated

2007-02-24 Thread Robert Watson
On Sat, 24 Feb 2007, Steven Hartland wrote: - Original Message - From: "Robert Watson" <[EMAIL PROTECTED]> As part of Kris and Jeff's recent work on improving MySQL scalability on FreeBSD Are there any results / info on what's been done that we can look at? I understand that Kris i

Re: Virtual performance

2007-02-24 Thread Václav Haisman
Ivan Voras wrote, On 17.2.2007 13:46: > Vlad GALU wrote: > >> At work, we have several build guests running FreeBSD. Overall it >> seems to be a timer problem when running in VMware. Running >> vmware-guestd helped in almost all circumstances. The worst cases we >> saw were in processes who were

Re: Fine-grained locking for UNIX domain sockets: patch updated

2007-02-24 Thread Vince
Steven Hartland wrote: > - Original Message - From: "Robert Watson" <[EMAIL PROTECTED]> >> As part of Kris and Jeff's recent work on improving MySQL scalability >> on FreeBSD > > Are there any results / info on what's been done that we can look at? > >Steve > Jeff's Blog would be the

Re: Fine-grained locking for UNIX domain sockets: patch updated

2007-02-24 Thread Steven Hartland
- Original Message - From: "Robert Watson" <[EMAIL PROTECTED]> I understand that Kris is preparing a summary to post to the lists in the next couple of days. The thrust of the work has been an investigation of MySQL on an 8-core system, and in particular, how to improve FreeBSD scalab

Progress on scaling of FreeBSD on 8 CPU systems

2007-02-24 Thread Kris Kennaway
Now that the goals of the SMPng project are complete, for the past year or more several of us have been working hard on profiling FreeBSD in various multiprocessor workloads, and looking for performance bottlenecks to be optimized. We have recently made significant progress on optimizing for MySQL

Re: Progress on scaling of FreeBSD on 8 CPU systems

2007-02-24 Thread Petri Helenius
Kris Kennaway wrote: This shows the graph of MySQL transactions/second performed by a multi-threaded client workload against a local MySQL database with varying numbers of client threads, with identically configured FreeBSD and Linux systems on the same machine. How does that compare to 6.2-

Re: Progress on scaling of FreeBSD on 8 CPU systems

2007-02-24 Thread Kris Kennaway
On Sun, Feb 25, 2007 at 09:00:32AM +0200, Petri Helenius wrote: > Kris Kennaway wrote: > > > >This shows the graph of MySQL transactions/second performed by a > >multi-threaded client workload against a local MySQL database with > >varying numbers of client threads, with identically configured Free