From owner-freebsd-questions@FreeBSD.ORG Tue Nov 27 13:04:15 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 13EBE16A46C for ; Tue, 27 Nov 2007 13:04:15 +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 A31F813C46B for ; Tue, 27 Nov 2007 13:04:14 +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 lARD4BIo002750; Tue, 27 Nov 2007 14:04:11 +0100 Date: Tue, 27 Nov 2007 14:04:11 +0100 From: Albert Shih To: "Philip M. Gollucci" Message-ID: <20071127130411.GD81551@pcjas.obspm.fr> References: <20071126115022.GA70340@pcjas.obspm.fr> <474ABA1B.9070808@riderway.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <474ABA1B.9070808@riderway.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:04:11 +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:04:15 -0000 Le 26/11/2007 à 07:20:43-0500, Philip M. Gollucci a écrit > Albert Shih wrote: > > 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. > Well -- we'll need more information, but as your say, if its not > threading related what makes you think its FreeBSD. You'd probably have > better luck over on mysql@lists.mysql.com. Thanks for this information. > Also, your my.cnf is the next step. [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 log-bin=mysql-bin server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Regards. JAS -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Mar 27 nov 2007 14:02:31 CET