From owner-freebsd-current@FreeBSD.ORG Wed Oct 26 13:04:01 2005 Return-Path: X-Original-To: current@freebsd.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E1A0516A420 for ; Wed, 26 Oct 2005 13:04:01 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id A8AE843D5E for ; Wed, 26 Oct 2005 13:04:00 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [209.31.154.41]) by cyrus.watson.org (Postfix) with ESMTP id 4776A46B85; Wed, 26 Oct 2005 09:04:00 -0400 (EDT) Date: Wed, 26 Oct 2005 14:04:00 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: Marian Hettwer In-Reply-To: <435F7B67.5080709@kernel32.de> Message-ID: <20051026135927.Y32255@fledge.watson.org> References: <435F48DA.6060009@kernel32.de> <20051026105411.L32255@fledge.watson.org> <435F6B01.5020003@kernel32.de> <20051026133606.O32255@fledge.watson.org> <435F7B67.5080709@kernel32.de> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: current@freebsd.org Subject: Re: MySQL Performance 6.0rc1 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Oct 2005 13:04:02 -0000 On Wed, 26 Oct 2005, Marian Hettwer wrote: >>> my.cnf is pretty much my-medium.cnf on Debian and FreeBSD. Although, >>> Debian has MySQL 4.1.11 and FreeBSD Ports has MySQL 4.1.14. As >>> mentioned before, this benchmark here is a quick shot. However, the >>> difference shouldn't be _that_ large (3600 vs. 14000). >> >> I think you will find people generally agree with this viewpoint. :-) >> > Ack. the difference is that huge... well, for some reasons I don't know, > I think a look into Linux' way of threading may be worth, hm? By the above, I mean that people will generally agree with the viewpoint that the difference is huge, and shouldn't be. The reason I suggested you try libthr is twofold: (1) libthr has undergone more performance optimization for MySQL -- in fact, MySQL has been one of the specific workload targets for libthr. (2) libthr uses a threading model more like the Linux model, and since MySQL has been heavily optimized for Linux, that also helps out. Note performance optimization for applications is often one by looking at what the underlying OS does badly, and what it does well, and modifying the application to use more features where it does well, and fewer where it does badly. This means, for example, that if Linux is optimized to support a small number of threads, and FreeBSD is optimized for a large number of threads, that MySQL developers who are targetting Linux will focus on having a small number of threads. This is an interesting property of plugging lots of parts together, and can't be ignored... It goes both ways, of course. Robert N M Watson