Bug #110951 Contribution: CONTRIB_371: Efficient zeroing of UNDO, REDO and tablespace f ...
Submitted: 8 May 2023 15:03 Modified: 8 May 2023 17:13
Reporter: OCA Admin (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[8 May 2023 15:03] OCA Admin 
Description:
This bug tracks a contribution by Mikael Ronström (Github user: mronstro) as described in http://github.com/mysql/mysql-server/pull/465

How to repeat:
See description

Suggested fix:
See contribution code attached
[8 May 2023 15:03] OCA Admin 
Contribution submitted via Github - CONTRIB_371: Efficient zeroing of UNDO, REDO and tablespace files 
(*) Contribution by Mikael Ronström (Github mronstro, mysql-server/pull/465#issuecomment-1538470393): I confirm the code being submitted is offered under the terms of the OCA,
and that I am authorized to contribute it.

Rgrds Mikael Ronström

On Mon, May 8, 2023 at 3:54 PM mysql-oca-bot ***@***.***>
wrote:

> Hi, thank you for your contribution. Please confirm this code is submitted
> under the terms of the OCA (Oracle''s Contribution Agreement) you have
> previously signed by cutting and pasting the following text as a comment:
> "I confirm the code being submitted is offered under the terms of the OCA,
> and that I am authorized to contribute it."
> Thanks
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/mysql/mysql-server/pull/465#issuecomment-1538398823>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AR2BEEGZXHNB22PCTLYGXBLXFD3LBANCNFSM6AAA...>
> .
> You are receiving this because you authored the thread.Message ID:
> ***@***.***>
>

Contribution: git_patch_1342161203.txt (text/plain), 24.91 KiB.
[8 May 2023 17:13] MySQL Verification Team 
Hello Mikael,

Thank you for the report and contribution.

regards,
Umesh
[16 May 2023 13:10] Mauritz Sundell 
Posted by developer:
 
init_zero function and fallocate(FALLOC_FL_ZERO_RANGE) and xfs variant will not be used from patch.
Unwritten file pages are already guaranteed to be zero-filled by ftruncate (called by ndb_file::extend).
And file blocks will already be allocated by posix_fallocate (called by ndb_file::allocate).