I see that you've already decided on 64-bit anyway, but here's a more
explicit reason to do so: in 32-bit (PAE-mode), no single process can
allocate more than 4GB of memory- that's all the address space there
is. The *system* can see it all, but each process can only work with a
single 4GB chunk of it.
Therefore MySQL, being single-process (multi-threaded), can only use
4GB of memory on a 32-bit platform. So unless you'd be doing something
else with that other 12-24GB of RAM, you'd effectively be flushing
money down the drain to put in more than 4-5GB. Even then, there's
lots of overhead involved with PAE mode, so if you actually have more
than 4GB of memory 64-bit will almost always be faster (as far as the
hardware is concerned).
On Wed, Nov 12, 2008 at 10:35 AM, Shain Miley <smiley@stripped> wrote:
> Hello all,
> I was wondering if anyone had any good insight into running the 32 bit and
> 64 bit versions of MySQL? We are going to be using a replication setup
> within my organization very shortly. We intend to a have at least one
> master (writable) DB and several (let's say 3 for this excersise ) read-only
> One suggestion that I got was to use 64 bit version of MySQL so that we can
> make better use of our servers memory as we are using servers that have 16 -
> 32 GB of RAM.
> Does anyone have any info on whether or not using the 64 Bit version is a
> good idea given the setup described above?
> Would I need to run the 64 bit version on all the servers or just the
> master, etc? Any help would be great.
> Thanks in advance,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1