Date: Thu, 6 Apr 2006 00:50:38 -0500 (CDT) From: Mike Silbersack <silby@silby.com> To: Sven Petai <hadara@bsd.ee> Cc: freebsd-performance@freebsd.org Subject: Re: mysql tests - one more thing to try Message-ID: <20060406004606.A25881@odysseus.silby.com> In-Reply-To: <200604060339.31800.hadara@bsd.ee> References: <20060405134919.T16926@odysseus.silby.com> <200604060339.31800.hadara@bsd.ee>
next in thread | previous in thread | raw e-mail | index | archive | help
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 years ago for a class >> project, and noticed that mysql's results were showing the same phenomena >> - our test program was using more cpu than mysqld. I run truss on our >> test program and found that it was doing ONE BYTE READS from the socket, >> rather than something larger. >> >> I never had the time to see if the problem was fixed at a later time or >> not. You may wish to see if that same condition is still happening. > > here are ktrace results for supersmack and mysqld from a dualcore opteron box > running select smack with 100 threads and 10000 queries > os: fbsd 6.1 prerelease > > ==== syscall stats for supersmack ==== > > request sizes for syscall read > size count % > --------------------------- > 4 15489977 47.06% > 50 3982797 12.10% > 1 3873493 11.77% > 52 2654645 8.07% > 60 1937753 5.89% > 5 1933249 5.87% > 8192 1931176 5.87% > 53 790179 2.40% > 51 274285 0.83% <rest of info cut> Thanks for running those tests, Sven. It looks like the problem still exists. :( I wish I had time to work on this... Mike "Silby" Silbersack
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060406004606.A25881>