How to Fix ERROR InnoDB: The InnoDB memory heap is disabled

Valic —  December 14, 2012 — 1 Comment

I just enabled InnoDB on my  MySQL server and I’ve made the necessary changes into my.cnf. When I restarted the MySQL server I got the following error in the log:

InnoDB: The InnoDB memory heap is disabled

After  some checking I’ve found that I need to set the value of innodb_use_sys_malloc to 0. After I added  this entry innodb_use_sys_malloc =  0 into the my.cnf and restarted the MySQL Server the error was gone.

NOTE: More info here: www.innodb.com/doc/innodb_plugin-1.0-doc-A4.pdf (see page 38)

Valic

Posts Twitter Facebook

Editor in Chief at Debian-Tutorials, Linux enthusiast.

One response to How to Fix ERROR InnoDB: The InnoDB memory heap is disabled

  1. Apologies for commenting on an old post, but you’re on the first page of results on Google and just wanted to give everyone a heads up.

    This isn’t really an error, just an indication that InnoDB is using the system’s internal memory allocator instead of its own. The default is yes/1, and is acceptable for production.

    According to the docs, this command is deprecated, and will be removed in MySQL versions above 5.6 (and I assume MariaDB):

    http://dev.mysql.com/doc/refman/5.6/en/innodb-performance-use_sys_malloc.html

    Cheers :)

Leave a Reply