Error:log file ./ib_logfile0...

2332阅读 0评论2011-05-11 ning_lianjie
分类:Mysql/postgreSQL

  1. 错误

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes

InnoDB: than specified in the .cnf file 0 33554432 bytes!

 

  1. 分析

大概意思:ib_logfile0这个文件的大小是异常的,应该按照.cnf配置文件,指定大小。

参考配置文件

# Size of each log file in a log group. You should set the combined size

# of log files to about 25%-100% of your buffer pool size to avoid

# unneeded buffer pool flush activity on log file overwrite. However,

# note that a larger logfile size will increase the time needed for the

# recovery process.

innodb_log_file_size = 256M

  1. 处理

直接删除已经存在的redo-log文件。

  1. 启动数据库
上一篇:MySQL升级(5.0->5.5)时,遇到一个故障
下一篇:Nginx安装