From owner-freebsd-questions@FreeBSD.ORG  Mon Nov 26 12:25:34 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 E1E9616A417
	for <freebsd-questions@freebsd.org>;
	Mon, 26 Nov 2007 12:25:34 +0000 (UTC)
	(envelope-from freebsd-questions@m.gmane.org)
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
	by mx1.freebsd.org (Postfix) with ESMTP id 9E06D13C455
	for <freebsd-questions@freebsd.org>;
	Mon, 26 Nov 2007 12:25:34 +0000 (UTC)
	(envelope-from freebsd-questions@m.gmane.org)
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1Iwd1N-0003nw-7g
	for freebsd-questions@freebsd.org; Mon, 26 Nov 2007 12:25:05 +0000
Received: from lara.cc.fer.hr ([161.53.72.113])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <freebsd-questions@freebsd.org>; Mon, 26 Nov 2007 12:25:05 +0000
Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <freebsd-questions@freebsd.org>; Mon, 26 Nov 2007 12:25:05 +0000
X-Injected-Via-Gmane: http://gmane.org/
To: freebsd-questions@freebsd.org
From: Ivan Voras <ivoras@freebsd.org>
Date: Mon, 26 Nov 2007 13:29:35 +0100
Lines: 16
Message-ID: <fiedup$bv7$1@ger.gmane.org>
References: <20071126115022.GA70340@pcjas.obspm.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr
User-Agent: Thunderbird 2.0.0.6 (X11/20070801)
In-Reply-To: <20071126115022.GA70340@pcjas.obspm.fr>
Sender: news <news@ger.gmane.org>
Subject: Re: Help for very bad perf for MySQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
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: Mon, 26 Nov 2007 12:25:35 -0000

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.