mysql挂掉后，再启动报错：MySQL Daemon failed to start.

[PHP编程者]

大家好，之前mysql一直正常运行，但不知什么原因，突然挂掉了，再启动mysql时报错，大家帮看下是什么原因呢？

service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

监控日志也没监控到数据：
tail -f /var/log/mysqld.log

[ACMAIN_CHM]

找MYSQL的错误日志。

[九月茅桃]

通过检索my.cnf查看下error错误日志， [root@tmp~]# more /etc/my.cnf |grep error |grep log log-error=/usr/local/mysql/mysqld.log [root@wgq_idc_dbs_3_62 ~]# 如果这也没有 ，就默认在mysql的数据目录，去数据库文件的目录看error日志。 贴下error日志的详细信息，大家再看看。

[PHP编程者]

这是启动错误日志，大家帮看下，谢谢！

150518 16:35:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150518 16:35:46 [Note] libgovernor.so not found
150518 16:35:46 [Note] Plugin 'FEDERATED' is disabled.
150518 16:35:46 InnoDB: The InnoDB memory heap is disabled
150518 16:35:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150518 16:35:46 InnoDB: Compressed tables use zlib 1.2.3
150518 16:35:46 InnoDB: Using Linux native AIO
150518 16:35:46 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
150518 16:35:46 InnoDB: Completed initialization of buffer pool
150518 16:35:46 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150518 16:35:46 [ERROR] Plugin 'InnoDB' init function returned error.
150518 16:35:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150518 16:35:46 [ERROR] Unknown/unsupported storage engine: InnoDB
150518 16:35:46 [ERROR] Aborting

150518 16:35:46 [Note] /usr/libexec/mysqld: Shutdown complete

150518 16:35:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[github_hloong]

引用 3 楼 helloqhq 的回复:

这是启动错误日志，大家帮看下，谢谢！

150518 16:35:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150518 16:35:46 [Note] libgovernor.so not found
150518 16:35:46 [Note] Plugin 'FEDERATED' is disabled.
150518 16:35:46 InnoDB: The InnoDB memory heap is disabled
150518 16:35:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150518 16:35:46 InnoDB: Compressed tables use zlib 1.2.3
150518 16:35:46 InnoDB: Using Linux native AIO
150518 16:35:46 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
150518 16:35:46 InnoDB: Completed initialization of buffer pool
150518 16:35:46 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150518 16:35:46 [ERROR] Plugin 'InnoDB' init function returned error.
150518 16:35:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150518 16:35:46 [ERROR] Unknown/unsupported storage engine: InnoDB
150518 16:35:46 [ERROR] Aborting

150518 16:35:46 [Note] /usr/libexec/mysqld: Shutdown complete

150518 16:35:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

请问楼主如何解决的，我也碰到同样的问题，网上搜的都解决不了

[微wx笑]

MySQL启动报1067错误，系统日志中是“服务 mysql 意外停止” Mysql日志中则是：“Plugin 'FEDERATED' is disabled” 网我在网上找到解决方案： 1、在MY.INI文件中的 [mysqld] 中增加一行 tmpdir="D:/MySQL/data/" 修改后，还是启动不了或者能启动但关机后又出现同样问题，接着我做了第二步，重启正常。 2、删除DATA目录下除数据库文件夹外的其他文件，重启mysql，问题解决。

[只做大代码的搬运工]