Nix World

blog

InnoDB: The InnoDB memory heap is disabled

July 29th, 2010 by Pankaj Joshi Leave a reply »

I enabled the innodb_plugin-1.0.4 made the necessary changes into the my.cnf file to bring the innodb plugin into the effect . Restarted MySQL and got the log entry into the MySQL error log InnoDB: The InnoDB memory heap is disabled , on some checking I got in this page (http://www.innodb.com/doc/innodb_plugin-1.0-doc-single/innodb-plugin.html#innodb-performance-use_sys_malloc) that I need to set
The value of innodb_use_sys_malloc as 0. so I made this entry innodb_use_sys_malloc =0 into the my.cnf and restarted the MySQL and the error was gone , happy MySQling

Thanks
Pankaj Joshi

Posted in Linux, Mysql

Tags: ERROR innodb MEMORY HEAP Mysql

You can follow any responses to this entry through the RSS 2.0 Feed. You can leave a response , or trackback from your own site.

airpig

innodb_use_sys_malloc =1 is default which allows it to use native calls for memory allocations which is currently considered faster.

http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-performance-use_sys_malloc.html
http://javarevisited.blogspot.com/ Javin Paul

Great article, you have indeed covered topic in detail with samples. I have also blogged my experience as 10 examples of grep command in unix ,let me know how do you find it.

Thanks
http://javarevisited.blogspot.com/2010/10/frequently-used-mysql-commands-part-3.html
Rohit

This is one of the problem which we were frequently encounter , thanks for quick resolution.
http://www.sayfamily.com/ Paul Goulart

thank you!
Kiran

Cool Post Works great
http://www.risingperfection.com/ Arun R

Hi Pankaj

But the content in the link you have shared is updated on 20th March 2012. The content you mentioned is available on the page: http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-performance-use_sys_malloc.html

Arun R
risingperfection.com

blog comments powered by Disqus

Back to Top

Valid XHTML 1.0 Transitional | Valid CSS 3