4Gb Process Limit on AMD Opteron

[Graeme Wallace]

Hi,

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 ?

G.


mysql-standard-4.1.8-unknown-linux-x86_64-glibc23

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