InnoDB is insanely picky about it's config; if something's not right, it'll just give up and go home. To make a change to the log file size without data loss:
- Revert any config changes you've made to the log file size and start MySQL again.
- In your running MySQL: SET GLOBAL innodb_fast_shutdown=0;
- Stop MySQL
- Make the configuration change to the log file size.
- Delete both log files.
- Start MySQL. It will complain about the lack of log files, but it'll create them and all will be well.
0 Comments