MySQL Forums
Forum List  »  InnoDB

Re: MySQL 5.7: Sharp checkpointing due to binlogs? *** SOLVED ***
Posted by: Thomas Bätzler
Date: January 24, 2022 04:40AM

To summarize: Since we upgraded our cluster from MySQL 5.5 to 5.7, we set "binlog_gtid_simple_recovery = OFF" for compatibility reasons. However, we missed the fine print that stated that this would cause performance problems. Switching to "binlog_gtid_simple_recovery = ON" fixed the issue.

There is a report for this problem (https://bugs.mysql.com/bug.php?id=99315) and it was deemed not to be a bug.

"- binlog_gtid_simple_recovery=OFF is for compatibility with 5.7.5 and older.
It is documented that this is slow when there are many binary logs and
gtid_mode=OFF. (It is impossible to fix the slowness, since 5.7.5 and older
don't have necessary information in the binary log to make the procedure
fast.)"

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.7: Sharp checkpointing due to binlogs? *** SOLVED ***
91
January 24, 2022 04:40AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.