From owner-freebsd-performance@FreeBSD.ORG Sun Jun 26 07:38:52 2005 Return-Path: X-Original-To: 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 F273F16A41C for ; Sun, 26 Jun 2005 07:38:51 +0000 (GMT) (envelope-from pfak@telus.net) Received: from priv-edtnes40.telusplanet.net (outbound05.telus.net [199.185.220.224]) by mx1.FreeBSD.org (Postfix) with ESMTP id A487E43D1D for ; Sun, 26 Jun 2005 07:38:51 +0000 (GMT) (envelope-from pfak@telus.net) Received: from [192.168.1.151] (really [64.180.103.26]) by priv-edtnes40.telusplanet.net (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id <20050626073851.PKZQ18930.priv-edtnes40.telusplanet.net@[192.168.1.151]>; Sun, 26 Jun 2005 01:38:51 -0600 Message-ID: <42BE5B8E.6070702@telus.net> Date: Sun, 26 Jun 2005 00:38:54 -0700 From: Peter Kieser User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Shawn Mitchell References: <20050626032128.CB954204F16@kcmop04.iodamedia.net> In-Reply-To: <20050626032128.CB954204F16@kcmop04.iodamedia.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: 'Michael Vince' , 'Steve Roome' , 'Daniel Gerzo' , performance@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 26 Jun 2005 07:38:52 -0000 They work fine on RELENG_5. --Peter Shawn Mitchell wrote: >Can't remember off the top of my head, I'll throw 5.x onto a lab box here in >a bit and see. > >-Shawn > > >-----Original Message----- >From: Daniel Gerzo [mailto:danger@rulez.sk] >Sent: Saturday, June 25, 2005 2:59 PM >To: Shawn Mitchell >Cc: 'Michael Vince'; 'Steve Roome'; performance@freebsd.org >Subject: Re[2]: FreeBSD MySQL still WAY slower than Linux > >Nemam dobru naladu Shawn, > >Saturday, June 25, 2005, 7:26:22 PM, si odoslal: > > > >>I tested a MySQL install on a Dell 6600. It's specs were 8 GB ram, 12 x >> >> >73 > > >>15k rpm drives (Ultra320) on a RAID5, 4 Xeon MP w/ 2 meg of cache, HT >>enabled so the OS saw 8 CPU's. >> >> > > > >>Every time, a stock linux install (SuSE, CentOS, and Fedora) were always >>faster than FreeBSD stock, or custom kernel utilizing different options. >> >> > > > >>I never could fully benchmark it running on Linux; as I never got the >> >> >server > > >>to max out before my benchmarking machine maxed out. >> >> > > > >>If your using 4.x, add these to your config file >> >> > > > >>options MAXDSIZ="(256*1024*1024)" >>options MAXSSIZ="(256*1024*1024)" >>options DFLDSIZ="(256*1024*1024)" >> >> > >these are not possible to use under 5.x? > > > >>I noticed a HUGE difference on FreeBSD with those added, but it still >>doesn't crank up there with Linux. >> >> > > > >>Also, default linux install's do not make it use more ram. You still have >>to copy one of the my-xxx.cnf files over to /etc/my.cnf or >>/usr/local/etc/my.cnf >> >> > > > >>MySQL is developed on Linux, and ported to FreeBSD. That's the best >>explanation you'll get probably. >> >> > > > >>Your posting a lot of configuration here except the most easily >>important one for performance in MySQL, thats your my.cnf configuration >> >> >file > > >>You will more then double your performance if you just start off by >> >> >copying > > >>/usr/local/share/mysql/my-large.cnf >>to >>/var/db/mysql >>MySQL out of the box setup to use a tiny amount of ram and it wouldn't >>surprise me if a lot of Linux distributions have a much more high >>performance my.cnf file since most distributions are aimed at people who >>don't know what they are doing. >> >> > > > >