From owner-freebsd-performance@FreeBSD.ORG Sat Jun 25 22:10:08 2005 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D5A3216A41C for ; Sat, 25 Jun 2005 22:10:08 +0000 (GMT) (envelope-from tec@mega.net.br) Received: from msrv.matik.com.br (msrv.matik.com.br [200.152.83.14]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2895143D49 for ; Sat, 25 Jun 2005 22:10:07 +0000 (GMT) (envelope-from tec@mega.net.br) Received: from [200.152.82.190] ([200.152.82.190]) by msrv.matik.com.br (8.13.1/8.12.11) with ESMTP id j5PMAAJv081869 for ; Sat, 25 Jun 2005 19:10:10 -0300 (BRST) (envelope-from tec@mega.net.br) From: "T.D.Wipnet (H.M.)" To: freebsd-performance@freebsd.org Date: Sat, 25 Jun 2005 19:09:21 -0300 User-Agent: KMail/1.8 References: <20050623145041.GC64879@bibipentium.lonres.com> <42BD64F1.4080001@roq.com> In-Reply-To: <42BD64F1.4080001@roq.com> Organization: Wipnet Telecom Ltda MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200506251909.24905.tec@mega.net.br> X-Filter-Version: 1.11a (msrv.matik.com.br) X-Virus-Scanned: ClamAV version 0.83, clamav-milter version 0.83 on msrv.matik.com.br X-Virus-Status: Clean Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: tec@mega.net.br List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 25 Jun 2005 22:10:09 -0000 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