List:General Discussion« Previous MessageNext Message »
From:Albert Chin Date:February 5 2002 9:32pm
Subject:Accessing large memory with 64-bit MySQL on Solaris
View as plain text  
We've built MySQL 3.23.46 on Solaris 8/SPARC as a 64-bit executable
using the Sun C compiler. Everything built OK. We built against
ncurses, readline, and zlib, all built as 64-bit libraries. Are there
any special settings to get MySQL to work properly in this environment
or should things work as expected.

If the server is started with the following settings:
  key_buffer=4608M
  max_allowed_packet=1M
  table_cache=1024
  record_buffer=1M
  sort_buffer=1M
  thread_cache=12
  thread_concurrency=12
  myisam_sort_buffer_size=512M

then "mysqladmin variables" shows key_buffer as 1G, not 4.5G.

The Solaris 8 machine this is running on has 6GB real memory and
14.5GB of swap.

-- 
albert chin (china@stripped)
Thread
Accessing large memory with 64-bit MySQL on SolarisAlbert Chin5 Feb