MySQL
fs.aio-max-nr

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

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'