解决centos6上vpsmate安装mysql启动失败问题

作者: 冬冬 分类: 网络技术 发布时间: 2013-11-01 09:27

 

 

# /etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

 

 

接下来运行

1 [root@pany99]#service mysqld start
2
3 Starting mysqld daemon  [FAILED]

看错误日志:

01 [root@pany99 ~]# less /var/log/mysqld.log
02 130821 23:48:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/project/etc/data
03 130821 23:48:39 [Note] Plugin 'FEDERATED' is disabled.
04 130821 23:48:39 InnoDB: The InnoDB memory heap is disabled
05 130821 23:48:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
06 130821 23:48:39 InnoDB: Compressed tables use zlib 1.2.3
07 130821 23:48:39 InnoDB: Using Linux native AIO
08 130821 23:48:39  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
09 InnoDB: Warning: io_setup() attempt 1 failed.
10 InnoDB: Warning: io_setup() attempt 2 failed.
11 InnoDB: Warning: io_setup() attempt 3 failed.
12 InnoDB: Warning: io_setup() attempt 4 failed.
13 InnoDB: Warning: io_setup() attempt 5 failed.
14 130821 23:48:41  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
15 InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
16 130821 23:48:41 InnoDB: Fatal error: cannot initialize AIO sub-system
17 130821 23:48:41 [ERROR] Plugin 'InnoDB' init function returned error.
18 130821 23:48:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
19 130821 23:48:41 [ERROR] Unknown/unsupported storage engine: InnoDB
20 130821 23:48:41 [ERROR] Aborting

InnoDB: Fatal error: cannot initialize AIO sub-system

 

解决方法:———————-转载请注明出处 x95.org———————–

 

  • 在my.cnf中添加在mysqldmysqld的部分 “innodb_use_native_aio=0”

QQ图片20130822122511.jpg

 

接下来在运行

1 # service mysqld start

 

mysql成功启动。

如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!

发表评论

电子邮件地址不会被公开。 必填项已用*标注