From owner-freebsd-performance@FreeBSD.ORG Fri Oct 20 20:06:59 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 1080416A407 for ; Fri, 20 Oct 2006 20:06:59 +0000 (UTC) (envelope-from emaste@phaedrus.sandvine.ca) Received: from gw.sandvine.com (sandvine.com [199.243.201.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 33C9843DF1 for ; Fri, 20 Oct 2006 20:06:39 +0000 (GMT) (envelope-from emaste@phaedrus.sandvine.ca) Received: from mailserver.sandvine.com ([192.168.1.10]) by gw.sandvine.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 20 Oct 2006 16:06:39 -0400 Received: from labgw2.phaedrus.sandvine.com ([192.168.3.11]) by mailserver.sandvine.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 20 Oct 2006 16:06:38 -0400 Received: by labgw2.phaedrus.sandvine.com (Postfix, from userid 12627) id 9158211614; Fri, 20 Oct 2006 16:06:38 -0400 (EDT) Date: Fri, 20 Oct 2006 16:06:38 -0400 From: Ed Maste To: Mike Tancsa Message-ID: <20061020200638.GA18727@sandvine.com> References: <7.0.1.0.0.20061020104944.144d9068@sentex.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7.0.1.0.0.20061020104944.144d9068@sentex.net> User-Agent: Mutt/1.4.2.1i X-OriginalArrivalTime: 20 Oct 2006 20:06:38.0785 (UTC) FILETIME=[40922310:01C6F483] 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:06:59 -0000 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. 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. -Ed Maste