From owner-freebsd-questions@FreeBSD.ORG Thu Sep 7 15:39:57 2006 Return-Path: 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 A51C116A4DD for ; Thu, 7 Sep 2006 15:39:57 +0000 (UTC) (envelope-from derek@computinginnovations.com) Received: from betty.computinginnovations.com (dsl081-142-072.chi1.dsl.speakeasy.net [64.81.142.72]) by mx1.FreeBSD.org (Postfix) with ESMTP id CDEA643D67 for ; Thu, 7 Sep 2006 15:39:47 +0000 (GMT) (envelope-from derek@computinginnovations.com) Received: from p28.computinginnovations.com (dhcp-10-20-30-150.computinginnovations.com [10.20.30.150]) (authenticated bits=0) by betty.computinginnovations.com (8.13.6/8.12.11) with ESMTP id k87FdLD6034727; Thu, 7 Sep 2006 10:39:22 -0500 (CDT) Message-Id: <6.0.0.22.2.20060907103744.02674d30@mail.computinginnovations.com> X-Sender: derek@mail.computinginnovations.com X-Mailer: QUALCOMM Windows Eudora Version 6.0.0.22 Date: Thu, 07 Sep 2006 10:40:02 -0500 To: VeeJay , freebsd-questions@freebsd.org, maanjee@gmail.com From: Derek Ragona In-Reply-To: <2cd0a0da0609070617u6416ebc1l711ec6e163c89a44@mail.gmail.co m> References: <2cd0a0da0609070617u6416ebc1l711ec6e163c89a44@mail.gmail.com> Mime-Version: 1.0 X-ComputingInnovations-MailScanner-Information: Please contact the ISP for more information X-ComputingInnovations-MailScanner: Found to be clean X-ComputingInnovations-MailScanner-From: derek@computinginnovations.com X-Spam-Status: No Content-Type: text/plain; charset="us-ascii"; format=flowed X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 07 Sep 2006 15:39:57 -0000 You would do better posting to the mysql lists, as this isn't really related to the OS. I would suggest you use the command line utilities to load the records. I would first slice them into chunks not too big, then iterate through them. If the records are in some order, if you get an error, you can pickup where you left off. -Derek At 08:17 AM 9/7/2006, 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 > > >-- >Thanks! > >BR / vj >_______________________________________________ >freebsd-questions@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-questions >To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" > >-- >This message has been scanned for viruses and >dangerous content by MailScanner, and is >believed to be clean. >MailScanner thanks transtec Computers for their support. > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks transtec Computers for their support.