MySQL:cannot allocate the memory for the buffer pool

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重新開機正常