Re: mysql performance on 4 * dualcore opteron

2006-04-20 Thread Steven Hartland
Just retested on a dual dual core so 2 * as quick as before Dual 265 ( 4 * 1.8 Ghz Cores ) == 4BSD + libthr + ACPI-Fast == super-smack -d mysql select-key.smack 100 1 Query Barrel Report for client smacker1 connect: max=36ms min=0ms avg= 18ms from 100 clients Query_type num_queries

Re: mysql performance on 4 * dualcore opteron

2006-04-20 Thread Michael Vince
kern/kern_thread.c Steve - Original Message - From: "Sven Petai" <[EMAIL PROTECTED]> To: Sent: Tuesday, April 04, 2006 5:42 PM Subject: mysql performance on 4 * dualcore opteron hi Before I begin, let me just say that I'm probably aware most of the threads about

Re: mysql performance on 4 * dualcore opteron

2006-04-08 Thread David Xu
On Saturday 08 April 2006 17:44, Michael Vince wrote: > I have also tried putting my Perl under libthr for a single thread log > analyzer and to my surprise it even could process logs faster. > I don't know why, but I only know I did some micro optimizations in libthr, and the library is small and

Re: mysql performance on 4 * dualcore opteron

2006-04-08 Thread David Xu
在 Thursday 06 April 2006 17:12,Michael Vince 写道: > I have also done benchmarking with libthr against Apache using 'ab' and > found it can deliver an extra amount of megabytes/sec of data (I think > it was about an extra 2000/requests sec) at the cost of giving the > server from what I remember

Re: mysql performance on 4 * dualcore opteron

2006-04-08 Thread Sven Petai
On Saturday 08 April 2006 13:32, David Xu wrote: > On Saturday 08 April 2006 17:44, Michael Vince wrote: > > I have also tried putting my Perl under libthr for a single thread log > > analyzer and to my surprise it even could process logs faster. > > I don't know why, but I only know I did some mic

Re: mysql performance on 4 * dualcore opteron

2006-04-08 Thread Michael Vince
David Xu wrote: ÔÚ Thursday 06 April 2006 17:12£¬Michael Vince дµÀ£º I have also done benchmarking with libthr against Apache using 'ab' and found it can deliver an extra amount of megabytes/sec of data (I think it was about an extra 2000/requests sec) at the cost of giving the server fr

Re: mysql performance on 4 * dualcore opteron

2006-04-06 Thread Michael Vince
inal Message - From: "Sven Petai" <[EMAIL PROTECTED]> To: Sent: Tuesday, April 04, 2006 5:42 PM Subject: mysql performance on 4 * dualcore opteron hi Before I begin, let me just say that I'm probably aware most of the threads about mysql performance in various fbsd lists

Re: mysql performance on 4 * dualcore opteron

2006-04-05 Thread Steven Hartland
work I needed the attached patch which is basically two failed chunks of: kern/kern_exit.c moved to kern/kern_thread.c Steve - Original Message - From: "Sven Petai" <[EMAIL PROTECTED]> To: Sent: Tuesday, April 04, 2006 5:42 PM Subject: mysql performance on 4 * dualco

Re: mysql performance on 4 * dualcore opteron

2006-04-05 Thread Sven Petai
On Wednesday 05 April 2006 08:31, David Xu wrote: > > Can you disable log-bin option in my.cnf to see if it is a FS bottleneck > when you are running update-smack ? please run Linux and FreeBSD > with same hardware and my.cnf configuration, thanks. > I know this is not very right, but it can be us

Re: mysql performance on 4 * dualcore opteron

2006-04-05 Thread David Xu
在 Wednesday 05 April 2006 00:42,Sven Petai 写道: > > hi > > Before I begin, let me just say that I'm probably aware most of the threads > about mysql performance in various fbsd lists over last couple of years, so > please let's not consentrate on the usual points made over and over again > like

mysql performance on 4 * dualcore opteron

2006-04-04 Thread Sven Petai
hi Before I begin, let me just say that I'm probably aware most of the threads about mysql performance in various fbsd lists over last couple of years, so please let's not consentrate on the usual points made over and over again like how filesystems are mounted under linux, how fast time() is o