mysql 程序崩溃无法启动_mysql数据库崩溃，无法启动

08:26:23 mysqld_safe Number of processes running now: 0

170329 08:26:23mysqld_safe mysqld restarted170329 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‘ isdisabled.170329 8:26:23 InnoDB: The InnoDB memory heap isdisabled170329 8:26:23InnoDB: Mutexes and rw_locks use GCC atomic builtins170329 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:23InnoDB: Completed initialization of buffer pool170329 8:26:23 InnoDB: Fatal error: cannot allocate memory forthe buffer pool170329 8:26:23 [ERROR] Plugin ‘InnoDB‘init function returned error.170329 8:26:23 [ERROR] Plugin ‘InnoDB‘ registration asa STORAGE ENGINE failed.170329 8:26:23 [ERROR] Unknown/unsupported storage engine: InnoDB170329 8:26:23[ERROR] Aborting170329 8:26:23 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete170329 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数据库崩溃，无法启动

标签：end   zlib   mysql错误   map   查看   processes   blog   logs   erro

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/yerkle/p/6639014.html