Re: Switch off InnoDB logging - Possible?
While MySQL is down, you can remove the iblog files. This is safe at least if there is nothing to recover. If you had a power failure, it is unclear how much will be lost.
To change the size of the iblog files:
1. Gracefully stop MySQL (so that it will flush whatever is in the log files)
2. change my.cnf
3. rm the iblog files
4. start MySQL; it will mildly complain that the log files are missing, then rebuild them (with the new size).
Subject
Written By
Posted
Re: Switch off InnoDB logging - Possible?
June 17, 2009 10:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.