From owner-freebsd-threads@FreeBSD.ORG Sun May 23 07:50:33 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 10D5C16A4CE for ; Sun, 23 May 2004 07:50:32 -0700 (PDT) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 674C743D48 for ; Sun, 23 May 2004 07:50:32 -0700 (PDT) (envelope-from eischen@vigrid.com) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mail.pcnet.com (8.12.10/8.12.1) with ESMTP id i4NEoN8Q013886; Sun, 23 May 2004 10:50:23 -0400 (EDT) Date: Sun, 23 May 2004 10:50:23 -0400 (EDT) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com 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 14:50:33 -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. How does remote vs local affect the threads library? If we're trying to narrow down where the performance bottleneck is, looking at the local benchmarks doesn't seem to point the finger at the threads library. > 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. Perhaps, but this is threads@ and if we're trying to narrow down where the bottleneck is ... > >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). Yes, but what do the entries mean? From the looks of them, none of them should affect how the threads library performs. I think they affect shared memory sizes, correct me if I'm wrong. > Tell me all the FreeBSD tests you want to see & I'll do them if I can. I think the tests you ran are fine, but just run them with the same version of the OS and mysql. Try to use -current if possible, there were a couple of bugs in libpthread (libkse as it was installed in 5.2-release) that affected its mysql performance. I think comparing local vs remote just shows how our network stack compares with Linux. Another thing to try is to change the my-huge.cnf settings one by one and see how they affect FreeBSD local performance. -- Dan Eischen