Please Help AMD, mysql, FreeBSD 64

Derek Ragona derek at computinginnovations.com
Thu Sep 7 08:39:57 PDT 2006


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 at freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>To unsubscribe, send any mail to "freebsd-questions-unsubscribe at 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.



More information about the freebsd-questions mailing list