Month: August 2016

  • Resizing InnoDB Logs

    If you have already created your database and you change the setting for “innodb_log_file_size=###M” and restart here you database and get an error that looks something like

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

    Here what you need to do.
    1.) Make sure your database shutdown clean.
    2.) Move(not delete) any existing ib_logfile[#] to a safe place.
    3.) edit the “innodb_log_file_size=###M” setting in your my.cnf.
    4.) Restart your database and check your log file to make sure there were no errors.
    5.) Check to make sure the new ib_logfile[#] are the right size.