Log file ./ib_logfile0 is of different size

The steps you outlined are correct. Therefore, please do not change anything you have stated. Community Bot 1.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta.

New post summary designs on greatest hits now, everywhere else eventually. Linked Related 1. Hot Network Questions. Thanks, I managed to find it. I think this will be easier. I should have also added initially that I increased the log file size as well to match the increase in the buffer pool I did add this info now. Ok giorgio Try to delete the log file s. Did you delete log file size first? Please add more info about what did you do exactly? Show 1 more comment.

Active Oldest Votes. Right from the error log you present, the last two lines say: InnoDB: Error: log file. Looking back at the link to my StackOverflow answer in your question, you had to do the following: Step 01 Add this to my. Improve this answer.

Thanks, yep I did not delete them first. Just wanted to see how mysql behaves. After performing step 3 restarting worked. I think one shouldn't delete the log files, but rather move them elsewhere, and delete them a while later when you've successfully changed the log file size.

Otherwise, you'd be in trouble if MySQL crashed before you ran service mysqld stop. Add a comment. Based on the error in the log, I'm guessing you did this: shut down mysql edited my. To change the log size, one must shut down mysqld cleanly delete the value in my.

Rick James Rick James Thanks, yes this is a correct answer as well. I could only accept one though. It worked. So that i can delete these files or should i do something else also.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 8 months ago. Active 8 years, 1 month ago. Viewed 8k times. Thanks in advance!!!! Improve this question. Trying Trying