mysql错误信息收集_错误日志中关于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设置为合适的值.