Wendell, ----- Original Message ----- From: ""Wendell Dingus"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, August 27, 2003 6:35 AM Subject: RE: 64-Bit and INNODB
> Ahh, so Linux on 64-bit right now with INNODB is really not much different > than on 32-bit x86? XEON CPUs have AWE/PAE which lets them address a 36-bit > memory address space, getting past the 4GB addressable limit. 64-bit CPUs > obviously can address _much_ more memory in a single chunk. MySQL/INNODB > though is still going to be limited to that same 2GB buffer size? Is that > correct? no. For example, people are running InnoDB on a 64-bit Sparc with > 4 GB buffer pools. > Hmmm... We've talked about sponsorship of Innobase to implement PAE on > XEON/x86 Linux but making it work on Opteron I think would be more > appropriate. Do you want to publicly talk about costs of that implementation > Heikki? How many folks here would want this and be willing to "pass the hat" > to make it happen? But InnoDB already works on 64-bit systems. Nothing to implement. There is an AMD64 binary downloadable from http://www.mysql.com/downloads/mysql-4.0.html. > A low-end 1U Opteron server including RAM and CPU are only marginally more > expensive than a (good) low-end similarly-equippped XEON server. In my > opinion there is no doubt that it will take off in a big way! > > PS. RedHat kernels definitely support PAE and that's possibly via an > additional patch beyond the stock kernel? Not just in "Advanced Server" > either, this is with the "bigmem" kernel on a box (standard RedHat 7.3) with > 5GB RAM for instance [too bad I can only allocate a bit under 2GB for the > INNODB buffer though :-) ] > > 10:07pm up 1 day, 1:07, 1 user, load average: 0.05, 0.07, 0.08 > 102 processes: 101 sleeping, 1 running, 0 zombie, 0 stopped > CPU0 states: 0.3% user, 8.2% system, 0.0% nice, 90.4% idle > CPU1 states: 1.0% user, 0.1% system, 0.0% nice, 98.3% idle > Mem: 5318292K av, 4571076K used, 747216K free, 0K shrd, 261444K > buff > Swap: 2096220K av, 123060K used, 1973160K free 3284376K > cached > > Kernel 2.6.0 definitely makes mention of PAE and support for large amounts > of memory. Andi Kleen just wrote that all 2.4.xx kernels support PAE. 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 > -----Original Message----- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 26, 2003 4:08 PM > To: [EMAIL PROTECTED] > Subject: Re: 64-Bit and INNODB > > > 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] > > > > > -- > 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]
