Bug #101512 Relationship between two system variables are not fully recorded.
Submitted: 9 Nov 2020 4:34 Modified: 7 Apr 2021 10:01
Reporter: Zhou Shu Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[9 Nov 2020 4:34] Zhou Shu
'transaction_write_set_extraction' value depends on 'binlog_transaction_dependency_tracking' but not fully record.

How to repeat:
The system variable  'transaction_write_set_extraction' must be set to XXHASH64 or MURMUR32 when 'binlog_transaction_dependency_tracking' is WRITESET or WRITESET_SESSION. However, the doc only record that 'transaction_write_set_extraction' cannot be changed when 'binlog_transaction_dependency_tracking' is set to either of WRITESET or WRITESET_SESSION in https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html#sysvar_transac...
[9 Nov 2020 5:13] MySQL Verification Team
Hello Zhou Shu,

Thank you for the report and feedback.

[7 Apr 2021 10:01] Margaret Fisher
Posted by developer:
Thanks for pointing this out! I have added an update:

When WRITESET or WRITESET_SESSION is set as the value for binlog_transaction_dependency_tracking, transaction_write_set_extraction must be set to specify an algorithm (not set to OFF). While the current value of binlog_transaction_dependency_tracking is WRITESET or WRITESET_SESSION, you cannot change the value of transac-tion_write_set_extraction.