Fine-grained locking for POSIX local sockets (UNIX domain sockets)

[Kris Kennaway]

On Tue, May 09, 2006 at 06:18:11PM +0300, Sven Petai wrote:
> On Tuesday 09 May 2006 03:42, Kris Kennaway wrote:
> > On Tue, May 09, 2006 at 03:34:59AM +0300, Sven Petai wrote:
> > > > Hmm, with this patch mysql 4.1 seems to crash at startup.  I haven't
> > > > yet had time to investigate.  Is anyone else seeing this?
> > >
> > > Seems to run fine here with 4.1.18 on amd64, but doesn't seem to make
> > > much difference though.
> > >
> > > I ran the tests again on the 8 core machine with and without rwatsons
> > > patch and this time with 6 tests for each setting and generated graphs:
> > > http://bsd.ee/~hadara/debug/mysql4/stats.html
> > >
> > > thr + select smack dynamics with the patch really do look quite
> > > interesting
> > >
> > > PS
> > > I'm currently running testround with rwatsons patch +
> > > http://people.freebsd.org/~csjp/kern_descrip.c.1145074052.diff  + mysqld
> > > change davidxu suggested.
> > > Are there any other patches out there that I should try ?
> >
> > Sorry, I meant
> > http://people.freebsd.org/~csjp/sys.mpsafe.fileops.1145896495.diff
> > instead of that patch.  Also try turning down HZ to 100, and changing
> > the wakeup()s to wakeup_one() in sys/filedesc.h.
> 
> I preformed additional tests with the settings you suggested,
> updated graphs are available @
> http://bsd.ee/~hadara/debug/mysql4/stats.html

Very useful, thanks!  I imagine we'll be discussing this issue in
detail at bsdcan over the next few days.

Kris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-performance/attachments/20060509/4170047d/attachment.pgp