InnoDB: The InnoDB memory heap is disabled


InnoDB: Mutexes and rw_locks use GCC atomic builtins


InnoDB: Compressed tables use zlib 1.2.3


InnoDB: mmap(2196766720 bytes) failed; errno 12


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


111222 13:51:45 [ERROR] Plugin 'InnoDB' init function returned error.


111222 13:51:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.


111222 13:51:45 [ERROR] Unknown/unsupported table type: INNODB


111222 13:51:45 [ERROR] Aborting


 


解决办法：


查看机器内存大小"free -m"


查看配置文件my.cnf中"innodb_buffer_pool_size"、"key_buffer_size"的大小设置


 


今天碰到的问题是机器内存2G，innodb_buffer_pool_size分配了2G，key_buffer_size分配了100M；调整innodb_buffer_pool_size为1G后，mysql重启正常