Date: Mon, 24 May 2004 18:45:02 +0100 From: "Niall Douglas" <s_sourceforge@nedprod.com> To: JG <amd64list@jpgsworld.com> Cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? Message-ID: <40B242AE.16121.2FAF11E3@localhost> In-Reply-To: <5.2.0.9.2.20040523201120.0158a100@mail.ojoink.com> References: <5.2.0.9.2.20040523200223.01583468@mail.ojoink.com>
next in thread | previous in thread | raw e-mail | index | archive | help
-----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?40B242AE.16121.2FAF11E3>