当试图重新启动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无法安装的问题。 这可能是因为:
quota -s
df -h
,看看有没有驱动器接近容量。 my.cnf
恢复您的configuration。 您可能还想尝试使用innodb_use_native_aio = 0
禁用AIO, innodb_use_native_aio = 0
只是一个解决方法。 希望这可以帮助。