陆续整理所有遇到过的,关于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设置为合适的值.