Bug #113818 optimize for buf_read_page_low

• Submitted: 31 Jan 2024 7:04
• Modified: 31 Jan 2024 7:20
• Reporter: alex xing (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S5 (Performance)
• Version: 8.0.32
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[31 Jan 2024 7:04] alex xing

Description:
optimize for buf_read_page_low
no need to execute ibuf_bitmap_page and trx_sys_hdr_page if sync=true

How to repeat:
just read the code

Suggested fix:
optimize as the below  patch

[31 Jan 2024 7:05] 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: optimize.patch (text/plain), 671 bytes.

[31 Jan 2024 7:20] MySQL Verification Team

Hello Alex Xing,

Thank you for the report and contribution.

regards,
umesh