From owner-freebsd-questions@FreeBSD.ORG Tue Nov 27 13:01:52 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 E6D8616A41A for ; Tue, 27 Nov 2007 13:01:52 +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 7F6CA13C45A for ; Tue, 27 Nov 2007 13:01:52 +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 lARD1phh001760; Tue, 27 Nov 2007 14:01:51 +0100 Date: Tue, 27 Nov 2007 14:01:51 +0100 From: Albert Shih To: Jan Catrysse Message-ID: <20071127130151.GB81551@pcjas.obspm.fr> References: <20071126120319.GA70494@pcjas.obspm.fr> <20071126122759.2734628C2F@smtp.proximedia.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20071126122759.2734628C2F@smtp.proximedia.com> 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:01:51 +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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Nov 2007 13:01:53 -0000 Le 26/11/2007 à 13:31:12+0100, Jan Catrysse a écrit > > > > 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). > > > > 6 seconds seem to be an awful lot. What kind of query are > > you running > > > on what kind of database / contents? > > > I don't really known it's some scientifical data. But the > > problem is on a basic linux pc (with SATA disk) the time is > > 0.6 sec with same request and same data. And it's for web > > applications. At 6 sec for one request it's become very long > > for the visitor because the application make many requests. > > > > Regards > > -- > > Albert SHIH > > Did you try pinpointing down the problem to make sure their is not another > bottleneck? Is the system running in production environment for the moment > or are you the sole user? No the server is empty (only root can logging) and no service running (other thant Mysql and apache). And when I try this test the load of the server is near zero. > > How did you install MySQL? I my experience (but I can be wrong) the default > settings give the best performance on 5.x MySQL FreeBSD 6.2. So no Linux > threads and stuff... Directly from the ports. Regards. > JAS -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Mar 27 nov 2007 14:00:40 CET