Re: Please Help AMD, mysql, FreeBSD 64

2006-09-07 Thread Ralph Ellis 
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 eachwith 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
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Re: Please Help AMD, mysql, FreeBSD 64

2006-09-07 Thread Derek Ragona 
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 eachwith 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 "[EMAIL PROTECTED]"

--
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.

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"