MySQL Forums
Forum List  »  Performance

4Gb Process Limit on AMD Opteron
Posted by: Graeme Wallace
Date: January 11, 2005 12:37PM


I am building up a large database and so installed the 64 bit version of Mysql 4.1.8 on a dual opteron with 8gb mem.

As the initial data load will take days, I created the tables (MyIsam) using delay_key_write=1, avg_row_length=300, max_rows=1.5G
I set the key_buffer_size to 5Gb.

As i run the processing job to populate the database the mysql process doesnt grow past 4Gb.

Is there something else i need to do to get it to use more mem ?



Linux neo 2.6.5-7.111-smp #1 SMP Wed Oct 13 15:45:13 UTC 2004 x86_64

ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 81920
virtual memory (kbytes, -v) unlimited

Options: ReplyQuote

Written By
4Gb Process Limit on AMD Opteron
January 11, 2005 12:37PM
January 12, 2005 12:50PM
January 28, 2005 06:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.