From owner-freebsd-threads@FreeBSD.ORG Sat May 22 21:40:45 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 9E6CB16A4CE for ; Sat, 22 May 2004 21:40:45 -0700 (PDT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by mx1.FreeBSD.org (Postfix) with ESMTP id 528E043D1D for ; Sat, 22 May 2004 21:40:44 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (sccrmhc12) with ESMTP id <2004052304402101200fkebje>; Sun, 23 May 2004 04:40:26 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id VAA05663; Sat, 22 May 2004 21:40:20 -0700 (PDT) Date: Sat, 22 May 2004 21:40:18 -0700 (PDT) From: Julian Elischer To: JG In-Reply-To: <5.2.0.9.2.20040522212217.01511190@mail.ojoink.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: freebsd-threads@freebsd.org 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:40:45 -0000 On Sat, 22 May 2004, JG wrote: > > > >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). > > > > For a start there are the following variations to try: SCHED_ULE vs SCHED_4BSD SCOPE_SYSTEM vs SCOPE_PROCESS threads > Tell me all the FreeBSD tests you want to see & I'll do them if I can. > > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" >