Re: mysql tests - one more thing to try

2006-04-06 Thread Joseph Koshy
> here are ktrace results for supersmack and mysqld from a dualcore opteron box > running select smack with 100 threads and 1 queries > os: fbsd 6.1 prerelease > > syscall stats for supersmack > number of syscalls captured: 42575687 > individual syscalls counts: >read 32914539

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