Which exceeds the log group capacity mysql

It should be bigger to do two things:. ButtleButkus just commented at EDT. What does that do? If deleting them makes you nervous, then make Step If the recreation of the logs is successful and mysqld starts up, then you can delete the old logs. Thanks again, ButtleButkus. Sign up to join this community. The best answers are voted up and rise to the top.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 9 years, 7 months ago. Active 8 years, 4 months ago. Viewed 47k times. Version: '5. Improve this question. The best that I can tell, the issue appears to be related to growth of data being inserted into the primary data tables that are of the type, InnoDB.

I have been using InnoDB tables because they support row level locking. Anyway, I have scanned the tables and I do not see any fields of the type Text or Blob so I think that insert load is the only other option that makes sense. The server is MySQL 4. However my efforts on the QA server caused the server to fail to start up properly after shutting down the service, updating the my. Is there a better method to adjust the InnoDB log file size? Has anyone seen this problem? I found that there is more information in the actual mysql.

So, as it seems, the InnoDB log file settings need to be updated. I found a listing of the steps to take on MySQL's website.

Here are those steps fleshed out a little. To fix this, set it to one by runnning the following query:. You may see people suggesting really large values for the log file size -- I saw a value of M in one StackOverflow answer.