前段时间重装了下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 配置过大不一定是好事。