List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:October 18 2005 8:23am
Subject:Re: Innodb buffer pool allocation on Window 2000
View as plain text  
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" <jonathan.stockley@stripped> 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
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Innodb buffer pool allocation on Window 2000Jonathan Stockley18 Oct
  • Re: Innodb buffer pool allocation on Window 2000Gleb Paharenko18 Oct