Mysql 5.6 resize innodb_log_file

kernow

• September 21, 2014 03:54

This tip might save some of you wanting to resize the innodb_log_file some time. We had to increase the log file on one of our servers so we proceeded in the usual manner of checking that innodb_fast_shutdown is set to 0 or 1, shutdown Mysql, rename ib_logfile0 and ib_logfile1 ( so Mysql would create new two logs) edit /etc/my.cnf to show the innodb log size new value, then restart Mysql. But you can image my panic when I ran the LS command only to see the two ib_logfiles that I had renamed to ib_logfile0-olde and ib_logfile1-olde. Where was the two new innodb log files that Mysql should have created?? was Mysql really running? it was, and the error log file showed all was well. The simple answer we found out is, Mysql versions up to and including 5.5 needed the above procedure to change the innodb_log_file value but in Mysql 5.6 all you do is change the value in my.cnf and restart Mysql. Easy eh? Not sure why the renamed files ib_logfile0-olde and ib_logfile1-olde still work but they do, maybe anything starting with the name ib_logfile* will do.

• 

  cPanelMichael

  • September 22, 2014 14:54

  Hello :) I just wanted to note that this feature is documented by MySQL: [url=http://dev.mysql.com/doc/refman/5.6/en/innodb-data-log-reconfiguration.html]MySQL :: MySQL 5.6 Reference Manual :: 14.5.7 Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace Feel free to add comments to their documentation if you notice behavior different than what they have documented. Thank you.

  0

Please sign in to leave a comment.