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
