Date: Fri, 17 Jun 2005 11:28:24 -0400 From: JM <jmartin37@speakeasy.net> To: "J. T. Farmer" <jfarmer@goldsword.com> Cc: freebsd-stable@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <42B2EC18.3030407@speakeasy.net> In-Reply-To: <42B2E9B5.7090803@goldsword.com> References: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net> <005c01c57354$3e877900$fe00a8c0@uzi> <42B2E9B5.7090803@goldsword.com>
next in thread | previous in thread | raw e-mail | index | archive | help
J. T. Farmer wrote: > Uzi wrote: > >> [...] >> >>> super-smack select-key >>> 5.4-RELEASE ~20,000 queries/second >>> 6.0-CURRENT ~24,000 queries/second >>> CentOS w/async ~36,000 queries/second >>> CentOS w/sync ~26,000 queries/second >>> >>> super-smack update-select >>> 5.4-RELEASE ~4,000 queries/second >>> 6.0-CURRENT ~4,500 queries/second >>> CentOS w/async ~7,500 queries/second >>> CentOS w/sync ~750 queries/second >>> >>> That last CentOS number is not a typo, it was an order of magnitude >>> slower. I didn't try other file systems on CentOS, just the default >>> ext3. It's possible that reiserfs or xfs might not be as affected by >>> switching from async to sync. >>> >>> So my production server is now happily running mysql 4.1 on >>> 6.0-CURRENT :). >> >> >> I don't get it. >> You get 30% less perfomance, running a non-production release for >> production, and happy about it? > > > > Try reading it again. The last time I checked, 24k queries/sec _is_ > faster than > 20k queries/sec. And 4.5k queries/sec is faster than 4.0k queries/sec. > > John > i think you're missing the point... using CURRENT on a production machine is a bad idea... the performance is great, but hardly worth the risk of breaking something.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42B2EC18.3030407>