From owner-freebsd-current@FreeBSD.ORG Wed Oct 26 10:04:13 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 0364516A41F for ; Wed, 26 Oct 2005 10:04:13 +0000 (GMT) (envelope-from xdamen@sci.kun.nl) Received: from hermes.uci.kun.nl (hermes.uci.kun.nl [131.174.93.58]) by mx1.FreeBSD.org (Postfix) with ESMTP id A004F43D45 for ; Wed, 26 Oct 2005 10:04:11 +0000 (GMT) (envelope-from xdamen@sci.kun.nl) Received: from [127.0.0.1] (vhe-383505.sshn.net [195.169.208.89]) by hermes.uci.kun.nl (PMDF V6.2-X17 #30689) with ESMTP id <0IOY000P7PA7QC@hermes.uci.kun.nl> for current@freebsd.org; Wed, 26 Oct 2005 12:03:45 +0200 (MEST) Date: Wed, 26 Oct 2005 12:02:02 +0200 From: Xander Damen In-reply-to: <1130320668.810.87.camel@spirit> Message-id: <435F541A.7050107@sci.kun.nl> MIME-version: 1.0 Content-type: text/plain; charset=UTF-8; format=flowed Content-transfer-encoding: 8BIT User-Agent: Thunderbird 1.4.1 (Windows/20051006) References: <435F48DA.6060009@kernel32.de> <1130320668.810.87.camel@spirit> 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 10:04:13 -0000 There was a similar discussion on stable a while back: http://lists.freebsd.org/pipermail/freebsd-stable/2005-June/015874.html which continued on performance: http://lists.freebsd.org/pipermail/freebsd-performance/2005-June/001403.html -- Xander Xin LI wrote: > Hi, Marian, > > 在 2005-10-26三的 11:14 +0200，Marian Hettwer写道： > >> Hi Folks, >> >> 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. >> > [...] > >> Any Ideas where this huge difference comes from? Did I oversee some >> debugging features still active in RC1 ? >> > > There are many factors that can affect the performance of MySQL. Would > you please post the output of "dumpfs /var | head -n 21" on your server? > (Replace /var with whatever mountpoint that your database is stored in). > > Some observations that I think can affect MySQL performance: > - Our malloc(3) implementation might be sub-optimal for the workload. > - Lack of some POSIX system call which was implemented in other ways > (e.g. we do not have fsyncdata yet) > - Some detailed implementation difference between our and Linux's > threading library, or MySQL itself. > > I think David (davidxu@) had worked on performance of MySQL and he may > have some suggestions. > > BTW. What file system are you using on your Debian test? What's the > mount options? > > Cheers, >