From owner-freebsd-threads@FreeBSD.ORG Sat May 22 21:33:21 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 86ED516A4CE for ; Sat, 22 May 2004 21:33:21 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 42A5443D2F for ; Sat, 22 May 2004 21:33:19 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 30349 invoked by uid 89); 23 May 2004 04:37:46 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 23 May 2004 04:37:46 -0000 Message-Id: <5.2.0.9.2.20040522212217.01511190@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Sat, 22 May 2004 21:33:22 -0700 To: freebsd-threads@freebsd.org From: JG In-Reply-To: References: <5.2.0.9.2.20040522153551.01459300@mail.ojoink.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: Re: Why is MySQL nearly twice as fast on Linux? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 23 May 2004 04:33:21 -0000 >Along with the other benchmarks it's still a little apples >and oranges. I've seen different versions of mysql run >with different versions of FreeBSD. I'm going to stick with 4.0.20 from now for tests. Most of my tests were done on 4.0.20. > I'd like to see the >same mysql version run on the same hardware with libpthread >and linuxthreads. I'll have to do that on the i386 install tomorrow, as Linuxthreads is not available for FreeBSD/AMD64. >This shows that -current (both SMP and UP) with libpthread is >faster than linuxthreads (different versions of FreeBSD and >mysql, though). For FreeBSD nothing (remote) has been faster than the i386 Linuxthreads test. I'll do everything local tomorrow. >Also, if you use the default mysql config settings, then >FreeBSD remote vs Linuxthreads remote also wins (2685.53 >vs. 2091.10 from earlier post). I understand what you're saying, but those numbers are horrible. >What modifications are you making to /etc/my.cnf and why >do they turn the results around the other way? I used either my-huge.cnf or no config file at all (as noted in the benchmarks). Tell me all the FreeBSD tests you want to see & I'll do them if I can.