MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Lopez David E-r9374c Date:October 21 2005 12:23am
Subject:problems with key_buffer_size > 4 GBytes
View as plain text  
solaris box with 16 Gbytes of memory
os using 5.8, mysql at 4.0.20_64bit

with key_buffer_size set to 6144m, the mysqld crashes
and re-starts (mysql_safe) under heavy load (1day to 1week). 
prior to this, key_buffer_size set to 1.5G and no crashes since
early 2004. 

the process size is 2G even though I specify key_buffer_size
to 6144m. I backed off to 4096m and the process size is correctly
set to 4G. has been stable ever since.

tried mysql version 4.1.15 64bit with same issue. will not
set the process size any larger than 4G.

anyone have ideas on how to track down this issue?

(checked ulimit for csh shell and vmemory is unlimited)

appreciate help.
problems with key_buffer_size > 4 GBytesLopez David E-r9374c21 Oct