From owner-freebsd-current@FreeBSD.ORG Thu Feb 10 22:46:49 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 430F716A4CE; Thu, 10 Feb 2005 22:46:49 +0000 (GMT) Received: from mta10-winn.mailhost.ntl.com (smtpout18.mailhost.ntl.com [212.250.162.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id A0D9143D53; Thu, 10 Feb 2005 22:46:47 +0000 (GMT) (envelope-from tom.hurst@clara.net) Received: from aamta03-winn.mailhost.ntl.com ([212.250.162.8]) by mta10-winn.mailhost.ntl.com with ESMTP <20050210224646.MACF20856.mta10-winn.mailhost.ntl.com@aamta03-winn.mailhost.ntl.com>; Thu, 10 Feb 2005 22:46:46 +0000 Received: from voi.aagh.net ([81.104.55.176]) by aamta03-winn.mailhost.ntl.com with ESMTP <20050210224646.QXHL9818.aamta03-winn.mailhost.ntl.com@voi.aagh.net>; Thu, 10 Feb 2005 22:46:46 +0000 Received: from freaky by voi.aagh.net with local (Exim 4.44 (FreeBSD)) id 1CzN5A-000EJ7-32; Thu, 10 Feb 2005 22:46:44 +0000 Date: Thu, 10 Feb 2005 22:46:43 +0000 From: Thomas Hurst To: Antony T Curtis Message-ID: <20050210224643.GA47912@voi.aagh.net> Mail-Followup-To: Antony T Curtis , Scott Long , freebsd-current@freebsd.org References: <20050209205943.34c39e15.flynn@energyhq.es.eu.org> <420A909C.8070701@freebsd.org> <1108071290.59338.8.camel@pcgem.rdg.cyberkinetica.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1108071290.59338.8.camel@pcgem.rdg.cyberkinetica.com> Organization: Not much. User-Agent: Mutt/1.5.6i Sender: Thomas Hurst 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: Thu, 10 Feb 2005 22:46:49 -0000 * 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. -- Thomas 'Freaky' Hurst http://hur.st/