From owner-freebsd-smp@FreeBSD.ORG  Wed Apr  5 00:32:51 2006
Return-Path: <owner-freebsd-smp@FreeBSD.ORG>
X-Original-To: freebsd-smp@freebsd.org
Delivered-To: freebsd-smp@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id DBCB216A423
	for <freebsd-smp@freebsd.org>; Wed,  5 Apr 2006 00:32:51 +0000 (UTC)
	(envelope-from markir@paradise.net.nz)
Received: from linda-4.paradise.net.nz (bm-4a.paradise.net.nz [203.96.152.183])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 60FF243D46
	for <freebsd-smp@freebsd.org>; Wed,  5 Apr 2006 00:32:51 +0000 (GMT)
	(envelope-from markir@paradise.net.nz)
Received: from smtp-3.paradise.net.nz
	(tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by
	linda-4.paradise.net.nz (Paradise.net.nz) with ESMTP id
	<0IX800BZ646PE6@linda-4.paradise.net.nz> for
	freebsd-smp@freebsd.org; Wed, 05 Apr 2006 12:32:49 +1200 (NZST)
Received: from [192.168.1.11]
	(218-101-29-132.dsl.clear.net.nz [218.101.29.132])	by
	smtp-3.paradise.net.nz (Postfix) with ESMTP id 0862B10AAC0C;
	Wed, 05 Apr 2006 12:32:48 +1200 (NZST)
Date: Wed, 05 Apr 2006 12:32:36 +1200
From: Mark Kirkwood <markir@paradise.net.nz>
In-reply-to: <008001c65825$f3c27700$65fd24c0@Eric>
To: Eric <ericd@free.fr>
Message-id: <44331024.7090807@paradise.net.nz>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7bit
X-Accept-Language: en-us, en
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20051106)
References: <009301c65418$cc029f30$65fd24c0@Eric>
	<64659004-E643-4044-AAED-076E0CC91977@foolishgames.com>
	<01a901c65493$77ad2740$65fd24c0@Eric>
	<442DC9B6.2090200@paradise.net.nz>
	<442EAA0A.8030704@he.iki.fi> <442F0E1B.9090505@paradise.net.nz>
	<027f01c657f4$0d0a66a0$65fd24c0@Eric> <4432858F.90701@he.iki.fi>
	<008001c65825$f3c27700$65fd24c0@Eric>
Cc: Lucas Holt <luke@foolishgames.com>, freebsd-smp@freebsd.org
Subject: Re: Low perf with smp
X-BeenThere: freebsd-smp@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: FreeBSD SMP implementation group <freebsd-smp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-smp>,
	<mailto:freebsd-smp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-smp>
List-Post: <mailto:freebsd-smp@freebsd.org>
List-Help: <mailto:freebsd-smp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-smp>,
	<mailto:freebsd-smp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 05 Apr 2006 00:32:52 -0000

Eric wrote:
> I know Pete but I downgrad because when installing 6.0 performance was 
> half than with 4.11.
> I done tests and tests but still have very low perfs. I then downdgrad 
> to 4.11 to see if it came from hardware or software.
> Conclusion is that my test wich is consist of loop of mysql query done 
> by a php script take :
> 
>             - 32 sec with 4.11 without SMP
>            - 54 sec with 4.11 with SMP
>            - 62 sec with 6.0 or 6.1 beta 4
> 
> That's why actually I'm with 4.11.
> 
> If you have any idea how improve perfs with 6.0 it will be a pleasure.
> Hardware is new dell 1850 with bi-xeon dualcore 2.8Ghz and scsi 15.000t 
> HDD on raid1 perc4si 256Mo  controller.

If you could post, or link to your mysql query and php script, then I 
(or in fact anyone) could try to reproduce this (I've got two almost 
identical machines running 6.0, so could downgrade one to 4.x.).

In addition, what versions of php and mysql are you using?

Cheers

Mark