无法启动/停止/重新启动服务:MySQL Daemon无法启动

当试图重新启动mysqld服务时,我得到这个erroe:无法启动/停止/重新启动服务:MySQL守护进程无法启动。

有人有想法如何解决它? 我运行centos 6.5,从我看到我缺less文件:/var/lib/mysql/mysql.sock

mysql错误日志

140707 12:09:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140707 12:09:29 [Note] libgovernor.so not found 140707 12:09:29 [Warning] option 'innodb-buffer-pool-size': signed value 2097152 adjusted to 5242880 140707 12:09:29 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288 140707 12:09:29 [Note] Plugin 'FEDERATED' is disabled. 140707 12:09:29 InnoDB: The InnoDB memory heap is disabled 140707 12:09:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140707 12:09:29 InnoDB: Compressed tables use zlib 1.2.3 140707 12:09:29 InnoDB: Using Linux native AIO 140707 12:09:29 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up. InnoDB: Warning: io_setup() attempt 1 failed. InnoDB: Warning: io_setup() attempt 2 failed. InnoDB: Warning: io_setup() attempt 3 failed. InnoDB: Warning: io_setup() attempt 4 failed. InnoDB: Warning: io_setup() attempt 5 failed. 140707 12:09:31 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts. InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf 140707 12:09:31 InnoDB: Fatal error: cannot initialize AIO sub-system 140707 12:09:31 [ERROR] Plugin 'InnoDB' init function returned error. 140707 12:09:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140707 12:09:31 [ERROR] Unknown/unsupported storage engine: InnoDB 140707 12:09:31 [ERROR] Aborting 140707 12:09:31 [Note] /usr/libexec/mysqld: Shutdown complete 140707 12:09:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 

感谢您的答案,但我需要从备份恢复它

这似乎是AIO无法安装的问题。 这可能是因为:

  1. 通过配额限制空间:您是否为您启动MySQL的用户设置了配额? 尝试查看quota -s
  2. 通过HD的空间限制:也许你的空间不足。 看看df -h ,看看有没有驱动器接近容量。
  3. 权限问题:您尝试重新启动服务的用户是否具有适当的权限?
  4. configuration更改:您最近是否更改configuration? 作为testing,请尝试在my.cnf恢复您的configuration。 您可能还想尝试使用innodb_use_native_aio = 0禁用AIO, innodb_use_native_aio = 0只是一个解决方法。
  5. 数据库损坏:我没有看到由于数据库损坏popup的这个错误,但我想这是一种可能性。

希望这可以帮助。