MENU

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

August 22, 2013 • 故障解决

前言:最近入手了一台VPS,centos6.4。今天有闲暇时间,准备来折腾了。由于只有256M的内存,选择了很久没更新的VPSmate面板。

首先在Ius源时就出了问题。后来解决了,结果启动mysql又出现了问题,搜索了很多文章,都没有找到自己想要的办法。在VPSmate论坛上也有人提出这个问题,但是没有大神回答,那我就自己来动手解决把。(好吧,停止,扯远了,直接进入主题。)

正文:


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


接下来运行

[[email protected]]#service mysqld start

Starting mysqld daemon  [FAILED]

看错误日志:

[[email protected] ~]# less /var/log/mysqld.log
130821 23:48:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/project/etc/data
130821 23:48:39 [Note] Plugin 'FEDERATED' is disabled.
130821 23:48:39 InnoDB: The InnoDB memory heap is disabled
130821 23:48:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130821 23:48:39 InnoDB: Compressed tables use zlib 1.2.3
130821 23:48:39 InnoDB: Using Linux native AIO
130821 23:48:39  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.
130821 23:48:41  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
130821 23:48:41 InnoDB: Fatal error: cannot initialize AIO sub-system
130821 23:48:41 [ERROR] Plugin 'InnoDB' init function returned error.
130821 23:48:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130821 23:48:41 [ERROR] Unknown/unsupported storage engine: InnoDB
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


接下来在运行 

# service mysqld start


mysql成功启动。

----------------------转载请注明出处-----------------------


Archives QR Code
QR Code for this page
Tipping QR Code