Once innodb_log_file ib_logfile0 & ib_logfile1 got full while running big transaction,so what is mysql next action in this situation ?

1 Answer 1


When innodb_log_file ib_logfile0 is full it start to write innodb_log_file ib_logfile1.

When this is full, it start to over with innodb_log_file ib_logfile0.

The only thing is to have enough space for both files.

The size is determined by `innodb_log_file_size=64M, but be careful mysql when you want to change the size, you need stop the server and delete the old ones. when you restart they will be created new.

  • The binlog is a separate issue.
    – Rick James
    Commented Jun 14, 2020 at 20:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.