From owner-freebsd-current@FreeBSD.ORG Fri Feb 11 07:10:31 2005 Return-Path: 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 F3D8616A4CE; Fri, 11 Feb 2005 07:10:30 +0000 (GMT) Received: from mta05-winn.mailhost.ntl.com (smtpout15.mailhost.ntl.com [212.250.162.15]) by mx1.FreeBSD.org (Postfix) with ESMTP id 646F343D54; Fri, 11 Feb 2005 07:10:29 +0000 (GMT) (envelope-from antony.t.curtis@ntlworld.com) Received: from aamta01-winn.mailhost.ntl.com ([212.250.162.8]) by mta05-winn.mailhost.ntl.com with ESMTP <20050211071028.ZNLT1139.mta05-winn.mailhost.ntl.com@aamta01-winn.mailhost.ntl.com>; Fri, 11 Feb 2005 07:10:28 +0000 Received: from localhost.localdomain ([81.107.94.210]) by aamta01-winn.mailhost.ntl.com with ESMTP <20050211071028.IQXV15415.aamta01-winn.mailhost.ntl.com@localhost.localdomain>; Fri, 11 Feb 2005 07:10:28 +0000 From: Antony T Curtis To: Thomas Hurst In-Reply-To: <20050210224643.GA47912@voi.aagh.net> References: <20050209205943.34c39e15.flynn@energyhq.es.eu.org> <420A909C.8070701@freebsd.org> <1108071290.59338.8.camel@pcgem.rdg.cyberkinetica.com> <20050210224643.GA47912@voi.aagh.net> Content-Type: text/plain Date: Fri, 11 Feb 2005 07:10:25 +0000 Message-Id: <1108105825.60161.4.camel@pcgem.rdg.cyberkinetica.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit cc: freebsd-current@freebsd.org cc: Scott Long Subject: Re: MySQL benchmarks X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 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: Fri, 11 Feb 2005 07:10:31 -0000 On Thu, 2005-02-10 at 22:46 +0000, Thomas Hurst wrote: > * Antony T Curtis (antony.t.curtis@ntlworld.com) wrote: > > > If I remember correctly, MyISAM with skip-locking should rarely use > > fsync() calls... so if possible, the test could be re-run using MyISAM > > tables to see if there is any performance difference. > > Poor performance is seen on read-only tests too; no fsync() overhead > there. However, this message caught my eye: > > http://lists.freebsd.org/pipermail/freebsd-threads/2005-February/002848.html > > "Linux uses ptmalloc2 as its memory allocator, an extremely efficient > implementation whose performance under a heavily loaded multithreaded > system is impressive. FreeBSD does not." > > There are a few malloc implimentations in ports which are supposedly > very good under threaded and multi-CPU conditions, including an older > ptmalloc, but I can't seem to make MySQL work with any of them using > LD_PRELOAD (it hangs with ptmalloc and SEGV's after a few seconds of > wdrain with Hoard). This on 5-STABLE as of Jan 14, though, so don't let > that put anyone here off trying. A couple of years ago, I compiled MySQL with Hoard on AIX (8-way power3 rs6000)... and AFAIK it's still being used in a production environment. I think I'll have to play with this when if get an SMP machine... -- Antony T Curtis, BSc. UNIX, Linux, *BSD, Networking antony.t.curtis@ntlworld.com C++, J2EE, Perl, MySQL, Apache IT Consultancy.