From owner-freebsd-questions@FreeBSD.ORG Mon Nov 26 12:28:00 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 E621016A41B for ; Mon, 26 Nov 2007 12:28:00 +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 AC29813C4EA for ; Mon, 26 Nov 2007 12:28:00 +0000 (UTC) (envelope-from j.catrysse@proximedia.be) Received: from TEC04 (unknown [194.88.104.244]) by smtp.proximedia.com (Postfix) with ESMTP id 2734628C2F for ; Mon, 26 Nov 2007 13:27:59 +0100 (CET) From: "Jan Catrysse" To: Date: Mon, 26 Nov 2007 13:31:12 +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: <20071126120319.GA70494@pcjas.obspm.fr> Thread-Index: AcgwJJxX7TOOxT5NT+WwwEM5NtYTIAAAotVA X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Message-Id: <20071126122759.2734628C2F@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 12:28:01 -0000 > > > 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? 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... Regs, Jan