From owner-freebsd-questions@FreeBSD.ORG Tue Nov 27 16:11:42 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 D6DED16A419 for ; Tue, 27 Nov 2007 16:11:42 +0000 (UTC) (envelope-from josh.carroll@gmail.com) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by mx1.freebsd.org (Postfix) with ESMTP id 1690513C4D1 for ; Tue, 27 Nov 2007 16:11:41 +0000 (UTC) (envelope-from josh.carroll@gmail.com) Received: by py-out-1112.google.com with SMTP id u77so2702049pyb for ; Tue, 27 Nov 2007 08:11:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=X/qLLKmzh2i5UVAHrl3Fcti7/BpmAzYDy0LsowkX6Gc=; b=PjPodRCezQwH82RcLOUSXgFERHj0y+jzAll5Wzh36w+rV3QeswAyb+0J+nTujx83HxojofmokLti/qnXFWKmSn8woAvNNFdzPhY7G5tVpSZtaRO0XnKr+Rpbi4Ch9q4NondxsuNurXUfFXY6Y+NTXTlPEWbIHK8uE6Vrx+7917c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bhI1BZFpw6Fd6mkiE3+wFzTsXw8is2P/dES1/Qxqr3QbfyeW3W4480X2QUDSwXeQI4gsYLZMeQL70XVOKIberu/O3NAes8UIuGHjR/LTiQsqtK9wrqAt1+M6ZLZTct2YThcb8tPQgogItz0SS3EGHcpMGRjjqaWNeJF8GbbrTKg= Received: by 10.35.86.19 with SMTP id o19mr4915258pyl.1196179893903; Tue, 27 Nov 2007 08:11:33 -0800 (PST) Received: by 10.35.57.12 with HTTP; Tue, 27 Nov 2007 08:11:33 -0800 (PST) Message-ID: <8cb6106e0711270811r706fa81di9fafa79acfd227a1@mail.gmail.com> Date: Tue, 27 Nov 2007 11:11:33 -0500 From: "Josh Carroll" To: "Ted Mittelstaedt" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20071127130020.GA81551@pcjas.obspm.fr> Cc: Albert.Shih@obspm.fr, 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: josh.carroll@gmail.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Nov 2007 16:11:42 -0000 > Is Hyperthreading enabled (by default it is not under > FreeBSD) mysql is heavily dependent on threading, if it is not > built and linked into the freebsd threads package you will get > poor performance. Some folks have installed the linux compat libs > and linked mysql into the linux threads package and reported good > results. Actually, on 6.2, it's better to use libthr instead of libpthread. This can be done for MySQL only, but to test this without recompiling MySQL, he can: % echo "libpthread.so.2 libthr.so.2" >> /etc/libmap.conf Then restart the mysql server and test again. I noticed a huge increase in performance on 6.2 with libthr instead of libpthread. It wasn't a 10x improvement, though, so there is definitely something else going on with his setup. Regards, Josh