Bug #109514 Update documentation for online alter to mention INVISIBLE index

• Submitted: 3 Jan 2023 4:55
• Modified: 3 Jan 2023 7:00
• Reporter: Kedar Vaijanapurkar
• Status: Verified
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8
• OS: Any
• CPU Architecture: Any
• Tags: documentation, Invisible Indexes

[3 Jan 2023 4:55] Kedar Vaijanapurkar

Description:
The invisible index documentation confirms 

"Dropping and re-adding an index can be expensive for a large table, whereas making it invisible and visible are fast, in-place operations."

but the same is not listed in:

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html#online-ddl-index...

How to repeat:
read documentation

Suggested fix:
Explicitly mention invisible operation in an online alter section.

[3 Jan 2023 7:00] MySQL Verification Team

Hello Kedar,

Thank you for the document enhancement request.

regards,
Umesh