From owner-freebsd-questions@FreeBSD.ORG  Tue Nov 27 13:02:29 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 9017A16A46C
	for <freebsd-questions@freebsd.org>;
	Tue, 27 Nov 2007 13:02:29 +0000 (UTC)
	(envelope-from Albert.Shih@obspm.fr)
Received: from mesiob.obspm.fr (mesiob.obspm.fr [145.238.2.2])
	by mx1.freebsd.org (Postfix) with ESMTP id C359D13C4E5
	for <freebsd-questions@freebsd.org>;
	Tue, 27 Nov 2007 13:02:28 +0000 (UTC)
	(envelope-from Albert.Shih@obspm.fr)
Received: from localhost (pcjas.obspm.fr [145.238.184.233])
	by mesiob.obspm.fr (8.13.4/8.13.4/SIO Observatoire de Paris) with ESMTP
	id lARD2RTi001970; Tue, 27 Nov 2007 14:02:27 +0100
Date: Tue, 27 Nov 2007 14:02:27 +0100
From: Albert Shih <Albert.Shih@obspm.fr>
To: Ivan Voras <ivoras@freebsd.org>
Message-ID: <20071127130227.GC81551@pcjas.obspm.fr>
References: <20071126115022.GA70340@pcjas.obspm.fr>
	<fiedup$bv7$1@ger.gmane.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <fiedup$bv7$1@ger.gmane.org>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2
	(mesiob.obspm.fr [145.238.2.2]);
	Tue, 27 Nov 2007 14:02:28 +0100 (CET)
X-Virus-Scanned: ClamAV version 0.91.2,
	clamav-milter version 0.91.2 on mesiob.obspm.fr
X-Virus-Status: Clean
Cc: freebsd-questions@freebsd.org
Subject: Re: Help for very bad perf for MySQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: Albert.Shih@obspm.fr
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 27 Nov 2007 13:02:29 -0000

 Le 26/11/2007 à 13:29:35+0100, Ivan Voras a écrit
> Albert Shih wrote:
> > Hi all
> > 
> > I've already send a message. But I don't receive any answer :-(. I try again
> > and hope there more solution 
> > 
> > I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql
> > 5.X on this server and the performance of MySQL is very bad. For some
> > complexe select I've got ~6secondes (on some basic Linux it's take 0.6
> > sec). And I think this is nothing about thead (that's mean I don't think
> > FreeBSD 7.0 can solve my problem) because it's just for one select.
> >
> 
> For starts, if you didn't do it already, copy
> /usr/local/share/mysql/my-huge.cnf to /etc/my.cnf and try again. These
> are just some general settings, they might or might not help you.

It's change nothing but thanks for you answer

Regards.

JAS
--
Albert SHIH
Observatoire de Paris Meudon
SIO batiment 15
Heure local/Local time:
Mar 27 nov 2007 14:02:06 CET