From owner-freebsd-questions@FreeBSD.ORG  Thu Sep  7 16:20:28 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 4ED4716A4DA
	for <freebsd-questions@freebsd.org>;
	Thu,  7 Sep 2006 16:20:28 +0000 (UTC)
	(envelope-from ralphellis@netscape.ca)
Received: from smtp-1.vancouver.ipapp.com (smtp-1.vancouver.ipapp.com
	[216.152.192.190])
	by mx1.FreeBSD.org (Postfix) with ESMTP id BE37943D79
	for <freebsd-questions@freebsd.org>;
	Thu,  7 Sep 2006 16:20:25 +0000 (GMT)
	(envelope-from ralphellis@netscape.ca)
Received: from [192.168.123.100] ([172.130.97.202]) by
	smtp-1.vancouver.ipapp.com ; Thu, 07 Sep 2006 09:20:23 -0700
From: Ralph Ellis <ralphellis@netscape.ca>
To: freebsd-questions@freebsd.org
Date: Thu, 7 Sep 2006 12:19:45 -0700
User-Agent: KMail/1.9.3
References: <2cd0a0da0609070617u6416ebc1l711ec6e163c89a44@mail.gmail.com>
In-Reply-To: <2cd0a0da0609070617u6416ebc1l711ec6e163c89a44@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200609071219.46086.ralphellis@netscape.ca>
X-Rcpt-To: <freebsd-questions@freebsd.org>
X-Country: US
Subject: Re: Please Help AMD, mysql, FreeBSD 64
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 07 Sep 2006 16:20:28 -0000

On Thursday 07 September 2006 6:17 am, VeeJay wrote:
> Hello
>
> Just wondering if I can get an advice from this forum?
>
> What kind of hardware i.e.(Processor, RAM) I need to accomplish following
> jobs on a FreeBSD plateform:
>
> I have some mysql dumps around 2 GB each....with each record is 100 KB...
>
>
> 1. What is the best method to import them into a mysql database without
> getting any "Out of Memory" Error? or freezing MySQL?
>
>
> 2. If I run a little Perl script and read a mysql record per iteration, how
> can I avoid "illigle memory address" access errors?
>
>
> Somebody talked about AMD 64 processor with FreeBSD 64 version, etc?
>
>
> I will be really grateful for your kind advices/suggestions....
>
> Regards
>
> VeeJay
The big advantage to AMD64 is that you can address memory above 4gigs. Below 
that and performance is not dramatically different between AMD64 and i386. If 
you are going to have a server with 5gigs or more of memory, then you should 
benefit from AMD64. How much more memory you might want I don't know. You 
might get more help on that from MySQL users.
Ralph Ellis