Re: mysql tests - one more thing to try

2006-04-05 Thread Mike Silbersack
On Thu, 6 Apr 2006, Sven Petai wrote: On Wednesday 05 April 2006 21:52, Mike Silbersack wrote: If you're willing to spend more time looking at this, I suggest that you run truss or ktrace on the super-smack processes. I did a small amount of mysql vs postgres vs firebird benchmarking two yea

Re: mysql tests - one more thing to try

2006-04-05 Thread Sven Petai
On Wednesday 05 April 2006 21:52, Mike Silbersack wrote: > If you're willing to spend more time looking at this, I suggest that you > run truss or ktrace on the super-smack processes. I did a small amount of > mysql vs postgres vs firebird benchmarking two years ago for a class > project, and not

mysql tests - one more thing to try

2006-04-05 Thread Mike Silbersack
I'm not subscribed to -performance, hence why this isn't a true reply... I noticed that Steve said: --- Looking at this on a dual box here ( waiting for the new MB for dual dual core ) All the time is spent processing super-smack and only 25% on mysqld. --- If you're willing to spend more ti

Re: mysql performance on 4 * dualcore opteron

2006-04-05 Thread Steven Hartland
Looking at this on a dual box here ( waiting for the new MB for dual dual core ) All the time is spent processing super-smack and only 25% on mysqld. Even dropping to 10 clients a large portion is take by the clients. That said there is a lot that can be gained by using the tweaks out there i.e. U

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