错误日志中关于innodb的问题收集

陆续整理所有遇到过的,关于innodb的错误问题

1.错误日志报告如下:

.....

120223 23:36:06 InnoDB: Compressed tables use zlib 1.2.3

120223 23:36:06 InnoDB: Initializing buffer pool, size = 24.0G

InnoDB: mmap(26474446848 bytes) failed; errno 12

120223 23:36:06 InnoDB: Completed initialization of buffer pool

120223 23:36:06 InnoDB: Fatal error: cannot allocate memory for the buffer pool

120223 23:36:06 [ERROR] Plugin 'InnoDB' init function returned error.

120223 23:36:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

120223 23:36:06 [ERROR] Failed to initialize plugins.

120223 23:36:06 [ERROR] Aborting

分析: 

分配给innodb_buffer_pool的内存超过了物理内存

解决办法:

查看my.cnf配置文件,将innodb_buffer_pool设置为合适的值.