Date: Fri, 17 Jun 2005 11:18:13 -0400 From: "J. T. Farmer" <jfarmer@goldsword.com> To: freebsd-stable@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <42B2E9B5.7090803@goldsword.com> In-Reply-To: <005c01c57354$3e877900$fe00a8c0@uzi> References: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net> <005c01c57354$3e877900$fe00a8c0@uzi>
next in thread | previous in thread | raw e-mail | index | archive | help
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
----------------------------------------------------------------------
John T. Farmer Owner & CTO GoldSword Systems
jfarmer@goldsword.com 865-691-6498 Knoxville TN
Consulting, Design, & Development of Networks & Software
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42B2E9B5.7090803>