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


On Sat, 6 May 2006, Attila Nagy wrote:

On 2006. 05. 06. 16:16, Robert Watson wrote:
In local measurements, I have observed a 0% change in MySQL performance on uniprocessor systems, and on a dual-processor system I have observed a 4%-5% performance improvement with two client MySQL threads.
Just a quick, nowhere correct test: http://people.fsn.hu/~bra/freebsd/20060506a-uds-fine-grain.diff/domsock.png

The machine is a quad core Xeon LV server, the client side is sysbench, accessing mysql 4.1.8 on a socket. Heap table, simple test.

Which threading library is that with, btw? If libpthread, could you run the same test with libthr, and vice versa?

I've noticed that libpthread has the interesting property that it greatly improves contention issues on certain locks when those locks are contended on within a process. The reason is that it avoids having threads within the process compete with themselves. The big locks threaded processes hit when contending with themselves are the file descriptor array lock and signal delivery related locks.

Robert N M Watson
_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: Fine-grained locking for POSIX local sockets (UNIX domain sockets)
    ... uniprocessor systems, and on a dual-processor system I have observed a 4%-5% performance improvement with two client MySQL threads. ... I've noticed that libpthread has the interesting property that it greatly improves contention issues on certain locks when those locks are contended on within a process. ...
    (freebsd-current)
  • Re: race on multi-processor solaris
    ... >> On a linked list with locks, one thread will always be running on ... >> at full speed and there will be zero contention. ... > busy-waiting threads waste an appreciable amount of CPU time. ... rebuttal to "context switches are bad, ...
    (comp.unix.solaris)
  • Re: race on multi-processor solaris
    ... > more than a few iterations in cas loops for things like ... >> More graceful degradation under contention is another. ... > is essentially a locked design. ... It's just careful in what it locks ...
    (comp.unix.solaris)
  • Re: [PATCH [RT] 00/14] RFC - adaptive real-time locks
    ... do all sorts of contention tracking and that is why I took implemented ... well as the specific locks that are contended against. ... but we are also interested in workloads where the polling ...
    (Linux-Kernel)
  • Re: race on multi-processor solaris
    ... > Once per CPU per timeslice. ... > lock-free versus regular locks. ... > contention is avoided by descheduling contending threads. ...
    (comp.unix.solaris)