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