From owner-freebsd-performance@FreeBSD.ORG Sun Jun 26 03:21:34 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 0419E16A41C for ; Sun, 26 Jun 2005 03:21:34 +0000 (GMT) (envelope-from shawnm@iodamedia.net) Received: from kcmop04.iodamedia.net (kcmop04.iodamedia.net [66.39.199.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id BDF9A43D48 for ; Sun, 26 Jun 2005 03:21:33 +0000 (GMT) (envelope-from shawnm@iodamedia.net) Received: from localhost (localhost.iodamedia.net [127.0.0.1]) by kcmop04.iodamedia.net (Postfix) with ESMTP id 342AD18EA3F; Sat, 25 Jun 2005 22:21:33 -0500 (CDT) Received: from kcmop04.iodamedia.net ([127.0.0.1]) by localhost (kcmop04.iodamedia.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17789-06; Sat, 25 Jun 2005 22:21:29 -0500 (CDT) Received: from zeus (CPE-65-30-37-142.kc.res.rr.com [65.30.37.142]) by kcmop04.iodamedia.net (Postfix) with ESMTP id CB954204F16; Sat, 25 Jun 2005 22:21:28 -0500 (CDT) From: "Shawn Mitchell" To: "'Daniel Gerzo'" Date: Sat, 25 Jun 2005 22:21:28 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 In-reply-to: <1986158848.20050625215848@rulez.sk> Thread-Index: AcV5xdNFcjvBZ0OITU2HsQeo9z4H4AAOC/mw Message-Id: <20050626032128.CB954204F16@kcmop04.iodamedia.net> X-Virus-Scanned: amavisd-new at kcmop04.iodamedia.net Cc: 'Michael Vince' , 'Steve Roome' , performance@freebsd.org Subject: RE: Re[2]: 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 03:21:34 -0000 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. -- Nieze by som chcel este nieco napisat, ale uz som to napisal. DanGer, ICQ: 261701668 | e-mail protecting at: http://www.2pu.net/ http://danger.rulez.sk | proxy list at: http://www.proxy-web.com/ | FreeBSD - The Power to Serve! [ s pokrokom by nic nebolo, len nie a nie ho skoncit. ]