fs.aio max nr mysql_InnoDB: Error: io_setup() failed with EAGAIN

最近安装好了MySQL之后，在启动MySQL服务时无法正常启动MySQL。提示没有更新/var/lib/mfailedZDB.pid并退出。该MySQL与Oracle位于同一主机。有些内核参数进行过调整应该也是使用与MySQL。下面是该问题的具体描述。

1、故障现象SZDB:/usr/src/mysql_src # /etc/init.d/mysql start

Starting MySQL...The server quit without updating PID file (/var/lib/mfailedZDB.pid).

SZDB:~ # cat /etc/issue     #故障环境

Welcome to SUSE Linux Enterprise Server 10 SP3 (x86_64) - Kernel \r (\l).

2、故障分析#查看err日志信息

SZDB:/var/lib/mysql # more SZDB.err

140505 16:05:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

140505 16:05:59 [Note] Plugin 'FEDERATED' is disabled.

140505 16:05:59 InnoDB: The InnoDB memory heap is disabled

140505 16:05:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins

140505 16:05:59 InnoDB: Compressed tables use zlib 1.2.3

140505 16:05:59 InnoDB: Using Linux native AIO

140505 16:05:59  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.

140505 16:06:02  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

140505 16:06:02 InnoDB: Fatal error: cannot initialize AIO sub-system

140505 16:06:02 [ERROR] Plugin 'InnoDB' init function returned error.

140505 16:06:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

140505 16:06:02 [ERROR] Unknown/unsupported storage engine: InnoDB

140505 16:06:02 [ERROR] Aborting

140505 16:06:02 [Note] /usr/sbin/mysqld: Shutdown complete

140505 16:06:02 mysqld_safe mysqld from pid file /var/lib/mysql/SZDB.pid ended

#从上面的错误日志中可以看到，关键的一个信息io_setup() failed with EAGAIN

#io_setup()锁定失败

3、故障解决错误代码EAGAIN表明超出了可用event限制的最大值(见第4点中的描述)

SZDB:~ # cat /proc/sys/fs/aio-max-nr

65536                        #64k个

SZDB:~ # vi /etc/sysctl.conf

fs.aio-max-nr=262144         #调整为256k个

SZDB:~ # sysctl -p

#  Author : Leshami

#  Blog   :http://blog.csdn.net/leshami

SZDB:~ # /etc/init.d/mysql start    #调整后启动成功

Starting MySQL...                                                     done

4、关于fs.aio-max-nr该参数指同时可以拥有的的异步IO请求数目

aio-nr & aio-max-nr:

aio-nr is the running total of the number of events specified on the

io_setup system call for all currently active aio contexts.  If aio-nr

reaches aio-max-nr then io_setup will fail with EAGAIN.  Note that

raising aio-max-nr does not result in the pre-allocation or re-sizing

of any kernel data structures.

NAME

io_setup - Create an asynchronous I/O context

SYNOPSIS

#include

Tag           Description

-----------   ------------------------------------

int io_setup (int maxevents, io_context_t *ctxp);

DESCRIPTION:

io_setup() creates an asynchronous I/O context capable of receiving at least maxevents.#创建一个接收异步i/o的上下文环境

ctxp must not point to an AIO context that already exists, and must be initialized to 0 prior to the call.

On successful creation of the AIO context, *ctxp is filled in with the resulting handle.

RETURN VALUE：

io_setup() returns 0 on success; otherwise, one of the errors listed in the "Errors" section is returned.

ERRORS：

Tag     Description

------  ----------------------------------------------

EINVAL  ctxp is not initialized,or the specified maxevents exceeds internal limits. maxevents should be greater than 0.

EFAULT  An invalid pointer is passed for ctxp.

ENOMEM  Insufficient kernel resources are available.

EAGAIN  The specified maxevents exceeds the user’s limit of available events.#此案例中返回的时超出了可用event限制的最大值

ENOSYS  io_setup() is not implemented on this architecture.

更多参考