Re: MySQL 5.7: Sharp checkpointing due to binlogs? *** SOLVED ***
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.)"
Subject
Views
Written By
Posted
402
December 02, 2021 04:39AM
268
December 02, 2021 09:55AM
204
December 02, 2021 10:42AM
188
December 02, 2021 11:40AM
Re: MySQL 5.7: Sharp checkpointing due to binlogs? *** SOLVED ***
131
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.