FreeBSD MySQL still WAY slower than Linux

JM jmartin37 at speakeasy.net
Fri Jun 17 15:28:28 GMT 2005


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.


More information about the freebsd-stable mailing list