Bug #118057 optimize for check_promoted_index
Submitted: 25 Apr 9:48 Modified: 25 Apr 13:04
Reporter: alex xing (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S5 (Performance)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[25 Apr 9:48] alex xing 
Description:
In the scenario of altering an invisible index, if the change involves a unique key, there is no need to maintain `has_unique_key`.
It is recommended to move the logic for maintaining `has_unique_key` to a later stage to reduce unnecessary overhead.

How to repeat:
just read the code

Suggested fix:
just as the below patch
[25 Apr 9:51] alex xing 
a simple patch to describe the optimization

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: check_promoted_index_optimize.patch (application/octet-stream, text), 714 bytes.
[25 Apr 13:04] MySQL Verification Team 
Bug #118058 marked as duplicate of this one
[25 Apr 13:04] MySQL Verification Team 
Hello Alex Xing,

Thank you for the report and contribution.

regards,
umesh