From owner-freebsd-stable@FreeBSD.ORG Fri Jun 17 15:19:26 2005 Return-Path: X-Original-To: freebsd-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 D5D9E16A41C for ; Fri, 17 Jun 2005 15:19:26 +0000 (GMT) (envelope-from jfarmer@goldsword.com) Received: from audi.websitewelcome.com (audi.websitewelcome.com [67.19.210.130]) by mx1.FreeBSD.org (Postfix) with ESMTP id B0F0C43D1F for ; Fri, 17 Jun 2005 15:19:26 +0000 (GMT) (envelope-from jfarmer@goldsword.com) Received: from adsl-065-013-105-239.sip.tys.bellsouth.net ([65.13.105.239]:4234 helo=[192.168.1.33]) by audi.websitewelcome.com with esmtpa (Exim 4.50) id 1DjIcs-00036t-3T for freebsd-stable@freebsd.org; Fri, 17 Jun 2005 10:19:22 -0500 Message-ID: <42B2E9B5.7090803@goldsword.com> Date: Fri, 17 Jun 2005 11:18:13 -0400 From: "J. T. Farmer" Organization: GoldSword Systems User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.7.7) Gecko/20050414 X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-stable@freebsd.org References: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net> <005c01c57354$3e877900$fe00a8c0@uzi> In-Reply-To: <005c01c57354$3e877900$fe00a8c0@uzi> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - audi.websitewelcome.com X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - goldsword.com X-Source: X-Source-Args: X-Source-Dir: 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: Fri, 17 Jun 2005 15:19:27 -0000 Uzi wrote: > [...] > >> super-smack select-key >> 5.4-RELEASE ~20,000 queries/second >> 6.0-CURRENT ~24,000 queries/second >> CentOS w/async ~36,000 queries/second >> CentOS w/sync ~26,000 queries/second >> >> super-smack update-select >> 5.4-RELEASE ~4,000 queries/second >> 6.0-CURRENT ~4,500 queries/second >> CentOS w/async ~7,500 queries/second >> CentOS w/sync ~750 queries/second >> >> That last CentOS number is not a typo, it was an order of magnitude >> slower. I didn't try other file systems on CentOS, just the default >> ext3. It's possible that reiserfs or xfs might not be as affected by >> switching from async to sync. >> >> So my production server is now happily running mysql 4.1 on >> 6.0-CURRENT :). > > I don't get it. > You get 30% less perfomance, running a non-production release for > production, and happy about it? Try reading it again. The last time I checked, 24k queries/sec _is_ faster than 20k queries/sec. And 4.5k queries/sec is faster than 4.0k queries/sec. John ---------------------------------------------------------------------- John T. Farmer Owner & CTO GoldSword Systems jfarmer@goldsword.com 865-691-6498 Knoxville TN Consulting, Design, & Development of Networks & Software