From owner-freebsd-performance@FreeBSD.ORG Fri Oct 20 20:29:16 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 5D34416A47B for ; Fri, 20 Oct 2006 20:29:16 +0000 (UTC) (envelope-from mike@sentex.net) Received: from smarthost1.sentex.ca (smarthost1.sentex.ca [64.7.153.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3B72E44133 for ; Fri, 20 Oct 2006 20:21:37 +0000 (GMT) (envelope-from mike@sentex.net) Received: from lava.sentex.ca (pyroxene.sentex.ca [199.212.134.18]) by smarthost1.sentex.ca (8.13.6/8.13.6) with ESMTP id k9KKLaJT050436; Fri, 20 Oct 2006 16:21:36 -0400 (EDT) (envelope-from mike@sentex.net) Received: from mdt-xp.sentex.net (simeon.sentex.ca [192.168.43.27]) by lava.sentex.ca (8.13.6/8.13.3) with ESMTP id k9KKLZWs091728 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 20 Oct 2006 16:21:35 -0400 (EDT) (envelope-from mike@sentex.net) Message-Id: <7.0.1.0.0.20061020161447.16083e08@sentex.net> X-Mailer: QUALCOMM Windows Eudora Version 7.0.1.0 Date: Fri, 20 Oct 2006 16:21:40 -0400 To: Ed Maste From: Mike Tancsa In-Reply-To: <20061020200638.GA18727@sandvine.com> References: <7.0.1.0.0.20061020104944.144d9068@sentex.net> <20061020200638.GA18727@sandvine.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: ClamAV version 0.88.3, clamav-milter version 0.88.3 on clamscanner2 X-Virus-Status: Clean Cc: freebsd-performance@freebsd.org 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 20:29:16 -0000 At 04:06 PM 10/20/2006, Ed Maste wrote: >On Fri, Oct 20, 2006 at 02:57:46PM -0400, Mike Tancsa wrote: > > > With all the threads about poor FreeBSD performance, I wanted to test > > it out myself to see how 64bit LINUX would compare using the same hardware. >[ snip ] > >It seems your message ended up with some unfortunate line wrapping, >which made it a little hard to see at a glance what the results were. Sorry about that, my 21 inch Radiation Master has a very wide res ;-) >Scott sent me them reformatted as: > > BSD LINUX >time mysql rt3 all.out (full import) 106m 123m >first full content search 35.92 45.29 >Second content search after first full content > search 24.66 26.14 >Subject search 0.48 0.35 >4 different select scripts run at the same time > on different tables 62 59 >create index Subject_IDX on Tickets (Sub 8.29 7.12 > >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 e.g. you could look at these results and say "so the import takes a long time, big deal. you only do that once! Look at the index, its 15% faster!" or "the index creation is barely a second... a second, big whoop. Look at the time to import, thats a big difference!" or... You are just measuring the quality of the driver or the speed of the disks etc etc... or "try 40 queries at the same time and you will see a BIG difference".... well, when my requirements get to 40 queries at once, great, I will focus testing on those requirements! For me, this exercise was very much driven by my own need to understand if there really would be a big (I mean > 50% in *my* world tests) to make it worth while to use LINUX that is (for me anyways) more cumbersome and less stable to administer (read more $$$$ and headache). I have to be practical about the boxes I manage. Put another way, if the same gear under FreeBSD is 10% slower than LINUX, the one time cost for me to buy hardware that will be 10% faster is laughably trivial.... The on going cost (let alone GNU vs BSD for our OEM products we put out) is WAY more. The next set of comparisons I want to run is in our spam scanners. The boxes which operate in round robin make heavy use of mysql, DNS lookups, perl, net io etc etc. That one I am quite interested in and will post the results in a week or two. ---Mike