Bug #107308 | ALTER TABLE...ALGORITHM=INSTANT stalls on AHI drop | ||
---|---|---|---|
Submitted: | 16 May 2022 21:50 | Modified: | 10 Aug 2022 12:25 |
Reporter: | Marcos Albe (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S4 (Feature request) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[16 May 2022 21:50]
Marcos Albe
[16 May 2022 21:57]
Marcos Albe
Corrected title (INSTANCE should be INSTANT)
[16 May 2022 21:57]
Marcos Albe
Corrected title (INSTANCE should be INSTANT)
[17 May 2022 13:11]
MySQL Verification Team
Hi Mr. Albe, Thank you very much for your bug report. However, what you describe is exactly how Adaptive Hash Indexing is supposed to work , since it was introduced. What you are suggesting are changing in the design of AHI. We can accept that, but only as a feature request or performance improvement. If you agree with this conclusion that we can verify your report as a feature request. Thanks in advance.
[18 Jun 2022 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[9 Aug 2022 21:52]
Sveta Smirnova
Yes, this will be a nice feature. I suggest at least add a warning that this DDL causes the process of removing data from the AHI.
[9 Aug 2022 23:40]
Marcos Albe
Hello Sinisa, Thanks, as mentioned by Sveta, this will indeed make for a good FR; A warning would be nice to have, and if re-architecting is feasible (now that CI development is rolling) it would be great to do this in a lazy way (in the background). Thanks for the attention to the issue, and apologies for slow response! Best, Marcos
[10 Aug 2022 12:25]
MySQL Verification Team
Hi All, This is, indeed, a very small, but useful feature request. Verified as aa feature request .......