I have modified the my.cnf for a MySQL 7 installation and now I receive the following error in syslog:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! [ERROR] Plugin 'InnoDB' init function returned error. [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
I have removed the lines from my.cnf one by one and found the error prone lines are:
innodb_log_file_size = 256M innodb_log_files_in_group = 3
Does anyone know what causes this problem? I don't see how specifying 256M limit is stopping a 5M file working.