Hi! ----- Original Message ----- From: "Marc Slemko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, August 26, 2003 6:56 AM Subject: RE: 64-Bit and INNODB
> On Mon, 25 Aug 2003, Wendell Dingus wrote: > > > I didn't notice a reply to this when first posted. Surely someone has > > stuffed a lot of memory into an Opteron or Itanium by now and knows the > > answer. Is a 64-bit Malloc all that is necessary or does INNODB have to > > specifically support more memory in some other fashion? Heikki? Thanks in > > advance! > > well, interestingly according to the innodb release notes, on windows: > > MySQL/InnoDB-4.1.0, April 3, 2003 > > * InnoDB now supports up to 64 GB of buffer pool memory in a > Windows 32-bit Intel computer. This is possible because InnoDB > can use the AWE extension of Windows to address memory over > the 4 GB limit of a 32-bit process. A new startup variable > innodb_buffer_pool_awe_mem_mb enables AWE and sets the size of > the buffer pool in megabytes. > > not sure what it would take to make that work on linux, but if all > you need is more memory, and the fairly reasonable performance hit > is ok, you may be a lot better off just getting an x86 box with 8 > dimm slots and loading them up with 1 or 2 gig dimms... then making > AWE in mysql work on linux. The cost you pay to go the 64 bit box is > pretty hefty. We are waiting to see if 64-bit Linux computers take off. Adding the 32-bit Intel "AWE" support into InnoDB on Linux would be rather easy if someone wants to sponsor the project. I recall "AWE" itself can be used with the Red Hat Linux Advanced Server, if I remember the OS name right. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
