Home / server / Questions / 316137
In Process
CMag
Asked: 2011-09-28 14:38:30 +0800 CST

mysql innodb problem

  • 772

seeing the following in my mysql error log file:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
110927 18:36:37 [ERROR] Plugin 'InnoDB' init function returned error.
110927 18:36:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

How can this be easily fixed?

Thanks!

mysql innodb

1 Answers

  1. As the error says, in your my.cnf you must have innodb_log_file_size= 256M.

    So stop your MYSQL server, rename the ib_logfile0 & ib_logfile1 files, then restart your server. It should create two new files each 256M in size.

    How you got into this situation is an important question. Trying to restore an old backup? i.e. Before the innodb_log_file_size was changed in your my.cnf.

    • 1