From owner-freebsd-performance@FreeBSD.ORG Fri Oct 20 21:57:21 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 21D5116A4D1 for ; Fri, 20 Oct 2006 21:57:21 +0000 (UTC) (envelope-from michel@lpthe.jussieu.fr) Received: from shiva.jussieu.fr (shiva.jussieu.fr [134.157.0.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id F106843D8B for ; Fri, 20 Oct 2006 21:56:10 +0000 (GMT) (envelope-from michel@lpthe.jussieu.fr) Received: from parthe.lpthe.jussieu.fr (parthe.lpthe.jussieu.fr [134.157.10.1]) by shiva.jussieu.fr (8.13.7/jtpda-5.4) with ESMTP id k9KLu9uA088524 for ; Fri, 20 Oct 2006 23:56:09 +0200 (CEST) X-Ids: 166 Received: from niobe.lpthe.jussieu.fr (niobe.lpthe.jussieu.fr [134.157.10.41]) by parthe.lpthe.jussieu.fr (Postfix) with ESMTP id E9A98A0061 for ; Fri, 20 Oct 2006 23:56:08 +0200 (CEST) Received: by niobe.lpthe.jussieu.fr (Postfix, from userid 2005) id 01FEE1D; Fri, 20 Oct 2006 23:56:30 +0200 (CEST) Date: Fri, 20 Oct 2006 23:56:30 +0200 From: Michel Talon To: freebsd-performance@freebsd.org Message-ID: <20061020215630.GA3028@lpthe.jussieu.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (shiva.jussieu.fr [134.157.0.166]); Fri, 20 Oct 2006 23:56:09 +0200 (CEST) X-Virus-Scanned: ClamAV 0.88.2/2060/Fri Oct 20 21:45:33 2006 on shiva.jussieu.fr X-Virus-Status: Clean X-Miltered: at shiva.jussieu.fr with ID 453945F9.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Mailman-Approved-At: Fri, 20 Oct 2006 23:17:46 +0000 Subject: Re: LINUX vs FreeBSD mysql performance using a large RT database X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 20 Oct 2006 21:57:21 -0000 >>If this is what you measured, the results look fairly competitive. >>Thanks for performing this real-world test and posting this info. > > >As I was saying to gnn offlist, you can look at these numbers all sorts of >ways In fact this type of result is not surprising at all, it has already been found by mysql specialists benchmarking Linux and FreeBSD here: http://www.mysqlperformanceblog.com/2006/06/15/freebsd-tests/ Of course one needs to look the results *after* the sentence: " I'm not big expert in FreeBSD and did not saw http://wikitest.freebsd.org/MySQL before. This page recommends to use libthr instead of libthreads. The results with libthr looks better: " which show that, on a dual core athlon, Linux and FreeBSD are basically equivalent. The real FreeBSD problem is that people say that it does not scale well on more than 4 processors. But, obviously things are becoming better and better, and machines with many processors are still not very common. It has taken a lot of time until Solaris has been optimized to not be a mollasse, and similarly Linux has taken some time before scaling well. -- Michel TALON