Bug #107857 only one LOG_CHECKPOINT block needed
Submitted: 13 Jul 2022 6:58 Modified: 13 Jul 2022 12:18
Reporter: alex xing (OCA) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S5 (Performance)
Version:8.0.19 OS:Any
Assigned to: CPU Architecture:Any

[13 Jul 2022 6:58] alex xing
Description:
In ib_logfile0, there are two checkpoint blcoks:LOG_CHECKPOINT_1  and LOG_CHECKPOINT_2.
If os guarantees 512 bytes atomic write for redo blcok, why not just one?

How to repeat:
just read the code

Suggested fix:
only one LOG_CHECKPOINT block needed
[13 Jul 2022 11:59] MySQL Verification Team
Hi Mr. xing,

Thank you for your bug report.

However, this is not a bug.

Our experience has shown that no operating system can handle many of the hard problems, like loss of power and similar, gracefully. That is why we still require two checkpoints.

Not a bug.
[13 Jul 2022 12:18] alex xing
Thank you very much for your apply