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). Jake On Wed, Nov 12, 2008 at 10:35 AM, Shain Miley <[EMAIL PROTECTED]> 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 > DB's. > 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, > > Shain > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
