iosetup mysql_InnoDB: Warning: io_setup() failed with EAGAIN 解决办法 | 学步园

前段时间重装了下mysql

修改了配置

innodb_data_file_path = ibdata1:5G;ibdata2:5G:autoextend

改成：

innodb_data_file_path = ibdata1:1G;ibdata2:1G:autoextend

开启mysql的时候

The server quit without updating PID file(..)

alter日志的错误信息如下：

110208 11:56:51 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.

110208 11:56:54 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.

网上也没有找到解决办法。

通过各种设置 最终通过调低 innodb_buffer_pool_size 的配置，问题得到了解决

innodb_buffer_pool_size = 3G  改成 innodb_buffer_pool_size = 1G

当配置为3G的时候 ibdata* 文件老是无法正常的生成。可能跟当前系统的资源有关，但是具体的原因还无从得知。

所以innodb_buffer_pool_size 配置过大不一定是好事。