From owner-freebsd-questions@FreeBSD.ORG Mon Nov 26 11:58:19 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 31D4416A419 for ; Mon, 26 Nov 2007 11:58:19 +0000 (UTC) (envelope-from j.catrysse@proximedia.be) Received: from smtp.proximedia.com (popop.online.be [194.88.108.79]) by mx1.freebsd.org (Postfix) with ESMTP id ED4D713C43E for ; Mon, 26 Nov 2007 11:58:18 +0000 (UTC) (envelope-from j.catrysse@proximedia.be) Received: from TEC04 (unknown [194.88.104.244]) by smtp.proximedia.com (Postfix) with ESMTP id DB21928C76 for ; Mon, 26 Nov 2007 12:58:16 +0100 (CET) From: "Jan Catrysse" To: Date: Mon, 26 Nov 2007 13:01:47 +0100 Organization: Proximedia Belgium S.A. MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <20071126115022.GA70340@pcjas.obspm.fr> Thread-Index: AcgwIs3P2IrNKbYrT9KjYKYE5lAragAAPiuQ X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Message-Id: <20071126115816.DB21928C76@smtp.proximedia.com> 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 11:58:19 -0000 > -----Original Message----- > From: owner-freebsd-questions@freebsd.org > [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of Albert Shih > Sent: Monday, November 26, 2007 12:50 PM > To: freebsd-questions@freebsd.org > Subject: Help for very bad perf for MySQL > > 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. > > The server have two SAS 10 000 tr/m disks. > > Anyone have some advise to tunning FreeBSD or MySQL for > increase the perf ? > > Regards > -- > Albert SHIH > Observatoire de Paris Meudon > SIO batiment 15 > Heure local/Local time: > Lun 26 nov 2007 12:46:06 CET 6 seconds seem to be an awful lot. What kind of query are you running on what kind of database / contents? Regs, Jan