From owner-freebsd-stable@FreeBSD.ORG Fri Jun 10 20:37:26 2005 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6B1B216A41C for ; Fri, 10 Jun 2005 20:37:26 +0000 (GMT) (envelope-from ghelmer@palisadesys.com) Received: from magellan.palisadesys.com (magellan.palisadesys.com [192.188.162.211]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1D5D643D49 for ; Fri, 10 Jun 2005 20:37:25 +0000 (GMT) (envelope-from ghelmer@palisadesys.com) Received: from [192.188.162.240] (volans.palisadesys.com [192.188.162.240]) (authenticated bits=0) by magellan.palisadesys.com (8.12.11/8.12.11) with ESMTP id j5AKbNk2066060 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 10 Jun 2005 15:37:23 -0500 (CDT) (envelope-from ghelmer@palisadesys.com) Message-ID: <42A9FA02.5080401@palisadesys.com> Date: Fri, 10 Jun 2005 15:37:22 -0500 From: Guy Helmer User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050413) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Steve Roome References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> In-Reply-To: <20050610170537.GA67849@bibipentium.lonres.com> X-Palisade-MailScanner-Information: Please contact the ISP for more information X-Palisade-MailScanner: Found to be clean X-MailScanner-From: ghelmer@palisadesys.com Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-stable@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 10 Jun 2005 20:37:26 -0000 Steve Roome wrote: >We're using mostly: > > 5.4-STABLE FreeBSD 5.4-STABLE #0: Mon Jun 6 12:22:18 BST 2005 > >This is on a Dell PowerEdge 2850. (2 * 2.8 GHz Xeons, 4GB ram, disks), >we've been keeping up with stable because supposedly all these new >fixes to threading will help us out here. > >We're trying to get FreeBSD to perform reasonably well, in comparison >to Linux, or even what we should expect to see. We're getting about >half the performance we get from gentoo on the same application >(mysql). > >The discussion on the 'freebsd-threads' mailing list about a year ago >seems to match our experiences nowadays pretty well: > > http://lists.freebsd.org/pipermail/freebsd-threads/2004-May/002002.html > >Nothing much seems to have changed, although lots of people claim that >FreeBSD 5.x is now fine, it doesn't seem to be. > >Here's a rough breakdown of the sort of performance we're seeing, this >is the default select-key super-smack but setup for innodb rather than >myisam. > > > >>Using the simple 'select-key.smack' Super-Smack benchmark (50 clients >>with 1000 runs each): >> >>OS CPUs Build Threading Kqueries/sec >>------------------------------------------------------------- >>FreeBSD 1 Pro KSE 10.6 >>FreeBSD 1 Pro libthr 10.6 >>FreeBSD 2 Pro libthr 14.4 >>FreeBSD 2 Source libthr 14.5 >>FreeBSD 2 Source KSE/P (static) 15.7 >>FreeBSD 2 Source KSE/P (dynamic) 15.8 >>FreeBSD 2 Source KSE/S (dynamic) 15.8 >>FreeBSD 2 Pro KSE 15.9 >>FreeBSD 2 Source LinuxThreads 17.7 >>Gentoo 2 Source NPTL 34.0 !! >> >>(KSE/P = KSE with Process Scope Threading, KSE/S = KSE with System >>Scope Threading) >> >> > Quick ideas: Have you tried a kernel with PREEMPTION enabled? I haven't quantified the effect, but it's improved performance in some situations. Have you tried increasing vfs.read_max? Guy -- Guy Helmer, Ph.D., Principal System Architect, Palisade Systems, Inc. ghelmer@palisadesys.com http://www.palisadesys.com/~ghelmer