InnoDB: Warning: io_setup() failed with EAGAIN 解决办法
来源:互联网 发布:淘宝和飞牛网价格对比 编辑:程序博客网 时间:2024/05/27 06:14
前段时间重装了下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 配置过大不一定是好事。
- InnoDB: Warning: io_setup() failed with EAGAIN 解决办法
- InnoDB: Error: io_setup() failed with EAGAIN
- InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts
- InnoDB: Warning: a long semaphore wait 解决办法
- InnoDB: Warning: a long semaphore wait 解决办法
- PHP Warning: file_get_contents failed to open stream解决办法
- compile" failed with error code 1 解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- conversion to dalvik format failed with error 1的解决办法
- java设计模式--工厂方法模式
- Android 常用代码---资源文件
- Sublime Text 2 快捷键用法大全
- android的定时及消息队列处理
- 智能指针是一种类,别名称为句柄类
- InnoDB: Warning: io_setup() failed with EAGAIN 解决办法
- 基于FS2410的SDIO WIFI移植
- 金币阵列问题
- 感谢csdn
- Android 常用代码---日志
- Objective-C、C++以及C之间的区别
- 从platform驱动看驱动模型
- Objective-C ,ios,iphone开发基础:3分钟教你做一个iphone手机浏览器
- Java基础<十五>---> IO