From owner-freebsd-current@FreeBSD.ORG Wed Oct 26 09:57:28 2005 Return-Path: X-Original-To: current@freebsd.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1C17A16A41F for ; Wed, 26 Oct 2005 09:57:28 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id C05C143D45 for ; Wed, 26 Oct 2005 09:57:27 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [209.31.154.41]) by cyrus.watson.org (Postfix) with ESMTP id E7B5946B86; Wed, 26 Oct 2005 05:57:26 -0400 (EDT) Date: Wed, 26 Oct 2005 10:57:26 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: Marian Hettwer In-Reply-To: <435F48DA.6060009@kernel32.de> Message-ID: <20051026105411.L32255@fledge.watson.org> References: <435F48DA.6060009@kernel32.de> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: current@freebsd.org Subject: Re: MySQL Performance 6.0rc1 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Oct 2005 09:57:28 -0000 On Wed, 26 Oct 2005, Marian Hettwer wrote: > I'm using RC1 on some of my test servers and workstations. So far, it > runs very good (as in stable and fast) :) However, I thought of doing a > small benchmark of MySQL in comparison to Linux 2.6.8 (Debian Sarge) and > the results are kinda... shocking. > > On FreeBSD I took a pretty much generic kernel, I just removed debugging > options, added SMP and changed the scheduler from BSD to ULE. I used > super-smack to do a select-key test. MySQL 4.1 was build from ports with > BUILD_OPTIMIZED and BUILD_STATIC Could you: - Switch back to 4BSD - Use libmap to configure the mysql server to use libthr instead of libpthread And see what that does to performance using otherwise identical configurations? You might also consider installing MySQL 4.0.x on freebsd and linux and see how they compare. I've not looked closely, but I seem to remember observing that something changed between 4.0 and 4.1 that seriously impacted performance on FreeBSD, but not on Linux. I've not had time to confirm or investigate this. Robert N M Watson > > super-smack gave me these numbers: Query Barrel Report for client > smacker1 connect: max=15ms min=1ms avg= 12ms from 10 clients Query_type > num_queries max_time min_time q_per_s select_index 200000 2 0 3673.36 > > My Kernel Config: http://unixoid.de/rabauke/freebsd/EDGECRUSHER My > dmesg: http://unixoid.de/rabauke/freebsd/dmesg.freebsd6rc1 > > Since I have an identical second disk in my Dual Xeon BOX, I installed a > Debian Sarge with Linux SMP Kernel 2.6.8, installed mysql-server41 (which is > 4.1.11) and did the same super-smack test. Results: > Query Barrel Report for client smacker1 > connect: max=35ms min=0ms avg= 9ms from 10 clients > Query_type num_queries max_time min_time q_per_s > select_index 200000 0 0 > 14736.23 > > Whut? 14700 queries/second compared to only 3600 q/s on FreeBSD? > > I do know, that rc1 is not about performance, this will be -RELEASE then. I > do know too, that it was just a quick shot and probably I should compile my > own version of the MySQL server from sources on FreeBSD and Debian to have > the very same mysql version. > However, I can't imagine that I would gain 4 to 5 times the performance on > FreeBSD just by compiling mysql myself... > > Any Ideas where this huge difference comes from? Did I oversee some debugging > features still active in RC1 ? > > Best regards and keep up the good work on 6.x! > - Marian > _______________________________________________ > freebsd-current@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org" >