RE: How Configure AWE with W2k3 and mysql5.0.33 (recompiled innobase)

"Spyros J. Papantoniou" <[email protected]> Mon, 29 Jan 2007 20:59:10 +0200
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
Dear MySQLers,

Tried to follow everything in the manuals in order to increase the innodb RAM size, but allas I cannot go over 1.3GB (compared to 1.1GB without AWE, this is only a 10% increase).

Is there any other hidden setting that I have to follow in order to increase my innodb RAM size?

Machine is P4 3GHz, 4GB.

Innodb file size 1.3GB and rising

More details:
070129 19:21:37  InnoDB: Started; log sequence number 0 3458140057
070129 19:21:37 [Note] C:\Program Files\MySQL\MySQL server 5.0.27\bin\mysqld-nt: ready for connections.
Version: '5.0.33'  socket: ''  port: 3306  Source distribution

.......
.....when buffer >1.3GB:
....
InnoDB: Using AWE: Memory window is 1300 MB and AWE memory is 2700 MB
InnoDB: Using Address Windowing Extensions (AWE); allocated 2700 MB
070129 20:16:19  InnoDB: Error: cannot allocate 86327572 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 1505068304 bytes. Operating system errno: 8
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
070129 20:17:19  InnoDB: We now intentionally generate a seg fault so that
InnoDB: on Linux we get a stack trace.
070129 20:17:19 [ERROR] C:\Program Files\MySQL\MySQL server 5.0.27\bin\mysqld-nt: Got signal 11. Aborting!

070129 20:17:19 [ERROR] Aborting

070129 20:17:19 [Note] C:\Program Files\MySQL\MySQL server 5.0.27\bin\mysqld-nt: Shutdown complete

My.ini:
#*** INNODB Specific options ***

innodb_additional_mem_pool_size=48M

#innodb_flush_log_at_trx_commit=1
innodb_flush_log_at_trx_commit=2

# innodb_flush_log_at_trx_commit=0 for fast import

innodb_log_buffer_size=1M

innodb_buffer_pool_size=1300M

#innodb_buffer_pool_size=1988M  
#does not work! process limit is 1.8GB on Windows
innodb_log_file_size=24M

innodb_buffer_pool_awe_mem_mb=2700