MySQL Bugs: #101717: Poor performance on a GTID slave when log_slave

Bug #101717	Poor performance on a GTID slave when log_slave_updates is disabled
Submitted:	23 Nov 2020 12:03	Modified:	11 Dec 2020 5:23
Reporter:	Venkatesh Prasad Venugopal	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	8.0, 8.0.22	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Clone, regression, rpl

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Error logs with debug prints of previous_gtids_logged in update_prev_gtids()

Attachment: Bug101717_slave_error_logs.txt (text/plain), 528.83 KiB.

Testcase to repeat the bug

Attachment: 0001-Bug-101717-Testcase-to-repeat-the-bug.patch (text/x-patch), 6.39 KiB.