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
514
December 02, 2021 04:39AM
343
December 02, 2021 09:55AM
301
December 02, 2021 10:42AM
267
December 02, 2021 11:40AM
Re: MySQL 5.7: Sharp checkpointing due to binlogs? *** SOLVED ***
227
January 24, 2022 04:40AM
Sorry, you can't reply to this topic. It has been closed.
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.