From owner-freebsd-current@FreeBSD.ORG Tue Apr 4 07:41:44 2006 Return-Path: X-Original-To: freebsd-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 4F73016A401 for ; Tue, 4 Apr 2006 07:41:44 +0000 (UTC) (envelope-from mv@roq.com) Received: from p4.roq.com (ns1.ecoms.com [207.44.130.137]) by mx1.FreeBSD.org (Postfix) with ESMTP id C8A4143D49 for ; Tue, 4 Apr 2006 07:41:43 +0000 (GMT) (envelope-from mv@roq.com) Received: from p4.roq.com (localhost.roq.com [127.0.0.1]) by p4.roq.com (Postfix) with ESMTP id C8A644CD1F; Tue, 4 Apr 2006 07:42:15 +0000 (GMT) Received: from [192.168.0.2] (ppp157-158.static.internode.on.net [150.101.157.158]) by p4.roq.com (Postfix) with ESMTP id D5F894CD1D; Tue, 4 Apr 2006 07:42:14 +0000 (GMT) Message-ID: <44322334.8010402@roq.com> Date: Tue, 04 Apr 2006 17:41:40 +1000 From: Michael Vince User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Ganbold References: <442B79AE.9000800@micom.mng.net> In-Reply-To: <442B79AE.9000800@micom.mng.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP Cc: freebsd-current@freebsd.org Subject: Re: mysql performance test results under FreeBSD-7.0-CURRENT 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: Tue, 04 Apr 2006 07:41:44 -0000 Ganbold wrote: > Hi all, > > I did make some mysql performance tests under FreeBSD-7.0-CURRENT with > various > scheduler and compile time options. > It seems like mysql(BUILD_OPTIMIZED=yes, BUILD_STATIC=yes, > WITH_PROC_SCOPE_PTH=yes)-libpthread-tsc-sched_4bsd+preemption gives > better performance. > > The test results are at: > > http://www.mnbsd.org/ftp/mysql_test_results.txt > > There are several things I didn't test and this leads to some questions: > > 1. I didn't make test with Poul-Henning's CPU accounting patch. > Somehow I can't apply it > (http://phk.freebsd.dk/patch/cpu_acct_2.patch) cleanly. Where can I > find latest patch? > When this patch will be included in CURRENT? > > 2. I didn't make test with Robert Watson's patch > (http://www.watson.org/~robert/freebsd/clock/)? Does CURRENT src tree > include it? If not when this patch will be included in CURRENT? > > 3. I did make tests with default malloc in CURRENT. I'm confused what > malloc options should try (jemalloc? phkmalloc?) What is the default > malloc in CURRENT? How to use these different mallocs? > > thanks in advance, > Ganbold Nice work! I think it would be equally interesting if you posted benchmarks for MySQL 4.1.x Since the last post comparing MySQL 5.x vs 4.1.x on FreeBSD showed that MySQL 4.1 series had almost double the benchmark performance numbers over 5.x MySQL I couldn't bare the idea of using MySQL 5 if its still only half as fast and has features I don't need. I believe most people would prefer 4.1 unless they really need the features that are in 5.x or don't need performance at all. Mike