Bug #110673 Optimize the garbage_collect of group_replication

Description:
In the current garbage_collect logic, for each key "is_subset_not_equals" will be called, this is not required as a Gtid_set_ref value may contains many keys, just once is required.

  Certification_info::iterator it = certification_info.begin();
  stable_gtid_set_lock->wrlock();
  while (it != certification_info.end()) {
    if (it->second->is_subset_not_equals(stable_gtid_set)) { /* very hot here */
      if (it->second->unlink() == 0) delete it->second;
      certification_info.erase(it++);
    } else
      ++it;
  }

How to repeat:
N/A

Suggested fix:
We could add a gc_version flag to Gtid_set_ref to avoid extra calls of "is_subset_not_equals".

Patch of LOCK_status optimization for global statistics summary

Attachment: temp.log (application/octet-stream, text), 2.55 KiB.

Patch of Optimize the garbage_collect of group_replication

Attachment: temp.log (application/octet-stream, text), 2.55 KiB.

Hello Fangxin Flou,

Thank you for the report and feedback.

Thanks,
Umesh

Documented fix as follows in the MySQL 8.0.41, 8.4.4, and 9.2.0 changelogs:

    Improved garbage collection in Group Replication by eliminating
    non-essential calls to is_subset_not_equals().

Closed.