I am having 'issues' with MySQL running on Redhat Advanced Server
on a 8 Gigbyte machine (dual P4-Xeon).
After large imports ('load data infile', file size about 1 Gigbyte) into
a large table (20-30 GByte, 100 Million rows), the database crashes.
I did try several key_buffer_size settings. The
Even if you have more than 4 Gb of physical RAM, a single process
cannot address more than 4 Gb of memory (a P4-Xeon is still a
32 bits processor :( ). You have also to take into account that
a process cannot use these 4 Gb for data since some memory is
used for code, stack,... The exact amount