From owner-freebsd-sparc64@FreeBSD.ORG Fri Mar 18 23:32:23 2005 Return-Path: Delivered-To: freebsd-sparc64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C842A16A4CE for ; Fri, 18 Mar 2005 23:32:23 +0000 (GMT) Received: from ghostwheel.tribble.net (ghostwheel.tribble.net [63.251.177.34]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6CAFD43D53 for ; Fri, 18 Mar 2005 23:32:23 +0000 (GMT) (envelope-from tribble@tribble.net) Received: from ghostwheel.tribble.net (tribble@localhost.tribble.net [127.0.0.1])j2INWJrq051583 for ; Fri, 18 Mar 2005 16:32:19 -0700 (MST) (envelope-from tribble@tribble.net) Received: (from tribble@localhost) by ghostwheel.tribble.net (8.13.1/8.13.1/Submit) id j2INWJrt051582 for sparc64@freebsd.org; Fri, 18 Mar 2005 16:32:19 -0700 (MST) (envelope-from tribble@tribble.net) X-Authentication-Warning: ghostwheel.tribble.net: tribble set sender to tribble@tribble.net using -f Date: Fri, 18 Mar 2005 16:32:19 -0700 From: Paul Schiro To: sparc64@freebsd.org Message-ID: <20050318233219.GA51467@tribble.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-PGP-Key: http://www.tribble.net/trib-pubkey.asc X-PGP-Fingerprint: 385D 453B 37B6 D54E 1B62 A44F D709 E581 1644 902D X-Virus-Scanned: by amavisd-new Subject: MySQL 4.1 on FreeBSD 5.4-PRERELEASE X-BeenThere: freebsd-sparc64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting FreeBSD to the Sparc List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 18 Mar 2005 23:32:23 -0000 I have an Ultra 80 w/ 2GB RAM and 4 450mhz CPUs. I installed FreeBSD 5.3-RELEASE on it and did cvsup/makeworld to get to 5.4-PRERELEASE. I got this box with the intention of running MySQL on it. I have installed MySQL 4.1 from ports, no errors or anything, installed fine. While importing data into MySQL on this machine, it seems to just sit around and do lots of disk i/o while the cpu sits at 8% usage. Ok... not neccessarily a big deal, it's supposed to be doing disk I/O not much CPU. What is unusual (and problematic) to me is that this same exact load w/ same mysql version on an old dinky x86 box with FreeBSD on it takes under 3 minutes and on the sparc64 machine it seems to stretch on forever. So I'm wondering: are there big problems with performance with the sym driver still lurking? If anyone is interested in helping me, i don't have much time but am perfectly willing to send any config/kernconf/dmesg/etc. infoz. I have to have MySQL set up on this and working (efficiently) by Monday so I will most likely wipe freebsd and install solaris (ugh) so I can get this up and running if I can't figure out and fix the bottleneck/issue in the next 20 hours or so. Sorry if this message is wacky at all I haven't slept much. Regards, Paul Schiro