aliyun mysql 宕机

InnoDB: mmap(137363456 bytes) failed; errno 12,表明内存不足(例如1G内存),因为mysql默认配置innodb_buffer_pool_size=128M,在内存不足情况下,mysql会出现类似的问题,建议修改innodb_buffer_pool_size=60M 或者更低,重启mysql即可, service mysqld start.

[source lang=”bash”]

016-03-16 17:06:57 26069 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-16 17:06:57 26069 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-16 17:06:57 26069 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-16 17:06:57 26069 [Note] InnoDB: Memory barrier is not used
2016-03-16 17:06:57 26069 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-16 17:06:57 26069 [Note] InnoDB: Using Linux native AIO
2016-03-16 17:06:57 26069 [Note] InnoDB: Using CPU crc32 instructions
2016-03-16 17:06:57 26069 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2016-03-16 17:06:57 26069 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2016-03-16 17:06:57 26069 [ERROR] Plugin ‘InnoDB’ init function returned error.
2016-03-16 17:06:57 26069 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2016-03-16 17:06:57 26069 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-03-16 17:06:57 26069 [ERROR] Aborting

[/source]

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注