Date: Thu, 07 Sep 2006 10:40:02 -0500 From: Derek Ragona <derek@computinginnovations.com> To: VeeJay <maanjee@gmail.com>, freebsd-questions@freebsd.org, maanjee@gmail.com Subject: Re: Please Help AMD, mysql, FreeBSD 64 Message-ID: <6.0.0.22.2.20060907103744.02674d30@mail.computinginnovations.com> In-Reply-To: <2cd0a0da0609070617u6416ebc1l711ec6e163c89a44@mail.gmail.co m> References: <2cd0a0da0609070617u6416ebc1l711ec6e163c89a44@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6.0.0.22.2.20060907103744.02674d30>