linux aio max nr,mariadb数据库aio-max_nr错误解决方法

在mariadb-10.0.12的时候,一个机器跑多个实例时,可能会出现如下报错。

2014-09-04 14:15:50 7f6c46b1f720 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.

2014-09-04 14:15:52 7f6c46b1f720 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

InnoDB: Warning: Linux Native AIO disabled because os_aio_linux_create_io_ctx() failed. To get rid of this warning you can try increasing system fs.aio-max-nr to 1048576 or larger or setting innodb_use_native_aio = 0 in my.cnf

解决办法：

root@localhost:~# echo “fs.aio-max-nr = 1048576″ >> /etc/sysctl.conf && sysctl -p