首页 > 代码库 > mysql数据库崩溃,无法启动
mysql数据库崩溃,无法启动
查看mysql错误提示
170329 08:26:23 mysqld_safe Number of processes running now: 0 170329 08:26:23 mysqld_safe mysqld restarted 170329 8:26:23 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 4353 ... 170329 8:26:23 [Note] Plugin ‘FEDERATED‘ is disabled. 170329 8:26:23 InnoDB: The InnoDB memory heap is disabled 170329 8:26:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170329 8:26:23 InnoDB: Compressed tables use zlib 1.2.3 170329 8:26:23 InnoDB: Initializing buffer pool, size = 4.0G InnoDB: mmap(4395630592 bytes) failed; errno 12 170329 8:26:23 InnoDB: Completed initialization of buffer pool 170329 8:26:23 InnoDB: Fatal error: cannot allocate memory for the buffer pool 170329 8:26:23 [ERROR] Plugin ‘InnoDB‘ init function returned error. 170329 8:26:23 [ERROR] Plugin ‘InnoDB‘ registration as a STORAGE ENGINE failed. 170329 8:26:23 [ERROR] Unknown/unsupported storage engine: InnoDB 170329 8:26:23 [ERROR] Aborting 170329 8:26:23 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 170329 08:26:23 mysqld_safe mysqld from pid file /usr/local/mysql/var/104-250-159-170.static.gorillaservers.com.pid ended
解决办法:在my.cnf 把 innodb_buffer_pool_size 的值设置小点。
参考:
http://serverfault.com/questions/379714/unknown-unsupported-storage-engine-innodb-mysql-ubuntu
http://blog.csdn.net/psiitoy/article/details/40106735
mysql数据库崩溃,无法启动
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。