Bug #118083 optimize for invisible indexes ddl
Submitted: 29 Apr 9:36 Modified: 29 Apr 10:24
Reporter: alex xing (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S5 (Performance)
Version:8.0.42 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[29 Apr 9:36] alex xing 
Description:
Optimize DDL execution for invisible indexes by reducing traversal from twice to once

Previously, the native logic would traverse the index_visibility_list twice when handling DDL operations related to invisible indexes. This commit refactors the relevant logic to complete the operation with just a single traversal.

How to repeat:
just read the code

Suggested fix:
optimize as the below patch
[29 Apr 9:36] 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: alter_invisible_index_optimize.patch (application/octet-stream, text), 1.97 KiB.
[29 Apr 10:24] MySQL Verification Team 
Hello Alex Xing,

Thank you for the report and contribution.

regards,
umesh