Bug #110600 optimize for page flush

• Submitted: 4 Apr 2023 8:55
• Modified: 4 Apr 2023 9:27
• 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

[4 Apr 2023 8:55] alex xing

Description:
If there no page flushed in the batch, no need to execute dblwr::force_flush.
So we can skip this operation and improve the performance of page flusing

How to repeat:
just read the code

Suggested fix:
we can skip this operation and improve the performance of page flusing, just as the below patch

[4 Apr 2023 8:55] alex xing

a simple patch to describe the optimization

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

Contribution: flush_optimize.patch (text/plain), 1.70 KiB.

[4 Apr 2023 9:27] MySQL Verification Team

Hello Alex Xing,

Thank you for the report and contribution.

regards,
umesh