From owner-freebsd-performance@FreeBSD.ORG Thu Apr 6 05:50:43 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 334E216A400 for ; Thu, 6 Apr 2006 05:50:43 +0000 (UTC) (envelope-from silby@silby.com) Received: from relay00.pair.com (relay00.pair.com [209.68.5.9]) by mx1.FreeBSD.org (Postfix) with SMTP id A349143D46 for ; Thu, 6 Apr 2006 05:50:42 +0000 (GMT) (envelope-from silby@silby.com) Received: (qmail 56733 invoked from network); 6 Apr 2006 05:50:41 -0000 Received: from unknown (HELO localhost) (unknown) by unknown with SMTP; 6 Apr 2006 05:50:41 -0000 X-pair-Authenticated: 209.68.2.70 Date: Thu, 6 Apr 2006 00:50:38 -0500 (CDT) From: Mike Silbersack To: Sven Petai In-Reply-To: <200604060339.31800.hadara@bsd.ee> Message-ID: <20060406004606.A25881@odysseus.silby.com> References: <20060405134919.T16926@odysseus.silby.com> <200604060339.31800.hadara@bsd.ee> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-performance@freebsd.org Subject: Re: mysql tests - one more thing to try X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 06 Apr 2006 05:50:43 -0000 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% 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