MySQL-mysql 崩溃 附上错误日志
131027 16:51:03 [Note] Plugin 'FEDERATED' is disabled.
131027 16:51:04 InnoDB: The InnoDB memory heap is disabled
131027 16:51:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131027 16:51:04 InnoDB: Compressed tables use zlib 1.2.3.4
131027 16:51:05 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
131027 16:51:05 InnoDB: Completed initialization of buffer pool
131027 16:51:05 InnoDB: Fatal error: cannot allocate memory for the buffer pool
131027 16:51:05 [ERROR] Plugin 'InnoDB' init function returned error.
131027 16:51:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131027 16:51:06 [ERROR] Unknown/unsupported storage engine: InnoDB
131027 16:51:06 [ERROR] Aborting
131027 16:51:10 [Note] Plugin 'FEDERATED' is disabled.
131027 16:51:10 InnoDB: The InnoDB memory heap is disabled
131027 16:51:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131027 16:51:10 InnoDB: Compressed tables use zlib 1.2.3.4
131027 16:51:10 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
131027 16:51:10 InnoDB: Completed initialization of buffer pool
131027 16:51:10 InnoDB: Fatal error: cannot allocate memory for the buffer pool
131027 16:51:10 [ERROR] Plugin 'InnoDB' init function returned error.
131027 16:51:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131027 16:51:10 [ERROR] Unknown/unsupported storage engine: InnoDB
131027 16:51:10 [ERROR] Aborting
131027 16:51:10 [Note] /usr/sbin/mysqld: Shutdown complete
131027 16:51:11 [Note] Plugin 'FEDERATED' is disabled.
131027 16:51:11 InnoDB: The InnoDB memory heap is disabled
131027 16:51:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131027 16:51:11 InnoDB: Compressed tables use zlib 1.2.3.4
131027 16:51:11 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
131027 16:51:11 InnoDB: Completed initialization of buffer pool
131027 16:51:11 InnoDB: Fatal error: cannot allocate memory for the buffer pool
131027 16:51:11 [ERROR] Plugin 'InnoDB' init function returned error.
131027 16:51:11 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131027 16:51:11 [ERROR] Unknown/unsupported storage engine: InnoDB
131027 16:51:11 [ERROR] Aborting
131027 16:51:11 [Note] /usr/sbin/mysqld: Shutdown complete
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
帮你google了一把, 据信主要在这里:
131027 16:51:11 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
131027 16:51:11 InnoDB: Completed initialization of buffer pool
131027 16:51:11 InnoDB: Fatal error: cannot allocate memory for the buffer pool
内存分配的问题, 解决方案:
http://infoheap.com/how-to-fix-mysql-service-stopping-intermittently-on-aws-micro-instance/
http://stackoverflow.com/questions/10284532/amazon-ec2-mysql-aborting-start-because-innodb-mmap-x-bytes-failed-errno-12