LoginSignup
0
0

More than 5 years have passed since last update.

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

Last updated at Posted at 2018-02-03
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'

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0