From owner-freebsd-questions@FreeBSD.ORG  Thu Sep  7 13:18:07 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 4E3A016A4DA
	for <freebsd-questions@freebsd.org>;
	Thu,  7 Sep 2006 13:18:07 +0000 (UTC)
	(envelope-from maanjee@gmail.com)
Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180])
	by mx1.FreeBSD.org (Postfix) with ESMTP id AB86A43D53
	for <freebsd-questions@freebsd.org>;
	Thu,  7 Sep 2006 13:17:57 +0000 (GMT)
	(envelope-from maanjee@gmail.com)
Received: by py-out-1112.google.com with SMTP id o67so304934pye
	for <freebsd-questions@freebsd.org>;
	Thu, 07 Sep 2006 06:17:57 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=MP03ZiW84glq4s4/Q7U0ffR+wFZKgcrkL/70w8JnoUhb3My2ULUUSHc/tiZdojfyJQsn7PE+zOsgo/zYtY3gmwhGnBelv+dGON6lMYz85vCEkgi1ZM2zgKFKbfwITMMV3iF64VGQ8w+ub/+8BC0/3nSjxBBVoUTOJA4iW8f9rlg=
Received: by 10.35.80.20 with SMTP id h20mr687731pyl;
	Thu, 07 Sep 2006 06:17:56 -0700 (PDT)
Received: by 10.35.123.1 with HTTP; Thu, 7 Sep 2006 06:17:56 -0700 (PDT)
Message-ID: <2cd0a0da0609070617u6416ebc1l711ec6e163c89a44@mail.gmail.com>
Date: Thu, 7 Sep 2006 15:17:56 +0200
From: VeeJay <maanjee@gmail.com>
To: freebsd-questions@freebsd.org, maanjee@gmail.com
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Cc: 
Subject: 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 13:18:07 -0000

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


-- 
Thanks!

BR / vj