From owner-freebsd-stable@FreeBSD.ORG Tue Jun 28 01:19:23 2005 Return-Path: X-Original-To: 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 420A816A4FE for ; Tue, 28 Jun 2005 01:19:08 +0000 (GMT) (envelope-from markir@paradise.net.nz) Received: from linda-3.paradise.net.nz (bm-3a.paradise.net.nz [202.0.58.22]) by mx1.FreeBSD.org (Postfix) with ESMTP id D75DB43E8D for ; Tue, 28 Jun 2005 01:11:17 +0000 (GMT) (envelope-from markir@paradise.net.nz) Received: from smtp-1.paradise.net.nz (smtp-1b.paradise.net.nz [202.0.32.210]) by linda-3.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IIR006XWSMSLA@linda-3.paradise.net.nz> for stable@freebsd.org; Tue, 28 Jun 2005 13:11:16 +1200 (NZST) Received: from [192.168.1.11] (218-101-14-94.paradise.net.nz [218.101.14.94]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id E849A827B9; Tue, 28 Jun 2005 13:11:15 +1200 (NZST) Date: Tue, 28 Jun 2005 13:11:15 +1200 From: Mark Kirkwood In-reply-to: <20050627161512.GE643@bibipentium.lonres.com> To: Steve Roome Message-id: <42C0A3B3.3080405@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050511) References: <20050627161512.GE643@bibipentium.lonres.com> Cc: 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: Tue, 28 Jun 2005 01:19:23 -0000 Steve Roome wrote: > I posted these results and anything else that went with this thread to > the freebsd-performance mailing list. > > -current proved a slightly better performer for us, but not enough to > bring it even close to the performance we get with gentoo. > > Off the top of my head the select key benchmarks were ROUGHLY: > > FreeBSD 5.various + MySQL 4.various : ROUGHLY 16k queries/second > FreeBSD 6.0-current + MySQL 4.1.12 : ROUGHLY 18k queries/second > Gentoo-something + MySQL 4.1.something : ROUGHLY 30k queries/second. > > The exact figures were posted to performance- (6.0 tests) and stable- > (gentoo vs. freebsd 5.x). > > Good luck to anyone who can manage to get MySQL to perform as well on > FreeBSD as Linux, we've been right out of luck so far and that's > really not advocating FreeBSD very well, which is what I'd rather be > doing. > I missed the mail where you mentioned this (apologies), thanks for updating us, well - me anyway :-) Hmmm - the results are a bit discouraging aren't they? I notice that (you mentioned) the Mysql guys were going to see if they can identify where the issue is. That would be good! best wishes Mark