• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1788
  • Last Modified:

InnoDB: Error: cannot allocate 536887296 bytes of memory with malloc!

Hi running Windows Server 2003 EE 4GB memory with 2CPU.

Has MYSQL 5.1 community version installation.  Database is running very slow so I have
tried increasing the innodb_buffer_pool_size from 256M to 1G which failed then 512M which
also failed both with the same error.

100408 14:05:13  InnoDB: Error: cannot allocate 536887296 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 7725316 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...
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
100408 14:06:13 [ERROR] Plugin 'InnoDB' init function returned error.
100408 14:06:13 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100408 14:06:13 [ERROR] Unknown/unsupported table type: INNODB
100408 14:06:13 [ERROR] Aborting

100408 14:06:13 [Warning] Forcing shutdown of 1 plugins
100408 14:06:13 [Note] D:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown

Have tried reducing the number of maximum connection from 800 to 100 but this made no
difference.  Still getting the same error.

Also tried adding the /3GB switch in the boot.ini but made no differnce.

Any help would be greatly appreciated.  Have attached the my.ini file

Thanks in advance.

1 Solution
johng33Author Commented:
Have resolved it.  Was running MYSQL 5.1.31 updated to 5.1.45 and now able to increase the innodb_buffer_pool_size
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now