Bug #106768 dummy index optimize: it is better to reuse the index object

• Submitted: 18 Mar 2022 7:40
• Modified: 18 Mar 2022 10:09
• Reporter: alex xing (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S5 (Performance)
• Version: 8.0.19
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[18 Mar 2022 7:40] alex xing

Description:
during innodb recover, create and release dummy index frequently  in mlog_parse_index. it is better to reuse the index object

How to repeat:
just read the below patch

Suggested fix:
reuse the index object

[18 Mar 2022 7:41] alex xing

a simple patch based on  8.0.19.  The same may be true for the latest version of the code.

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

Contribution: dummy_index_optimize.patch (text/plain), 9.79 KiB.

[18 Mar 2022 7:52] alex xing

before optimize

Attachment: before_optimize.png (image/png, text), 1.14 MiB.

[18 Mar 2022 7:53] alex xing

before optimize

Attachment: before_optimize.png (image/png, text), 1.14 MiB.

[18 Mar 2022 7:53] alex xing

after_optimize

Attachment: after_optimize.png (image/png, text), 1.04 MiB.

[18 Mar 2022 10:09] MySQL Verification Team

Hello Alex Xing,

Thank you for the report and contribution.

regards,
umesh