Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 25 Jun 2005 19:09:21 -0300
From:      "T.D.Wipnet (H.M.)" <tec@mega.net.br>
To:        freebsd-performance@freebsd.org
Subject:   Re: FreeBSD MySQL still WAY slower than Linux
Message-ID:  <200506251909.24905.tec@mega.net.br>
In-Reply-To: <42BD64F1.4080001@roq.com>
References:  <20050623145041.GC64879@bibipentium.lonres.com> <42BD64F1.4080001@roq.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Saturday 25 June 2005 11:06, Michael Vince wrote: 
> configuration file You will more then double your performance if
> you just start off by copying /usr/local/share/mysql/my-large.cnf

you are very fast with your conclusions ... 

I am not a system engineer but

IMO it is not as easy as you say

First for answering the thread, IMO, FBSD 4.11 has 20% of performance 
benefit comparing to 5.x (means 5.2.1-R 5.3-R and 5.4-R) on i386 as 
P-4 and P-3 machines  including AMD

This number I'm talking about is for GW-boxes running squid/proxies - 
[natd] - named - ipfw for certain limitations - dummy - mrtg - apache 
only for acessing local stats

means also that I am talking about servers with more than 2 NICs

means also that this server are well tuned (for my understandings) and 
with more than 2GB of RAM, SCSI UW-320 Adaptec and HD-UW320 and > 
2Ghz CPUs

there are appearently several issues on IPFW for FBSD 5.2 and above 
which are not resolved (natd,divert,ipfw count etc ...)

even if I do not have exact data I believe on my experience and 
especially stats that the performance on 4.11 is superiour to 5.x

On this special issue for MySQL I say: FBSd 5.x gets slowwww with 
DB-tables over 10MB and 4.11 does not care, query fast (and here does 
matter your personal .cf config)

anyway, seams for me that FBSD5.x is slow on any larger throughput, fs 
or nic does not matter and generally 5.x as router/gw do not even get 
close to 4.11

My experience is on almost 500 servers we have from 1 to 8 MB 
sustained througput each and we tried to migrate to 5.x about more 
than 6 month

On Mailservers ore any dedicated server with singleNIC I do *_NOT_* 
experience this difficulty[ies] and get sustained throughputs of 
8-10MB/s without any problem.

\Hans






-- 

WIPNET Telecom Ltda. http://wip.mega.net.br
http://wip.mega.net.br/tec.asc








A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200506251909.24905.tec>