From owner-freebsd-questions@FreeBSD.ORG Mon Nov 26 12:20:45 2007 Return-Path: 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 A5B9E16A419 for ; Mon, 26 Nov 2007 12:20:45 +0000 (UTC) (envelope-from philip@ridecharge.com) Received: from EXHUB015-4.exch015.msoutlookonline.net (exhub015-4.exch015.msoutlookonline.net [207.5.72.96]) by mx1.freebsd.org (Postfix) with ESMTP id 92DB013C465 for ; Mon, 26 Nov 2007 12:20:45 +0000 (UTC) (envelope-from philip@ridecharge.com) Received: from philip.hq.rws (74.93.213.161) by smtpx15.msoutlookonline.net (207.5.72.103) with Microsoft SMTP Server (TLS) id 8.0.744.0; Mon, 26 Nov 2007 04:20:44 -0800 Message-ID: <474ABA1B.9070808@riderway.com> Date: Mon, 26 Nov 2007 07:20:43 -0500 From: "Philip M. Gollucci" Organization: Riderway Inc. User-Agent: Thunderbird 2.0.0.6 (X11/20070919) MIME-Version: 1.0 To: "Albert.Shih@obspm.fr" References: <20071126115022.GA70340@pcjas.obspm.fr> In-Reply-To: <20071126115022.GA70340@pcjas.obspm.fr> Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit 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 List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 26 Nov 2007 12:20:45 -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. Well -- we'll need more information, but as your say, if its not threading related what makes you think its FreeBSD. You'd probably have better luck over on mysql@lists.mysql.com. A good start would be the query itself, and the output of EXPLAIN for that query. Also, your my.cnf is the next step. -- ------------------------------------------------------------------------ Philip M. Gollucci (philip@ridecharge.com) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/EC88A0BF 0DE5 C55C 6BF3 B235 2DAB B89E 1324 9B4F EC88 A0BF Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching.