From owner-freebsd-current@FreeBSD.ORG Wed Oct 26 11:40:00 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 8F71716A41F; Wed, 26 Oct 2005 11:40:00 +0000 (GMT) (envelope-from MH@kernel32.de) Received: from crivens.unixoid.de (crivens.unixoid.de [81.169.171.191]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9ABD143D46; Wed, 26 Oct 2005 11:39:59 +0000 (GMT) (envelope-from MH@kernel32.de) Received: from localhost (localhost [127.0.0.1]) by crivens.unixoid.de (Postfix) with ESMTP id 5D6903FDE; Wed, 26 Oct 2005 13:39:58 +0200 (CEST) Received: from crivens.unixoid.de ([127.0.0.1]) by localhost (crivens.unixoid.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 35257-08; Wed, 26 Oct 2005 13:39:45 +0200 (CEST) Received: from [192.168.100.10] (p54BDD77B.dip.t-dialin.net [84.189.215.123]) by crivens.unixoid.de (Postfix) with ESMTP id 0069B3EDC; Wed, 26 Oct 2005 13:39:44 +0200 (CEST) Message-ID: <435F6B01.5020003@kernel32.de> Date: Wed, 26 Oct 2005 13:39:45 +0200 From: Marian Hettwer User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Robert Watson References: <435F48DA.6060009@kernel32.de> <20051026105411.L32255@fledge.watson.org> In-Reply-To: <20051026105411.L32255@fledge.watson.org> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at unixoid.de 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 11:40:00 -0000 Hi Robert, Robert Watson wrote: > > 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 > yep. by the way, back in the days of FreeBSD 4.x and 5.x, after I did a config MYKERNEL, it doesn't said I need to do a "make cleandepend" before doing a "make depend"... why that? Seems like this additional step in compiling the Kernel is around since 6-CURRENT, right? Here we go with a super-smack with 4BSD (but unchanged libmap.conf)... Kernel is apart from scheduler still the same like the on uploaded at http://unixoid.de/rabauke/freebsd/ I did the select-smack 4 times. This is now: 4BSD, MySQL 4.1.14, BUILD_STATIC, BUILD_OPTIMIZED: select_index 200000 2 0 3776.34 select_index 200000 2 0 3802.04 select_index 200000 2 0 3809.38 select_index 200000 2 0 3796.41 Numbers are quite the same with 4BSD... > - Use libmap to configure the mysql server to use libthr instead of > libpthread > uh. Last time I fiddled around with libmap.conf was back in FreeBSD 5.1 ... could you enlighten me a wee bit in regards to libmap.conf ? :) If not, I'll stress google a bit and hopefully find something useful... > And see what that does to performance using otherwise identical > configurations? > my.cnf is pretty much my-medium.cnf on Debian and FreeBSD. Although, Debian has MySQL 4.1.11 and FreeBSD Ports has MySQL 4.1.14. As mentioned before, this benchmark here is a quick shot. However, the difference shouldn't be _that_ large (3600 vs. 14000). > 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. > I'll give that a shot too and see what'll happen. Hopefully I'll have a MySQL 4.0.x on Debian. Otherwise the pain of self compiling or debian packages searching starts ;) I'll get back with another eMail as soon as I figured the libmap.conf thing out and tried it with MySQL 4.0.x best regards, Marian