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

2006-05-06 Thread David Xu
On Sunday 07 May 2006 06:39, Attila Nagy wrote: > On 2006. 05. 06. 22:50, Robert Watson wrote: > >> 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 libpthr

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

2006-05-06 Thread Attila Nagy
On 2006. 05. 06. 22:50, Robert Watson wrote: 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? thr

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

2006-05-06 Thread Kris Kennaway
On Sat, May 06, 2006 at 03:16:48PM +0100, Robert Watson wrote: > > Dear all, > > Attached, please find a patch implementing more fine-grained locking for > the POSIX local socket subsystem (UNIX domain socket subsystem). Dear Sir, Per your request, please find attached the results of my measur

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

2006-05-06 Thread Robert Watson
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. Ju

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

2006-05-06 Thread Attila Nagy
Hello, 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:

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

2006-05-06 Thread Robert Watson
On Sat, 6 May 2006, Robert Watson wrote: Attached, please find a patch implementing more fine-grained locking for the POSIX local socket subsystem (UNIX domain socket subsystem). In the current implementation, we use a single global subsystem lock to protect all local IPC over the PF_LOCAL s

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

2006-05-06 Thread Robert Watson
Dear all, Attached, please find a patch implementing more fine-grained locking for the POSIX local socket subsystem (UNIX domain socket subsystem). In the current implementation, we use a single global subsystem lock to protect all local IPC over the PF_LOCAL socket type. This has low overh