InnoDB, innodb_log_file_size

Discussion in 'Server Operation' started by Keeper, Sep 8, 2009.

  1. Keeper

    Keeper New Member

    To get InnoDB enabled in the first place, I followed instructions here:
    http://www.geedew.com/2008/05/21/how-to-fix-innodb-has-been-disabled-for-this-mysql-server/

    Now I noticed that if I change innodb_log_file_size value and restart InnoDB, InnoDB engine and tables become unusable.

    After googling a bit, I found some obscure comments;

    Seriously? Something this important should be written to all mysql conf files if MySQL can't handle something like this automatically. This is just a recipe for panic attacks and data loss.
     
    Last edited: Sep 8, 2009

Share This Page