Hello.


It is a bit strange, usually MySQL should be able allocate up to 2G 

of memory. Check that summary memory usage of MySQL is less than 2G.

You may be interested in PAE extention. But to be able to use it

you should compile MySQL yourself. See:



  http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx

        http://dev.mysql.com/doc/mysql/en/Memory_use.html

        http://lists.mysql.com/mysql/185635





"Jonathan Stockley" <[EMAIL PROTECTED]> wrote:

>I have a Windows 2000 host with 3.5 G of ram. I have configured MySQL

>4.1.14 with innodb_buffer_pool = 1024M, when I start mysqld I get the

>following error:

>

> 

>

>051013 16:46:00  InnoDB: Error: cannot allocate 1073758208 bytes of

>

>InnoDB: memory with malloc! Total allocated memory

>

>InnoDB: by InnoDB 16975556 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: We keep retrying the allocation for 60 seconds...

>

>InnoDB: Fatal error: cannot allocate the memory for the buffer pool

>

>051013 16:47:00 [ERROR] Can't init databases

>

>051013 16:47:00 [ERROR] Aborting

>

> 

>

>051013 16:47:01 [Note] C:\Program Files\MySQL\bin\mysqld: Shutdown

>complete

>

> 

>

>If I lower the value to 512M it comes up ok. Not being an in depth

>Windows admin, What do I look for in the registry or elsewhere to allow

>MySQL to have a 1024M innodb_buffer_pool?

>

> 

>

>Thanks,

>

>Jo

>

> 

>

>

>



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to