From owner-freebsd-questions@FreeBSD.ORG Tue Nov 27 06:33:03 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 AF57916A468 for ; Tue, 27 Nov 2007 06:33:03 +0000 (UTC) (envelope-from tedm@toybox.placo.com) Received: from mail.freebsd-corp-net-guide.com (mail.freebsd-corp-net-guide.com [65.75.192.90]) by mx1.freebsd.org (Postfix) with ESMTP id 758A713C4D9 for ; Tue, 27 Nov 2007 06:33:03 +0000 (UTC) (envelope-from tedm@toybox.placo.com) Received: from TEDSDESK (nat-rtr.freebsd-corp-net-guide.com [65.75.197.130]) by mail.freebsd-corp-net-guide.com (8.13.8/8.13.8) with SMTP id lAR6X1qL094159; Mon, 26 Nov 2007 22:33:02 -0800 (PST) (envelope-from tedm@toybox.placo.com) From: "Ted Mittelstaedt" To: , Date: Mon, 26 Nov 2007 22:34:34 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914 In-Reply-To: <20071126115022.GA70340@pcjas.obspm.fr> Importance: Normal Cc: 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: Tue, 27 Nov 2007 06:33:03 -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 3:50 AM > 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 ? > Start with the obvious stuff first. How big is the database? How big is system ram? If you have less ram than you have database then mysql will have to go to the hard disk for the select which will kill it's performance. Ted