From owner-freebsd-questions@FreeBSD.ORG Fri Nov 23 22:15:31 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 7BCF716A41B for ; Fri, 23 Nov 2007 22:15:31 +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 26A3B13C469 for ; Fri, 23 Nov 2007 22:15:30 +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 lANMFTaw000956 for ; Fri, 23 Nov 2007 23:15:29 +0100 Date: Fri, 23 Nov 2007 23:15:29 +0100 From: Albert Shih To: freebsd-questions@freebsd.org Message-ID: <20071123221529.GA48031@pcjas.obspm.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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]); Fri, 23 Nov 2007 23:15:29 +0100 (CET) X-Virus-Scanned: ClamAV version 0.91.2, clamav-milter version 0.91.2 on mesiob.obspm.fr X-Virus-Status: Clean Subject: Tunning 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: Fri, 23 Nov 2007 22:15:31 -0000 Hi all I've some question about MySQL on FreeBSD 6.x. I've running MySQL 5.x on FreeBSD 6.x on a dual Xeon 3.2Ghz (mono-core) with 2 SAS 10000 rpm. And the perf is very...poor (x10 vs Linux) and it's nothing about thread because the performance is poor for a single select in mysql. I known you want to say when 7.0 come out everything go fine hummm.... Well, event it's true I cannont make the migration so fast. What's I want to known is how can tunning my FreeBSD and my Mysql for increase the performance. What's option I need to choose on mysql compilation. etc.... I forget to say the Mysql run into a jail but I think this don't have any impact. Regards. -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Ven 23 nov 2007 23:09:02 CET