Error:log file ./ib_logfile0...

1. 错误

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

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

 

2. 分析

大概意思：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

3. 处理

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

4. 启动数据库