Edited at

MySQLの起動に失敗(fs.aio-max-nrが少ない)

More than 1 year has passed since last update.

2018-01-28T11:33:56.703532Z 0 [ERROR] InnoDB: io_setup() failed with EAGAIN after 5 attempts.

2018-01-28T11:33:56.703773Z 0 [ERROR] InnoDB: Cannot initialize AIO sub-system
2018-01-28T11:33:56.703833Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-01-28T11:33:56.703880Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-01-28T11:33:56.703923Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-01-28T11:33:56.703963Z 0 [ERROR] Failed to initialize builtin plugins.
2018-01-28T11:33:56.703998Z 0 [ERROR] Aborting

my.cnfの[mysqld]のセクションに以下を追加

innodb_use_native_aio=0

※カーネルパラメータを書き換えようとしたがvpsではだめらしい。

$ sudo vi /etc/sysctl.conf

fs.aio-max-nr = 131072
$ sudo sysctl -p
error: permission denied on key 'fs.aio-max-nr'