List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:May 15 2003 4:41pm
Subject:Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?
View as plain text  
Steff,

in MySQL-4.1 you can use the AWE memory of a 32-bit Windows in the InnoDB
buffer pool.

The limits are the following:

"InnoDB: In Windows XP Home you cannot use AWE. In Windows 2000 and XP\n"
"InnoDB: Professional you must go to the Control Panel, to\n"
"InnoDB: Security Settings, to Local Policies, and enable\n"
"InnoDB: the 'lock pages in memory' privilege for the user who runs\n"
"InnoDB: the MySQL server.\n"

"InnoDB: In Windows XP Professional and 2000 Professional\n"
"InnoDB: Windows PAE size is max 4 GB. In 2000 and .NET\n"
"InnoDB: Advanced Servers and 2000 Datacenter Server it is 32 GB,\n"
"InnoDB: and in .NET Datacenter Server it is 64 GB.\n"
"InnoDB: A Microsoft web page said that the processor must be an Intel\n"
"InnoDB: processor."

4.1.0:

"
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.
"

In ..._awe_mem_mb you specify the number of megabytes of physical AWE memory
(= RAM) you want to use. In innodb_buffer_pool_size you specify the logical
address space window size where InnoDB maps that AWE memory on demand.

I have tested AWE memory with InnoDB on my XP Professional computer.

Best regards,

Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL support from http://www.mysql.com/support/index.html

Thread
does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?Steff14 May
  • Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?David Griffiths15 May
  • Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?miguel solorzano15 May
    • MySql licenseElkin Fernando Ortiz15 May
      • Re: MySql licensePaul DuBois15 May
    • Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?Steff15 May
      • Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?miguel sol√≥rzano15 May
      • Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?Dan Nelson15 May
    • Connections: was MySql licenseJames15 May
  • Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?Becoming Digital15 May
Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?Heikki Tuuri15 May
  • Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?Jeremy Zawodny15 May
Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?Heikki Tuuri15 May