From owner-freebsd-threads@FreeBSD.ORG Mon May 24 11:10:48 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 50D6416A4CE for ; Mon, 24 May 2004 11:10:48 -0700 (PDT) Received: from mail1.mail.iol.ie (mail1.mail.iol.ie [193.120.142.151]) by mx1.FreeBSD.org (Postfix) with ESMTP id AD5F943D31 for ; Mon, 24 May 2004 11:10:47 -0700 (PDT) (envelope-from s_sourceforge@nedprod.com) Received: from dialup130.ts521.cwt.esat.net ([194.165.162.130] helo=kate) by mail1.mail.iol.ie with esmtp (Exim 3.36 #9) id 1BSJtn-0003wu-00 for freebsd-threads@freebsd.org; Mon, 24 May 2004 19:10:07 +0100 From: "Niall Douglas" To: JG Date: Mon, 24 May 2004 18:45:02 +0100 MIME-Version: 1.0 Message-ID: <40B242AE.16121.2FAF11E3@localhost> Priority: normal In-reply-to: <5.2.0.9.2.20040523201120.0158a100@mail.ojoink.com> References: <5.2.0.9.2.20040523200223.01583468@mail.ojoink.com> X-PM-Encryptor: IDWPGP-PM32, 4 X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body 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: Mon, 24 May 2004 18:10:48 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 23 May 2004 at 20:23, JG wrote: > Is this a threads problem? > > Is this a kernel problem? > > Is this a MySQL problem? > > Or some combination of all three... or more. > > Does anyone even know what the problem is? Or care to find out? > [snip] > I love using FreeBSD, but this performance issue is really starting to > frustrate me. I've kept out of this so far but maybe now we're at straw clutching time my experiences might be useful. I've personally found that in general the same applications run faster on FreeBSD than Linux. KDE is noticeably more responsive and I can happily use 256Mb RAM for FreeBSD whereas Linux needs 384Mb RAM in VMWare. However when it comes to threads, things stop working properly. I never got my code to work with libc_r at all. With kse threads, pipes ran fine but I never got sockets working (v5.2.1). There appears to be something odd with sockets in threads, they appear to hang momentarily for no reason. I don't know if that's fixed yet. Perhaps MySQL is seeing pauses during threaded socket i/o though I'd have thought it would use pipes when it can. It's worth checking which your build of MySQL is using and whichever it is, try the other one to see what difference it makes. Cheers, Niall -----BEGIN PGP SIGNATURE----- Version: idw's PGP-Frontend 4.9.6.1 / 9-2003 + PGP 8.0.2 iQA/AwUBQLI0n8EcvDLFGKbPEQKNfwCbBFc4BUh6l5PabzQWk0EY9EBJrDEAn3Wl BEAu0FkWOeepTJYszTp5jHYY =YVcD -----END PGP SIGNATURE-----