Mysql启动异常:[ERROR] InnoDB: Cannot allocate memory for the buffer pool
cannot 提问于:2017-03-03
0 0

查看了下mysql错误日志:

2017-03-03 07:56:07 12211 [Note] Plugin 'FEDERATED' is disabled.
2017-03-03 07:56:07 12211 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-03-03 07:56:07 12211 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-03 07:56:07 12211 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-03 07:56:07 12211 [Note] InnoDB: Memory barrier is not used
2017-03-03 07:56:07 12211 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-03 07:56:07 12211 [Note] InnoDB: Using Linux native AIO
2017-03-03 07:56:07 12211 [Note] InnoDB: Using CPU crc32 instructions
2017-03-03 07:56:07 12211 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2017-03-03 07:56:07 12211 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2017-03-03 07:56:07 12211 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-03 07:56:07 12211 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-03 07:56:07 12211 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-03-03 07:56:07 12211 [ERROR] Aborting
  • 所有回答
xiaofei 回答于:2017-07-06
0 0

服务器内存不足
修改/etc/my.conf文件中为
innodb_buffer_pool_size=50M
重启

我来回答    Mysql启动异常:[ERROR] InnoDB: Cannot allocate memory for the buffer pool