From owner-freebsd-performance@FreeBSD.ORG Wed Apr 5 18:52:30 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 0674916A422 for ; Wed, 5 Apr 2006 18:52:30 +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 7ED9843D70 for ; Wed, 5 Apr 2006 18:52:29 +0000 (GMT) (envelope-from silby@silby.com) Received: (qmail 96664 invoked from network); 5 Apr 2006 18:52:28 -0000 Received: from unknown (HELO localhost) (unknown) by unknown with SMTP; 5 Apr 2006 18:52:28 -0000 X-pair-Authenticated: 209.68.2.70 Date: Wed, 5 Apr 2006 13:52:26 -0500 (CDT) From: Mike Silbersack To: Steven Hartland Message-ID: <20060405134919.T16926@odysseus.silby.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-performance@freebsd.org Subject: 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: Wed, 05 Apr 2006 18:52:30 -0000 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 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. Mike "Silby" Silbersack