Bug #113688 reduce memory usage for purge
Submitted: 19 Jan 2024 3:49 Modified: 19 Jan 2024 5:26
Reporter: alex xing (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S5 (Performance)
Version:8.0.32 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[19 Jan 2024 3:49] alex xing 
Description:
If the table does not have a secondary index, there is no need to allocate memory for the secondary index's purge

How to repeat:
just read the code

Suggested fix:
optimize as the below patch
[19 Jan 2024 3:49] alex xing 
a simple patch to describe the optimization based on 8.0.32

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

Contribution: purge_memory_optimize.patch (text/plain), 2.33 KiB.
[19 Jan 2024 5:26] MySQL Verification Team 
Hello Alex Xing,

Thank you for the report and contribution.

regards,
umesh